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 entrieswhere vgart= we only.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').