Skip to Content
Product Information
Author's profile photo Marius Lauruc

Bank account management in SAP S/4HANA

The following article is an exemplification of the most common business operations related to bank account management, performed in a SAP S/4HANA environment using SAP Fiori App instead of classic SAP GUI transaction code (tcode). This may be useful once your company implements  the next generation ERP, i.e. SAP S/4HANA starting with which you can create or edit Bank Accounts only by using Manage Bank Accounts Fiori App.

Contents

  1. A) Open Bank Account
  2. B) Create a bank key
  3. C) Create a new Bank G/L Account (Optional)
  4. D) Manage House Banks
  5. E) Create Bank Account
  6. F) Close Bank Account
  7. G) Reopen Bank Account
  8. H) Export/Import Bank Accounts
  9. I) Conclusions
  10. Appendix

 

A) Open Bank Account

Bank accountant or company representative goes to the bank and open a new bank account.

 

B) Create a bank key

Create a bank key that does not exist in production system. If the bank key already exists, you can skip this step.

Note: In a productive scenario the bank key must be created in the production system, development system, and consolidation test system.

Manage Banks Basic – Fiori App applicable to creation of Bank Key/Bank Number

  1. Create Bank
  2. Change Bank
  3. Set Bank deletion flag (If House Banks exist. Bank will not be marked as deleted. Delete house banks first).
Table SAP GUI Tcode in ERP Fiori App in SAP S/4HANA SAP GUI Tcode in SAP S/4HANA
Bank Key
(BNKA)
FI01, FI02, FI03, FI06 (Create, change, display, set deletion flag) – Manual creation or upload tools for mass creation Manage Banks Basic

Still possible but not recommended

FI01, FI02, FI03

Note: Fiori App Manage banks can also be used to add a new Bank Key/Bank Number but additionally House bank (also used for linking house bank to bank).

Exercise:

Create a new bank key, for example:

Bank Country     +            Bank Key             +            Bank Name

NO                       +            12345                  +            BANK TEST 1

Steps:

  1. In the app Manage Banks search the bank number you desire to create to check if it was not already created.
  2. Click Create Bank button in the bottom-right corner of the screen
  3. Fill in at least mandatory fields like Bank Country & Key & Name, then Save.

 

C) Create a new Bank G/L Account (Optional)

Create a Bank G/L Account – The G/L accountant may create the G/L accounts of newly created bank account.

Note:

You can use the same G/L accounts for different bank accounts when they use the same currency key.

– If you want you can create a new G/L account for a new bank account. Create G/L accounts in production system, development system, and consolidation test system.

For exemplification an existing GL Acc 192000 (CoCd 1100 – MyCompany) will be used.

 

D) Manage House Banks

Create a house bank that does not exist in productive system. If you opened a new bank account in an existing house bank in your system, skip this step.

Note: In a real productive business scenario, perform this step in the development system, consolidation test system, and production system since house banks are master data in the SAP S/4HANA system. Only Bank Accounts can be imported/exported using the Excel spreadsheet import/export feature.

Manage banks – Fiori app applicable to Bank Key/Bank Number and House bank (also used for linking house bank to bank).

  • Create Bank
  • Change Bank
  • Set Bank deletion flag (If House Banks exist. Bank will not be marked as deleted. Delete house banks first).
  • Add/Delete House Bank V_T012 (If bank accounts exist, deletion is not possible);
Table SAP GUI Tcode in ERP Fiori App in SAP S/4HANA SAP GUI Tcode in SAP S/4HANA
House Bank
(V_T012)
FI12 Manage Banks

Possible but not recommended

FI12_HBANK

 

Exercise:

Create a new house bank, for example:

CoCd     +            House Bank        +            Bank Country    +            Bank Key

1100      +            HBT1                   +            NO                      +            12345

Steps:

  1. In the app Manage Banks search your desired bank key or create a new one if required
  2. Click on the bank name in search displayed results
  3. Click Edit button in the bottom-right corner of the screen
  4. Under the house bank tab, click on the “+” sign to create a new house bank within your Bank.
  5. Fill in at least mandatory fields like CoCd and House Bank name, then Save.

 

E) Create Bank Account

This step describes how to create a new bank account by a bank accountant

Manage Bank AccountsThis App is used for Bank Account Master Data Processing to Create/Modify/Copy/Close & Reopen Bank Account.

Manage Bank Accounts – with Direct Revision Active:

  • Create Bank Account
    • Export/Import Bank Accounts
  • Modify Bank Account
    • Export/Import Bank Accounts
  • Close and reopen Bank Account

 

Table SAP GUI Tcode in ERP Fiori App in SAP S/4HANA SAP GUI Tcode in SAP S/4HANA
Bank Account
(FCLM_BAM_AMD)
FI12 Manage Bank Accounts FI12 Read access only

 

Exercise:

Create a new bank account, for example:

Header and General Data tab:

Account Number: 12345678913

Account Description: ABC Account

Bank Country:  NO

Bank Key: 12345

Note: To maintain the bank key in this step, the bank key must already exist in the system.

Account Currency: NOK

Company Code: 1100

Account Holder: Company Code 1100 (company code name is defaulted by system)

Account Type: BNK_ACC

Opening Date: current date

Generate IBAN Note:

– Only perform this step if this country is using IBAN.

– If you do not use IBAN in your process, you can skip this step.

– Choose the IBAN button. When the warning dialog box appears, choose OK. The proposed IBAN is automatically entered

Connectivity Path tab:

ID Category: Central System: House Bank Account

Company Code: 1100

House Bank: HBT1

House Bank Acct: NOK01

G/L Account: 192000.

Steps:

  1. Access Manage Bank Accounts Fiori App and search the account number you wish to create to assure it does not exist already.
  2. If it does not exist, click on the “+” sign to create it and start filling in all mandatory fields under Header and General data tabs.
  3. Proceed to Connectivity Path tab to make the connection to your House Bank by clicking on the “+” sign to add your desired House Bank and G/L Account (must be already existing) and then click Apply.
  4. Select id category radio button and then click Save to finalize account creation.
  5. Now if you go back to initial screen of Manage Bank Accounts and repeat search from step a) you should be able to find you bank account and edit/delete/copy/close it if required or view the history changes.

 

F) Close Bank Account:

For example: The bank accountant (Cash Management Specialist) goes to the bank and asks the bank employee to close the bank account. This step does not occur in the system.

The key user marks the G/L account of a closed bank account as deletion. Before marking G/L account as deletion, its balance should be zero.

Note: If this is a shared G/L account for several bank accounts, you can skip this step.

Note: if it is not a shared account, update the G/L accounts in the production, development and consolidation test systems.

Exercise:

Close a bank account.

Account Number: 12345678912

Bank Country:  NO

Bank Key: 12345

Steps:

  1. Access Manage Bank Accounts Fiori App and search the account number you wish to close
  2. In the search results, click the bank account line you wish to close
  3. Select Close
  4. Make the following entries in the dialog box: Closing Date and hour: current date or any other date and then choose OK.

 

G) Reopen Bank Account

Exercise:

Reopen a closed bank account.

Account Number: 12345678912

Bank Country:  NO

Bank Key: 12345

Steps:

  1. Access Manage Bank Accounts Fiori App and search the account number you wish to reopen
  2. In the search results, click the bank account line you wish to reopen
  3. Select Reopen

 

H) Export/Import Bank Accounts

Export Bank Accounts: The new bank account (including house bank account) creation in production system is completed in previous procedure.

Some system configuration is based on the house bank and the house bank account. Because configuration is done in the development system, you must export the bank accounts from the system to the development and consolidation test system.

Access Manage Bank Accounts Fiori App and select the Import/Export Bank Accounts feature to export the bank accounts.

Import Bank Accounts: Import the exported bank accounts into the development system and consolidation test system.

Access Manage Bank Accounts Fiori App and select the Import/Export Bank Accounts feature to export the bank accounts.

A complete step by step guide is not part of the current document.

 

I) Conclusions

  • Not all bank account management SAP GUI tcodes are deprecated in SAP S/4HANA.
  • FI01, FI02, FI03 and Fiori App Manage Banks Basic are equally available in SAP S/4HANA for managing Bank Keys.
  • FI12_HBANK (replacing part of SAP GUI tcode FI12 used in ERP) or Manage Banks Fiori App, equally available for managing House Banks.
  • The main change coming with SAP S/4HANA is for Bank Accounts. FI12 SAP GUI tcode allows read mode only. Edit of existing/creation of new Bank Accounts master data becomes possible only by using the Manage Bank Accounts Fiori App.

In my opinion, there are unquestionable reasons why one should switch to using the Fiori Apps in favor of classic SAP GUI tcodes:

  • The 3 Fiori Apps are interlinked, allowing quick navigation from one to another; the user has simply to click on the blue linked object in the results.
  • Fiori Apps are in general role-based oriented and simplified, thus an user can expect to see less screens/tabs/fields, respectively a decrease of the overall task duration and clutter elimination, which translates into an increase of the productivity.
  • Another characteristic is responsiveness, meaning automatic adaptation of the app to the used device and display (mobile, tablet, laptop, desktop screen etc).
  • Fiori was designed to be delightful, focusing on an appealing UX. Expect to see features like context-sensitive user assistance or ability to personalize the Fiori Launchpad appearance.

Appendix

BAM – SAP GUI Tcode and SAP Fiori Apps in SAP S/4HANA; Relevant tables and fields:

  • FI01 / Manage Banks Basic:
    • BNKA-BANKS – Bank Country
    • BNKA-BANKL – Bank Key
    • BNKA-BANKA – Bank Name
    • BNKA-SWIFT – Bank Swift
    • BNKA-BNKLZ – Bank Number
  • FI12_HBANK / Manage Banks:
    • V_T012-HBKID – House Bank
  • FI12 (read access only) / Manage Bank Accounts:
    • FCLM_BAM_AC_LINK – Linkages Between House Bank Accounts and Bank Accounts
    • FCLM_BAM_AMD – Bank Account Master Data

Assigned Tags

      19 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Naga Deepthi Chopparapu
      Naga Deepthi Chopparapu

      Thank you for a good document

      Author's profile photo Ignacio Kristof
      Ignacio Kristof

      Crystal clear.  Good work!

      Author's profile photo Former Member
      Former Member

      Helpful and well written document. Thank you!

      Author's profile photo Yoshiro Nagata
      Yoshiro Nagata

      This document is very helpful as we cannot use the SAP GUI transactions which are abolished. I believe there are  some other SAP GUI transactions which will be abolished but how can we found the list of such transactions?

      Author's profile photo Marius Lauruc
      Marius Lauruc
      Blog Post Author

      Dear Yoshiro Nagata, if you are speaking in general of the transaction codes and programs which become obsolete in SAP S/4HANA, there are couple of SAP Notes that have attached such lists.

      You can check for instance https://launchpad.support.sap.com/#/notes/2742613, https://launchpad.support.sap.com/#/notes/2270335.

      For legal reporting and localization you can check out SAP note https://launchpad.support.sap.com/#/notes/2480067https://launchpad.support.sap.com/#/notes/2835816

      a good starting point is always the Simplification Item Catalog, aka SIC available here . Simply search keyword "Transaction codes", "obsolete" etc and you will get the relevant simplification item IDs within which you always find a Business Impact Note on the subject.

      Hope this helps.

      Stay safe and all the best!

      Marius

      Author's profile photo Dipen Datta
      Dipen Datta

      Thanks for the detail analysis and lots of relevant information.

      Is there any way we can create house bank master data directly in the production system, without transporting from Dev?

       

      -- Anupam Bera

       

      Author's profile photo Marius Lauruc
      Marius Lauruc
      Blog Post Author

      Dear Dipen Datta,

      Yes, you can create it directly in the production system subject you have the Fiori Launchpad set-up and Fiori App Manage Banks. Since it is treated like master data, you can simply create it in every system manually. Make sure no typos and same values are entered in each system if you opt for manual creation in each DEV, QUA, PRD.

      Stay safe and all the best!

      Marius

      Author's profile photo Winny Loh
      Winny Loh

      Appreciate your post!

       

      Would like to understand would it be possible to mass upload the bank key? I have looked in the app "Manage Bank-Basic" and only manual creation is allowed. As currently migration object: bank is retired.

       

      Thank you.

      Winny

      Author's profile photo Marius Lauruc
      Marius Lauruc
      Blog Post Author

      Hi Winny,

      How did you use to do it in ERP ECC? LSMW?

      Regards,

      Marius

      Author's profile photo Raunak Bhatia
      Raunak Bhatia

      Nice Post

      but one thing, if once bank account is created in Fiori and set active, how can I set inactive again or make changes (considering no posting is done) like change currency as these option are grey out in Fiori?

       

      Author's profile photo Tom Schmelzer
      Tom Schmelzer

      Hey,

      great Article!

      One question. What kind of authorization roles I have to assign to a user that he can use the "Manage Bank Accounts" Fiori App?

       

      Thanks in advance!

      Author's profile photo Marius Lauruc
      Marius Lauruc
      Blog Post Author

      Hi Tom,

      You are looking for role SAP_BR_CASH_MANAGER. This kind of information you can find in Fiori App Library, tab Implementation Information, section Business Roles.

      https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps('F1366A')/S20OP

      Your responsible department for authorizations and roles can create a copy of the standard role and adapt it to internal requirements.

      All the best,

      Marius

      Author's profile photo ILYA KATAEV
      ILYA KATAEV

      Thank you, great article!

      Ilya.

      Author's profile photo Cheng Wang
      Cheng Wang

      Is there anywhere I can found some definition? such as what the difference is between Central System: House Bank Account and Remote System: House Bank Account? thanks!

      Author's profile photo Teodora Petkova
      Teodora Petkova

      Hi there and thank you for the explanation. How do I find the correct bank key length and check rule per country? I have tried with notes 1012293 & 1529550 but the information is insufficient. 1012293 is very good, I basically need the same nut for Bank Key rule. Thanks in advance.

      Author's profile photo Tim Bown
      Tim Bown

      We are experiencing a big problem with the validation in the manage bank accounts app which prevents us doing the following:-

       

      Move an external bank account number from one company code to another

      Change the bank number/bank key on an external bank account

       

      In both cases, it seems we need to remove the house bank connectivity and close the bank account, in order to make the changes.    However SAP has validation rules checking for existance of both the FBZP configuration and transactional data, which prevents you from doing this.

      see sap note 2541154 - Manage Bank Accounts: Account Number already exists

       

      Question is how can you override this, it is a legitimate business requirement to move a bank account to a different company code.

       

      Author's profile photo Alberto Ramos Pinto
      Alberto Ramos Pinto

      Hi, thank you for all this information it's very helpful.

      I'm sorry to ask this here but i hope someone can help me with the following issue: After upgrading from release 1709 to 2021 of S/4 HANA the currency value from all the bank accounts was missing.
      I tried to modify or delete the account through out the mentioned standard webdynpro transactions in this article but I can't succed. If I try to delete the account it has a validation and ask me to complete the value on the currency field and when I try to modify that field the screen doesn't allow any entries. So I can't find the way to complete that field (T012K-waers) that was missing after upgrading.
      I would appreciate if someone has something to share that helps me face this problem.

       

      Author's profile photo Alejandra Rodriguez Gurpegui
      Alejandra Rodriguez Gurpegui

      Hello Alberto,

       

      We faced the same issue and we found this note that afterwards was deleted by SAP. You need to run this report

      3252612 - Missing currency data in table FCLM_BAM_AMD after upgrade to S/4 Hana 2021

       

      *&---------------------------------------------------------------------*
      *& Report ZCORR_FCLM_BAM_AMD
      *&---------------------------------------------------------------------*
      *&
      *&---------------------------------------------------------------------*
      REPORT ZCORR_FCLM_BAM_AMD.

      TABLES: fclm_bam_amd, fclm_bam_amd_cur.

      SELECT * FROM fclm_bam_amd_cur INTO TABLE @DATA(lt_amd_cur) WHERE deleted_flag <> 'X'.
      DATA: counter type sy-tabix.
      LOOP AT lt_amd_cur INTO DATA(ls_amd_cur).
      UPDATE fclm_bam_amd SET waers = ls_amd_cur-waers WHERE acc_id = ls_amd_cur-acc_id AND revision = '0000'.
      CHECK sy-subrc = 0.
      COMMIT WORK.
      counter = counter + 1.
      ENDLOOP.

      WRITE: 'Field value of currency for ', counter, 'entries got updated successfully'.

      Author's profile photo Alberto Ramos Pinto
      Alberto Ramos Pinto

      Alejandra thank you so much, you are right, we got the same solution from SAP support