Analysis of tax codes master data
If you check the topics of my blog posts, you will notice my obvious interest in topics around automatic payment program and bank statement. However, being SAP FI consultant who works extensively with Ukrainian localization, my main specialization is VAT accounting.
I’ve been responsible for implementation of VAT localization for Ukraine, Russia, Kazakhstan as well as Belarus and Georgia. Although these are different countries, there is one common denominator – complex legal landscape and a lot of special reporting requirements. Considering that VAT reporting in SAP is heavily based on tax codes, implementation of VAT processes usually implies creation of many tax codes. For instance, concept of tax codes for Ukraine on one of my recent projects involved 75 tax codes.
On one hand, that doesn’t sound overtly complicated. On the other hand, consider typical tasks of consultant during project life cycle:
- Design concept of tax codes for a country;
- Devise a tool to create these tax codes en masse, usually LSMW;
- Check the settings of tax codes in the system.
While first two tasks are easy and might be considered as one-time activities, analysis of tax codes settings is more complicated. You might check all tax codes’ requisites / account determination in FTXP, but it will be very time consuming.
You might also use standard SAP report RF_STEUERINFO (accessible via t-code S_ALR_87012365). It contains all necessary details in one place – but it doesn’t support export to Excel and essentially, you’ll have to check each tax code separately. Example of a standard report can be found below:
Now consider, that you’ll have to analyze tax codes settings in each system i.e. development, quality and production. Your project landscape might involve even more systems e.g. sandbox, additional systems for trial loads, pre-prod system, training environments etc. As a result, you will spend a lot of time on analysis, which can be significantly reduced.
Lately, I had a bit of free time and decided to improve my ABAP-skills. As a result, I’ve developed small report on tax codes master data. This report has two modes – i.e. translations mode and settings.
In translations mode, you can review tax code names in all languages:
Settings mode allows you to review all tax codes’ requisites along with GL accounts. Report will list all condition types maintained for a tax code and all GL accounts.
Both reports are ALV-based and can be easily saved into Excel and compared with target values. Both report modes support drill-down to tax code level i.e. to transaction FTXP, allowing to adjust the settings of tax code quickly and efficiently.