SAP Knowledge Base Article - Public

3283167 - Update of Materials Tax Details not possible through Migration Tool and Mass Data Maintenance

Symptom

You want to update the Tax Details for Materials using the Migration Tool with Enhance already existing record or using Mass Data Maintenance for the same, however you get the below error messages.

"Similar entry already exists"

"Missing key specification for processing node PDM_MATERIAL DEVIANT_TAX_CLASSIF Update not possible; existing data for DEVIANT_TAX_CLASSIFICATION not fully specified"

Environment

 SAP Business ByDesign

Reproducing the Issue

  1. Go to the Mass Data Maintenance work center
  2. Click on Import Materials link
  3. Upload the Template
  4. Click on Execute Data Import 
  5. Error received as "Missing key specification for processing node PDM_MATERIAL DEVIANT_TAX_CLASSIF Update not possible; existing data for DEVIANT_TAX_CLASSIFICATION not fully specified"

And other way is to update the Tax details are as follows:

  1. Go to Business Configuration
  2. Select overview
  3. Search Migration of Materials
  4. Select the link and open the migrtaion tool
  5. Upload the file with details in Tax tab
  6. Select Enhance already existing record
  7. Error received as "Error detected in source record with key value 'XYZ' Similar entry already exists" 

Resolution

If you encounter the similar situation please follow the below:

The field: TAX_RATE_TYPE_CODE-CONTENT is PSM write released and therefore kindly use the workaround to make changes using OData service.

See Also

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

You can refer these documentation for your help:

SAP Business ByDesign – OData API Examples (https://blogs.sap.com/2019/02/27/sap-business-bydesign-api-usage-samples/)

SAP Business ByDesign – API Overview(https://blogs.sap.com/2019/09/26/sap-business-bydesign-an-api-overview/)

SAP Business ByDesign(https://api.sap.com/package/BYD/soap)

Keywords

Tax Details, TAX_RATE_TYPE_CODE-CONTENT, Migration of Materials, Tax Rate Type, MATERIAL-DEVIANT_TAX_CLASSIFICATION , KBA , tax_rate_type_code-content , tax details , migration of materials , tax rate type , material-deviant_tax_classification , AP-PRD-MAT , Material , Problem

Product

SAP Business ByDesign 2208