Bank account management in SAP S/4HANA (2022)

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

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

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).
TableSAP GUI Tcode in ERPFiori App in SAP S/4HANASAP 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 creationManage 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.

Bank account management in SAP S/4HANA (1)

Bank account management in SAP S/4HANA (2)

Bank account management in SAP S/4HANA (3)

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

Note:

(Video) SAP S/4 HANA 1909 Bank Account Management - Approval Workflow

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.

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);
TableSAP GUI Tcode in ERPFiori App in SAP S/4HANASAP GUI Tcode in SAP S/4HANA
House Bank
(V_T012)
FI12Manage 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.

Bank account management in SAP S/4HANA (4)

Bank account management in SAP S/4HANA (5)

Bank account management in SAP S/4HANA (6)

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:

(Video) Using Dual Control for Bank Account Management SAP S/4HANA Cloud

  • Create Bank Account
    • Export/Import Bank Accounts
  • Modify Bank Account
    • Export/Import Bank Accounts
  • Close and reopen Bank Account
TableSAP GUI Tcode in ERPFiori App in SAP S/4HANASAP GUI Tcode in SAP S/4HANA
Bank Account
(FCLM_BAM_AMD)
FI12Manage Bank AccountsFI12 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

(Video) Using Workflow Processes for Bank Account Management SAP S/4HANA Cloud

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.

Bank account management in SAP S/4HANA (7)

Bank account management in SAP S/4HANA (8)

Bank account management in SAP S/4HANA (9)

Bank account management in SAP S/4HANA (10)

Bank account management in SAP S/4HANA (11)

Bank account management in SAP S/4HANA (12)

Bank account management in SAP S/4HANA (13)

Bank account management in SAP S/4HANA (14)

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.

(Video) House Bank in S/4HANA 2020 | Configuration | End User Postings

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.

Bank account management in SAP S/4HANA (15)

Bank account management in SAP S/4HANA (16)

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

Bank account management in SAP S/4HANA (17)

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.

(Video) SAP S4HANA Bank Account Management | Automatic Payment Program (F110) configuration | Abhiram Aditya

  • 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.

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

Videos

1. How to Create Bank Account ID | T Code – NWBC | S/4 HANA Finance
(SAP Passion)
2. Extending Workflows for Bank Account Management Using Teams and Functions SAP S/4HANA Cloud
(SAP Technology)
3. S/4HANA Finance - Bank Account Management
(SAP Tutorials)
4. S/4HANA Finance - Bank Account Management
(SAP is SIMPLE!)
5. SAP Treasury - Bank Account Management
(CarlsonCash)
6. S4 HANA Fiori App Manage Bank Account (Account Ids)
(karan bhambra)

You might also like

Latest Posts

Article information

Author: Jonah Leffler

Last Updated: 09/05/2022

Views: 6015

Rating: 4.4 / 5 (65 voted)

Reviews: 88% of readers found this page helpful

Author information

Name: Jonah Leffler

Birthday: 1997-10-27

Address: 8987 Kieth Ports, Luettgenland, CT 54657-9808

Phone: +2611128251586

Job: Mining Supervisor

Hobby: Worldbuilding, Electronics, Amateur radio, Skiing, Cycling, Jogging, Taxidermy

Introduction: My name is Jonah Leffler, I am a determined, faithful, outstanding, inexpensive, cheerful, determined, smiling person who loves writing and wants to share my knowledge and understanding with you.