Tables linking the invoice and accounting document

[Former Member]

Hi,

Can anyone tell me tables linking the invoice and accounting details table BSEG?

Regards,

Shanu

[Former Member · Accepted solution]

HI,

VBRK-BELNR = BSEG-BELNR

Regards

raj.

[Former Member · Accepted solution]

Thank you Venky but in VBRK the field BELNR is not populating for our client so can you let me know any other table which can link up with BSEG?

Regards,

Shanu

[Former Member · Accepted solution]

Dear Shanu,

Goto the table BKPF(SE16).In that table in the field AWKEY (Reference key) give the billing document number(SD).Excecute

You will get the accounting number in the field BELNR(Document number).

. In the other way round ie form accounting document to billing document we can use the table BSEG itself.

Hope this answers your query.

Regards,

Nithin.

[Former Member · Accepted solution]

Hi,

Your client might have not checked properly.In both BSEG and VBRK, BELNR field is present.

Regards

Vadiraj

[Former Member · Accepted solution]

Hi,

VBRK-VBELN=BSEG-VBELN

Regards

raj.

[former_member566877]

Hi,

SAP has provided index tables for Customers for Accounting. BSID and BSAD and it recommends to use these tables for reporting as performance improvement measure. You can link BSID-BELNR or BSID-VBELN to VBRK.

Thanks

Krish.

[Lakshmipathi]

Following BSEG fields can be found in VBRK

MANDT

BUKRS

BELNR

GJAHR

ZUONR

VBUND

VBELN

ZTERM

ZLSCH

BVTYP

MSCHL

MANSP

MABER

STCEG

XEGDR

KKBER

KIDNO

BUPLA

Similarly following fields can be found in VBRP

MANDT

VBELN

thanks

G. Lakshmipathi

[Former Member]

Hi,

In the BKPF table you can find the ACCOUNTING DOCUMENT and the INVOICE number

BKPF-BELNR and BKPF- AWKEY are the fields for the accont document and invoice respectively

please check and revert bck if u need more details

thanks,

santosh