SD Billing Document to FI document Link

[Former Member]

Given an SD Billing Document number, what tables do I need to read to get to the subsequent FI documents?

[Former Member]

This should help: [Quickly Retrieving FI document Data from BSEG|/people/rob.burbank/blog/2007/11/12/quickly-retrieving-fi-document-data-from-bseg]

Rob

[Former Member]

Rob,

When I look at a doc flow of a billing document, it shows the accounting document. That's what I need to know; that link that shows "previous document" and then the "subsequent document". Table VBFA does not go into the FI world. It only shows doc flows within SD.

[Former Member]

Check the function module RV_ORDER_FLOW_INFORMATION. The Row with VBTYP_N = '+' and VBTYP_V = 'M' in the output internal table structure VBFA_TAB will have the accounting document information related to Billing document.

[SuhaSaha]

Hello Wardell,

You'll have to use the billing document number & query in BSEG with BSEG-AWKEY = Billing Document Number.

BR,

Suhas

[Former Member]

Suhas, its BKPF-AWKEY.

[SuhaSaha]

>

> Suhas, its BKPF-AWKEY.

Hello Vinod,

Silly typo & thanks for correcting me

@OP: You can also use an additional filter while selecting the data BKPF-GLVOR = 'SD00'.

BR,

Suhas

[Former Member]

I believe everything is there in the blog.

Rob

[Former Member]

Hi

Use table VBFA. Use appropriate values of VBTP_N and VBTYP_V fields.

Regards

Sachin

[Former Member]

Table VBFA does not show the doc flow out of SD. It stops at the Billing Doc. I need the link over to FI.