When you are trying to update Company ID for existing Suppliers using Mass Data Maintenance 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
*XYZ represents the Company ID
SAP Business ByDesign
Reproducing the Issue
- Go to Mass Data Maintenance work center
- Select Export Suppliers link
- Export the Payment Data tab to CSV file and update the Company ID details for the Supplier
- Select Import Suppliers link and upload the file to the Payment Data tab
- Execute Data Import Immediately
- Error occurs
These errors occur as the Company ID field is a key field, and the key fields update from Mass Data Maintenance is not supported.
The Mass Data Maintenance functionality purely depends on the key field values to perform the update of other fields.
In this case the Supplier ID, Company ID and the Account Determination Group together form the key and hence it will not be possible to update any of these key fields.
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 would not be existing.
The only possible option now would be to manually update the Company ID for the Suppliers from the UI.
Account Determination Group, Company ID, Suppliers, Import Suppliers , KBA , update not possible , supplier-payment_data , payment data , SRD-MD-BP-SUP , Suppliers , How To