Hi,
VBRP and BSID are not directly linked. But it is possible to find out any value in BSID if you know the biling document number.
Lemme explain teh process to you here.
When an invoice is created, VBRK adn VBRP are updated in SD (I m neglecting other SD tables like VBPA). It creates an accounting document simultaneously. The account document header is updated in the table BKPF and the item is updated in BSEG. When we talk about accounting item, it is not billing item. An accounting item refers to one GL account, and not a sales item. Along with BKPF and BSEG, the entries are also updated in BSID which means that these are the customer open items which are due for payment. Once the invoice amount is paid, the entries in BSID will be moved to BSAD. This is the process.
Now using the invoice value, you will be able to find out the acct document. VBRK-VBELN = BKPF-AWKEY
Now once you get the accounting document, you can mention this accounting document number in BSID to get the other details. BKPF-BELNR = BSID-BELNR and VBRK-KUNNR = BSID-KUNNR
For an accounting document, if there is no value in BSID, please check in BSAD for that accounting document. It will be there either in BSID or in BSAD.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.