Skip to Content
0
Former Member
Jul 03, 2007 at 01:45 PM

How to fetch vendors corresponding to particular plant

53 Views

how to get all the vendors corresponding to plant 4014 where purchase oragnisation is 1000.i fetched all the vendors from LFB1 and LFM1..

select a~lifnr

a~bukrs

b~ekorg

INTO TABLE t_vendor

FROM lfb1 AS a INNER JOIN lfm1 AS b

ON alifnr = blifnr

WHERE a~bukrs EQ p_bukrs

AND b~ekorg = c_1000.