report

[Former Member]

: The base list consist of the table ?Vendor Master? and I need to use checkbox to get the related data from Purchasing Document Header based on ?Vendor Account No.? and then third screen to generate related data of ?Purchasing Document Header?. how to do? pls help

[Former Member]

First list to be displayed w.r.t details from LFM1.

Display list with Check boxes. - <b>Display Vendor Numbers</b>

For the selected vendors, extract PO details from EKKO using ekorg = p_ekorg and lifnr in (selection from basic list) - <b>Display PO Numbers</b>

For selected PO display the details of PO i.e already extracted. - <b>Display PO Details</b>

Just two selections, one from LFM1 and another from EKKO & EKPO if necessary.

Hope this helps you.

Kind Regards

Eswar

[Former Member]

Hi,

go to ekpo-lifnr = lfa1-lifnr to get purchase items

details tan use ekpo-ebeln = ekko-ebeln to get

purchase order header

select a_{ebeln a}ebelp a~lifnr into

table i_ekko from ekpo as a

inner join ekko as b

on a_{ebeln = n}ebeln

for all entries in itab

where b~lifnr = itab-lifnr.

regards

amole