Bank Account Managme

Download as pdf or txt
Download as pdf or txt
You are on page 1of 54
At a glance
Powered by AI
The document discusses bank account management in SAP S/4 HANA Finance compared to ECC, including differences in tables, configuration steps, and creation of house banks and bank accounts.

Some of the main differences discussed are the tables used, with S/4 HANA Finance using universal journal entries instead of subledger postings. S/4 HANA Finance also provides a simplified data model and process for bank account management.

The main configuration steps discussed are setting up the financials general ledger in SAP Simple Finance, defining the bank supervisory authority, and defining the bank country.

SAP S/4 HANA Finance

Bank Account Management

a
ty
Ad
Revision History

a
ty
Ad
Table of contents
1. Summary of changes in S/4 HANA Finance compare to ECC ........................................................................................ 4
1.1. SAP ECC ................................................................................................................................................................... 4
1.2. SAP S/4 HANA Finance ............................................................................................................................................ 4
1.3 Comparison of Existing Bank Account Management in ECC with Bank Account Management in S/4 HANA
Fi a e………………………………………………………………………………………………………………………………………………………………………….
2. Tables in ECC and S/4 HANA Finance............................................................................................................................. 6
3. Configuratrion of Bank Account Management in S/4 HANA Finance ......................................................................... 7
3.1. SAP Simple Finance, on-premise edition 1503 ....................................................................................................... 7
3.1.1. Configuration Steps ......................................................................................................................................... 7
4. Creation of House Bank and House Bank accounts ...................................................................................................... 25
4.1. Creation of House Bank – Bank Account Mnaagement Lite ................................................................................. 25
4.2. Creation of House Bank Accounts – Bank Account Management Lite ................................................................. 28
4.3. Creation of House Bank – Bank Management in full ............................................................................................ 29
4.4. Creation of House Bank Accounts – Bank Management in full ............................................................................ 31
5. Bank Account Management in Fiori apps ..................................................................................................................... 38
a
5.1 Bank Account Management Fiori apps available in 150 ……………………………………………………………………………………38
ty

. Ba k A ou t Ma age e t Fiori apps a aila le i 709……………………………………………………………………………………43


Test Results of Bank Account Management Apps in 1709 . ........................................................................................ 46
Ad

6.
6.1. Manage Banks apps .............................................................................................................................................. 46
6.2. Manage Banks –Basic apps ................................................................................................................................... 47
6.3. Manage Bank accounts –Overview and Maintenance apps ................................................................................. 48
6.4. My Bank Account Worklists apps.......................................................................................................................... 49
6.5. My Sent Requests for Bank Accounts .................................................................................................................. 50
6.6. Foreign Bank account Report apps ...................................................................................................................... 50
6.7. Maintain Signatory in Multiple Bank accounts ..................................................................................................... 51
6.8. Initiate Review Process for Bank accoutns ........................................................................................................... 53
6.9. Monitor Bank account review status apps ........................................................................................................... 54
1. Summary of changes in S/4 HANA Finance compare to ECC
1.1. SAP ECC

In ECC, House bank and bank accounts have been c created through t-code F112 and not fall under over all Bank Account
Management of Financial Supply Chain Management

1.2. SAP S/4 HANA Finance

In SAP S/4 HANA Finance on premise edition 1503 /1511and on, house bank accounts are completely merged into Bank
Account Management (BAM) in SAP Cash Management powered by SAP HANA.

For Bank Account management 2 version are provided

 Bank Account Management Lite (BAM Lite)


 Bank Account Management the full version

Bank Account Management Lite: Bank Account Management Lite is a compact version of Bank Account Management
provided for customers without the license of SAP Cash Management powered by SAP HANA
a
With Bank account Management Lite , Cash Managers and Bank accountants are able to centralize the management of
ty
bank accounts and perform the following tasks:-


Ad

Displaying bank accounts in a list view


 Searching for a bank account either by exact search or fuzzy search
 Maintaining the bank account master data
 Importing or exporting bank accounts using the tool Import and Export Bank Accounts

Business function FIN-FSCM-BNK to be activated for utilizing this Bank Account Management Lite...

House Bank to be created through t-code FI12_HBank or through Fiori apps Create Bank Fiori apps in 1503 and
Manage
Bank/Manage Banks –basic Fiori apps I n 1709 and bank accounts through NWBC role
SAP_FI_BL_BANK_MASTER_DATA.

Bank Account Management the full version:

Bank Account Management the full version provided for customers with the license of SAP Cash Management
powered by SAP HANA

With Bank Account Management, cash managers and bank accountants are able to centralize the management of bank
accounts by using the following features
 Displaying bank accounts in bank hierarchy view
 Maintaining bank contact persons in master data
 Defining payment approval processes using signatories
 Managing overdraft limits for bank accounts
 Creating user-defined views using bank account groups
 Managing cash pools and perform cash concentration
 Using workflows in opening, modifying, closing, and reviewing bank accounts
 Integrating with bank accounts in remote systems

The above functions are not supported in Bank Account Management Lite

Below 2 Business functions to be activated

 FIN_FSCM_CLM: Business function for SAP Cash Management

 FIN-FSCM-BNK: Business function for Bank Communication Management

House bank can be created through t-code FI12_HBANK or through Fiori apps Create Banks in 1503 and
Manage Banks/Manage Banks – Basic Fiori apps in 1709

Bank Accounts through NWBC role SAP_SFIN_CASH_MANAGER both in 1503 and 1709 edition

Bank accounts can also be created through Manage Bank account apps in 1709 edition
a
ty
Ad
1.3. Comparison of Existing Bank Account Management in ECC with Bank Account Management in S/4
HANA Finance

Existing Bank Account Management – ECC

 Group wise account management


 Overdraft Limit
 Bank Account Maintaining
 Usability
 Multiple currencies

New Bank Account Management in Net Weaver;

 Group wise Bank account management


 Account Opening with Approval Process
 Account closing with Approval process
 Account Sensitive changes with Approval process
 Signatory mass changes with Approval process
 Integrated with BCP Payment approval
 Account Review Process
 Bank and Bank Account Hierarchy and Table view
a
 Change History
ty

2. Tables in ECC and S/4 HANA Finance


Ad

House Bank Bank Tables in ECC6 are replaced by Compatibility View

Compatibility view
Tables in S/4 HANA
Tables Tables in ECC6 Finance
House Bank Accounts T012K V_T012K_BAM
House Bank Accounts name T012T V_T012T_BAM

Other New Tables in Bank Account Management of S/4 HANA Finance are:-
3. Configuration of Bank account management in S/4 HANA Finance
3.1. SAP Simple Finance, on premise edition 1503/1709
a
3.1.1. Configuration Steps
ty

1) ACTIVATE BTE is BEV


Ad

Purpose: This activity describes how you can connect additional components (such as in the form of function
modules developed yourself or a product from an external software provider) to the standard SAP system

Steps:-
1. Access the transaction using the following navigation path:
IMG Menu:- Financial Accounting (New) Financial Accounting Global Settings (New) Tools  Customer
Enhancements  Business Transaction Events

2. On the SAP Business Framework: Business Transaction Events screen, from the menu, choose Settings  Products
...of a customer.
3. On the Change View "Customer Products": Overview screen, choose New Entries.
2. Basic settings

Define number ranges for Bank Account Technical IDs

IMG Path: Financial Supply Chain Management Cash and Liquidity Management  Bank Account Management 
Basic Settings  Define Number Ranges for Bank Account Technical IDs
a
Purpose : In this Customizing activity, you create number range intervals for bank account technical IDs. The system
ty

automatically assigns a technical ID to a bank account once it is created in the bank account master data.
Ad
3. Define Number Ranges for Worklfow Change Requests

Purpose:- In this Customizing activity, you create number range intervals for change requests used in Bank Account
Management. The system automatically assigns a number to a change request once it is created in Bank Account
Management.
a
ty
Ad

4. Define Settings for Bank account master


Purpose: In this Customizing activity, you define the following basic settings for the bank account master data.
a) Assign number ranges to Technical ids

Purpose:- To do this step, you must have maintained number ranges in Define Number Ranges for Technical ids

a
ty
Ad

b) Account type Definition

Purpose: Define nature of accounts i.e account type


c) Define Sensitive field for modification

Purpose:- Making changes to sensitive fields defined here will trigger workflow change requests if SAP Business
Workflow is enabled.

a
ty

d) Define Import Method for Bank statement


Ad

Purpose: On the Additional Data tab for each bank account master record, users can select one of defined methods as
the Import Method for End-of-Day Statements, and one as the Import Method for Intra-Day Statements.
e) Define Signatory groups

Purpose: Define different groups of authorized signatories to suit different business purposes.

f) Define approval patterns

Purpose: In the Define Approval Patterns view, you define patterns for payment approvals.
a
ty
For a sequential pattern, the signatory groups defined in this pattern approve payments in a sequential order. You can
assign up to four signatory groups for a sequential approval pattern.
Ad

For non-sequential patterns, the signatory groups approve payments regardless of sequential order. You must assign at
least two signatory groups for non-sequential patterns. You can create non-sequential approval patterns by specifying
the approval sequence as Non-Sequential.

You can then maintain the non-sequential approval patterns in the Maintain Non-Sequential Approval Patterns view.

We can Maintain non-sequential pattern under define approval patter for the patterns
g) Assign approval pattern

Purpose: Assign pattern to company code, account type with priority

a
ty
Ad

5) Maintain the Evet type Linkage for triggering Workflow process

Purpose: To enable the workflow for Bank Account Management process (for example, opening, modification, closing,
and so on), you must register an Event Type Linage entry.

In SAP standard deliver, a default entry with Object Type FCLM_CR and Receiver Type WS74300043 is provided.
To enable the approval process for bank account, there should be only one activate event type linkage defined for BOR
o je t FCLM_CR’s event CREATED.

If customers need to use a new workflow, add and activate a new entry, and deactivate the default one.

Transaction code: SWETYPV

IMG MENU: Financial Supply Chain Management Cash and Liquidity Management  Bank Account Management 
Maintain the Event Type Linkage for Triggering Workflow Processes

a
ty
Ad
a
ty
Ad

The linkage activated should be ticked inorder to trigger workflow

6) Define Responsibilities for rule in the workflow

Purpose:-

In this step, you can define responsibilities for the workflow rules used in your workflow processes. SAP predefines the
following rules for Bank Account Management:
a) First

CASH MANAGER to approve for initiation of creation of bank accounts, the initiator and cash manager should
ot e the sa e perso ….

a
ty
Ad

b
b) Secondly

Bank accountant to Confirm and to update certain fields. Its advisable to be Bank accountant a different person other
than in the first rule a
ty
Ad

Check by clicking the Bank accountant and to check whether it has been extended to respective company codes
a
ty
Ad

c) once its confirm the key user have to create the bank accounts
Thirdly

a
ty
Ad
Note Advisable to have different user id for all the above rules.. The user who act as Cash Manager will not be
assigned against as a Key User..

7 )Enable Signatory control


Purpose:- In this Customizing activity, you enable the signatory control in Bank Account Management by
assigning the required function modules.
a
When signatory control is enabled, users defined as signatories are able to approve or reject payment documents in
ty
Bank Account Management. The signatory information maintained in the bank account master data does not take
effect until the signatory control is enabled here.
Ad

If the signatory control is not enabled, payment approvals are handled using the logic in the Bank
Communication Management component.

IMG MENU: Financial Supply Chain Management Cash and Liquidity Management  Bank Account
Management  Enable Signatory Control
8)Define new BP role BAM001
Purpose: In this IMG activity, you define the business partner roles and their attributes. You also define the role
categories with other relevant data.

The BP role categories are stored in a table with delivery class E. To create Contact Person in Bank Account
Management, a new Business Partner Role BAM001 must exist in the system.

IMG PATH: Cross- Application Components SAP Business Partner Business Partner  Basic Settings 
Business Partner Roles  Define BP Roles
a
ty
Ad
a
ty
Ad

9. House Bank Accounts re-direction


Purpose: In this step, the house bank accounts are redirected to the compatibility views V_T012K_BAM and
V_T012T_BAM. Tables T012K and T012T (which store the house bank accounts information) are replaced by
views V_T012K_BAM and V_T012T_BAM in the SAP Business Suite 4 for HANA systems. Transaction code FI12
is rendered obsolete.
Call the method CL_FCLM_CDS_GENERATE=>REGISTER_HBACC with IV_DEL= ‘‘.
When solution activation, this is done by eCATT /SMBA0/BAM_REDIRECT_O001_J73.

10. Maintain Task for workflow

Transaction code : PFTC_CHG

IMG MENU: Tools  ABAP Workbench  Development  SAP Business Workflow  Definition tools 
Task/Task group  Change

ON THE TASK TYPE SELECT THE BELOW


Define the above task as general task
a
ty
Ad

11. Define Rating

Purpose: In this IMG activity you can define ratings. Ratings are part of the business partner's credit standing data.
You can store an internal, time-independent rating for a business partner from an institute providing credit
standing information in the credit standing data.

IMG PATH: Financial Supply Chain Management Cash and Liquidity ManagementGeneral SettingsMarket
DataDefine Rating
a
ty
Ad

12) Manual transport movement :-


Configuration activity Manual Manual Remarks
transport action in
possible target
system /
client
required
3.3 Maintain the Event Type Linkage Yes No
for Triggering Workflow Processes

3.6 BAM - House Bank Accounts No Yes


Redirection

3.7 Maintain Task for Workflow No Yes

Manual Manual Remarks


transport action in
possible target
Configuration activity system /
client
required

3.2 Define Responsibilities for Rules No Yes


a
Used in Workflow Steps-Create
ty

Responsibilities
Ad

Configuration steps 1 to 4 to be followed in the case of Bank Account Management Lite

Configuration steps 1 to 12 to be followed in the case of Bank Account Management full

4. Creation of House bank and House Bank accounts


4.1. Creation of House Bank – Bank Account management Lite

Select the Company code DE01


Transaction code: FI12_HBANK
Select the Company code DE01

a
ty
Ad
Ad
ty
a
a
ty

Both in 1503 and 1709, House bank can be created through FI12_HBANK
Ad

4.2. Creation of House Bank Accounts – Bank Account management Lite

House bank accounts in BAM Lite can be created through the NWBC role
SAP_FI_BL_BANK_MASTER_DATA
Click it on New Bank account, a screen will appear, fill the account number and the GL account and
then save it, o orkflo ill get triggered…

a
ty
The above process can be followed both in 1503 and 1709 for Maintenance of Bank of accounts through Bank
Management Lite..
Ad

4.3. Creation of House Bank – Bank Account management full

T-code: FI12_HBANK
Ad
ty
a
4.4. Creation of House Bank Accounts – Bank Account management full

Bank accounts can be created through NWBC role SAP_SFIN_CASH_MANAGER

a
ACDOCA – Values will be posted to ACDOCA tablle for FSL field
ty
Ad

Click it on New Bank account


1

a
ty
Ad

1) Request

Click on New bank account


Please click on save and submit , Workflow will get triggerd and it will be in the Group cash manager Work flow inbox
for approval

2) Global Cash Manager Approval

a
ty
Ad

Bank Workflow Approval

T code SBWP
Net Weaver

a
ty
Ad
a
Appro ed…
ty
Ad

3) IT configuration
There will be workflow item in the Key user inbox
Below screen will appear once the Key user click the workflow items in his/her inbox...

a
ty
Ad

Click it on Connectivity path


After reatio a other s ree ill appear to o fir the a k a ou ts reated, li k it o Co fir …
a
ty
Ad
Bank accounts created

I 1709 Ba k a ou ts a e reated through Fiori apps…

5. Bank account Management in Fiori apps


5.1 Bank Account Management Fiori apps available in 1503
a
ty
Ad
Fioir apps User Role PFCG Role Key Features Require
ments
Create Bank Global Cash SAP_SFIN_BCR_CASHM To Create House Bank User can
Manager ANAGER use
either
Fiori
apps or
through
NWBC
to
create
bank
Change Bank Global Cash SAP_SFIN_BCR_CASHM To change Bank User can
Manager ANAGER change
Bank
created
through
Fiori
apps or
through
NWCB
a
role
ty
Ad
Manage House Bank Global Cash SAP_SFIN_BCR_CASHM Check your bank either
Manager ANAGER accounts in standard views Through
including Bank Hierarchy NWBC
view and Account list view. role or
Define your own views through
by creating bank account Fiori
groups For more apps for
information, see Creating creation
Bank Account Groups. of Bank
Filter your bank accounts account
by their status, including s and
active accounts, inactive Manage
accounts, closed accounts, bank
and all accounts account
Create new bank account s
master records
Open a bank account
master record, where you
can check account details,
make changes to attributes,
track change history, copy
the account to create a new
account, close bank
a
account or delete the
ty

account if it is inactive
Create, display, edit, and
Ad

delete cash pools, as well


as perform cash
concentration For more
information, see Working
with Cash Pools.
Import bank accounts
and export bank accounts
For more information, see
Importing and Exporting
Bank Accounts.
My Bank Account Worklist Global Cash SAP_SFIN_BCR_CASHM Check and process the Either
Manager ANAGER received requests that are through
to be approved or NWBC
processed by you for the role or
following activities: through
Opening a bank this Fiori
accountChanging a bank apps
accountMaintaining a
signatory in multiple bank
accountsReviewing bank
accountsClosing a bank
account
Forward a request to
another colleague if
needed

Initiate Review Process for Bank Global Cash SAP_SFIN_BCR_CASHM Search for bank accounts Either
accounts Manager ANAGER to be reviewed using the through
following filters: Company NWBC
codeCountryBankAccount role or
numberContact person through
Initiate a review process this Fiori
for the selected bank apps
accounts The system sends
the review request to
contact persons of each
bank account respectively.
Each contact person
receives a request that
a
contains all the bank
ty

accounts that he or she is


responsible for and
Ad

selected for review. Only


bank accounts assigned
with a contact person can
be reviewed. Make sure
you have defined the
contact person for each
bank account in the bank
account master data. To do
so, on the General Data
tab, under the Internal
Contact Person section,
specify the contact person
in the General Contact
field.
My sent Requests for Bank Global Cash SAP_SFIN_BCR_CASHM With the Web Dynpro app
accounts Manager ANAGER My Sent Requests, you can
track the bank-account-
related requests you have
sent.
Key Features

Check your requests in


terms of request status,
step, history, next
processor, and date of
creation and last change.
Send a reminder to the
current processor
Monitor Review status for Bank Global Cash SAP_SFIN_BCR_CASHM With the Web Dynpro app Either
accounts Manager ANAGER Monitor Review Status, you through
can monitor the review NWBC
status of bank accounts role or
selected for account through
reviews and send this Fiori
reminders to account apps
contact persons who are
responsible for the reviews.
a
Key Features
ty

Search for bank accounts


Ad

that have been selected for


review by the following
parameters: Request
titleReview
statusBankCountryContact
person who is responsible
for reviewing the bank
accountAccount holder of
the bank account
Check the review status
of a certain bank account
Check the percentage of
reviewed bank accounts in
all requests and completed
requests
Send a reminder to the
contact persons who are
responsible for account
reviews
Make Bank Transfer Global Cash SAP_SFIN_BCR_CASHM With the transactional app Thorugh
Manager ANAGER Make Bank Transfers you Fiori
can conduct bank-to-bank apps or
transfers of cash. You can thorugh
view information about the sap gui
bank account from which F111
or to which you want to
make the transfer. You can
filter or search for bank
accounts by several
dimensions.
Key Features

Conduct transfers of cash


among different banks
accounts
List bank accounts from
which or to which you want
to make the transfer
Let you choose the
payment method and date
of conducting the transfer
Display details about a
a
bank account
ty
Ad

For configuration and Activation steps required for the above apps, please refer the below link:-

http://help.sap.com/saphelp_fiori_sfin_200/helpdata/en/12/5ec0544e238d21e10000000a44176d/content.htm

5.2 Bank Account Management Fiori apps available in 1709


Fioir apps User Role PFCG Role Key Features Requirements
The Manage Banks app provides you with an
overview of all the banks in your system.
You can add new banks, contacts, and
banking relationships to your database. You
SAP_BR_CASH_MANAGER
can also create, display, and change data for User can use either Fiori apps or
existing banks that your company, your through NWBC to create bank or
customers, and your suppliers use to through t-code FI12_HBANK in sap
Manage Banks Cash Manager transact business gui
a
The Manage Banks app provides you with an
overview of all the banks in your system.
ty
You can add new banks, contacts, and
banking relationships to your database. You
SAP_BR_CASH_MANAGER
can also create, display, and change data for
Ad

existing banks that your company, your User can change Bank created
customers, and your suppliers use to through Fiori apps or through
Manage Banks - Basic Cash Manager transact business NWCB role or FI12_HBANK
You can use this app to have an overview of
your bank accounts and maintain bank
SAP_BR_CASH_MANAGER
account master data according to your
Manage Bank Accounts - Overview and Maintenance Cash Manager business needs Through Fiori apps only
You can use this app to check and process
SAP_BR_CASH_MANAGER bank-account-related requests that need to
My Bank Account Worklist Cash Manager be approved or processed by you. Through Fiori apps only
You can use this app to initiate a review
process for selected bank accounts to ensure
SAP_BR_CASH_MANAGER
the bank account master data is up to date
Initiate Review Process for Bank accounts Cash Manager for each bank account. Through Fiori apps only
You can use this app to track the bank-
SAP_BR_CASH_MANAGER
My sent Requests for Bank accounts Cash Manager account-related requests you have sent. Through Fiori apps only
You can use this app to monitor the review
SAP_BR_CASH_MANAGER status of bank accounts selected for account
Monitor Review status for Bank accounts Cash Manager reviews Through Fiori apps only
You can use this app to maintain a signatory
SAP_BR_CASH_MANAGER
Maintain Signatory in Multiple Bank accounts Cash Manager in multiple bank accounts. Through Fiori apps only

With this app you can identify foreign bank


accounts and responsible signatories in your
company. You can use the information to file
SAP_BR_CASH_SPECIALIST legitimate reports, if required in your
country, for example the Report of Foreign
Bank and Financial Accounts (FBAR) required
for United States persons. You can also use
Foreign Bank Account Report SAP CASH MANAGEMENT SPECIALISTS the information for analytical purposes. Through Fiori apps only
For Detail Technical Configuration and activation of apps, please refer the below link

https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps%28%27F1371%27%29/S5OP

6. Test results of Bank account Management Fiori apps 1709


6.1 Manage Banks apps:-

a) Click it on Manage Bank apps, below screen will appear

a
ty
Ad

b) For creation of New Bank Click it on Create Bank in the right end bottom corner, the below screen appear
Enter Bank country: DE

Bank id: 23459718


a
Bank Name: ABN AMRO BANK
ty
Ad

Then click on SAVE


6.2 Manage Banks – Basics

a) Click it on Mange Banks –Basics apps, in the input screen select the Country as DE and click it on Go

We can view all the banks created for DE

a
ty
Ad

B) To Create a New Bank, Click in on Create Bank tab which is in right bottom end
Cli k I o SAVE utto hi h is i right otto e d…

6.3 Manage Bank Accounts – Overview and Maintenance

a) Click it on Manage Bank accounts – Overview and Maintenance apps:

We a ie the Ba k a ou t Hierar hy hi h ha e already ee reated …

To Create a New Bank click it on the tab New Bank account (In 5.2 section clearly defined the creation of banks
accounts with all the steps)

a
ty
Ad

6.4 My Bank Account Worklists...

a) Click it on My Bank account Worklists apps, before that in the tiles itself we can view the 1 requests is Pending
a
ty
Ad

6.5 My Sent Requests for Bank Accounts

a) Click it on the My sent Requests apps, you can view all the request sent by my user id for approval
6.6 Foreign Bank account Report
a
ty
a) Click it on Foreign bank account report apps, select the Company Code 1010 and click it on GO.

We can view all the foreign bank created for this company code
Ad
6.7 Maintain Signatory in multiple Bank accounts

a) Click it on Maintain Signatory in multiple Bank accounts apps, select the company code 1010 and Select GO

Select the respective bank and click on Change Signatory to change the signatory

a
ty
Ad
b) To Add on New Signatory , Click it on Add Signatory , then fill below the details and click on OK

a
ty
Ad

6.8 Initiate Review Process for Bank Accounts

a) Please click on Initiate Review Process apps , through this apps we can initiate review for the Bank accounts
which we have created

Select the Company Code 1010 and Select GO


b) To initiate the Bank account , select the bank account and click on Initiate Review

a
ty
Ad

6.8 Monitor Bank Account Review Status

a) Click it on the apps, you can view the status of the Bank accounts which have to be reviewed/
a
ty
Ad

Note:

Some Functions will not work in test system and with out mapping fiorio its not possible to update
functions

You might also like