topic Re: Problem in select query in Application Development and Automation Discussions

Problem in select query

Former Member — Fri, 30 May 2008 03:54:41 GMT

This is my query

select a_{ebeln a}lifnr a_{waers a}bukrs

b_{ebelp b}matnr b_{netpr b}netwr

c_{vbeln c}vbelp

d_{vrkme d}bmeng d~etenr

e_{vbeln e}posnr e~netwr

f_{kunag f}waerk f_{vkorg f}fkdat
i_{belnr i}wrbtr i_{gjahr i}shkzg
j_{budat j}waers j_{stblg j}stjah
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 a_{ebeln = b}ebeln )

inner join ekkn as c on c_{ebeln = b}ebeln and

c_{ebelp = b}ebelp )

inner join vbep as d on d_{vbeln = c}vbeln and

d_{posnr = c}vbelp and

d~wepos = 'C' )

inner join vbrp as e on e_{aubel = c}vbeln and

e_{aupos = c}vbelp )

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

Re: Problem in select query

Former Member — Fri, 30 May 2008 04:17:52 GMT

This error will come when feild what u r selecting and fields where u r inerting ,are not matching .

and r not declared .

also try to remove '(' .

will work

Re: Problem in select query

Former Member — Fri, 30 May 2008 10:55:20 GMT

Hi,

Try this.............

*************************************************

tables: ekko.

select-options: so_ebeln for ekko-ebeln,

so_bsart for ekko-bsart,

so_bedat for ekko-bedat.

parameters: p_bukrs type ekko-bukrs,

p_lifnr type ekko-lifnr.

data: begin of int_master occurs 0,

ebeln type ekko-ebeln,

lifnr type ekko-lifnr,

waers type ekko-waers,

bukrs type ekko-bukrs,

ebelp type ekpo-ebelp,

matnr type ekpo-matnr,

netpr type ekpo-netpr,

netwr type ekpo-netwr,

vbeln type ekkn-vbeln,

vbelp type ekkn-vbelp,

vrkme type vbep-vrkme,

bmeng type vbep-bmeng,

etenr type vbep-etenr,

e_vbeln type vbrp-vbeln,

posnr type vbrp-posnr,

e_netwr type vbrp-netwr,

end of int_master.

select a_{ebeln a}lifnr a_{waers a}bukrs

b_{ebelp b}matnr b_{netpr b}netwr

c_{vbeln c}vbelp

d_{vrkme d}bmeng d~etenr

e_{vbeln e}posnr e~netwr

into int_master from ( ( ( ( ekko as a

inner join ekpo as b on a_{ebeln = b}ebeln )

inner join ekkn as c on c_{ebeln = b}ebeln and

c_{ebelp = b}ebelp )

inner join vbep as d on d_{vbeln = c}vbeln and

d_{posnr = c}vbelp and

d~wepos = 'C' )

inner join vbrp as e on e_{aubel = c}vbeln and

e_{aupos = c}vbelp )

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.

endselect.

******************************************************

Reward if helpful.

Regards,

Syed.

Re: Problem in select query

Former Member — Mon, 02 Jun 2008 11:29:31 GMT

Thanks