[Arthur.ntagarama]

Hi,

How can i generate the report which show date of PR link with LPO till to GRN or posting of Payment.

Thanks

[Edward T]

Hi Arthur,

You can create a query or simple report program for this purpose. The tables you will need are :
PR data can get from EBAN
PO data can get from EKKO + EKPO
GR data can get from MKPF + MSEG
IR data can get from RBKP + RSEG
And PO history from EKBE

The logic should follow this:

1. SELECT BANFN, BNFPO, LFDAT, FRGDT, EBELN, EBELP, …
FROM EBAN

2. SELECT EBELN, EBELP, AEDAT, …
FROM EKKO INNER JOIN EKPO
WHERE EKKO~EBELN = EBAN~EBELN
AND EKPO~EBELP = EBAN~EBELP

3. SELECT EBELN, EBELP, VGABE, BELNR, BUZEI, BUDAT,…
FROM EKBE
WHERE EBELN = EKKO~EBELN
AND EBELP = EKPO~EBELP

4. If you need details for GR then
get from MKPF + MSEG
Where MKPF~MBLNR = EKBE~BELNR
and MKPF~MJAHR = EKBE~GJAHR
and MSEG~ZEILE = EKBE~BUZEI
(for EKBE~VGABE = ‘1’)

5. If you need details for Inv Receipt then
get from RBKP + RSEG
Where RBKP~BELNR = EKBE~BELNR
and RBKP~GJAHR = EKBE~GJAHR
and RSEG~BUZEI = EKBE~BUZEI
(for EKBE~VGABE = ‘2’)

Thanks,
Edward

• This reply was modified 5 years, 3 months ago by Edward T.

[Arusi kumari]

To generate a report from SAP, you need to follow a few steps. First, navigate to the Definitions → Reports section and choose “New” from the context menu. On the Report tab, fill in a name into the Name field and choose a filter name in the query. Then, enter the Directory, File Name and click “Generate” to create the report. Once the report is generated, it must be saved. Z reports are created when the client’s reporting requirement cannot be fulfilled with the SAP standard report. In such cases, a functional consultant’s role is to create the Z report to meet the specific requirements of the client.

[Author]

Posts