SAP – Sales and Distribution – Tax control and Revenue Account Determination – Lesson 10
Define Tax condition type
Taxes as applicable in a country as per material and customer can be configured using pricing condition types for the relevant taxes.
Tax rates can be maintained by integration with FI. Departure and destination can also be used in configuring taxes.
Specific requirements of local taxes with tax jurisdiction can be mapped by allowing interface with external tax systems like Vertex.
Follow Menu Path: IMG –> Sales and Distribution –> Basic Functions –> Pricing –> Pricing Control
Taxes are defined as condition types in pricing
Double click on “Maintain Condition Types”
Example – Tax determination for US sales documents with tax jurisdiction
Country – United States
Tax condition type – UTXJ, XR1 to XR6
UTXJ is statistical tax type to pass jurisdiction data to external system.
XR1 to XR6 are defined to receive tax rates for local taxes. On the screen displayed, search condition type UTXJ.
Select condition type XR1
Define Tax determination rules
Let us understand how tax condition types are configured for determination in sales documents.
Click on “Define Tax determination rules”
Define Tax relevancy of master records
Click on “Tax relevancy of master records”
In this configuration, select tax classifications allowed per tax condition type for material and customer taxes.
As taxes could be exempt for certain customers and materials or could be charged with different rates depending upon the classification of materials or customers as per tax laws, tax classifications are maintained against a tax condition type.
In material and customer masters, for a tax condition type, one of these tax classifications is entered. While maintaining tax records, material and customer tax classifications could be used as a part of key combination.
Click on “Customer taxes” Select UTXJ
Click on “Material taxes” Select UTXJ
When tax jurisdiction code is required for external tax system for delivering location, it is taken from the plant definition.
The above configuration gives the tax jurisdiction number, which is passed on to external tax system like Vertex for calculation of tax rates.
Revenue account determination
We will study Revenue Account Determination, which is important to understand from SD point of view.
The settings in revenue account determination enable posting of billing values like sales revenue, discount & tax to the correct G/L (General ledger) account.
There are following factors given by standard SAP to determine G/L accounts
- Chart of account (As assigned to company code)
- Sales organization (Sales organization of the sales document)
Optional factors can be
- Account key (It gets determined as per the account key assignment to condition type in the pricing procedure of the sales document)
- Material account assignment group (sales org data of the material)
- Customer account group (sales area data of Payer master record)
Let us see where they are maintained in IMG
Follow Menu Path: IMG –> Sales and Distribution –> Execute Project
Click on “Execute Project”
Enter Transaction Code – “SPRO”
Master data relevant for account assignment
Of the optional factors mentioned above, let us understand the configuration of Customer and Material Account Group.
Menu Path:- IMG –> Sales and Distribution –> Basic Functions –> Account Assignment/Costing –> Check master data relevant for account assignment
Click on “Check Master Data relevant for Account Assignment”
Keep the cursor on the line and click on
Material account assignment group can be used to post billing values of different types of materials, for example – trading goods to different G/L accounts than finished goods.
Note - With configuration, also understand where material account assignment group maintained in the material master.
Customer account group can be used to post billing values to different G/L accounts depending on requirement like reporting revenues separately for domestic and export sales.
Note - With configuration, also understand where customer account assignment group maintained in the customer master.
Define and assign account key
Menu Path: – IMG –> Sales and Distribution –> Basic Functions –> Account Assignment/Costing –> Define and Assign Account Keys
Click on “Define and assign account key”
Double click on “define account key”
Assign Account key to condition types in the pricing procedure
So far, we have seen configuration for factors / criteria, which could be used in determining G/L accounts.
Condition technique for account determination
Now, understand use of condition technique to use these factors
1. Create condition tables by selecting fields from the field catalog. These fields would be required to map the criteria.
2. Create Access Sequence to add condition tables
3. Create Condition type to link the access sequence.
4. Create Procedure to include condition types, which would be checked and processed during document processing
5. Assign procedure to the document type so that procedure is used during processing of document.
Click on “Define dependencies of Revenue account determination”
Double click on Field catalog: Allowed fields for the tables
This will have the fields required as criteria for G/L account determination.
Tables can be created using above fields. Each table can then used in access sequence KOFI.
Let us see standard table, 1 used in access sequence KOFI Double click on “Account determination: Display tables”
In table, 001, criteria set is seen in selected fields.
Click on “Access sequences and Account determination types”
Double click on “Maintain access sequences for account determination”
Select KOFI and click on Accesses
Standard tables created in step 1 are assigned in this access sequence.
Select access 10 and click on fields, it will show fields which were used in table 001.
Double click on “define account determination types”
Access sequence KOFI is linked to Account determination type KOFI.
Click on “Define and Assign Account Determination Procedures”
Double click “Assign account determination procedure”
Select KOFI00 and click ‘control data’
Double click “Assign account determination procedure”
With the above configuration set up, G/L accounts can be setup using different criteria.
Double click on “Assign G/L accounts”
These are standard criteria given. Using condition technique steps above, new criteria can always be setup creating new condition tables and then following rest of the steps as required.
Double click on table 001
Table 001 can have entry like the one below.