Product Information
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
- A) Open Bank Account
- B) Create a bank key
- C) Create a new Bank G/L Account (Optional)
- D) Manage House Banks
- E) Create Bank Account
- F) Close Bank Account
- G) Reopen Bank Account
- H) Export/Import Bank Accounts
- I) Conclusions
- 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
- Create Bank
- Change Bank
- 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:
- In the app Manage Banks search the bank number you desire to create to check if it was not already created.
- Click Create Bank button in the bottom-right corner of the screen
- 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:
- In the app Manage Banks search your desired bank key or create a new one if required
- Click on the bank name in search displayed results
- Click Edit button in the bottom-right corner of the screen
- Under the house bank tab, click on the “+” sign to create a new house bank within your Bank.
- 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 Accounts – This 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:
- Access Manage Bank Accounts Fiori App and search the account number you wish to create to assure it does not exist already.
- 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.
- 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.
- Select id category radio button and then click Save to finalize account creation.
- 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:
- Access Manage Bank Accounts Fiori App and search the account number you wish to close
- In the search results, click the bank account line you wish to close
- Select Close
- 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:
- Access Manage Bank Accounts Fiori App and search the account number you wish to reopen
- In the search results, click the bank account line you wish to reopen
- 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
Thank you for a good document
Crystal clear. Good work!
Helpful and well written document. Thank you!
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?
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/2480067 & https://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
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
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
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
Hi Winny,
How did you use to do it in ERP ECC? LSMW?
Regards,
Marius
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?
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!
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
Thank you, great article!
Ilya.
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!
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.
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.
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.
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'.
Alejandra thank you so much, you are right, we got the same solution from SAP support