Looking for report to list PO Numbers from a set of Invoice documents

[Former Member]

Hi all,

It's my first post at SCN, sorry if it's in wrong place.

I need a standard report to show the PO Numbers from a set of Invoice documents, I can do the reverse with the ME80FN (show the Invoices with a set of PO Numbers).

Can anyone help me please?

Thanks

[former_member201529 · Accepted solution]

Dear Rodrigo,

There is no standard report to find PO and Invoice combination directly, in RSEG table you can get the invoice document (BELNR) by passing PO number in EBELN.

Else get the help from ABAPers and develop custom report.

Regards,

Karna J

[Former Member · Accepted solution]

It's bad.

I think its a very simple relationship, why SAP don't have this as standard?

One option is to get the PO Number from the FI Doc Number from an Invoice, its possible? I can do it direct on FBL1N?

[former_member201529 · Accepted solution]

Dear Rodrigo,

Well and good if the PO number will take it from FBL1N...

Regards,

Karna J

[Former Member · Accepted solution]

Hi Schiavo,

You have PO.NO field in FBL1N report but it is not in active state to activate this field you have to run standard BTE  00001650.

OR

Second option you can go with your own Z report using of RSEG , RKPF,EKKO,EKPO tables.

Thanks & Regards,

Anjali.p

Message was edited by: p anjali

[former_member183424 · Accepted solution]

You need to take the FI accounting document number with regards to the invoice, then you need to fetch the PO number with regards to the FI accounting document number.

I think it would be the lengthy process than fetch the PO number with regards to the invoice number from RSEG table.

FBL1N will give you the PO number with regards to the accounting document number not the invoice document number..

[Former Member]

Thanks all for help.

I solved my problem with FBL1N, but I look into the FBL3N and it will work too.

Very thank you.

[raviraj_sharma]

FBL3N  has the info.   SAP note 152335 explains some limitations of FBL1N for this field.

Check the below threads:

[former_member198650]

Hi,

There is a report MIR5 is there for invoice details. But you cannot get purchase order details. So you have to create a query by linking the tables RBKP & RSEG.

Regards,

Mukthar

[Former Member]

Thank you, I know MIR5, it not shows what I need and I can't create querys.

I need a Standard report or transaction to do this.