Skip to Content
Former Member
Dec 18, 2006 at 10:44 PM

Report: Fetching data more time



My report is facing the performance issue. Actually for a PO I am getting the BELNR from the EKBE. for all the BELNR in EKBE where BWTYP = 'Q'. I need to get the Invoice No. This I am fetching from BKPF based on AWKEY as input. When I saw in debug mode I found that fetching data from BKPF is taking much more time. Here to get the data from BKPF I am giving only input AWKEY (EKBE-BELNR + GJAHR). I am able to find the correct keys to get the invoice details. Is there any other table which maintain Invoice document No. and invoice posting data. or can i tune my report. Please help.