topic Re: report in Application Development and Automation Discussions

report

Former Member — Tue, 03 Oct 2006 09:55:23 GMT

: 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

Re: report

Former Member — Tue, 03 Oct 2006 10:17:59 GMT

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

Display list with Check boxes. - Display Vendor Numbers

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

For selected PO display the details of PO i.e already extracted. - Display PO Details

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

Hope this helps you.

Kind Regards

Eswar

Re: report

Former Member — Tue, 03 Oct 2006 10:25:03 GMT

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