SAP Knowledge Base Article - Public

3796097 - Invalid key entry in but0bk when updating vendor bank accounts via manage mass maintenance

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

  1. Open the app Manage Mass Maintenance.
  2. Select Business Partners.
  3. 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

  1. Open the upload file used in Manage Mass Maintenance.
  2. In the sheet "BUT0BK - Bank Accounts", add a column named BUT0BK-_ACTION_CODE (format the column as Text).
  3. For every new bank account row being inserted, set BUT0BK-_ACTION_CODE to I.
  4. Ensure the value I is uppercase and has no leading or trailing spaces.
  5. 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