Table for Invoice accounting doc

[former_member565100]

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.

[Former Member · Accepted solution]

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

[Former Member]

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.

[Former Member]

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?

[Former Member]

Hi,

Please check

VBFK for Invoicing header

VBFP for Invoicing detail

Regards,

SMuvva

[former_member565100]

I checked in se11-it says does not exist the below tables.

VBFK for Invoicing header

VBFP for Invoicing detail

Please suggest.