SAP Knowledge Base Article - Public

2931889 - How to Mass Update Blank Values in the Region Field of Materials Under Taxes tab

Symptom

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

Environment

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.

Cause

The Region field is a Key field in Mass Data Maintenance and the Migration Tool. So, it is not possible to update blank values.

Resolution

You need to use the WebService "ManageMaterialIn" inorder to update the blank values in the Region Field.

Sample Payload: -

<n0:MaterialBundleMaintainRequest_sync_V1 xmlns:n0="http://sap.com/xi/SAPGlobal20/Global">
<Material actionCode="02">
<InternalID>XXXXXXXXX</InternalID>
<ProductCategoryID>50-10</ProductCategoryID>
<BaseMeasureUnitCode>ZZ</BaseMeasureUnitCode>
<DeviantTaxClassification actionCode="02">
<CountryCode>YY</CountryCode>
<RegionCode></RegionCode>
<TaxTypeCode listID="">1</TaxTypeCode>
<TaxRateTypeCode listID="">2</TaxRateTypeCode>
<TaxExemptionReasonCode listID="">G</TaxExemptionReasonCode>
</DeviantTaxClassification>
</Material>
</n0:MaterialBundleMaintainRequest_sync_V1>

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.

See Also

For detailed explanation on how to use the web service, please refer to the below links: -

https://help.sap.com/doc/a2b4c7ef61d64397b2b1d052082a8a08/1905/en-US/IntegrationServices.html

https://help.sap.com/doc/a2b4c7ef61d64397b2b1d052082a8a08/1905/en-US/PSM_ISI_R_II_MANAGE_MATERIAL_IN.html

Keywords

 Webservice, Mass Data Maintenance, Migration, Taxes , KBA , AP-PRD-MIG , Product Data Migration and Replication , Problem

Product

SAP Business ByDesign all versions