How To Get Accounting Document Number From Billing Document Number

Find out what's the link between billing document table and accounting document table

Published Jun 25, 2021

The Sales Invoice and Accounting document are linked through the Object Key from the Accounting Document Header table and the Billing Document number from the Billing Document Header Data table.

Table VBRK (Billing Document: Header Data) is linked to table BKPF (Accounting Document Header) through the fields BKPF-AWKEY (Object key) and BKPF-AWTYP (Ref. procedure).

The Reference procedure field BKPF-AWTYP must be set to 'VBRK'.

Link Between Billing Document And Accounting Document

BKPF-AWTYP = 'VBRK'
BKPF-AWKEY = VBRK-VBELN