Skip to Content

MM Invoice and relevant FI document number details

Dear experts,

Can some one help me how to link the MM Invoice number and FI document number. We are developing a report where

I need to find the relvant FI document number for an Invoice document (MM).

Can some one provide me the table details where I can find these details.

Regards,

Krish

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 21, 2011 at 01:51 PM

    HI,

    Use table BKPF there input document type "RE" and then use field AWKEY i.e. Reference Key, it contains MIRO Document No with Fiscal Year.

    That is if your LIV document is say 5605100011 and fiscal year is 2011 AWKEY is 56051000112011

    You will get the Accounting document number (BKPF -BELNR and year BKPF- GJAHR) for your LIV document

    Edited by: redriver on Dec 21, 2011 3:14 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 21, 2011 at 01:53 PM

    Link Tables: EKBE, BKPF, BSEG, BSAK & BSIK

    EKBE- get Invoice document,

    BSEG & BKPF- FI document details

    BSAK & BSIK- Payment details

    Umakanth R

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 21, 2011 at 04:32 PM

    Go to MIR4 and enter your invoice number and year

    Click on follow on documents and that document number is FI related

    Srinivas

    Add comment
    10|10000 characters needed characters exceeded