Symptom
You are trying to update Company ID for existing Suppliers using Mass Data Maintenance and you receive the following errors:
"No Suppliers - Script Changes imported successfully, 1 Suppliers - Script Changes failed."
"Update not possible; specified data for SUPPLIER-PAYMENT_DATA with key COMPANY_ID = XYZ does not exist" (where XYZ represents the Company ID)
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Mass Data Maintenance work center.
- Click on the Export Suppliers link.
- Export the Payment Data tab to CSV file and update the details for the Supplier.
- Select Import Suppliers link and upload the file to the Payment Data tab.
- Execute Data Import Immediately.
- Error occurs.
Cause
The Supplier ID, Company ID and the Account Determination Group together form the key of a particular record, which will determine the data to be updated from the remaining fields in the CSV file.
Being the key fields, an entry with the combination of these fields must already exist in the system. Otherwise the record from the CSV cannot be fetched with the existing data for the Mass Data Maintenance operation and is interpreted as an update of the key fields, which is not supported.
The Mass Data Maintenance functionality purely depends on the key field values to perform the update of other fields.
Resolution
Using Mass Data Maintenance functionality, you can update data of the respective sheet which are not marked as key. Key fields are used to uniquely determine the records. Changing the key field would give you an error that the record is not found as the record with that key does not exist.
Keywords
Account Determination Group, Company ID, Suppliers, Import Suppliers , KBA , update not possible , supplier-payment_data , payment data , SRD-MD-BP-SUP , Suppliers , How To