cancel
Showing results for 
Search instead for 
Did you mean: 

Link between MIGO and MIRO documents

murugesan_r
Participant
0 Kudos

Hi,

My client posts one invoice for every goods receipt. However, there are multiple goods receipts for one PO. Now, I need to relate an invoice to goods receipt meaning, I want to be able to find the GR document with reference to the invoice document. Which table and field enable this link?

Muru

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi you can go to EKBE table(purchase order history table here you will get the you invoice document purchase order etc)

an dcontrol purpose item category as 2 select it it means invoice is completed. I think so your problem will solve. still if you need further details let me know.

Former Member
0 Kudos

Yes, in table EKBE if you put in PO HIstory Category (BEWTP) = Q you can see all your posted Invoices. If you have your POs set to GR-Bsd IV then the Reference field (LFBNR) will populate with the GR number.

iklovski
Active Contributor
0 Kudos

Hi,

Invoices (MIRO) are in RSEG table (RBKP for header), GR (MIGO) are in MSEG (MKPF for header).

Regards,

Eli