Skip to Content

Table for Invoice accounting doc

I have got the invoice number posted in MIRO,i need to get the accounting document number generated for this invoice number.

Can any one please let me know th etable where i could give the the invoice number posted in MIRO and get accounting doc generataed for it.I need to pass invoice number posted in MIRO and get the accounting doc.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 15, 2009 at 02:03 PM

    Hi,

    Table BKPF will help you...

    BELNR = Accounting document number

    AWKEY = Object Key which is nothing but Material Doc no + Fiscal year

    From SE16, select table BKPF

    In the field AWKEY (Object Key), give the material doc number+fiscal year ( for example, 50000000002009)

    Execute.

    You will get the corresponding accounting doc number

    Regards,

    Mike

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 15, 2009 at 01:40 PM

    Hi,

    Please check

    VBFK for Invoicing header

    VBFP for Invoicing detail

    Regards,

    SMuvva

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 15, 2009 at 01:55 PM

    Are you saying that you want to be able to take the actual invoice number received from a vendor and track it back to the accounting document? Would that invoice number be keyed in the reference number field on the basic data tab in MIRO?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 15, 2009 at 02:05 PM

    If you go to SE16 and view table BKPF, the field that has the reference number from the MIRO basic data screen is XBLNR. You can search for the invoice number using that field.

    Add comment
    10|10000 characters needed characters exceeded