Page 1 of 1

Tax percentages set up in FTXP

Posted: Thu Oct 31, 2013 3:29 pm
by sapnov05
Hello friends,

I have a requirement from our tax department that they need to vet all the tax percentages set up for the cities, counties and states in US. In other words, I need to pull down all the data set up in FTXP - by Jurisdiction code and tax code. What table, if any, holds this data? I don't see any logical database either in the query area. Appreciate any help you can provide!

Please let me know if I can provide more info to be clear.

Thank you.

Re: Tax percentages set up in FTXP

Posted: Thu Oct 31, 2013 11:48 pm
by Jim B
T007V normally has these percentages, but I have no experience with the US model of tax juristictions, so it may be more complex in your case.

best wishes,

Jim

Re: Tax percentages set up in FTXP

Posted: Fri Nov 01, 2013 4:37 am
by darkduck
Usually you use a separate Taxware system to determine tax rate in the US, because it depends on a number of factors: jurisdiction and date.

http://www.sapexpert.co.uk/tag/vat - there's a couple of article about the topic.

Re: Tax percentages set up in FTXP

Posted: Fri Nov 01, 2013 6:03 am
by sapnov05
Hi darkduck,

Yes, normally one would use Vertex or something, however in our case the complexity was not so high as our services are taxable in just 4 states (though with lots of JCs within them), so we configured it all internally itself. ...thus, all our tax percentages reside within ECC. Which is where I am trying to pull the data down from...and can't find any tables that could be holding this data...

Thanks for your guidance.

Re: Tax percentages set up in FTXP

Posted: Fri Nov 01, 2013 6:20 am
by darkduck
It is not a simple select.
Look at tables
T683
T683S
KONH
KONP

Re: Tax percentages set up in FTXP

Posted: Fri Nov 01, 2013 1:44 pm
by sapnov05
Thanks to everybody...

A053 and KONP helped solve this...