Skip to Content
avatar image
Former Member

Table for Tax code

Hi,

I need table name for Tax code in which i can get all the detail information. For example: tax code, tax procedure, country code, EU code, tolerance, tax percentage, GL accounts assigned to tax code , description. I can get half of the information from T007A and GL related information from the table T030K.

Shall I get the name of the table where I can find all the information.

Regards

Debadas Mishra

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 20, 2010 at 10:14 AM

    Table T005 is helpful to check the tax procedure details country wise.

    You can't get all the information in one table.

    Rgds

    Murali. N

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 20, 2010 at 01:31 PM

    Hi,

    you can use the following

    T007S ---> Tax Code Names

    T007A ---> Tax Keys

    T007C ---> Groupings for tax codes

    IDCFMBRSETX_HST ---> History table for taxation

    Thanks,

    Shakeel

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 26, 2011 at 02:22 AM

    Hi Debojit Dey,

    For Tax Percentage, you could use table A003 to get Condition record no.(KNUMH).

    Then, use the Condition Record No. to get Tax Rate (KBETR) in table KONP

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 21, 2010 at 04:44 AM

    Hi Debojit,

    Use T.Code SQVI and build a query by joining both tables on Tax Code, then you can have all the data in single tabular format.

    Please keep the table T030k on right side.

    Thanks & Regards

    Krishna Chaitanya

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I've just tried to use T030K in SQVI and have got following error:

      Table T030K cannot be used in a join