Solved: HOW to get to MIgo through MIRO

nbarboza · ‎2022 Apr 07

Hi,

I'm doing a report, where I need to tie the MIRO to the MIRO, which field do I use in the MIRO to know what her MIGO is?

I'm using EKBE as a base for select.

Grateful.
Neemias.

DominikTylczyn · ‎2022 Apr 08

Hello nbarboza

First of all, a link between an invoice and a goods receipt is only available directly if GR based invoice verification is active for the purchase order item:

Then you can read the link from PO history table EKBE. EKBE records where VGABE = 2 are invoice receipts. Corresponding goods receipt items are stored in LFGJA, LFBNR, LFPOS.

Best regards

Dominik Tylczynski

Jeansy · ‎2022 Apr 07

Can you please share some code?

I did not understand what you try to achieve.

KR Jens

DominikTylczyn · ‎2022 Apr 08

Hello nbarboza

First of all, a link between an invoice and a goods receipt is only available directly if GR based invoice verification is active for the purchase order item:

Then you can read the link from PO history table EKBE. EKBE records where VGABE = 2 are invoice receipts. Corresponding goods receipt items are stored in LFGJA, LFBNR, LFPOS.

Best regards

Dominik Tylczynski

nbarboza · ‎2022 Apr 10

Thank you all,

Dominik Tarczynski, I managed to parse the value of the VGABE field.

Grateful. Nehemiah.