SQL Problem

[bettina_martin]

Wie ist denn die aktuelle Quelle?

 
CREATE VIEW ZKNA2_VIEW AS ( SELECT A.MANDT, A.KUNNR, A.NAME1, A.NAME 
2, A.STRAS, A.ORT01, A.PSTLZ, A.LAND1, A.SORTL, VALUE(TEL1, '') AS T 
EL1, VALUE(TEL2, '') AS TEL2, VALUE(MOBIL1, '') AS MOBIL1, VALUE(MOB 
IL2, '') AS MOBIL2, VALUE(EMAIL1,'') AS EMAIL1, VALUE(EMAIL2,'') AS 
EMAIL2, A.STCEG FROM ( SELECT A.MANDT, A.KUNNR, A.NAME1, A.NAME2, A. 
STRAS, A.ORT01, A.PSTLZ, A.LAND1, A.SORTL, (SELECT TEL_NUMBER FROM R 
3P02DATA.ADR2 WHERE ADDRNUMBER=A.ADRNR AND R3_USER = '1' ) AS TEL1, 
(SELECT TEL_NUMBER FROM R3P02DATA.ADR2 WHERE ADDRNUMBER=A.ADRNR AND 
R3_USER = ' ' ) AS TEL2, (SELECT TEL_NUMBER FROM R3P02DATA.ADR2 WHER 
E ADDRNUMBER=A.ADRNR AND R3_USER = '3' ) AS MOBIL1, (SELECT TEL_NUMB 
ER FROM R3P02DATA.ADR2 WHERE ADDRNUMBER=A.ADRNR AND R3_USER = '2' ) 
AS MOBIL2, (SELECT SMTP_ADDR FROM R3P02DATA.ADR6 WHERE ADDRNUMBER=A. 
ADRNR AND FLGDEFAULT = 'X' ) AS EMAIL1, (SELECT SMTP_ADDR FROM R3P02 
DATA.ADR6 WHERE ADDRNUMBER=A.ADRNR AND FLGDEFAULT = ' ' ) AS EMAIL2, 
A.STCEG FROM R3P02DATA.KNA1 A ) AS A WHERE A.KUNNR < '0000999999' A 
ND A.MANDT = '101' AND A.KUNNR <> '0000062871' )

sry, hab die quelle nur mehr in dieser unstrukturierten form

die subselects bringen hin und wieder mehr als einen satz (aber selten). das möchte ich verhindern indem ich in den jeweiligen abfragen das MIN von der CONSNUMBER nehme.