Link between GL account and Billing Document

[Former Member]

Dear SD Gurus,

We are involved in a BI report generation. In the sales report customer wants to bifurcate the sales into Domestic and Export. They are give a logic of taking this bifurcation from GL account. Customer is maintaning 2 different GL account 40000000 - Export and 40100000 for Domestic.

My question here is How i will relate GL account to billing document? If yes, please tell me the table where i can find both...

With Regards,

Balachander.S

[Former Member]

Solved myself

[Former Member]

Hi Bala

Can you pls explain how u solved this. I'm also looking for the same.

Regards

Sathar

[former_member183879]

Hi,

For every invoice, an accounting document is created and stored in BKPF table

BKPF will have the account document number

Each line item of the accounting document can be seen in teh table BSEG.

Here youc an see the GL account to which each line item is linked. BSEG will also give you the details about the customer/vendor for whom the postings are made.

Hope this helps you

[Lakshmipathi]

Dear Balachander

You can try with FBL3N.

thanks

G. Lakshmipathi

[Former Member]

hello, friend.

one way of looking at this is through account determination. billing documents are posted to accounting (and therefore, accounting documents are created that are linked to the billing document) based on settings in account determination.

please check if the postings to GL accounts are based on any or all of the following:

1. sales organization

2. account key (e.g. ERL for revenue)

3. account assignment group (customer, material, etc.)

4. condition type

we use t-code VKOA to do account determination.

regards.

[Former Member]

Hi,

Just look into the structure "RFPSD". I dont know how much it is helpful to you..... but for better understanding you can consult FI people......

Regards

Bugs