How to configure SAP S4 HANA MM Tax in 7 Easy Steps
In this post we will configure SAP S4 HANA MM Tax in 7 Easy Steps
In this step we will see the difference between two types of SAP S4 HANA MM input tax -Jurisdiction Tax (Used in USA) & VAT (Used in EU)
In this step we will configure Tax Jurisdictions, FI Tax calculation Procedure, Tax code configuration & condition records creation
In this step we will configure all necessary parameters for automatic Tax code determination in PO and to bring the Tax amount from FI Tax calculation procedure to PO Price determination.
In this step we will look into the master data requirement
In this step we will test Automatic Tax ode determination, Tax amount calculation & flow of tax amount from Tax calculation procedure to PO Price determination.
In this step we will check accounting entries related to mm input tax at the time of Goods Receipt as well as at the time of invoice receipt.
In this step, various FAQs related to MM input tax are answered.
Input tax (Purchase Tax) is levied on all types of purchases and output tax (Sales Tax) is levied on all types of sales. Every country follow its own sales tax, purchase tax procedure.
Table of Contents
1. introduction to SAP MM Input Tax
At a broad level, there are two types of input tax
- Jurisdiction Tax (Used in US/Canada)
- Non- jurisdiction Tax (VAT in EU)
The choice of methods is a parameter in configuring the country’s global settings
To check the detail difference between Jurisdiction Tax (Used in USA) & VAT (Used in EU), Please check FAQ section at the end of the post. In this post we will look in detail into Jurisdiction Tax (Used in US/Canada) , which is more complex to configure compare to VAT configuration.
1.1. Jurisdiction Tax (Sales & Use Tax in USA)
With this method, you manually define the jurisdiction for every region in which you do business.
US follow Jurisdiction tax where tax authority is different for each area and tax authority decides tax percentage in that area.
There are three type of taxes in US
- A/P Sales Tax (MM input Tax)
- Self -Assessment Tax
Out of these three taxes US sales tax is MM input tax (Since we are purchaser, then our vendors collect and remit the collected tax to tax authorities) Hence it is classified as A/P MM input tax
Let,s configure & test A/P Sales Tax (MM input Tax) in the post.
1.1.1 A/P Sales Tax (MM input Tax) in SAP S4 HANA
If a transaction is happening within a state, then Sales tax is levied on the sale of taxable goods and is imposed by the tax authorities. If we are purchaser, then our vendor should collect and remit the collected tax to tax authorities.
As vendor is responsible to collect the A/P sales tax , so at the time of incoming invoice posting in Sap S4 HANA MM module , Vendor Account will be debited cost of material + Applicable A/P Sales tax (MM input Tax)
Credit side is handled two ways in SAP S4 HANA
1.1.1.1. Non-deductible A/P Sales tax (MM input Tax)
Non-deductible tax is not refunded or offsetting against liabilities by tax authorities , so this tax is treated as extra cost . Therefore, the non-deductible part of the tax is added to the stock value during the inventory posting.
1.1.1.2 Deductible A/P Sales tax (MM input Tax)
The deductible tax amount is not to be considered as a cost item of the procurement. This tax is levied within the state
In this post we will configure & test Non-deductible A/P Sales tax (MM input Tax) (1.1.1.1. in the above two)
Let,s start with FI related configuration first.
2. FI related Configuration of SAP S4 HANA MM Input Tax
Let,s first do FI related configuration for the MM input tax
2.1 Assign Tax Jurisdictions to Regions
First of all We need to assign our plant regions to the tax Jurisdictions. We have three plants for our car business. The three plants have the below regions
So we will assign the Jurisdictions to these regions
SPRO -> Cross-Application Components -> SAP Business Partner -> Business Partner -> Basic Settings -> Tax Jurisdictions -> Using SAP Software -> Assign Tax Jurisdictions to Regions and Postal Codes -> Assign Tax Jurisdictions to Regions
2.2 Check Calculation Procedure
We have to first select a Tax schema to calculate the taxes. We will use SAP standard Tax schema w. Jurisdictions given by SAP
SPRO–> Financial Accounting –> Financial Accounting Global Settings –> Tax on Sales/Purchases –> Basic Settings –> Check Calculation Procedure
Note : The above given tax procedure is SAP standard. Mostly this serves the purpose. Generally 3 Tax condition types (S.No. 210, 220 & 230 in the above) are used to configure US input tax with Jurisdictions. See the details below
- A/P Sales Tax 1 Inv. with 6% for state (JP1I).
- A/P Sales Tax 2 Inv. with 1% for county (JP2I).
- A/P Sales Tax 3 Inv. with 1% for city Taxes (JP3I).
2.3 Assign Country/Region to Calculation Procedure
We need to assign our county “US” to the calculation procedure.
We will select the standard Tax scheme given in system for US and make the necessary changes for automatic determination of Tax code in the purchase orders & subsequently automatic tax calculation.
SPRO–> Financial Accounting –> Financial Accounting Global Settings –> Tax on Sales/Purchases –> Basic Settings –> Assign Country/Region to Calculation Procedure
2.4 Check and Change Settings for Tax Processing
Here we make the necessary specifications for posting taxes.
We have used NVV key for all our three tax level i.e. County level, City level, state level
2.5 Define Tax Codes for Sales and Purchases
We will configure below two input tax codes
- I0 – A/P Sales Tax, exempt
- I1 – A/P Sales Tax,taxable, distributed to line items
First Created I0 tax code for Massachusetts Tax Jurisdiction.
Press Enter and you will be presented below screen
Note : In the above screen do not fill any value (for both I0 & I1). just save it . This will get value automatically once we will maintain FV11 for our Condition Types given in Tax procedure. We will see this soon.
Complete the above for the below Combination
2.6 Condition Record Creation (FV11)
We need to create condition records for all the three Condition Types of Tax schema
Below Condition records will be created
- A/P Sales Tax 1 Inv. with 6% for state (JP1I) for all our 3 Tax Jurisdictions.
- A/P Sales Tax 2 Inv. with 1% for county (JP2I) for all our 3 Tax Jurisdictions.
- A/P Sales Tax 3 Inv. with 1% for city Taxes (JP3I) for all our 3 Tax Jurisdictions.
Once you maintained the above check the FTXP. It is maintained automatically
FI configuration related to S4 HANA MM Input tax is completed now.
Let,s check the MM configuration
3. MM Related Config. of SAP S4 HANA MM Input Tax
We need to do the below configuration in order to be able for the system to calculate the input tax automatically in the Purchase Oder
3.1 Condition Types Related to MM input Tax
3.1.1 condition type to bring tax amount in purchase order.
Tax amount is calculated in Tax schema. The system only calculates the non-deductible part of the tax. This amount should be regarded as an additional cost item of the procurement because the tax authorities do not refund this amount unlike the deductible part of the tax. Therefore, the non-deductible part of the tax is added to the stock value during the inventory posting. In the purchase order item, the non-deductible tax amount is saved in field EKPO-NAVNW
NAVS is the condition type which brings the value of the calculated tax to the PO field EKPO-NAVNW , if configured as per below configuration.
Note : Please ignore NAVM as we want to calculate and flow the tax to PO automatically. NAVM is the manual Condition type
3.1.2 Condition Type for Automatic Determination of Tax Code in PO
We will do configuration to determine the tax code automatically in the PO item. Please note that the tax code can be defaulted from the purchasing info record also in the purchase order item. We will create condition records through MEK1 to determine Tax code automatically in the PO.
During the determination via the condition technique an access sequence is assigned in the standard system of condition. Assign access sequence 0003 to our condition type MWVZ
Insert this condition type in our pricing procedure
Note : Please click HERE to check the configuration of price determination procedure.
3.1.3 Supporting Configuration for Automatic Tax Determination in PO
Below configuration is required for automatic tax code determination in PO in S4 HANA MM
3.1.3.1 Setting Tax Indicator for Material
Here we maintain the tax indicators for corresponding materials, specific to each destination country
We have created below three Tax indicator for our companies
3.1.3.2 Setting Tax Indicator for Plant
Here we maintain the tax indicators to assign to plants. This is done for each country of destination
For our three plants we have maintained below two tax indicators
3.1.3.3 Assigning Tax Indicators for Plant
Here we assign tax indicator to each of our three plants
To promote clean fuel, our Electric car plant is tax free
Maintain Tax indicator for plants as below
Out both IC Car plants are taxable
Configure Electric car plant as Tax exempt
3.1.3.4 Condition Record to determine Tax code automatically in PO
4. Master Data Requirements
In the material master purchasing view maintain the “Tax ind. f. mater” field
- Plant Tax indicator is coming from configuration as explained in the post.
- Import indicator logic is hard coded in SAP system.
5. Testing of MM Input Tax
Create a Purchase order for material “66” and vendor “PA01VEN03”
5.1 Automatic Tax Code Determination
System has correctly determined tax code as “I1” automatically as per the condition type values explained HERE.
To check how system has considered condition type & record to determine tax code automatically go to “Conditions” tab and click on “Analysis”
5.2 Tax Calculation Check
Click on Taxes on Invoice Tab
System has successfully calculated all the three taxes as required and total.
5.3 Flow of Tax amount from Tax Procedure to Pricing Procedure
Te amount of tax calculated shown in the previous step should flow to the PO Pricing procedure (under NAVS condition Type).
To check this click on conditions
6. Accounting Entries
Post The Goods Receipt. System will create the material document & corresponding FI Document. Similarly when the enter raise invoice so at the time of entering invoice , system will post the documents.
First we need to create a Purchase order to check the good receipt & invoice entry accounting entries.
Please note that this PO is different from the previous PO created at the Point 5.
We have created PO in the post Ultimate guide to configure S4 HANA MM-FI Integration . You can check the details of the PO price and it’s components HERE
In the PO created in the above link , Tax code is determined automatically as “I1”.
Tax calculations in PO (shown below)
This calculation of tax of USD 1.53 is brought into PO MM price determination procedure (Picture Below) from the FI Tax determination procedure (Picture Above) through condition NAVS to calculate the total value of material. This is fully explained in the post above
Below is the summary of full PO Price components. We will refer this to check the GR accounting entries as well as invoicing accounting entries
Tax Postings at Goods Receipt (GR)
Below is the FI document generated after posting the Goods Receipt (MIGO)
As expected & explained in the post, system has added the tax value to the material value and debited the cost to the inventory
Credit to the GR IR/IR account , which will be cleared at the time of invoicing.
Tax Postings at Invoice Receipt (IR)
Below is the FI document generated after posting the Invoice (MIRO)
Tax amount (including material value) is credited to vendor , as expected because vendor is responsible to collect A/P input tax.
7. FAQ on Input Tax
We get the offset of deductible tax amount so system does not include this in material landing price calculation. Example – PO pricing: Basic – USD 100 Input Tax (16%) – USD 16 (Deductible) Since input tax is deductible, NAVS condition value in PO pricing will be 0.00. Goods Receipt: Credit GR/IR Account – USD 100 Debit Inventory Account – USD 100 (Input tax is not loaded on Inventory due to deductible tax) Invoice Receipt: Credit Vendor – USD 116 Debit GR/IR Account – USD 100 Debit VAT Credit Pool Account – USD 16
System calculate non-deductible tax and inserted the amount under non-deductible tax amount in PO. So Non-Deductible tax is included in landing price calculation and loaded on inventory i.e. included in material valuation as shown through FI document posting in the post.
* Sales tax is state level, plus thousands of local jurisdictions; VAT is only levied at the country level. * Sales tax is set by the US states – 45 of the 50 US states, plus DC, have a sales tax. However, and this is where sales tax gets very cluttered. Counties, cities and a number of other special jurisdictions (in excess of 12,000) have the right to set and charge tax on the transaction on top of the state sales tax. This makes the determination of the right sales tax rate a huge challenge as the business must determine exactly which jurisdictions’ taxes apply, and how to combine them. VAT is controlled and levied at the federal government only. * Huge diversity of sales tax rates, with frequent changes. While only three or fewer VAT rates and changes are rare. * Sales tax only on final consumer; VAT is collected on all transactions. This is where sales tax is ‘simple’. It is only charged on the final consumer (at the till or online checkout).
I n the Previous post, we have completed Business Partner & CVI related configuration. Please click on the above button to see the details
In the next post we will configure S4 HANA MM Pricing procedure .
Image Courtesy : Business vector created by macrovector – www.freepik.com
Join the discussion Cancel reply
Further reading.
All About Purchase Orders in SAP MM
How to Configure Logistics Invoice Verification in SAP S4 HANA
Ultimate guide to SAP S4 HANA MM Pricing Procedure
2 Minutes Guide to Create your First Material in S4 HANA
Ultimate guide to configure S4 HANA MM-FI Integration
How to activate Material Ledger in S4HANA in 5 Easy Steps
Blog about all things SAP
ERProof » SAP FI » SAP FI Training » SAP Tax Configuration
SAP Tax Configuration
SAP tax configuration for sales and purchases is summarized in three customizing menus which we will present as separate sections in this tutorial:
- Basic settings
Calculation
Before starting this tutorial, it is recommended to get familiar with the overview about SAP FI taxes .
Basic Settings
To access the configuration activities under basic settings, use the customizing path below in transaction code SPRO :
Financial Accounting – Financial Accounting Global Settings – Tax on Sales/Purchases – Basic Settings
The menu explodes into various optional, mandatory and nonrequired activities as shown below:
Check Calculation Procedure
Execute the check calculation procedure activity under SAP tax configuration basic settings. You will be presented with various sub-activities. Select the Define Procedures activity as shown below:
Assign Country to Calculation Procedure
Now enter the calculation procedure you created to assign it to the country as shown below:
Now, access the calculation SAP tax configuration activities using the customizing path below in transaction code SPRO :
Financial Accounting – Financial Accounting Global Settings – Tax on Sales/Purchases – Calculation
Define Tax Codes for Sales and Purchases
Define tax codes for sales and purchases by executing the first activity in the calculation menu. Enter your country code and press enter.
Enter two-digit alphanumeric characters as your new tax code. Press enter to proceed.
Enter a long description for your tax code and specify tax type of V for input tax or A for output tax, as demonstrated below:
Press enter to go to the next page.
Enter the tax percentage rate on the appropriate line, depending on whether it is input tax or output tax. For example, the below tax code is an input tax at a rate of 15%:
Now, access the SAP tax configuration activities for posting using the customizing path below in transaction code SPRO :
Financial Accounting – Financial Accounting Global Settings – Tax on Sales/Purchases – Posting
The menu explodes into various optional, mandatory and non-required activities as shown below:
Define Tax Accounts
Execute the define tax accounts activity, and select the tax type. In our example, we select Input tax , as shown below. Press enter, specify the chart of accounts and press enter again.
Enter the general ledger account that all tax codes of this tax type shall post to. In our example, when a user picks any input tax code when posting a document, the system will automatically post to G/L account 151000 :
All necessary SAP tax configuration settings have now been completed. The newly created tax code will appear when entering a document and the tax will calculate and post automatically to the specified G/L account .
Finally, check that your tax code was created correctly by posting a test document. In our example, we created an input tax code relevant to vendor invoices. Therefore, go to transaction code FB60 . Here you can see the new tax code in the dropdown for available tax codes:
Did you like this tutorial? Have any questions or comments? We would love to hear your feedback in the comments section below. It’d be a big help for us, and hopefully it’s something we can address for you in improvement of our free SAP FI tutorials.
Navigation Links
Go to next lesson: SAP Document Change Rules
Go to previous lesson: SAP FI Tax
Go to overview of the course: Free SAP FI Training
7 thoughts on “SAP Tax Configuration”
Hi, Middle East is going on VAT implementation for 5% from Jan 2018. Does the procedure is same or is it different? Can you published same prodedure for Middle East SAP user companies. it will be great benefits to online learners and experts.. Regards, Neelu
The general principles of VAT configuration are the same. It is difficult for us to create a tutorial for Middle East SAP user companies without knowing detailed business and legal requirements in these countries. If you can share your experience of VAT implementation for Middle East countries in 2018, we will be happy to publish it on this blog.
Hello Cleo,
VAT implementation and legal requirement is same is EU as per BIG4 Audit firms. 5% on SALES & PURCHASES. Net of each month will be payable to Tax Authorities here in Middle East. There are few companies exempted but the principal remains same as what is in EU.
Will keep you progressed with Tax Law to be published as nothing has been declared yet. It’s 5 % we know as of now.. So probably the implementation rule remains the same and tax code to be created and assigned on sales & purchases..
Regards, Neelu Bhojwani
Don’t make excuses for failure, just find a way for success
Could you please share complete end to end tax procedure for India after entry of GST in India. It would help a lot.
Please provide details to configure non-deductible tax for purchasing, and tax procedure where vat is calculated on cost plus non-deductible tax.
THANKS A LOT for your valuable work! A few comments to this article: 1) It would be great to mention here the importance of maintenance of “Tax category” and “Posting without tax allowed” in the GL master. Without these settings the system will not calculate tax on sales/purchases, even if the customizing correctly done and the a tax code is specified in the document. 2) Would be nice, if you can make an additional tutorial for the case, when “Plants abroad” functionality is activated for a client. – This case will require additional customizing settings to post sales/purchases tax accounts automatically.
Leave a Reply Cancel reply
Do you have a question and want it to be answered ASAP? Post it on our FORUM here --> SAP FORUM !
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.
- ABAP Snippets
- Top SAP Courses
- Top SAP Books
SAP and ABAP Free Tutorials
The main list of SAP MM Tables and Tcodes (Material Management)
SAP MM Tcodes and Tables (Material Management Module).
You will find in this article the main list of the most important Transaction Codes in SAP MM.
Also, we tried to add the list of SAP MM Tables to be considered in SAP Material Management Module.
Table of Contents
SAP Material Tables (SAP MM Tables)
The main SAP MM Tables for Material Management in SAP are:
SAP MM Tables for Purchasing
Regarding Purchasing in SAP Material Management , the most important tables for purchasing are:
SAP MM Tables for Inventory Management
The main Inventory Management Tables for SAP MM are:
SAP MMBE : SAP Stock Overview MMBE Tcode
For SAP Stock Overview Tcodes, you have Vendor, Dunning, Bank and Transactions details.
The most important SAP MMBE SAP Stock Overview MMBE Tcode are:
SAP MM Tables fro Material Master
Material Master Data are stored in the following SAP MM tables
SAP MM Tables for Invoice Verification
For Invoice Verification, check the following SAP MM Tables:
- The Most Important SAP Stocks Tables used in SAP MM/SD
- SAP KNVV : Customer Master Sales Data
- MVKE Table in SAP MM (Material Sales Data Table)
SAP MM Tcodes
Within the most important Transactions Code in SAP MM (Material Management), we can list
Check also SAP MMBE: SAP Stock Overview MMBE Tcode
Further Reading on SAP MM
If you want to go further on SAP MM, I recommend the following books on SAP Material Management.
- Materials Management with SAP ERP: Functionality and Technical Configuration (SAP MM) (2016)
- SAP MM PURCHASING: TECHNICAL REFERENCE AND LEARNING GUIDE
- SAP MM (Material Management): Complete Reference to Implementation / Customization Paperback
- SAP Material Master: A Practical Guide
Related Posts
The Most Important SAP Payment Terms Tables (ZTERM, Text…)
October 21, 2018 March 24, 2021
SAP Batch Management: User-exits and BAdIs
June 17, 2017 January 21, 2022
SAP Batch Management Tcodes, Tables and Customizing (SAP Batch Management)
June 16, 2017 January 21, 2022
3460963 - Tax amount of certain tax code with normal tax and non deductible tax filled manually is changed when you post the park document
You parked a document with BAPI or Add-on with tax code about normal tax and non deductible tax filled manually, when you post the document, the tax information is changed.
But if you use BAPI to post the document directly, the amount is as expected.
Environment
- SAP enhancement package for SAP ERP
- SAP enhancement package for SAP ERP, version for SAP HANA
- SAP ERP Central Component
NVV, Manual, Park , KBA , FI-GL-GL-F , Value Added Tax (VAT) , How To
About this page
Search for additional results.
Visit SAP Support Portal's SAP Notes and KBA Search .
Privacy | Terms of use | Legal Disclosure | Copyright | Trademark
How to Create tax codes in SAP – FTXP
Create tax codes in sap.
The following tutorials guide you on how to create tax code step by step in SAP. We are creating an output tax VAT 5%.
Create a new tax code by using the following methods:
- SAP IMG Path: – SPRO > SAP Reference IMG (F5) > Financial Accounting > Financial Accounting Global Settings > Tax on sales/purchase > Calculation > Define tax codes for sales and purchases
- Transaction Code: – FTXP
Step 1: – A pop-up screen will be open and asks for a country key for which country you are configuring. Enter the country key and press enter to continue
Step 2: – Enter the new tax code in the tax code field and enter
Step 3: – Update the following data.
- Update the description of the tax code
- Enter tax type i.e V is for Input Tax and A is for output tax
Step 4: – Enter the tax rate in the tax. percent.rate field
Choose the save icon to save the data. A message will be displayed as ” Tax code was created”
IMAGES
VIDEO
COMMENTS
The tax codes are used in A/R sales and use tax, A/P sales tax and A/P self-assessment/use tax. For MM and FI document transactions, the company code's country and the tax code entered forms the FI tax condition records for the country tax procedure. For MM, if the tax code is not entered manually, an automatic tax code determination is ...
Step 1- Introduction - What is SAP S4 HANA MM Input Tax. In this step we will see the difference between two types of SAP S4 HANA MM input tax -Jurisdiction Tax (Used in USA) & VAT (Used in EU) Step 2- FI related configuration of SAP S4 HANA MM Input Tax. In this step we will configure Tax Jurisdictions, FI Tax calculation Procedure, Tax code ...
Open SSCUI 100297 (Automatic Account Determination). Step1:Area. Area:Financial Accounting Subarea:General Ledger Accounting Process:Define Tax Accounts. Step2:Parameters. Transaction Group:%TX (Tax on Sales/Purchases) Transaction Key:VST Chart of Accounts:YCOA Tax Code:Z8 Country:CN. Step3:Account Assignments. Click "Add" button.
Welcome to our tutorial on SAP tax configuration. When users post documents in SAP they only need to select a tax code. The system automatically calculates the tax amounts and posts to tax accounts. Here, as part of our free SAP FI course, we walk you through the customizing settings step-by-step to enable the automatic posting of tax using a ...
Tax Calculation in MM and FI | SAP Help Portal. 6.0 EHP8 SP20. This document. Advanced Search.
Within the most important Transactions Code in SAP MM (Material Management), we can list. Tcode. SAP MM Tcodes. AC02. Service Master. MB01. Post Goods Receipt for Purchase Order. MB1A. Goods Withdrawal.
From the Maintain Tax Code: Initial Screen , choose Tax Code Transport Import . The Import Tax Codes After Transport screen appears. Choose . Check that the related batch input has been processed, by choosing System Services Batch Input Sessions . For more information, refer to the report documentation. Find SAP product documentation, Learning ...
You parked a document with BAPI or Add-on with tax code about normal tax and non deductible tax filled manually, when you post the document, the tax information is changed. But if you use BAPI to post the document directly, the amount is as expected. ... SAP R/3; SAP ERP; SAP enhancement package for SAP ERP;
Create a new tax code by using the following methods: Step 1: - A pop-up screen will be open and asks for a country key for which country you are configuring. Enter the country key and press enter to continue. Step 2: - Enter the new tax code in the tax code field and enter. Step 3: - Update the following data.
Just wondering what options I have for defaulting the Tax Code for a PO line item that is non-stock. There is an account assignment category against the line item and I've tried the config: MM>Purchasing>Taxes>Assign Tax Indicators for Account Assignments. Here I set the tax indicator to "1" for the Acct Ass Cat I'm using in the PO.
You can maintain the tax indicator for the account assignment category in OMKO. Now, create a condition record with KPMP-TAXIK field as explained in the doc: Defaulting Tax Code in PO - Condition Technique. If you still want to go for development, refer the settings mentioned in the note: 566002 - M/03: Can't use field PSTYP in the condition table.