Skip to Content
0
Former Member
Dec 29, 2007 at 04:58 PM

unable to display selected range of vendor numbers in the output list

46 Views

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&regards,

mallika