topic Re: Problem in where clause in Application Development and Automation Discussions

Problem in where clause

Former Member — Mon, 21 Apr 2008 08:54:23 GMT

Hi all,

Can anybody tell me what is the problem in my where clause. Showing error

Comma without preceding colon (after LOOP ?).

loop at main_table1 where bwart IN('105','104').

loop at i_mkpf where mblnr = i_mseg-mblnr and

mjahr = i_mseg-mjahr.

main_table1-budat = i_mkpf-budat.

append main_table1.

clear main_table1.

endloop.

Definitely rewards points.

Best regards,

Aastha

Re: Problem in where clause

Former Member — Mon, 21 Apr 2008 08:58:18 GMT

here in operator is not supported

loop at main_table1 where bwart = '105'

and bwart = '104'.

loop at i_mkpf where mblnr = i_mseg-mblnr and

mjahr = i_mseg-mjahr.

main_table1-budat = i_mkpf-budat.

append main_table1.

clear main_table1.

endloop.

loop at main_table1

case main_table1-bwart

when '105'

loop at i_mkpf where mblnr = i_mseg-mblnr and

mjahr = i_mseg-mjahr.

main_table1-budat = i_mkpf-budat.

append main_table1.

clear main_table1.

endloop.

endcase.

Re: Problem in where clause

Former Member — Mon, 21 Apr 2008 09:00:26 GMT

give spaces between the operators

eg, IN ( '105' , '104' ).

as always,

Re: Problem in where clause

Former Member — Mon, 21 Apr 2008 09:01:34 GMT

Hi,

Change the where clause in loop statement to

WHERE bwart = '105' AND bwart = '104'.

Reward points if helpful.

Regards,

Ramya

Re: Problem in where clause

Former Member — Mon, 21 Apr 2008 09:52:15 GMT

Hi,

create a range for bwart and fill it accordingly.

Then you can:

loop at itab into wa where bwart in range.

endloop.

Cheers,

Raymond