Symptom
- An error occurs when trying to update vendor bank accounts in the app "Manage Mass Maintenance".
- Error message: "Invalid key entry in line 3, sheet 'BUT0BK - Bank Accounts' in table 'BUT0BK'".
- Message no.: MDC_LOAD139.
- The error occurs with vendors whose bank account details have not been updated.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Open the app Manage Mass Maintenance.
- Select Business Partners.
- Select the process ID 75 or attempt to upload the vendor bank account file.
Cause
Missing _ACTION_CODE column for the BUT0BK sheet when inserting new bank account records, causing the upload to fail with an invalid key entry error.
Resolution
- Open the upload file used in Manage Mass Maintenance.
- In the sheet "BUT0BK - Bank Accounts", add a column named BUT0BK-_ACTION_CODE (format the column as Text).
- For every new bank account row being inserted, set BUT0BK-_ACTION_CODE to I.
- Ensure the value I is uppercase and has no leading or trailing spaces.
- Save the file and re-upload it in Manage Mass Maintenance.
See Also
Keywords
manage mass maintenance, business partners, but0bk, bank accounts, invalid key entry, mdc_load139, _action_code, insert, vendor bank data, file upload, bank key, upload error, mass update, data import, supplier bank details , KBA , CA-MDG-CMP-AF , Application Framework , Problem
Product
SAP S/4HANA Cloud Public Edition all versions
SAP Knowledge Base Article - Public