This website is not affiliated with, sponsored by, or approved by SAP AG.

Tax percentages set up in FTXP

Financials (FI, CO, TR, EC)

Moderators: Snowy, thx4allthefish, darkduck, Baz

Tax percentages set up in FTXP

Postby sapnov05 » Thu Oct 31, 2013 3:29 pm

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.
sapnov05
 
Posts: 287
Joined: Sun Feb 06, 2005 8:35 am

Re: Tax percentages set up in FTXP

Postby Jim B » Thu Oct 31, 2013 11:48 pm

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
Jim B
 
Posts: 1181
Joined: Sun Dec 01, 2002 3:06 am

Re: Tax percentages set up in FTXP

Postby darkduck » Fri Nov 01, 2013 4:37 am

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.
SAP FI FAQ: http://en.sap.darkduck.com

Just before submitting any question, have a look at http://www.catb.org/~esr/faqs/smart-questions.html please...
darkduck
 
Posts: 2456
Joined: Thu Aug 25, 2005 3:55 pm
Location: whereami?

Re: Tax percentages set up in FTXP

Postby sapnov05 » Fri Nov 01, 2013 6:03 am

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.
sapnov05
 
Posts: 287
Joined: Sun Feb 06, 2005 8:35 am

Re: Tax percentages set up in FTXP

Postby darkduck » Fri Nov 01, 2013 6:20 am

It is not a simple select.
Look at tables
T683
T683S
KONH
KONP
SAP FI FAQ: http://en.sap.darkduck.com

Just before submitting any question, have a look at http://www.catb.org/~esr/faqs/smart-questions.html please...
darkduck
 
Posts: 2456
Joined: Thu Aug 25, 2005 3:55 pm
Location: whereami?

Re: Tax percentages set up in FTXP

Postby sapnov05 » Fri Nov 01, 2013 1:44 pm

Thanks to everybody...

A053 and KONP helped solve this...
sapnov05
 
Posts: 287
Joined: Sun Feb 06, 2005 8:35 am


Return to Financials

Who is online

Users browsing this forum: No registered users and 6 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.