Condition Type - GL Account Determination

[sachin_thombre]

Hello All,

I have a condition type XXXX which has been called in the billing doc. My intend was to find all the GL's used for this condition type. I followed below steps:

Table T683S - Get the Account Keys & based on Account keys get the list of GL's used

Since the condition type does not have any account key used. Can you suggest some other way in this?

[Lakshmipathi · Accepted solution]

First check in VKOA for which combination, that particular Account Key and G/L Account is maintained. Then you can find out in which table it is stored. Generally, it starts with C001, C002 etc. Next in SQVI, select Logical Database with which, you can filter out billing documents related to that particular condition type and value. Now you have a list of billing documents with the value of that condition type. Finally, again execute SQVI with Table Join for VBRK, VBRP and C001 (for example) and execute. You will get the desired result.

[former_member222241]

Hi,

For the same account key you need to configure Tax code - GL combination.

Warm regards,

Tejas

[former_member222241]

Hi,

How did you assign GL to condition types? as normally in FI - Tax integration through OB40, MM - FI Integration through OBYC and SD - FI Integration through VKOA requires an Account or Transaction event key to assign GL account.

[sachin_thombre]

In VKOA it has been assinged with combination with Account Key (XXX), this Account key is assinged to condition type in the pricing procedure