Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

The purpose of this document is to describe the process as how Tax classification data should be maintained for Material/ Product and BP/Customer in both ERP and CRM. The below description will guide you through the necessary tables and configuration to be maintained on ERP and CRM side.

1)      PRODUCT TAX CLASSIFICATION

The product Tax classification in ERP and CRM side is maintained manually. To maintain the tax data for product following tables and settings should be consider:

1)      The check tables for Product Tax data in ERP are TSTL and TSKM.

SPRO Path for Table TSTL:

 Sales and Distribution Basic Functions Taxes Define Tax Determination Rules.


SPRO Path for Table TSKM

Sales and DistributionàBasic FunctionsàTaxesàDefine Tax Relevancy Of Master Records (double click on Material Taxes).

Fig: Table TSKM

2) For each combination of country, tax category and tax classification in the tables TSTL and

TSKM we have to create an entry in the table CRMC_TAX_MAP in the CRM system as follows:

a)      SPRO Path: Customer Relationship Management  Basic Functions  Taxes àBasic Settings  Tax Types and Tax Groups à Assign Tax Groups to SAP ECC Tax Classifications (Product).

Fig: Table CRMC_TAX_MAP

b)      Choose New Entries.

c)       Enter values for country, tax type, product tax group, tax sequence and tax classification (The data should be similar with table TSTL and TSKM).

So, the above entries we have to do it “manually” for the Product tax classification in CRM system.

Example:

Table TSTL

Country

LFDNR

TATYP

CA

1

CTX1

CA

2

CTX2

CA

3

CTX3

 

Table TSKM

TATYP

TAXKM

CTX1

0

CTX1

1

CTX2

0

CTX2

1

CTX3

0

CTX3

1

 

  • CRM

Table CRMC_TAX_MAP (assignment) which is also the IMG activity Assign Tax Groups to SAP ECC Tax Classifications (Product)

Country

Region

Tax Type

Tax Group

Tax Seq.

Tax Class.

CA

 

CTX1

NON

1

0

CA

 

CTX1

FULL

1

1

CA

 

CTX2

NON

2

0

CA

 

CTX2

FULL

2

1

CA

 

CTX3

NON

3

0

CA

 

CTX3

FULL

3

1

 

2)      BP TAX CLASSIFICATION

Follow the below steps to replicate Tax classification data from ERP to CRM:

1)      Maintain the Country, Tax Category and sequence in table TSTL. The same will be replicated to CRM table TB070.

For this follow the below SPRO path:

Sales and Distributionà Basic Functionsà Taxesà Define Tax Determination Rules

Fig:  Table TSTL

2)      Then maintain the Tax Category and Tax  Classification in table TSKD in the below SPRO path:

Sales and DistributionàBasic FunctionsàTaxesàDefine Tax Relevancy of Master Records (double click on Customer Taxes).

Fig: Table TSKD

3)      The entry of the above two tables (TSTL & TSKD) should be maintain in table TB071_CM. follow the below steps to maintain the business partner details in other SAP component.

SPRO path for TB070_CM:

Integration with Other mySAP.com Components à Customer Relationship Management à Basic Functions à Taxes à Business Partner Tax Groups à Define SAP CRM Tax Types and Business Partner Tax Groups.

Fig:  Table TB070_CM

The entry for table TB071_CM will come by selecting particular country and double click on “Assign BP Tax Group”.

Note: The table TB071_CM should have same entry maintained as in TSTL and TSKD for the particular country. The Table TB071_CM will be replicated to CRM table TB071.

Fig: Table TB071_CM

4)      Then Assign the SAP CRM BP Tax Groups to Tax Classifications in table TB072_CM.The Tax group maintained in table TB071_CM is assign to CRM Tax classification. The entry maintained in this table is replicated to CRM table CRMC_TAX_MAP_BP.

SPRO Path:

Integration with Other mySAP.com Components à Customer Relationship Management à Basic Functions à Taxes à Business Partner Tax Groups à Assign SAP CRM BP Tax Groups to Tax Classifications

Fig: Table TB072_CM

5)      After maintaining the SPRO settings check the BP customizing in Transaction CRM_TAX_VALIDATE_BP for the particular country. It should be green then only the Tax data will download to CRM.

6)      Now, follow the below steps to copy the Tax data from ERP to CRM.

In CRM system open T-Code R3AS.Run the object “DNL_CUST_TAX”. The object should be in running status.



7)      Replication done in CRM table TB070, TB071 and CRMC_TAX_MAP_BP







  • No labels