topic select probelm in Application Development and Automation Discussions

select probelm

Former Member — Thu, 07 Sep 2006 08:36:44 GMT

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 )

Re: select probelm

Former Member — Thu, 07 Sep 2006 08:39:29 GMT

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

USe SELECT...into table itab.

Re: select probelm

Former Member — Thu, 07 Sep 2006 08:41:40 GMT

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

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

Re: select probelm

Former Member — Thu, 07 Sep 2006 08:42:53 GMT

hi,

Give Space here

<b>( EKKO</b>-BUKRS

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

Regards,

Santosh

Re: select probelm

Former Member — Thu, 07 Sep 2006 08:43:15 GMT

i have endselct thanks

Re: select probelm

Former Member — Thu, 07 Sep 2006 08:43:59 GMT

santosh i give space i get err select???

Re: select probelm

Former Member — Thu, 07 Sep 2006 08:44:06 GMT

Hi rani,

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

Re: select probelm

Former Member — Thu, 07 Sep 2006 08:48:04 GMT

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

this select copied from SQVI 4 times and steel have err

Re: select probelm

Former Member — Thu, 07 Sep 2006 08:52:58 GMT

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