AP register report with PO and related invoices

[Former Member]

Hi SAP gurus,

Business wants a AP register report, listing all processed invoices related to a PO.

Basically they want to see the PO no. and invoices on the same report.

I have tried to find a std report but couldnt. Please suggest if there is any such report or if not how I can get it thru may be SAP query. Also please give me step by step procedure to right a SAP query.

Thanks a million, in advance. I will reward point promptly.

[former_member188826 · Accepted solution]

What is the purpose of this report. There are multiple invoices possible for every item in the PO. These are visible in the PO History.

EKBE is the table, you may play around the PO history category to get various invoices.

[Former Member]

If you want to do this from Finance an idea is to make sure the PO number is being written to the assignment field of the Vendor line item.

This can be done simply by making the correct selection for the sork key of the recon account for Vendors.

Once you are happy that the PO number is being added into the field, you can run an open item report per Vendor and sub total it by Assignment, thus giving you a break down by PO number.

Please award points if this is helpful.