Tables with tax configuration in SAP

Dmitry Kaglik

November 11, 2013

SAP

2 Comments

Share the knowledge
Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInDigg thisEmail this to someone

Taxes in SAP are a very important part of functionality. It is a topic of interest for different segments of the SAP community: Finance business users, Finance functional consultants, Logistics consultants and so on.

From the functional viewpoint, the taxes’ configuration is quite simple. There is a Sales Tax section within the Finance part of IMG. Most of the configuration for particular tax codes you can do in the transaction code FTXP.

However, have you ever thought about how SAP stores the data for tax configuration? If you ever had to write an overview of existing tax codes in your system, then you probably have already thought about this.

The diagram below summarizes some of the tables and their relations for tax codes’ configuration in SAP. It also shows the fields you need to extract to get a simple report: Country, tax code, GL account and description.

I must warn you that SAP Expert had to slightly simplify the diagram, excluding the tables that hold tax rates. If you need to get the rates, you need to add KONH and KONP tables into the overview.

I hope the diagram will be useful for the readers of SAP Expert. If you want to get a MS Visio version of the same file for a small fee, or have additional questions, please contact SAP Expert for details.

Tax Tables in SAP
Tax Tables in SAP
(click to enlarge)
Share the knowledge
Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInDigg thisEmail this to someone

Related Posts

SAP expert news, part 4 – we care about your security

Dmitry Kaglik

February 19, 2018

SAP

No Comment

Share the knowledgeSAP Expert always takes security seriously. That’s why both SAP Expert projects have recently been upgraded to use secure connection. It means that you will now access sapexpert.co.uk and job.sapexpert.co.uk sites through secure and encrypted HTTPS protocol. Your browser should show this as a green padlock on the address bar. Enjoy your reading! […]

Read More

SAP, Freelance and Digital Nomads

Dmitry Kaglik

February 5, 2018

SAP

No Comment

Share the knowledgeSand, warm sea in front of you, swimming pool behind, and a glass of an ice-cold drink on the table nearby your laptop. Isn’t it an ideal workplace for many? That’s the life you can get living in a Southern country like Cyprus, Thailand or Indonesia. There are some people and organisations to […]

Read More

2 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Search this site

Subscribe!

Polls

Will you be happy to pay for the 3rd edition of the book FREQUENTLY ASKED QUESTIONS ON SAP FINANCE?

View Results

Loading ... Loading ...
Disclaimer and privacy policy