invoice is booked for purhcase order

[Former Member]

Hi,

i should develop some report which depends on information if for concrete purchase order is invoice booked. I dont know exactly what means booking of invoice? what it can be? and which tables plays role in this task?

thanks

JJ

[Former Member]

Hi,

Pls post your query clearly,

regards,

mahesh

[former_member195032]

Hi Jiri,

From your information ,it is not clear that you want this in SRM system or in ERP system.I donot have any information on Technical scenario in SRM system.

If you want to know Invoice Number booked for a particular PO,Use SAP given FM

BBP_BE_PO_GETHISTORY and pass PO number (I_OBJECT_ID) and logical system (I_LOG_SYSTEM) and .

E_ITEM_HISTORY table will give you invoice number .

Based on above logic you can develop your report.

Regards,Nishant

[Former Member]

Thanks a lot for your answer.

I am using extended classic scenario(i hope:).

The report should run in ERP system. Where is the invoice nb in e_item_history? why it is in history?

thanks

JJ

[former_member195032]

Hi Jiri,

Use the transaction me87 in backend R/3 System.

I have talked about History as PO history gets updated at item level once GR and Invoicing is done for a particular line item.

Run this transaction ME87 with suitable parameter and it will give you the results which you are trying to achieve through custom report.

Once you run this report you will get PO history record record number of history line items like GR and Invoicing with their number.

Regards,Nishant

Please reward if this helps.