Skip to Content
avatar image
Former Member

How to pick tax code percentage for US country

Hi Gurus,

How can I get the percentage for tax code created for US country code (Jurisdiction code) - TAXUSJ. For example tax code is XX and % is 5%. How can I pick the same (i.e. 5) in a report. T007* tables are not giving for US country code.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Dec 29, 2014 at 09:48 PM

    It would be good if you could tell the transaction where you maintain the percentage.

    Especially for the US many companies are interfacing Vertex software as this saves quite a lot work of maintaining the percentages for any possible relation.

    If you maintain it in SAP with condition records then you can usually find the table via the display transaction

    Example: if you maintain conditions in MEK1 then you can use MEK3 to obtain the table names for each access sequence  (key combination).

    Just execute MEK3, enter your condition type, click the button for condition info and execute the selection screen.

    You will see the table name above the records: (you just need to know that you have to add a A in front of 044 (A044) for a full qualified table name that can be used in SE16 or in a program

    An alternative appearance is:

    And here you can even switch the appearance on the left window part by clicking the icon above:

    In those tables you can then find the condition record number that is used to access the corresponding record in KONP table to get the value

    MEK3_1.PNG (9.6 kB)
    MEK3_2.PNG (17.3 kB)
    MEK3_3.PNG (16.7 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Dec 29, 2014 at 03:40 AM

    Dear Bharat,

    You can take the Country Key (US)(Field - LAND1) and Tax Procedure (TAXUSJ) (Field - KALSM) from T005 table and pass the tax procedure into (T007A-KALSM) to find the tax code(XX) (T007A-MWSKZ).


    Karna J

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Karunanithi Jayapal

      Hi ,

      I did that. Message displayed "No values found"

      My condition type is JP3U and this tax code is US jurisdiction based tax code.


  • Dec 29, 2014 at 05:31 AM


       Ensure that you have maintained the condition record correctly. Then check T007V table. Too7V-KBETR will give you the percentage maintained (multiplied by 10 as other percentage condition)



    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 29, 2014 at 03:20 PM


    Check your tax code  XX is created for county key US and the same county key US assigned to your plant & company code which you are entering in your purchase order.

    Now where and how you maintained 5% tax rate with tax code  as you are using TAXUSJ. Either you can mantain tax rate 5% directly in FTXP itself for tax code  XX for that condition type or check that condition type, which access sequence used where you can go for condition based by having tax rate 5% for tax code XX in FV11.

    More refer:-

    Condition-Based Excise Determination - India - SAP Library


    Biju K

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member


      I have maintained the same in FTXP with county code and Jurisdiction code combination for condition type JP3U.