SAP Knowledge Base Article - Public

2297838 - "No Suppliers - Script Changes imported successfully" Error in Mass Data Maintenance

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

  1. Go to Mass Data Maintenance work center.
  2. Click on the Export Suppliers link.
  3. Export the Payment Data tab to CSV file and update the details for the Supplier.
  4. Select Import Suppliers link and upload the file to the Payment Data tab.
  5. Execute Data Import Immediately.
  6. 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

Product

SAP Business ByDesign all versions