Table for link between Expense receipts and G/L account

[Former Member]

Hello,

Could you give me the table where we we can see for all "expense receipt" the account of finance (G/L account associated to each expense)

Thank you in advance

[Former Member · Accepted solution]

Hi Tarek,

Thatu2019s correct what Nandagopal is saying, there is no table where you can see all G/L account associated to each expense.

However you can see the all your expense type relation to Wage type in view V_T706B4 and then respective wage type relation to symbolic account in view V_T706K.

Then you can check the link of symbolic account to particular GL account at below IMG Path.

Financial Accounting / Travel Management / Travel Expenses / Transfer to Accounting

Please note that the link happens in below manner and we cannot get any direct link between Expense type and GL account.

Expense Type -> Wage type -> Symbolic Account -> GL Account

Do let us know for any query.

Thanks,

Vaibhav

[Former Member · Accepted solution]

faster way:

transaction Se16 table T706k copy to excel

for field KONT1 and KONT2 do a rule from (transaction PRT3 = Transaction HRT dobble click (general modification + account)

Example:

Excel KONT1 = +10 this belongs in PRT3 case "110" and this is mapped to G/L acccount 474210.

[Former Member]

Hi,

There is no direct assignment between expense types & GL account.

The travel expense types are assigned with wage types and the wage types are assigned to Symbolic accounts. The sym acc is assigned with GL account. So down load all the assignment between exp types & GL account then compare manually.

Thanks,

Nandagopal C