SAP Knowledge Base Article - Public

2498592 - Error Message While Uploading Tax Data for Materials Using Mass Data Maintenance

Symptom

1. The Tax details are not present for the Materials. Your requirement is to upload the Tax data for the Materials using Mass Data Maintenance. Upon executing the file, you receive the below error:

Update not possible; specified data for MATERIAL-DEVIANT_TAX_CLASSIFICATION with key COUNTRY_CODE = `XX` AND TAX_RATE_TYPE_CODE-CONTE does not exist

2. Your requirement is to modify the existing Tax Rate Type for the Materials using Mass Data Maintenance. Upon executing the file, you receive the below error:

Update not possible; specified data for MATERIAL-DEVIANT_TAX_CLASSIFICATION with key COUNTRY_CODE =`XX` AND REGION_CODE-CONTENT = `YY` AND TAX_RATE_TYPE_CODE-CONTENT = `Z` AND TAX_TYPE_CODE-CONTEN

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Mass Data Maintenance work center
  2. Select Export Materials link
  3. Export the Taxes tab to CSV file and add the data in the field required fields
  4. Select Import Materials link and upload the file to the Taxes tab
  5. Execute Data Import Immediately
  6. Error occurs

Cause

Mass Data Maintenance tool is used to modify already existing records, but it is not possible to upload new data in the system.

Resolution

1. To add Tax data in Materials, you can use the activity Migration of Materials with the migration mode: Enhance already existing records by following the below steps:

  1. Go to Business Configuration work center
  2. Select Implementation Projects view or Overview
  3. Search and Open the activity Migration of Materials
  4. Choose Migrate materials using the migration tool
  5. Select You Can Also at the top right corner of the screen and Download Migration Template
  6. Fill the necessary fields and upload the migration file in the migration tool
  7. Select Properties and choose the migration mode: Enhance already existing records
  8. Execute migration
  9. Check the respective Materials to understand if the Tax data upload was successful

 

2. You have not filled Region field in the template. Region is part of key information (Country, Region and Tax Type) and Tax data without Region cannot be updated. Update of tax details is possible from mass data maintenance , provided the keys(Country, Region and Tax Type) are filled completely.

Keywords

COUNTRY_CODE, Tax, REGION_CODE-CONTENT, Migration of Materials, MATERIAL-DEVIANT_TAX_CLASSIFICATION, Tax Rate Type, TAX_RATE_TYPE_CODE-CONTENT , KBA , tax , country_code , region_code-content , migration of materials , material-deviant_tax_classification , tax rate type , tax_rate_type_code-content , SRD-MD-PRD-PRD , Product , How To

Product

SAP Business ByDesign all versions