Hi Forum,
If i select particular range of vendor numbers(lifnr) in selection screen, the whole list of vendor numbers displaying in the output list. I'm not getting this problem if i use inner join. Pls help me out why im unable to display the range what i choose in the selection screen.............
Report ven_dors.
tables : bsik , bsak.
data : begin of itab1 occurs 0,
lifnr like bsik-lifnr, "vendor numbers
end of itab1.
data : begin of itab2 occurs 0,
bukrs like bsak-bukrs,
end of itab2.
data : begin of itab3 occurs 0,
lifnr like itab1-lifnr,
bukrs like itab2-bukrs,
end of itab3.
select-options : s_lifnr in bsik-lifnr.
*select-options : s_lifnr in itab1-lifnr.
select * from bsik into corresponding fields of itab3 for all entries in itab1 where lifnr =itab1-lifnr and
lifnr in s_lifnr.
select * from bsak into corresponding fields of itab3 for all entries in itab2 where bukrs =itab2-bukrs.
loop at itab3.
write : / itab3-lifnr, itab3-bukrs.
endloop.
thanks®ards,
mallika