Symptom
The Tax details are not present for the Suppliers. Your requirement is to upload the Tax data for the Suppliers using Mass Data Maintenance. Upon executing the file, you receive the below 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 Suppliers link
- Export the Taxes tab to CSV file and add the data in the field required fields
- Select Import Suppliers link and upload the file to the Taxes tab
- Execute Data Import Immediately
- 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
- Go to Business Configuration work center
- Select Implementation Projects view or Overview
- Search and Open the activity Migration of Suppliers
- Choose Migrate suppliers using the migration tool
- Select You Can Also at the top right corner of the screen and Download Migration Template
- Fill the necessary fields and upload the migration file in the migration tool
- Select Properties and choose the migration mode: Enhance already existing records
- Execute Migration
Check the respective Suppliers to understand if the Taxes data upload was successful.
Keywords
SUPPLIER-DEVIANT_TAX_CLASSIFICATION, Tax, TAX_NUMBER_TYPE_CODE-CON, COUNTRY_CODE , KBA , supplier-deviant_tax_classification , tax_number_type_code-con , SRD-MD-BP-SUP , Suppliers , How To