Skip to Content
avatar image
Former Member

Table for link between Expense receipts and G/L account

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 14, 2009 at 02:19 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • avatar image
    Former Member
    Dec 14, 2009 at 05:29 AM

    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

    Add comment
    10|10000 characters needed characters exceeded