How to find an MM invoice through the FI accounting document?

[dev_parbutteea]

Hi, in the table BKPF i have the accounting document of type FX .I wish to find the MM document associated to it( document created in MIRO)

[Former Member]

check the table RSEG

[former_member182371]

Hi,

BKPF-AWKEY holds the invoice verification document number (and year).

Best regards.

[GauthamV]

hi,

use this.

SELECT belnr

awkey

INTO TABLE it_bkpf

FROM bkpf

FOR ALL ENTRIES IN it_mkpf

WHERE awkey = it_mkpf-awkey.