urgent , abap select statement error ...

[carlos_zhang3]

Hi all ,

here i attached my code , has anyone can tell me where is the error ???

when i active this code , it showed :

"comma without preceding colon(after select?)"

thanks a lot !

SELECT LIPS_{ERDAT LIPS}VBELN LIPS_{POSNR LIPS}VGPOS LIPS~LFIMG

LIPS_{VRKME LIKP}WADAT_IST LIKP_{KUNAG LIKP}KUNNR LIKP~VBELN

VBAP_{VBELN VBAP}MATNR VBAP_{NETWR VBAP}WAERK VBAP_{MWSBP VBAP}NETPR

VBAP_{POSNR VBUP}KOSTA VBUP_{WBSTA VBUP}FKSTA VBUP_{POSNR VBUP}VBELN

VBPA_{PARVW VBPA}VBELN VBUK_{CMGST VBUK}VBELN VBAK_{AUART VBAK}VBELN

INTO (

WASTATUS-ERDAT , WASTATUS-VBELN , WASTATUS-POSNR ,

WASTATUS-VGPOS , WASTATUS-LFIMG , WASTATUS-VRKME ,

WASTATUS-WADAT_IST , WASTATUS-KUNAG ,WASTATUS-KUNNR ,

WASTATUS-LIKPVBELN , WASTATUS-VBAPVBELN , WASTATUS-MATNR ,

WASTATUS-NETWR , WASTATUS-WAERK , WASTATUS-MWSBP ,

WASTATUS-NETPR , WASTATUS-POSNR , WASTATUS-KOSTA , WASTATUS-WBSTA ,

WASTATUS-FKSTA , WASTATUS-VBUPPOSNR , WASTATUS-VBUPVBELN ,

WASTATUS-PARVW , WASTATUS-VBPAVBELN , WASTATUS-CMGST ,

WASTATUS-VBUKVBELN , WASTATUS-AUART , WASTATUS-VBAKVBELN )

FROM ( LIPS inner join LIKP

on LIKP_{VBELN = LIPS}VBELN

inner join VBAP

on VBAP_{VBELN = LIPS}VGBEL

and VBAP_{POSNR = LIPS}VGPOS

inner join VBUP

on VBUP_{POSNR = LIPS}POSNR

and VBUP_{VBELN = LIPS}VBELN

inner join VBPA

on VBPA_{VBELN = LIPS}VBELN

inner join VBUK

on VBUK_{VBELN = LIPS}VBELN

inner join VBAK

on VBAK_{VBELN = VBAP}VBELN )

WHERE

LIPS~VBELN in P_SVBELN

and LIPS~ERDAT in P_ERDAT

and LIKP~KUNAG in P_KUNAG

and LIKP~KUNNR in P_KUNNR

and VBAP~VBELN in P_PVBELN

and VBUP~KOSTA in P_KOSTA

and VBUP~WBSTA in P_WBSTA

and VBUP~FKSTA in P_FKSTA

and VBPA~PARVW in P_PARVW

and VBUK~CMGST in P_CMGST .

[Former Member]

Hello CArlos,

Make this change:

SELECT LIPS~ERDAT LIPS~VBELN LIPS~POSNR LIPS~VGPOS LIPS~LFIMG
LIPS~VRKME LIKP~WADAT_IST LIKP~KUNAG LIKP~KUNNR LIKP~VBELN
VBAP~VBELN VBAP~MATNR VBAP~NETWR VBAP~WAERK VBAP~MWSBP VBAP~NETPR
VBAP~POSNR VBUP~KOSTA VBUP~WBSTA VBUP~FKSTA VBUP~POSNR VBUP~VBELN
VBPA~PARVW VBPA~VBELN VBUK~CMGST VBUK~VBELN VBAK~AUART VBAK~VBELN
INTO (
WASTATUS-ERDAT,WASTATUS-VBELN,WASTATUS-POSNR,
 " Remove the "space between the fields
WASTATUS-VGPOS , WASTATUS-LFIMG , WASTATUS-VRKME ,
WASTATUS-WADAT_IST , WASTATUS-KUNAG ,WASTATUS-KUNNR ,
WASTATUS-LIKPVBELN , WASTATUS-VBAPVBELN , WASTATUS-MATNR ,
WASTATUS-NETWR , WASTATUS-WAERK , WASTATUS-MWSBP ,
WASTATUS-NETPR , WASTATUS-POSNR , WASTATUS-KOSTA , WASTATUS-WBSTA ,
WASTATUS-FKSTA , WASTATUS-VBUPPOSNR , WASTATUS-VBUPVBELN ,
WASTATUS-PARVW , WASTATUS-VBPAVBELN , WASTATUS-CMGST ,
WASTATUS-VBUKVBELN , WASTATUS-AUART , WASTATUS-VBAKVBELN )
FROM ( LIPS inner join LIKP
on LIKP~VBELN = LIPS~VBELN
inner join VBAP
on VBAP~VBELN = LIPS~VGBEL
and VBAP~POSNR = LIPS~VGPOS
inner join VBUP
on VBUP~POSNR = LIPS~POSNR
and VBUP~VBELN = LIPS~VBELN
inner join VBPA
on VBPA~VBELN = LIPS~VBELN
inner join VBUK
on VBUK~VBELN = LIPS~VBELN
inner join VBAK
on VBAK~VBELN = VBAP~VBELN )
WHERE
LIPS~VBELN in P_SVBELN
and LIPS~ERDAT in P_ERDAT
and LIKP~KUNAG in P_KUNAG
and LIKP~KUNNR in P_KUNNR
and VBAP~VBELN in P_PVBELN
and VBUP~KOSTA in P_KOSTA
and VBUP~WBSTA in P_WBSTA
and VBUP~FKSTA in P_FKSTA
and VBPA~PARVW in P_PARVW
and VBUK~CMGST in P_CMGST . 

[Former Member]

Hi,

Remove the spaces after the brackets everywhere.

i mean.

like,

INTO <b>(</b>WASTATUS-ERDAT , WASTATUS-VBELN , WASTATUS-POSNR ,

WASTATUS-VGPOS , WASTATUS-LFIMG , WASTATUS-VRKME ,

WASTATUS-WADAT_IST , WASTATUS-KUNAG ,WASTATUS-KUNNR ,

WASTATUS-LIKPVBELN , WASTATUS-VBAPVBELN , WASTATUS-MATNR ,

WASTATUS-NETWR , WASTATUS-WAERK , WASTATUS-MWSBP ,

WASTATUS-NETPR , WASTATUS-POSNR , WASTATUS-KOSTA , WASTATUS-WBSTA ,

WASTATUS-FKSTA , WASTATUS-VBUPPOSNR , WASTATUS-VBUPVBELN ,

WASTATUS-PARVW , WASTATUS-VBPAVBELN , WASTATUS-CMGST ,

WASTATUS-VBUKVBELN , WASTATUS-AUART , WASTATUS-VBAKVBELN<b>)</b>

FROM <b>(</b>LIPS inner join LIKP

on LIKP_{VBELN = LIPS}VBELN

inner join VBAP

on VBAP_{VBELN = LIPS}VGBEL

and VBAP_{POSNR = LIPS}VGPOS

inner join VBUP

on VBUP_{POSNR = LIPS}POSNR

and VBUP_{VBELN = LIPS}VBELN

inner join VBPA

on VBPA_{VBELN = LIPS}VBELN

inner join VBUK

on VBUK_{VBELN = LIPS}VBELN

inner join VBAK

on VBAK_{VBELN = VBAP}VBELN<b>)</b>

Thanks.

Message was edited by:

Pritha Agrawal

null

[Former Member]

Try this

SELECT LIPS_{ERDAT LIPS}VBELN LIPS_{POSNR LIPS}VGPOS LIPS~LFIMG

LIPS_{VRKME LIKP}WADAT_IST LIKP_{KUNAG LIKP}KUNNR LIKP~VBELN

VBAP_{VBELN VBAP}MATNR VBAP_{NETWR VBAP}WAERK VBAP_{MWSBP VBAP}NETPR

VBAP_{POSNR VBUP}KOSTA VBUP_{WBSTA VBUP}FKSTA VBUP_{POSNR VBUP}VBELN

VBPA_{PARVW VBPA}VBELN VBUK_{CMGST VBUK}VBELN VBAK_{AUART VBAK}VBELN

INTO (WASTATUS-ERDAT , WASTATUS-VBELN , WASTATUS-POSNR ,

WASTATUS-VGPOS , WASTATUS-LFIMG , WASTATUS-VRKME ,

WASTATUS-WADAT_IST , WASTATUS-KUNAG ,WASTATUS-KUNNR ,

WASTATUS-LIKPVBELN , WASTATUS-VBAPVBELN , WASTATUS-MATNR ,

WASTATUS-NETWR , WASTATUS-WAERK , WASTATUS-MWSBP ,

WASTATUS-NETPR , WASTATUS-POSNR , WASTATUS-KOSTA , WASTATUS-WBSTA ,

WASTATUS-FKSTA , WASTATUS-VBUPPOSNR , WASTATUS-VBUPVBELN ,

WASTATUS-PARVW , WASTATUS-VBPAVBELN , WASTATUS-CMGST ,

WASTATUS-VBUKVBELN , WASTATUS-AUART , WASTATUS-VBAKVBELN )

FROM ( LIPS inner join LIKP

on LIKP_{VBELN = LIPS}VBELN

inner join VBAP

on VBAP_{VBELN = LIPS}VGBEL

and VBAP_{POSNR = LIPS}VGPOS

inner join VBUP

on VBUP_{POSNR = LIPS}POSNR

and VBUP_{VBELN = LIPS}VBELN

inner join VBPA

on VBPA_{VBELN = LIPS}VBELN

inner join VBUK

on VBUK_{VBELN = LIPS}VBELN

inner join VBAK

on VBAK_{VBELN = VBAP}VBELN )

WHERE

LIPS~VBELN in P_SVBELN

and LIPS~ERDAT in P_ERDAT

and LIKP~KUNAG in P_KUNAG

and LIKP~KUNNR in P_KUNNR

and VBAP~VBELN in P_PVBELN

and VBUP~KOSTA in P_KOSTA

and VBUP~WBSTA in P_WBSTA

and VBUP~FKSTA in P_FKSTA

and VBPA~PARVW in P_PARVW

and VBUK~CMGST in P_CMGST .

After INTO , there is a paranthesis. After this there should be NO space.

Hope this helps.

[Former Member]

Hi

Remove all the spaces after that Bracket..Then it will work..

Reward All Helpfull Answers...

[Former Member]

remove the all spaces in between (WASTATUS-ERDAT and WASTATUS-VBAKVBELN) after , (comma) only one space...

(WASTATUS-ERDAT, WASTATUS-VBELN, WASTATUS-POSNR not befor the , (comma)

regards

shiba dutta

[Former Member]

Hi.,

Ur problem is surely with spacing in into clasue:

check this standard codes and smake changes in ur statement accordingly specifally in INTO(......) clasue.

DATA wa TYPE spfli. 

SELECT carrid connid cityfrom cityto 
       FROM spfli 
       <b>INTO (wa-carrid, wa-connid, wa-cityfrom, wa-cityto).</b>   WRITE: / wa-carrid, wa-connid, wa-cityfrom, wa-cityto. 
ENDSELECT.

Jogdand M B

null

[carlos_zhang3]

sorry all ,

i already removed the space on my code like that :

but it still displayed the error .

SELECT LIPS~ERDAT

<b>*LIPS_{VBELN LIPS}POSNR LIPS_{VGPOS LIPS}LFIMG

*LIPS_{VRKME LIKP}WADAT_IST LIKP_{KUNAG LIKP}KUNNR LIKP~VBELN

*VBAP_{VBELN VBAP}MATNR VBAP_{NETWR VBAP}WAERK VBAP_{MWSBP VBAP}NETPR

*VBAP_{POSNR VBUP}KOSTA VBUP_{WBSTA VBUP}FKSTA VBUP_{POSNR VBUP}VBELN

*VBPA_{PARVW VBPA}VBELN VBUK_{CMGST VBUK}VBELN VBAK_{AUART VBAK}VBELN</b> FROM ( LIPS inner join LIKP

on LIKP_{VBELN = LIPS}VBELN

inner join VBAP

on VBAP_{VBELN = LIPS}VGBEL

and VBAP_{POSNR = LIPS}VGPOS

inner join VBUP

on VBUP_{POSNR = LIPS}POSNR

and VBUP_{VBELN = LIPS}VBELN

inner join VBPA

on VBPA_{VBELN = LIPS}VBELN

inner join VBUK

on VBUK_{VBELN = LIPS}VBELN

inner join VBAK

on VBAK_{VBELN = VBAP}VBELN )

INTO (WASTATUS-ERDAT)

<b>*WASTATUS-VBELN, WASTATUS-POSNR, WASTATUS-VGPOS,WASTATUS-LFIMG)

*WASTATUS-VRKME,

*WASTATUS-WADAT_IST, WASTATUS-KUNAG,WASTATUS-KUNNR,

*WASTATUS-LIKPVBELN, WASTATUS-VBAPVBELN, WASTATUS-MATNR,

*WASTATUS-NETWR, WASTATUS-WAERK, WASTATUS-MWSBP,

*WASTATUS-NETPR, WASTATUS-POSNR, WASTATUS-KOSTA, WASTATUS-WBSTA,

*WASTATUS-FKSTA, WASTATUS-VBUPPOSNR, WASTATUS-VBUPVBELN,

*WASTATUS-PARVW, WASTATUS-VBPAVBELN, WASTATUS-CMGST,

*WASTATUS-VBUKVBELN, WASTATUS-AUART, WASTATUS-VBAKVBELN )</b> WHERE

LIPS~VBELN in P_SVBELN

and LIPS~ERDAT in P_ERDAT

and LIKP~KUNAG in P_KUNAG

and LIKP~KUNNR in P_KUNNR

and VBAP~VBELN in P_PVBELN

and VBUP~KOSTA in P_KOSTA

and VBUP~WBSTA in P_WBSTA

and VBUP~FKSTA in P_FKSTA

and VBPA~PARVW in P_PARVW

and VBUK~CMGST in P_CMGST .

[Former Member]

as per your posted thread you are fetching two fields LIPS_{ERDAT and VBAK}VBELN but you are using only one field in into and where condition is commented as per your thread...just check that

one more thing if you are fetching one value then no need of ( )

select matnr from mara into itab-mara where....

SELECT LIPS~ERDAT 
*LIPS~VBELN LIPS~POSNR LIPS~VGPOS LIPS~LFIMG
*LIPS~VRKME LIKP~WADAT_IST LIKP~KUNAG LIKP~KUNNR LIKP~VBELN
*VBAP~VBELN VBAP~MATNR VBAP~NETWR VBAP~WAERK VBAP~MWSBP VBAP~NETPR
*VBAP~POSNR VBUP~KOSTA VBUP~WBSTA VBUP~FKSTA VBUP~POSNR VBUP~VBELN
*VBPA~PARVW VBPA~VBELN VBUK~CMGST VBUK~VBELN VBAK~AUART VBAK~VBELN FROM ( LIPS inner join LIKP
on LIKP~VBELN = LIPS~VBELN
inner join VBAP
on VBAP~VBELN = LIPS~VGBEL
and VBAP~POSNR = LIPS~VGPOS
inner join VBUP
on VBUP~POSNR = LIPS~POSNR
and VBUP~VBELN = LIPS~VBELN
inner join VBPA
on VBPA~VBELN = LIPS~VBELN
inner join VBUK
on VBUK~VBELN = LIPS~VBELN
inner join VBAK
on VBAK~VBELN = VBAP~VBELN )

INTO (WASTATUS-ERDAT, WASTATUS-VBAKVBELN)
*WASTATUS-VBELN, WASTATUS-POSNR, WASTATUS-VGPOS,WASTATUS-LFIMG)
*WASTATUS-VRKME,
*WASTATUS-WADAT_IST, WASTATUS-KUNAG,WASTATUS-KUNNR,
*WASTATUS-LIKPVBELN, WASTATUS-VBAPVBELN, WASTATUS-MATNR,
*WASTATUS-NETWR, WASTATUS-WAERK, WASTATUS-MWSBP,
*WASTATUS-NETPR, WASTATUS-POSNR, WASTATUS-KOSTA, WASTATUS-WBSTA,
*WASTATUS-FKSTA, WASTATUS-VBUPPOSNR, WASTATUS-VBUPVBELN,
*WASTATUS-PARVW, WASTATUS-VBPAVBELN, WASTATUS-CMGST,
*WASTATUS-VBUKVBELN, WASTATUS-AUART, WASTATUS-VBAKVBELN ) 
WHERE
LIPS~VBELN in P_SVBELN
and LIPS~ERDAT in P_ERDAT
and LIKP~KUNAG in P_KUNAG
and LIKP~KUNNR in P_KUNNR
and VBAP~VBELN in P_PVBELN
and VBUP~KOSTA in P_KOSTA
and VBUP~WBSTA in P_WBSTA
and VBUP~FKSTA in P_FKSTA
and VBPA~PARVW in P_PARVW
and VBUK~CMGST in P_CMGST . 

regards

shiba dutta

Message was edited by:

SHIBA DUTTA

[Former Member]

simply commas that u have there in workares as

WASTATUS-VGPOS WASTATUS-LFIMG WASTATUS-VRKME

WASTATUS-WADAT_IST WASTATUS-KUNAG WASTATUS-KUNNR

WASTATUS-LIKPVBELN WASTATUS-VBAPVBELN WASTATUS-MATNR

WASTATUS-NETWR WASTATUS-WAERK WASTATUS-MWSBP

WASTATUS-NETPR WASTATUS-POSNR WASTATUS-KOSTA WASTATUS-WBSTA WASTATUS-FKSTA WASTATUS-VBUPPOSNR WASTATUS-VBUPVBELN WASTATUS-PARVW WASTATUS-VBPAVBELN WASTATUS-CMGST WASTATUS-VBUKVBELN WASTATUS-AUART WASTATUS-VBAKVBELN

its enough

reward some points if helpful.

regards,

suresh babu aluri.

[sharadendu_agrawal]

Make sure that u give spaces after the opening bracket and then write something or u give the space before closing the bracket and then i suppose the query will wrk..

[Former Member]

Hi,

This is ur code

SELECT LIPS~ERDAT

*LIPS_{VBELN LIPS}POSNR LIPS_{VGPOS LIPS}LFIMG

*LIPS_{VRKME LIKP}WADAT_IST LIKP_{KUNAG LIKP}KUNNR LIKP~VBELN

*VBAP_{VBELN VBAP}MATNR VBAP_{NETWR VBAP}WAERK VBAP_{MWSBP VBAP}NETPR

*VBAP_{POSNR VBUP}KOSTA VBUP_{WBSTA VBUP}FKSTA VBUP_{POSNR VBUP}VBELN

*VBPA_{PARVW VBPA}VBELN VBUK_{CMGST VBUK}VBELN VBAK_{AUART VBAK}VBELN FROM <b>(</b>LIPS inner join LIKP

on LIKP_{VBELN = LIPS}VBELN

inner join VBAP

on VBAP_{VBELN = LIPS}VGBEL

and VBAP_{POSNR = LIPS}VGPOS

inner join VBUP

on VBUP_{POSNR = LIPS}POSNR

and VBUP_{VBELN = LIPS}VBELN

inner join VBPA

on VBPA_{VBELN = LIPS}VBELN

inner join VBUK

on VBUK_{VBELN = LIPS}VBELN

inner join VBAK

on VBAK_{VBELN = VBAP}VBELN<b>)</b>

INTO (WASTATUS-ERDAT)

*WASTATUS-VBELN, WASTATUS-POSNR, WASTATUS-VGPOS,WASTATUS-LFIMG)

*WASTATUS-VRKME,

*WASTATUS-WADAT_IST, WASTATUS-KUNAG,WASTATUS-KUNNR,

*WASTATUS-LIKPVBELN, WASTATUS-VBAPVBELN, WASTATUS-MATNR,

*WASTATUS-NETWR, WASTATUS-WAERK, WASTATUS-MWSBP,

*WASTATUS-NETPR, WASTATUS-POSNR, WASTATUS-KOSTA, WASTATUS-WBSTA,

*WASTATUS-FKSTA, WASTATUS-VBUPPOSNR, WASTATUS-VBUPVBELN,

*WASTATUS-PARVW, WASTATUS-VBPAVBELN, WASTATUS-CMGST,

*WASTATUS-VBUKVBELN, WASTATUS-AUART, WASTATUS-VBAKVBELN<b>)</b> WHERE

LIPS~VBELN in P_SVBELN

and LIPS~ERDAT in P_ERDAT

and LIKP~KUNAG in P_KUNAG

and LIKP~KUNNR in P_KUNNR

and VBAP~VBELN in P_PVBELN

and VBUP~KOSTA in P_KOSTA

and VBUP~WBSTA in P_WBSTA

and VBUP~FKSTA in P_FKSTA

and VBPA~PARVW in P_PARVW

and VBUK~CMGST in P_CMGST .

Now notice the bold brackets.

Remove the spaces.

Hope it helps.

Thanks

Message was edited by:

Pritha Agrawal

[carlos_zhang3]

Thanks everybody .

i was solved the problem .

now i attach the code , please pay a attention the <b>Black</b> Code :

select lips_{erdat lips}vbeln lips_{posnr lips}vgpos lips~lfimg

lips_{vrkme likp}wadat_ist likp_{kunag likp}kunnr likp~vbeln

vbap_{vbeln vbap}matnr vbap_{netwr vbap}waerk vbap_{mwsbp vbap}netpr

vbap_{posnr vbup}kosta vbup_{wbsta vbup}fksta vbup_{posnr vbup}vbeln

vbpa_{parvw vbpa}vbeln vbuk_{cmgst vbuk}vbeln vbak_{auart vbak}vbeln

into

<b>(wastatus-erdat</b> , wastatus-vbeln , wastatus-posnr ,

wastatus-vgpos , wastatus-lfimg , wastatus-vrkme ,

wastatus-wadat_ist , wastatus-kunag , wastatus-kunnr ,

wastatus-likpvbeln , wastatus-vbapvbeln , wastatus-matnr ,

wastatus-netwr , wastatus-waerk , wastatus-mwsbp , wastatus-netpr ,

wastatus-vbapposnr , wastatus-kosta , wastatus-wbsta , wastatus-fksta ,

wastatus-vbupposnr , wastatus-vbupvbeln , wastatus-parvw ,

wastatus-vbpavbeln , wastatus-cmgst , wastatus-vbukvbeln ,

wastatus-vbakauart , <b>wastatus-vbakvbeln)</b>from (

lips inner join likp

on likp_{vbeln = lips}vbeln

inner join vbap

on vbap_{vbeln = lips}vgbel and vbap_{posnr = lips}vgpos

inner join vbup

on vbup_{posnr = lips}posnr and vbup_{vbeln = lips}vbeln

inner join vbpa

on vbpa_{vbeln = lips}vbeln

inner join vbuk

on vbuk_{vbeln = lips}vbeln

inner join vbak

on vbak_{vbeln = vbap}vbeln ).