topic Fields that relate Billing documents in Application Development and Automation Discussions

Fields that relate Billing documents

Former Member — Thu, 25 Jan 2007 19:44:15 GMT

Hello, I need to construct a list of all billing documents that I choose and to obtain the sales order, delivery and accounting documents linked to this billing document.

Can anyone tell me which fields in the tables relate them? I need to do something simmilar to the doccument flow

TIA

Re: Fields that relate Billing documents

Former Member — Thu, 25 Jan 2007 19:46:20 GMT

Hi Scott,

Query on VBRP table which has fields gives us information about Sales order and Delivery.

VBRP-VGBEL - Delivery document number

VBRP-VGPOS - Line item of Delivery document

VBRP-AUBEL - Sales document number

VBRP-AUPOS - Line item of Sales document

Otherwise, You can query on VBFA table

Give invoice number to VBFA-VBELN and get the Sales order and Delivery numbers into field VBELV.

Specify VBTYP_V = 'C' to get Sales order and

Specify VBTYP_V = 'J' to get delivery numberr.

Thanks,

Vinay

Re: Fields that relate Billing documents

Former Member — Thu, 25 Jan 2007 19:48:09 GMT

Hi,

1) Link to Sales document.

VBRP-AUBEL = VBAP-VBELN.

VBRP-AUPOS = VBAP-POSNR.

2) Link to Delivery document.

VBRP-VGBEL = LIPS-VBELN.

VBRP-VGPOS = LIPS-POSNR.

3) Link to accounting document.

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

Thanks,

Naren

Re: Fields that relate Billing documents

Former Member — Thu, 25 Jan 2007 19:59:57 GMT

Check this link for SD Tables and their relationships:

http://www.erpgenie.com/abap/tables_sd.htm

Thanks,

Santosh