Change of bank key in banks and house bank

[maekman]

Hi SAP professionals,

We have a client S/4 HANA public cloud implementation project. We have created the bank - house bank - bank account - house bank account structure in DEV system and related to that also the bank determination config has been done based on that, using HB and HBA codes. 

Now the client wants to have bank key in bank changed from randomly what was in legacy system to SWIFT/BIC code. In 2 bank accounts for 2 banks, there are transactions already in DEV and TEST. 

How should we carry out the setup step by step in the right order. We only get errors referring to that something is in use already. 

Appreciate your comments very soon!

Br,

ME

[erickgoulardt]

Dear Maekman, I hope you find yourself well! Thank you for joining the community. As soon as possible, a technical expert will contact you to clarify your question. I am adjusting the tags to redirect the issue to the right team. Best Regards, Erick Goulardt SAP Support

[HenrikeGrötecke]

Thanks for your question. It has been forwarded to the experts.

[BobShen · Accepted solution]

To change the bank key from a random legacy system value to the SWIFT/BIC code and update the bank account structure in your S/4 HANA public cloud implementation project, follow these steps:

1. Create a new bank master record:

   • Use the "Manage Banks" app to create a new bank with the SWIFT/BIC code as the bank key [1].
   • Set up the bank name, address, SWIFT code, bank branch, and bank number [1].

2. Set up a new house bank:

   • In the "Manage Banks" app, search for the newly created bank record [1].
   • Click on the bank name to display the record [1].
   • Go to the House Bank tab and click "Add Record" [1].
   • Enter the new House Bank ID and Company Code, then save [1].

3. Create a new bank account number:

   • Use the "Manage Bank Accounts" app and click "Add Record" [1].
   • Enter the new account details, including Account Number, Description, Bank Country, and Currency [1].
   • Select the newly created bank key from the drop-down menu [1].
   • In the General Data section, enter Company Code, Account Holder, Account Type, and Opening Date [1].
   • If applicable, maintain IBAN and Bank Control Key [1].

4. Link the new house bank account:

   • In the "House Bank Connectivity" tab, click "Add Record" [1].
   • Enter the Company Code, select the new House Bank from the drop-down, and maintain the House Bank Account ID [1].
   • In the House Bank Account Data section, select the Main Bank G/L Account number [1].

5. Update bank determination configuration:

   • After creating the new house bank account, update the settings in the configuration activity "Set Up Bank Determination for Payment Transactions" [2].

6. Handle existing transactions:

   • For the two bank accounts with existing transactions in DEV and TEST, you may need to create a migration strategy to move these transactions to the new account structure.

7. Update payment methods:

   • Revise the payment method configuration to use the new bank account details [3].

8. Block or delete old accounts:

   • Once all transactions are migrated, block or delete the old bank accounts to prevent further use [4].

9. Remove old house bank and account ID:

   • After ensuring all processes are using the new structure, remove the old house bank and account ID configurations [4].

10. Update electronic bank configuration:

    • If necessary, adjust the electronic bank configuration to reflect the new account structure [4].

Remember to test these changes thoroughly in your DEV and TEST environments before implementing them in production. If you encounter errors related to items already in use, you may need to carefully migrate existing data or transactions to the new structure before removing the old one.

[HenrikeGrötecke]

Hello,

Thank you for your question. Here's what the expert replied:

Ideally, bank key (BNKA-BANKL) can’t be changed since this is primary key of bank master. User can change bank number (BNKA-BNKLZ) and BIC (BNKA-SWIFT) code or create a new bank master with different bank key.

If new bank master is created, then the idea is to create new bank account, house bank, house bank account. For the existing bank accounts, customer can close them if they are no longer valid.

Kind regards,

Henrike