Cross reference MM document number and FI document number?

[andrew_jacobs2]

Hello,

Is there a table that contains both the MM document number (MBLNR) and FI document number (BELNR_D) so I can cross reference these numbers?

If not, how can I get this via a SQL join?

Thx.

Andy

[ferry_lianto · Accepted solution]

Hi,

Please check table MSEG for field MBLNR and BELNR.

Regards,

Ferry Lianto

[jack_graus2]

For a material document in table MKPF you can find the accounting document in table BKPF on BKPF-AWTYP = 'MKPF' and BKPF-AWKEY = MKPF-MBLNR & MKPF-MJAHR.

regards Jack