Table for link between Accounting document and Billing document

[Former Member]

Which is the table for link between Accounting document and Billing document ?

Thanks & Regards

[jiteshmehta · Accepted solution]

Hi Sagar

Billing tables are VBRK for header and VBRP for item

VBFA is table for Document flow

BKPF and BSEG are accounting document

you should try to pickup link from VBFA, it is good table , with proper indexing and few field subsequent document is accounting document and preceeding document is billing document

Regards

Jitesh

[Former Member · Accepted solution]

Ø Go to SE16N, enter table BSAD

Ø In the Reference Field (VBELN) enter the Billing Document no.

Tips:

Ø Make sure that only those billing documents will be considered whose accounting documents actually exists

Ø No Accounting documents will be displayed for Credits, Free of charge orders and those acc. Documents which have been cancelled.

[former_member204513]

Hi Sagar,

Through these tables you can have link with accounting document and billing document.

BSEG

BKPF

I hope it will help you,

Regards,

Murali.

Edited by: Murali Mohan.Tallapaneni on Jun 11, 2008 2:00 PM