Skip to Content
0
Former Member
Jul 30, 2007 at 11:47 AM

please correct this code

19 Views

Hello Experts please solve this

select mblnr into table itab1

from mkpf

where budat in s_budat

and vgart = 'WE'.

select mblnr into table itab2

from mkpf

where budat in s_budat

and vgart = 'WO'.

I modified the above query as

select mblnr into table itab1

from mkpf

where budat in s_budat

and ( vgart = 'WE'or vgart = 'WO').

Now please tell me how to modify the below query because we have to select data only from itab1 entries.But in above we selected vgart = 'wo' into itab1.

select mblnr matnr bwart menge into table lt_menge

from mseg

for all entries in itab1.

where mblnr = lt_we-mblnr

and matnr = it_temp-matnr

and werks = p_werks

and bwart in ('501', '502').