Symptom
Unable to update table BUT0ID "Identification" table using Manage Mass Maintenance app.
Environment
- SAP S/4HANA Cloud Public Edition
- SAP Master Data Governance
Reproducing the Issue
- Open Export Master Data - Business Partners and select scope for Identification numbers (BUT0ID) and export the file.
- In the file make changes to field Identification type (BUT0ID-TYPE).
- Upload the file into the App Manage Mass Maintenance.
- Notice the process completes without error but no changes are saved.
Cause
The Manage Mass Maintenance application does not update key fields.
For the BUT0ID table the fields Partner number (BUT0ID-PARTNER), Identification type (BUT0ID-TYPE) and Identification Number (BUT0ID-IDNUMBER) are key fields.
Resolution
Since the key field values cannot be changed in the Manage Mass Maintenance app you will need to delete the entry and insert the entry with the updated value.
The following assumes you already have the file exported using "Export Master Data - Business Partner"
Note: Perform the below only if you wish to update field Identification type (BUT0ID-TYPE) or Identification number (BUT0ID-IDNUMBER)
- In the excel file use action code (D) to delete the line entry that you wish to change the value for field Identification type (BUT0ID-TYPE) or Identification number (BUT0ID-IDNUMBER).
- In the excel file use action code (I) to insert the line record with the updated value for field Identification type (BUT0ID-TYPE) or Identification number (BUT0ID-IDNUMBER).
- Upload the file in app "Manage Mass Maintenance - Business Partner" and check if the changes are saved properly.
Note for more information regarding action codes please see documentation: https://help.sap.com/docs/SAP_S4HANA_CLOUD/f86dc2eb1f8b48c880a7607213104b27/a09c0ef011d846eb9b3968b0323d239b.html?ai=true&version=2608.500
See Also
Keywords
mass update business partner, supplier business partner, import template missing fields, export master data bp, manage mass maintenance bp, BUT0ID, BUT000, action_code, fiori app, mass changes bp, template attributes missing, import fails, Invalid Key Entry in Line 3, Sheet "BUT0ID - Identifiers" , KBA , CA-MDG-CMP-BP , Business Partner , Problem
SAP Knowledge Base Article - Public