- Ask a Question
- Write a Blog Post
- Login / Sign-up
Tax code Tax procedure
what is taxcode and taxprocedure and also what is condition type hows the these three related?please explain with an example
TECH CONCEPT HUB
Welcome to tech concept hub -it training institute.
- UI5 / FIORI
- AWS (AMAZON WEB SERVICES)
- DATA SCIENCE
- CLASSROOM TRAINING
- COLLEGE TRAINING/ WORKSHOP
- CORPORATE TRAINING
Tax configuration in sap: Tax procedure, Tax code & Tax jurisdiction code
For calculation of tax, we need to have tax base amount and tax rate.
Tax rate is the tax percentage which is to be applied on tax base amount to arrive at tax amount. Tax base amount is the amount on which tax rate is to be applied.
As directed by tax authority in a country:
Every country has a list of different taxes which may be applicable on a business transaction in the country.
Different business transaction might invite different types of taxes with different tax rates.
Tax base amount can be inclusive or exclusive of cash discount.
Once tax base amount and tax rate is known for a transaction, tax amount can be calculated.
Calculated tax amount along with business transaction details need to be recorded.
Let’s see how sap handles the above requirements for tax calculation
TAX PROCEDURE
In sap, country specific tax procedure is created and assigned to country. Tax procedure is a list of tax condition types. Each condition type represents a type of tax applicable in the country.
Hence tax procedure represents the list of different types of taxes which are valid in the country.
TAX CODE, TAX JURISDICTION CODE
In sap, tax code is created to store the value of tax percentage.
A business transaction might invite different type of taxes with different tax rates. Hence in sap, tax condition types are assigned to tax percentage. This combination of tax condition types and corresponding tax percentage is stored in tax code.
A tax code in sap is a two digit alphanumeric code which stores different tax conditions (defined in tax procedure) and corresponding tax percentage.
Normally tax code is created at national level but in few countries like USA, different areas have different tax authority and each tax authority decides its own tax percentage. Hence applicable tax percentage depends upon which tax authority the business transaction belongs to.
In sap, each tax authority is created as tax jurisdiction code .
Hence in USA, tax percentages are assigned to tax condition types for the combination of tax code and tax jurisdiction code.
When a business transaction happens, tax code is supplied and system derives tax jurisdiction code information. Corresponding tax percentage maintained against tax condition type is applied for tax amount calculation. Tax amount is posted to GL account assigned to condition type.
With huge number of tax jurisdiction code (tax authority) and each are regulating its own tax percentage, it becomes very challenging for companies to keep track to up to date tax percentage. Instead of committing resources on keeping track of tax percentage, companies take help from other companies who maintain up to date tax percentage for each tax jurisdiction code.
Companies like vertex, taxware, sabrix maintain tax percentage on their server. When transaction is entered in sap, software determines the jurisdiction code and fetches tax percentage from vertex/ taxware/ sabrix server.
Hence companies free themselves from the load of maintaining tax percentages by using the services provided by other companies. Hence tax percentage is fetched from external sources like vertex, sabrix and taxware.
TAX BASE AMOUNT
In sap, for each company code we can define if tax base amount is inclusive of cash discount or exclusive of tax discount.
POSTING OF TAX AMOUNT
When a business transaction is recorded, tax code is supplied. System calculates the tax amount for each condition type. Condition types are mapped to account key and account key is linked to GL account.
When document is posted, system automatically picks the mapped GL account for posting tax amount.
Let’s put the entire concept together to understand calculation and posting of tax amount in sap
From entered document, system knows the company code. Company code leads to country and country leads to tax procedure.
From tax code which is entered while posting document, system fetches the percentage against each tax condition type and applies the percentage on determined tax base amount.
— Tax condition types are assigned tax percentage in tax code.
— Tax condition types are assigned tax percentage in (tax code and tax jurisdiction code) combination.
— Tax percentage is fetched from external sources like vertex/ taxware/ sabrix etc on the basis of tax jurisdiction code.
Calculated tax is posted in GL account assigned to tax condition type.
To read more on tax configuration:
http://www.saptraininghq.com/tax-configuration-for-sap-implementations/
Click on below links to read more.
Basic concepts and GL accounting
- What is SAP Finance ?What business requirement is fulfilled in this module?
- What is sap enterprise structure?
- What is difference between company and company code in sap?
- What is GL account? What is account group? What is operational chart of accounts?
- What is the need of country chart of account or alternate chart of account? How country chart of account helps fulfill a business requirement?
- What is the need for group chart of account? How group chart of account helps in consolidation of financial data?
- Non leading ledger helps in parallel accounting. Explain with example
- What is company code global settings? What global parameter is assigned to company code?
- What is fiscal year variant? Why fiscal year variant is assigned to company code?
- What is posting period variant? Why posting period variant is assigned to company code?
- What is field status variant? What is field status group?
- What is document type in sap? Explain the purpose of document type?
- Document date vs Posting date vs Entry date vs Translation date. Explain
- What is posting key? what is the use of posting key?
- Document header & line items capture information of business transaction.
- Everything about currency & exchange rate in sap.
- How exchange rate is loaded in sap?
- Foreign currency valuation in sap. Explain with example
- Retained earnings account helps in year end balance carry forward. Explain
- What is the significance of tolerance groups in sap?
- What parameters are maintained in GL master and how does it impact in document posting?
ACCOUNTS PAYABLE
- How sap overcomes challenges in accounts payable process?
- Understanding procure to pay (PTP) cycle and accounting document at each step.
- Understanding MM FI integration in very simple terms.
- Purchase order price calculation in very simple terms.
- House bank, Bank key, Account ID
- What configuration (FBZP) needed for executing F110 in sap ?
- Understanding steps to execute F110 in sap
ACCOUNTS RECEIVABLE
- How sap overcomes challenges in accounts receivable process?
- What is customer reconciliation account?
- Understanding order to cash cycle in sap.
- Understanding SD FI integration in very simple terms.
- What is lock box? How lockbox helps in collection from customers?
TAX ACCOUNTING
- How sap helps in tax accounting?
- Tax configuration in sap: Tax procedure, Tax code & Tax jurisdiction code
- Concept of tax jurisdiction code & tax jurisdiction structure
- Significance of "Tax category & Posting without tax allowed" in GL master.
- Tax base amount and Discount base amount
- Assigning tax code V0 & A0 for non taxable transaction?
- Deductible input tax vs non deductible input tax
- How tax is calculated in purchase order and sales order?
WITHHOLDING TAX
- Withholding tax explained with example.
- How sap overcomes challenges in managing withholding tax?
- Withholding at the time of invoice or payment
- Withholding tax configuration in sap
- Business place & Section code in sap
- Withholding tax certificate numbering
- Withholding tax report for filling tax returns
ASSET ACCOUNTING
- How sap helps in asset accounting?
- What is meant by asset accounting?
- What is the use of asset class?
- What is the use of depreciation key in asset accounting?
- What is APC (Acquisition & Production cost)?
- Depreciation area and Chart of depreciation
- Derived depreciation area VS real depreciation area?
- Understanding asset accounting configuration needed in sap
- GL account determination for posting asset transaction
- Asset transaction and corresponding accounting document?
- How depreciation is posted in sap?
- What are different reports required by business?
How to Define Tax Procedure in SAP
In this SAP tutorials, you will learn how to define tax procedure in SAP systems . In our previous training tutorial we have discussed about what is sales tax and purchase tax in SAP .
How to Define tax procedure in SAP
You can maintain tax calculation procedures in SAP by following one of the navigation method.
Transaction code: – OBYZ Menu Path: – SPRO –> IMG –> Financial Accounting (New) –> Financial Accounting Global Settings (New) –> Tax on sales/purchases –> Basic settings –> Check calculation procedure.
Step 1) Enter transaction code “OBYZ” in the SAP command field and enter.
Step 2) A pop up window condition element screen displays with options, you need to choose procedures so double click on it.
Step 3) On change view procedure screen, click on new entries button for definition of new tax procedure in SAP.
Step 4) On new entries calculation procedures screen, update the following details.
- Procedures: – Enter the four digits key that identifies the tax procedure in SAP.
- Description: – Update the descriptive text of tax calculation procedure – Sales tax India.
After maintaining the details, click on save button and save in your request number.
Step 5) Now select TKCP procedures row and double click on control data folder.
Step 6) Select new entries button.
Step 7) On new entries screen, update the following details.
- Step: – Enter the number (10, 20, 30…) which specifies the sequence of the conditions within a procedure
- Condition type: – Update the condition type key that indicates the each activity or tax.
- Description: – Description text will be automatically updated based on condition type text.
- From, To: – This indicate which tax should be calculated on which base amount.
- Account key: – Assign the account that respective to condition types.
After maintaining all the required details, click on save button and save the configured details.
Successfully we have maintained tax calculation procedures in SAP.
Most Read Articles
Tax company code Table in SAP
- ESERV_C_BUKRS Table for Allocation of Auxilliary Company Code to Company Code Table Type : TRANSP Package : EE_DEREG_INV Module : IS-U-IDE
- PAYAC07 Table for Company Code/Company Code Groups Assignment (FM) Table Type : TRANSP Package : FMFI Module : PSM-FM-PO
- UDM_COMPCODE_MAP Table for Assignment of FI Company Code to Collection Company Code Table Type : TRANSP Package : UDM_COLL_CUSTOMIZING Module : FIN-FSCM-COL
- IDPL_SI_TAX Table for Assign Tax Code for Self Invoices to Company Code Table Type : TRANSP Package : ID-FI-PL Module : FI-LOC
- TFK001GB Table for Company Codes for Company Code Groups Table Type : TRANSP Package : FKKB Module : FI-CA
- J_3RUMSV Table for Tax Balances per Comp.Code, Tax Code and Process.Key+ client Table Type : TRANSP Package : J3RF Module : FI-LOC
- UMSV Table for Tax Balances per Comp.Code, Tax Code and Process.Key Table Type : TRANSP Package : FREP Module : CRM
- J_1IEWT_MIGRATE Table for Map Classic tax code to EWT Tax type - Tax codes Table Type : TRANSP Package : J1ICIN30A Module : FI-LOC
- BTXCOMP Table for BSI: Tax Company Code Table Type : TRANSP Package : PZ1B Module : PY-US-NT-TX-BSI
- BTXCOMP_O Table for BSI: Tax Company Code Table Type : TRANSP Package : PZ1B Module : PY-US-NT-TX-BSI
- J_1AT001TC Table for Tax Category Data per Company Code Table Type : TRANSP Package : J1AT Module : CRM-BF-TAX
- J_1AT001TG Table for Tax Category Data per Company Code Table Type : TRANSP Package : J1AT Module : CRM-BF-TAX
- J_3RFTAX_ASSIGN Table for Tax hierarchy assignment to company code Table Type : TRANSP Package : J3RFTAX Module : FI-LOC
- J_3RFTAX_ASSIGNE Table for Tax hierarchy assignment to company code/ledger Table Type : TRANSP Package : J3RFTAX Module : FI-LOC
- T001N Table for Company Code - EC Tax Numbers / Notifications Table Type : TRANSP Package : FBAS Module : CRM
- T001RWT Table for Rounding rules for company code, withhold.tax type and curr. Table Type : TRANSP Package : FQST Module : FI-AP-AP
- T001WT Table for Company code-specific information per withholding tax type Table Type : TRANSP Package : FQST Module : FI-AP-AP
- T001_UMKRS Table for Time-Dep. Assignment of Company Code to Sales/Purch. Tax Grp Table Type : TRANSP Package : FBAS Module : CRM
- TBUVTX Table for Transfer Posting of Tax in a Cross-Company Code Transaction Table Type : TRANSP Package : FREP Module : CRM
- TE503_TAX Table for Deifne Tax Determination Procedure Per Company Code Group Table Type : TRANSP Package : EE21 Module : IS-U-IN
- /KJRTAX01/A04 Table for Property Tax Rpt: Declaration Key-Company Code Relationship Table Type : TRANSP Package : /KJRTAX01/FI-AA Module : FI-LOC
- /SAPPCE/TDPC75 Table for Deferred Tax: Logging of Program Calls by Company Code Table Type : TRANSP Package : /SAPPCE/DPC Module : FI-AF-DPC
- T5UTLAVK Table for Additional Attributes of Tax Company on Tax Authority Level Table Type : TRANSP Package : PC10 Module : PY-US
- J_7LC02 Table for REA Company Codes: Common Company Codes Table Type : TRANSP Package : J7LR Module : IS-REA-COR
- T5DP4 Table for Assignment PAISY Company - Superordinate Company Table Type : TRANSP Package : P01Y Module : PY-DE
- CDBC_CODEPROFILG Table for CDB: Code Catalog: Code Groups for Code Group Profile Table Type : TRANSP Package : CDB Module : CRM-MSA
- COMC_CODEPROFILG Table for Code Catalog: Code Groups for Code Group Profile Table Type : TRANSP Package : QSKT Module : CRM-BF-CAT
- FIPTC_ATTXCODE Table for Mapping of Tax Code to AT Code for Portugal Table Type : TRANSP Package : ID-FI-PT Module : FI-LOC
- J_1ITCJCMAP Table for Tax code and Jurisdiction code mapping Table Type : TRANSP Package : J1I2 Module : FI-LOC
- TE011 Table for Code for Tax Code Determination Table Type : TRANSP Package : FKKB Module : FI-CA
- WTMIGMATCH Table for Withholding Tax Changeover: Creation of Code -> Type/Code Table Type : TRANSP Package : FWTM Module : FI-AP-AP
- WTMIGTC Table for Changeover - Assgt of Classic W/Tax Code to Ext.Type/Code Table Type : TRANSP Package : FWTM Module : FI-AP-AP
- /KJRTAX01/A06 Table for Property Tax Report: Assign Decl.Key to C.Code and City Code Table Type : TRANSP Package : /KJRTAX01/FI-AA Module : FI-LOC
- CDBC_T_SPREGJSD Table for Determine Special Tax Region from Tax Jurisdiction Code Table Type : TRANSP Package : CDB Module : CRM-MSA
- CDBC_T_TAXCODE2 Table for Assign Tax Events to Tax Code Table Type : TRANSP Package : CDB Module : CRM-MSA
- J_3RTNTVEH Table for Tax-free code of vehicle (358 asset of tax codex) Table Type : TRANSP Package : J3RT Module : FI-LOC
- OIUX6_WY_TXCLRC Table for Tax 2.0 - Wyoming Tax Class Rate Code XRef Table Type : TRANSP Package : OIU_X6 Module : IS-OIL-PRA-REP-TAX
- T076M Table for EDI: Conversion of External Tax Rate Tax Code Table Type : TRANSP Package : FBAS Module : CRM
- TFK007FK Table for Tax Item Categories for Other Tax Code Table Type : TRANSP Package : FKKB Module : FI-CA
- TFK007FKT Table for Tax Item Categories for Other Tax Code Table Type : TRANSP Package : FKKB Module : FI-CA
- TIVEXFITAXMAP Table for Tax Code Assignment per RE Tax Type/Group Table Type : TRANSP Package : RE_EX_FI Module : RE-FX-RA
- TIVEXTAXCODEMAP Table for Assignment of RE Tax Type/Group per Tax Code Table Type : TRANSP Package : RE_EX_FI Module : RE-FX-RA
- TTEC_TAXCODE_2 Table for Assign Tax Events to Tax Code Table Type : TRANSP Package : AP_TTE Module : AP-TTE
- /KJRTAX01/A03 Table for Property Tax Report: Tax Office Code Table Type : TRANSP Package : /KJRTAX01/FI-AA Module : FI-LOC
- CDBC_TB071_T Table for Tax Classification Texts: Assignment of Tax Groups to Tax Table Type : TRANSP Package : CDB Module : CRM-MSA
- SMOTB071 Table for Tax Classification: Assignment of Tax Groups to Tax Types Table Type : TRANSP Package : CDB Module : CRM-MSA
- TB071_CM Table for Tax Classification: Assignment of Tax Groups to Tax Types Table Type : TRANSP Package : CCCI Module : LO-MD-BP-CM
- A038 Table for Overhead Type/Company Code Table Type : TRANSP Package : VKON Module : AP-PRC-PR
- A059 Table for Controlling Area/Company Code Table Type : POOL Package : VKON Module : AP-PRC-PR
- A062 Table for Controlling Area/Company Code/Cost Center Table Type : POOL Package : VKON Module : AP-PRC-PR
- A105 Table for Controlling Area/Company Code/Business Area Table Type : TRANSP Package : VKON Module : AP-PRC-PR
- P10_COMPM_MATCH Table Data element for Tax Company or Tax Company Group Match
- COMPANY Table Data element for BSI: Tax Company Code
- EESERV_C_LBUKRS Table Data element for Company Code to Which an Auxill. Company Code is Allocated
- GLE_DTE_ECS_ORIG_BUKRS Table Data element for Source Company Code from Cross-Company-Code Posting
- VVKONTO3 Table Data element for Commitments to object company code (Management company code)
- RESCMSUREFCC Table Data element for Reference Company Code for Cross-Company-Code MSUs
- BP_CCOM_RE Table Data element for Company Relationship in Company Code
- BUTXT Table Data element for Name of Company Code or Company
- JBUKRS Table Data element for IS-M: Company Code for Service Company
- SMO3BUTXT Table Data element for Name of the company code or company
- RCOMP_FLAG Table Data element for X: For global company, otherwise for company code
- CORR_BUKRS_TXT Table Data element for Name of Company Code or Company
Tax company code related terms
Definitions.
SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
Popular Table Searches
Latest table searches.
Assign Tax Calculation Procedure to Country in SAP for GST
How to assign tax calculation procedure to country for gst in sap.
You need to assign tax calculation procedures to every country where your company is operating the business.
You can assign tax calculation procedure to country IN (India) for SAP GST by using the following navigation method
- IMG Path : IMG > Financial Accounting > Financial Accounting Global Setting > Tax on Sales/Purchases > Basic Settings > Assign country to calculation procedure.
- Transaction code : OBBG.
Important Configurations to be done before assignment
- GST Calculation Procedures
Refer below step-by-step procedure on how to assign tax calculation procedure to country IN (India) for SAP GST
Step 1 ) Execute the transaction code “OBBG” as shown below
Step 2 ) In the next screen change view “Assign Country -> Calculation procedure” overview, the complete list of countries displays on the screen for assignment of country to calculation procedure. Choose the position option and enter the country key India as IN.
Step 3 ) Now enter the tax calculation procedure procedure key “GSTIN” for the country IN (India) in the filed procedure and press enter to continue.
After the assignment of tax calculation procedure to country IN, Choose save icon and save the configured details.
Also Refer: Next Configuration steps
Define Access Sequence for GST
Define Condition types for GST
Define account keys for GST.
The Procedure of Tax Configuration in SAP
Tax determination is mainly a country-specific setting and there are separate SAP modules for tax. In SAP the amount of tax is determined mainly on the basis of Tax procedures and Tax Codes.
Tax on Purchase/Sale - When we purchase something we have to pay the tax, it is called input tax. It is denoted by V. When we are selling something we have to pay the tax, it is called output tax and it is denoted by A.
The Procedure of Tax Calculation in SAP
Define condition types, define the account key, create tax procedure, assign the country to the calculation procedure, define tax codes.
It indicates different types of tax such as GST, VAT, etc, and conditions applicable.
Steps to create Condition Types
Step 1 : Enter the T-Code SPRO in the SAP Command Field and press Enter .
Now on the next screen click on SAP Reference IMG Button
Step 2 : Navigate to SAP IMG Path:
Financial Accounting >> Financial Accounting Global Settings >> Tax on Sale/Purchase >> Basic Settings >> Check Calculation Procedure
Enter T-Code OBYZ
Here you can Define your Condition Types
Click on Define Condition Types
Step 3 : Click on the New Entries button on the top navigation
Step 4 : Now make an entry in the following fields
Condition type : Enter condition type as RGST for company code 1982.
Access sequenc e: Select standard Access Sequence MWST from the list.
Condition class : Select Condition Class D for Taxes.
Calculation Type : Select Calculation Type A for Percentage.
After making all the entries press the Save button.
Now Condition Type RGST for company code 1982 is created.
Steps to create Account Key
Step 1 : Enter T-Code SPRO and click on the button SAP Reference IMG & Navigate to SAP IMG Path
Financial Accounting >> Financial Accounting Global Settings >> Tax on Sale/Purchase >> Basic Settings >> Check and Change Setting for Tax Processing
Here we will define our account key
Enter T-Code OBCN
Step 2 : On Change View Text Processing and Accounting Screen click on the New Entries button
Step 3 : Give information in the following field.
Process : Enter process name as RG1
Description : RGST for company code 1982
Tax type : Select Tax type 1 for Input tax and Tax type 2 for Output tax
Posting indic : Select Posting indicator 2 for Separate line item
Press the Save button
Now the Account Key RG1 is created you can see it from the list.
It is the automatic mechanism developed to calculate tax on sales and purchases by the system. Tax Procedure should not be created for any company codes, it should be for one specific country.
There can be multiple tax procedures for the same country but for multiple company codes, there is a single tax procedure. There are so many country-specific Tax Procedures available in SAP, simply you can assign the tax procedure to your country and its applications. Tax Procedure should be assigned to the country before creating the Tax Codes.
Steps to create Tax Procedure
Financial Accounting(New) >> Financial Accounting Global SettingS(New) >> Tax on Sale/Purchase >> Basic Settings >> Check Calculation Procedure
Enter T.code OBYZ
Step 2 : A popup window screen appears with options. Double click the Define Procedures field.
Step 3 : On Change View “Procedure”: Overview screen click on New Entries button
Step 4 : On New Entries: Overview of Added Entries screen update the following field.
Procedure : Enter the name of the tax procedure which is a 5 digit key for example XYZIN.
Description : Descriptive text of the tax calculation procedure for example TAX PROCEDURE FOR XYZ INDIA.
After maintaining the details click on the Save button.
.jpg)
Step 5 : Now select the procedure XYZIN you created from the procedure tree and double click the Control Data folder
Step 6: Select the New Entries button
Step 7 : On the New Entries screen give information in the following fields.
Step : Enter the number like 10, 20 30….etc. which specifies the sequence of the procedure.
Condition type : Either we can create or use sap standard condition type for example BASB for Base Amount.
Description : The description text appears automatically based on the condition type
Account key : We link the account key to the tax procedure
After completing all the details click on the Save button and your tax procedure is successfully created and you can see it from the Procedure tree.
Step to assign the country to the tax procedure
Step 1: Enter T-Code SPRO and click on the button SAP Reference IM G & Navigate to SAP IMG Path
Financial Accounting(New) >> Financial Accounting Global Settings(New) >> Tax on Sale/Purchase >> Basic Settings >> Assign Country to the Calculation Procedure
Run T.code OBBZ
Step2: On the Change View “Assign Country” screen select the country from the list and change the tax procedure to XYZIN
Then press the Save button
Now your Tax procedure XYZIN is assigned to the country India .
Tax Codes are the tax rates used in the calculation of tax. We can create multiple Tax Codes.
Step to create Tax Code
Financial Accounting >> Financial Accounting Global Settings >> Tax on Sale/Purchase >> Calculation >> Define Tax Codes for Sales and Purchases
Now it will ask you to select the country of which you want to define Tax Codes
Step 2 : On the Maintain Tax Code : Initial Screen
- Country as IN India
- Tax Code as R1
Step 2 : Double click Tax code R1
Then the Properties window well come, update the following fields
- Tax Code : R1
- Tax type : V for Input Tax
Then press the check button
Now Maintain Tax Code: Tax Rates screen appears
In the field, Tax Percent Rate give the Input and Output Tax percentage as 18%.
Then press the Save button.
Now your Tax Code R1 is created successfully.
- SAP FICO Reverse Clearing Document
- Foreign Currency Valuation Configuration
- SAP FICO User Exit for Vendor Master
- SAP FICO Cash Management Group
- Assessment Cycle vs Profit Center
- SAP FICO Asset Accounting
- SAP FICO Posting Key for Bank
- SAP FICO Document Type
- SAP FICO Document Number Ranges
- SAP FICO Parked Workflow Configuration
- SAP FICO GL Account for Cash Journal
- SAP FICO Accounts Receivable Configuration
- SAP FICO Transaction Codes
- SAP AS11 Create Asset Sub-Number
- SAP Business Area and Profit Center
- SAP Active vs Passive Document Splitting
- Reverse MIRO Document in SAP
- SAP FICO Scope and Opportunity
- FICO Certification Cost in India
- SAP FICO Interview Questions
- What is SAP FICO?
- SAP FICO Training Tutorials for Beginners
- SAP FICO Define Account Group
- FICO Vendor Account Group Table
- SAP FICO Withholding Tax
- SAP FICO Dunning Area
- SAP FICO Classic GL vs New GL
- SAP FICO Accounts Receivable Process Cycle
- GR/IR Accounting Entries and Journal Entries
- SAP FICO Chart of Accounts
- SAP Inconsistent Withholding Tax Info
- SAP FICO Tree Menu
SAP SD Tax Determination Procedure Tutorial: VK12, OX10, OVK4, OVK1
SAP uses Condition Method technique to calculate taxes (except Withholding Tax) in the system. Tax Calculation Procedures (defined in the system) together with the Tax Codes are used in calculating the amount of tax.
The Tax Code is the first step in the tax calculation procedure. The Tax code describes following –
- Tax type (Tax Type can be defined by T-code –OVK1).
- Amount of tax calculated / entered.
- GL account for tax posting.
- Calculation of additional tax .
Each country has a specific Tax Procedure defined in the standard system. A Tax calculation procedure contains the following fields:
- Steps — It determine the sequence of lines within the procedure.
- Condition Types — Indicates how the tax calculation model will work (whether the records are for fixed amount or percentages and whether the records can be processed automatically.)
- Reference Step s— System obtains the amount/value it uses in its calculation (e.g. the base amount).
- Account/Process Keys — Provide the link between the tax procedure and the GL accounts to which tax data is to be posted. This helps in automatic tax account assignments. To enable this automatic assignment, there is a need to define the following:
- Posting keys (unless there is a specific requirement, it will be sufficient to use the GL posting keys: Debit: 40, Credit: 50).
- Rules to determine on which fields the account determination is to be based (such as the tax code or country key).
Step 1) Tax Category
Tax Category is used to group and manage similar product tax rates or service tax rates. Tax Rates are defined for each of the tax codes. The tax rates are linked to Tax Types and are included in the tax procedures (in this relationship, it is technically possible that a single tax code can have multiple tax rates for various tax types.) The tax code is assigned to a Tax Procedure, which attaches to a GL master record. A specific tax procedure is accessed whenever that GL account is used in document processing.
- Enter T-code OVK3 in the command field .
- Click on New Entries Button.
- Enter Tax Categories , Tax class and description.
- Click on save button.
A Message “Data was saved ” is displayed.
Step 2) Define Tax Types
- Enter T-code – OVK1 in the command field.
- Click on new entries button.
Step 2.2 Enter Tax country / Sequence / tax category and save the data .
Step 3) Assign the plant for Tax Determination.
- Enter T-code OX10 in the command field.
- Click on New entries Button.
- Enter Plant / Name1.
- Enter country code / city code.
- Save the data.
Step 4 Define the Material Taxes.
- Enter T-code OVK4 in the command field.
- Enter Tax category / Tax classification and description.
Step 5 Define the Tax Determination
- Enter T-code VK12 in the command field.
- Enter condition type .
Step 5.2 Select Domestic taxes.
- Enter Country / customer tax class / material tax class.
- Run the report.
Enter Customer Tax class/Material Tax class / amount / validity period and tax code.
Save the record.
You Might Like:
- SAP SD – Return Order, Free of Charge & Subsequent Delivery
- All About Consignment Process in SAP SD
- Output Determination in SAP SD using Tcode V/30
- Substitution Reasons OVRQ in SAP
- SAP Item Category Determination: VOV7, VOV4
- Ask a Question
- Write a Blog Post
- Login / Sign-up
Tax Procedure vs MM Pricing Procedure
Introduction:
In Indian taxation, we have different structure for calculating tax with vendor inward invoice. Few are discussed here.
Case 1: Freight / discount NOT included for Excise duty & VAT (Normal)
Case 2: Freight / discount included for Excise & VAT (Normal)
Case 3: Freight / discount NOT included for Excise but included for VAT (Non-Standard)
Case 4: Fetch tax value (deductible) from Tax procedure to MM Pricing Procedure
Case 5: Fetch tax value (non-deductible) from Tax procedure to MM Pricing Procedure
Case 6: Pass excise value from MM Pricing Procedure to Tax Procedure
========================================================================================================================
Reference for Case 3:
As per SAP Note 1559145 (3rd Question)
- Q. Tax element to be calculated on a differential base.
- A. Passing alternate base for Tax calculation. For E.g. # VAT to be calculated on Base + Excise + Freight. Use subtotals 4 or 6 against the Freight condition in PO. Assign alternate base value routine 362 or 363 against the condition whose base value is to be altered.
Base type in tax procedure:
Routine 362 : Refers to ‘subtotal’ MM pricing procedure, includes condition values ‘with subtotal 4’ and excludes condition values ‘with subtotal 6’
Routine 363 : Refers to ‘subtotal’ MM pricing procedure, includes condition values ‘with subtotal 6’ and excludes condition values ‘with subtotal 4’
Config in MM Pricing procedure: M/08
Case 1 : FRA1 – Freight condition not included for excise & VAT :subtotal ‘blank’
Case 2 : ZF10 – Freight condition included for excise & VAT :subtotal ‘4’
Case 3 : R010 – Discount condition not included for excise but included for VAT :subtotal ‘6’
Case 4 : JEXS – To fetch deductible tax value in tax procedure to pricing procedure
Case 5 : NAVS – To fetch non-deductible tax value in tax procedure to pricing proocedure
Case 6 : JEXC – To pass manual excise percentage or value to tax procedure
Config in Tax procedure: OBYZ
Case 2 : BASB : Maintain routine 362 in Base type
Case 3 : ZVAT : Maintain routine 363 in Base type
Case 4 : Account Key VS1 & IN1 for excise & tax conditions respectively for deductible taxes (see below screen shot in OBCN for VS1 & IN1)
Case 5 : Account key NVV for VAT conditions for non-deductible taxes (see below screen shot in OBCN for NVV)
Note : config for account key NVV & IN1
Tcode : OBCN or Financial Accounting (New) -> Financial Accounting Global Settings (New) -> Tax on Sales/Purchases -> Check and Change Settings for Tax Processing -> Execute : Check below setting for NVV (non deductible) & IN1 (deductible)
Freight is statistical or could be accounted to freight vendor separately
PO price : INR 100 per 1 EA (PB00)
Discount : INR 1 (FRA1)
ED : PB00
VAT : PB00 + ED
Case 2: Freight / discount included for Excise duty & VAT (Normal)
Freight : INR 1 (ZF10)
ED : PB00 + ZF10
VAT : PB00 + ZF10 + ED
Case 3: Freight / discount included for VAT ONLY (Non-Standard)
Discount : INR -1 (R010)
VAT : PB00 + R010 + ED
Excise is calculated on 100 (without discount) and VAT is calculated on 100 – 10 + 20 + 0.40 + 0.20 = 110.60 x 5% = 5.53
VAT and excise conditions are configured deductible. Rs. 26.63
VAT and excise condition values are transferred to condition JEXS in pricing procedure. Rs. 26.63
VAT is configured non-deductible. Tax : Rs. 6.03
VAT is transferred to condition NAVS in pricing procedure. Tax : Rs. 6.03
Value or percentage entered in JEXC in pricing procedure is transferred to tax procedure JMOP
JMOP value is copied from JEXC in pricing procedure
Hope the document is useful
Assigned Tags
i have a query, if there are any other conditions and configured after JEXS and the from value against those condition are taken on basic,then TAX should not calculate on the value after JEXS condition.
How to achieve this,i am facing this issue.
- Share Right click and copy the link to share this comment
Hi Kavitha,
Thanks for this nice document.
But it will be more helpful if you can brief the use of various type available:
1.) Subtotal .
2.) Requirement
3.) Calculation Type
4.) Bas Type
Manjeet Singh
Insert/edit link
Enter the destination URL
Or link to existing content
IMAGES
VIDEO
COMMENTS
List of Tax procedure tables in SAP. T5A2D for Tax procedure / reasons for tax exemption. EEDMSETTLPROCPA for Settlement Procedure (Procedure Parameters). EEDMSETTLPROCPAG for Settlement Procedure (Profiles as Procedure Parameters). ... Table for Assignment TTE Tax Type to Nota Fiscal Tax Type Table Type : TRANSP Package : CRM_LOC_BRAZIL Module ...
SAP Tables for Tax Procedure — the most relevant and popular Tables are listed at the top. You can click on a Table to view more information like table structure, field names, SAP Help/reference links etc. You can also click on the Functional Area to view all the Tables for that module/sub-module. Communication Release Strategy Determination ...
Configuration for Tax Code steps are 1. Maintain the Tax Procedure OBQ1 2. Maintain the Tax Processing in Accounting OBCN 3. Change View of procedure & go to control OBQ3 4. Maintain the Tax Code FTXP 5. Changing in GL Master for assign TAX Code FS00 6. GL assign to Maintain Configuration for automatic posting OB40 7.
Tax Procedures are assigned to countries in transaction OBBG Tax Jurisdictions Represent government authorities to which taxes need to be paid SAP allows up to 4 levels tax jurisdictions representing state, country, city, and others Configuration - Jurisdiction Code Structure Tax Jurisdiction structure must be defined in transaction OBCO
SAP Tax Procedure Tables : TTEC_PROCEDURE - Tax Procedure Tcode, T5A2T - Tax Procedure (A) Tcode, T5D2G - Tax Procedure (D) Tcode, T5W2F - (Old) RSA Tax Procedures Tcode, TTE2C_TAX_MAP - Mapping between Tax Type and Procedure Tcode ... Taxes: Material, Plant, Account Assignment and Origin: SD-MD: A094: Taxes: Material, Plant, Origin and Region ...
Tax configuration in sap: Tax procedure, Tax code & Tax jurisdiction code Share this: For calculation of tax, we need to have tax base amount and tax rate. Tax rate is the tax percentage which is to be applied on tax base amount to arrive at tax amount. Tax base amount is the amount on which tax rate is to be applied.
CRMC_TAX_CP is a standard Tax Determination Transparent Table in SAP CRM application, which stores Assignment of Partner System to Pricing Procedure data. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition. Table of Contents
Step 1) Enter transaction code "OBYZ" in the SAP command field and enter. Step 2) A pop up window condition element screen displays with options, you need to choose procedures so double click on it. Step 3) On change view procedure screen, click on new entries button for definition of new tax procedure in SAP.
Here is a list of possible Tax company code related tables in SAP. You will get more details about each SAP table by clicking on the table name. ... Table for Deifne Tax Determination Procedure Per Company Code Group Table Type : TRANSP Package : EE21 ... Table for Tax Code Assignment per RE Tax Type/Group Table Type : TRANSP Package : RE_EX_FI
You can assign tax calculation procedure to country IN (India) for SAP GST by using the following navigation method IMG Path: IMG > Financial Accounting > Financial Accounting Global Setting > Tax on Sales/Purchases > Basic Settings > Assign country to calculation procedure. Transaction code: OBBG.
Step to assign the country to the tax procedure. Step 1: Enter T-Code SPRO and click on the button SAP Reference IM G & Navigate to SAP IMG Path. Financial Accounting (New) >> Financial Accounting Global Settings (New) >> Tax on Sale/Purchase >> Basic Settings >> Assign Country to the Calculation Procedure. Or.
Step 5.1. Enter T-code VK12 in the command field. Enter condition type . Step 5.2 Select Domestic taxes. Step 5.3. Enter Country / customer tax class / material tax class. Run the report. Step 5.4. Enter Customer Tax class/Material Tax class / amount / validity period and tax code.
Tax Procedure vs MM Pricing Procedure 2 5 12,017 Introduction: In Indian taxation, we have different structure for calculating tax with vendor inward invoice. Few are discussed here. Case 1: Freight / discount NOT included for Excise duty & VAT (Normal) Case 2: Freight / discount included for Excise & VAT (Normal)