Skip to Content
0
Former Member
May 30, 2008 at 03:54 AM

Problem in select query

26 Views

Hi

This is my query

select aebeln alifnr awaers abukrs

bebelp bmatnr bnetpr bnetwr

cvbeln cvbelp

dvrkme dbmeng d~etenr

evbeln eposnr e~netwr

  • fkunag fwaerk fvkorg ffkdat

  • ibelnr iwrbtr igjahr ishkzg

  • jbudat jwaers jstblg jstjah

  • j~blart

into ( int_master-ebeln, int_master-lifnr, int_master-waers, int_master-bukrs, int_master-ebelp

int_master-matnr, int_master-netpr, int_master-netwr, int_master-vbeln, int_master-vbelp,

int_master-vrkme, int_master-bmeng, int_master-etenr, int_master-e_vbeln, int_master-posnr ,

int_master-e_netwr )

from ( ( ( ( ekko as a

inner join ekpo as b on aebeln = bebeln )

inner join ekkn as c on cebeln = bebeln and

cebelp = bebelp )

inner join vbep as d on dvbeln = cvbeln and

dposnr = cvbelp and

d~wepos = 'C' )

inner join vbrp as e on eaubel = cvbeln and

eaupos = cvbelp )

where a~ebeln in so_ebeln and

a~bsart in so_bsart and

a~bedat in so_bedat and

a~bukrs eq p_bukrs and

a~lifnr eq p_lifnr.

endif.

And i am getting a error like Comma without preceding colon (after SELECT ?).

Can any one help me in this??

Arun