How to get Accounting document number from billing document number

[Former Member]

Hi,

How to get Accounting document number from billing document number i.e. from VBAK- VBELN.

Cheta Pant

[Former Member]

Thanks for your all help

[Former Member]

Hi,

VBAK is the Sale Order header table, Billing document table is VBRK.

Sales tables (VBAK,VBAP,VBRP,VBRK) do not store accounting document numbers.

You do other way around. Just go to SE16 and enter the Billing document number in field Billing document VBELN in BSEG or BSID or BSAD table and execute, you will find the accounting document number.

If you just want collect this information once then you can use table BSEG, but if you think to develope a report then use table BSID and BSAD.

Regards,

Chintan Joshi

[Former Member]

You can also get the accounting document number from table BKPF, where the reference pocedure is RBKP and object key is billing document number

The query on BKPF will be more efficient (Less time consuming) then query on BSEG

Regards,

Gaurav