PO detail report

[Former Member]

Hi Gurus,

My client want to have a report which tells us the PO number and its corresponding GRNs and the invoice verification number for the GRN.Also he wants a excise document captured against a GDN in the report.

Is there is any stanadard report available in SAP.

Waiting for an earliest reply.

Regards,

Abhi.

[Former Member · Accepted solution]

Hi Abhinandan,

U will have to create a customised report with the help of an ABAPer.

Regards,

Kiran

[former_member1005784]

Hi,

You can find it all details by sap table 'EKBE' . This is PO history table and will full fill your wish.

With considering this table you can develop Z report with help of ABAPER which will exactly meet your requirement.

Dhananjay Singh.

[Former Member]

Hi,

Put PO number and line item in fields EBELN and EBELP respectively in MSEG table and then extract unique MBLNR with corresponding MJAHR. This will give you GR done for the PO

Then input those MBLNR and MJAHR in RSEG table in fields LFBNR and LFGJA and extract BELNR and GJAHR corresponding to each and then concatenate both (BELNR and GJAHR) to input the same in BKPF table and extract BUKRS, BELNR and GJAHR corresponding to it. This will give MIRO document against each GR document.

Now input these extracted BUKRS, BELNR and GJAHR in BSAK table, and extract AUGBL against each. If there is not entry existing in BSAK table, payment not received (keeping the fact that payment received means we clear the pending invoice entry as well). If entry exists, then either partial payment has been received or full payment has been received. For this will check the amount passed in the AUGBL document and in BELNR document and if both matches, then full payment else partial payment

assign points if helpfull.

Regards

Aditya

[Former Member]

Thanks

[Former Member]

you will get this details through Tables

the tables name is RSEG , P.O number, GRN Number & IV Number (MIRO Document Number)

Regards

Akmal