select probelm

[Former Member]

i cpoy this select from SQVI

and i get err : "the list (EKKO-BUKRS is not in the list

SELECT EKKO_{BUKRS EKKO}EBELN EKKO_{LPONR EKKO}ZBD1T EKPO~EBELN

EKPO_{EBELP MSEG}BNBTR MSEG_{DMBTR MSEG}EBELN MSEG~EBELP

MSEG_{LIFNR MSEG}MAT_PSPNR MSEG_{MBLNR MSEG}MJAHR MSEG~PPRCTR

MSEG_{PRCTR MSEG}SAKTO MSEG_{WAERS MSEG}ZUSTD MKPF~BUDAT

MKPF_{MBLNR MKPF}MJAHR

INTO (EKKO-BUKRS , EKKO-EBELN , EKKO-LPONR , EKKO-ZBD1T , EKPO-EBELN

, EKPO-EBELP , MSEG-BNBTR , MSEG-DMBTR , MSEG-EBELN , MSEG-EBELP

, MSEG-LIFNR , MSEG-MAT_PSPNR , MSEG-MBLNR , MSEG-MJAHR

, MSEG-PPRCTR , MSEG-PRCTR , MSEG-SAKTO , MSEG-WAERS , MSEG-ZUSTD

, MKPF-BUDAT , MKPF-MBLNR , MKPF-MJAHR )

FROM ( EKKO

INNER JOIN EKPO

ON EKPO_{EBELN = EKKO}EBELN

AND EKPO_{EBELP = EKKO}LPONR

INNER JOIN MSEG

ON MSEG_{EBELN = EKPO}EBELN

AND MSEG_{EBELP = EKPO}EBELP

INNER JOIN MKPF

ON MKPF_{MBLNR = MSEG}MBLNR

AND MKPF_{MJAHR = MSEG}MJAHR )

[Former Member]

This Should be a SELECT..ENDSELECT statement and hence your are getting this error

USe SELECT...into table itab.

[Former Member]

INTO <b>(</b> EKKO-BUKRS , EKKO-EBELN

bold --- give the space b/w '(' & ekko-bukrs.

[Former Member]

hi,

Give Space here

<b>( EKKO</b>-BUKRS

and also end the select statement with endselect statement...

Regards,

Santosh

[Former Member]

i have endselct thanks

[Former Member]

santosh i give space i get err select???

[Former Member]

Hi rani,

Give a space after ( in (EKKO-BUKRS i.e, ( EKKO-BUKRS

[Former Member]

firend i tried to give space before i asked u it not work

this select copied from SQVI 4 times and steel have err

[Former Member]

i think... i replied 1st ...anyway it's ok..