You are trying to Mass update Region Field with blank values in the Taxes tab of Materials. But, the system is giving the error, Update not possible; specified data for SUPPLIER-DEVIANT_TAX_CLASSIFICATION with key COUNTRY_CODE = `XX` AND TAX_NUMBER_TYPE_CODE-CON does not exist
SAP Business ByDesign
Reproducing the Issue
- Go to Mass Data Maintenance work center.
- Select Export Materials link.
- Export the Taxes tab to CSV file and remove the entries in the Region Field.
- Select Import Materials link and upload the file to the Taxes tab.
- Execute Data Import Immediately.
- Error occurs.
The Region field is a Key field in Mass Data Maintenance and the Migration Tool. So, it is not possible to update blank values.
You need to use the WebService "ManageMaterialIn" inorder to update the blank values in the Region Field.
Sample Payload: -
Note: While update or delete the values of fields CountryCode, RegionCode, TaxTypeCode are mandatory and have to be filled with correct values. The RegionCode field has to be left blank if the Region is empty but the tag has to be there in the payload with empty value as in the examples above.
For detailed explanation on how to use the web service, please refer to the below links: -
Webservice, Mass Data Maintenance, Migration, Taxes , KBA , AP-PRD-MIG , Product Data Migration and Replication , Problem