MIR7 Park Invoice - where is PO number stored?

[Former Member]

Hi all,

When registering an invoice in transaction MIR7, I can enter one or more PO numbers in the field "Purchase Order/Scheduling Agreement" on the "PO Reference" tab. If I temporary save the invoice, then in which table is the link between the Invoice No. and the PO numbmer stored?

All invoices appear in table RBKP, but not always in table RSEG (which contains the PO number).

Same goes for EKBE, it contains quite a few of the invoices, but not all of them.

Your help is much appreciated!

Kind regards,

Bas

[Former Member · Accepted solution]

Bas,

You should find the PO numbers for the parked invoices in table RBSELBEST or RSEG. If the invoice is for a service entry sheet, you can can the SES number from table RBSELERFB and then subsequently get the PO number from table ESSR.

You will not have entries in RSEG only if you park the invoice without any item reference. In this case, you will not have a PO number associated with the invoice.

Hope this helps.

H Narayan

[Former Member · Accepted solution]

Thanks, problem solved!

Table RBSELBEST contained the PO numbers I was looking for.

Regards,

Bas