Management of Bank Master across SAP Systems

In a SAP implementation, there can be scores of Bank Master data which needs to be created in SAP from the existing legacy system. Moreover, going forward, Bank Master will get created on an ad-hoc basis depending on the creation of new bank entities in the specific geography.

The transaction code for creating a Bank Master in SAP is ‘FI01’(individually) and ‘BAUP’(mass).

The most common approach followed for the creation of Bank Master in SAP during implementation phase is through the use of a data migration tool, ‘LSMW’ (Legacy System Migration Workbench), wherein based on the recording of the transaction ‘FI01’ for a single record, a file containing the full list of Bank Masters along with the relevant fields is uploaded into SAP system, which in turn reads the file and creates the Bank Masters in the system, or using the transaction ‘BAUP’ where in bank masters can be uploaded in to SAP from a flat file depending on the file format assigned against the Business Transaction event for bank data transfer.

However, there are risks associated with these process as the file containing the list of bank master may get corrupted and the system is unable to read the file.

A more sophisticated and clean approach would be to use the ‘IDOCs’ functionality to transfer the Bank Masters from one SAP system to another. The major advantage of following this process is that it reduces the uncertainty around the creation of bank masters in SAP to a great extent. Once the connection is set up between two systems, the transferring can be done as much number of times.

SAP transaction ‘FI08’ is used for the transmission of bank master data in the form of IDOCs from a source SAP System to a given receiver SAP system, provided a RFC connection is set up within the two systems along with some basic ALE configuration

Advantages of FI08

(a) Management of the Bank Master will be user-independent and will be controlled by SAP.

(b) Transferring the Bank Master through IDOCs across SAP system is a much more secure way than uploading the same through a flat file or creating it individually.

(c) Once the connection is set up, the Bank master are transferred automatically to the receiver SAP system once they are created in the source SAP system either individually or in mass.

Step by Step Procedure for using FI08

There are certain pre-requisites which needs to be completed, before executing the transaction ‘FI08’. These pre-requisites are explained in detail as steps in the pages to follow.

Situation

Managing/Transferring the Bank Master Data across SAP systems

Assumptions

(a) The Source and target SAP systems have already been created.

(b) The Bank Masters in Source and Target Systems are not in Sync.

Pre-requisites

The country specific checks under the following configuration node in the Source System and the Target System should be in sync.

Here, the value of the bank key for the specific country across SAP system should be same.

In brief, the steps are as follows-

Step(s)

Description

SAP Transaction Code

1

Configuration and Checking of RFC Connections

SM59

2

Configuration of t-RFC port

WE21

3

Creation of Source & Target System as Logical Systems

BD54

4

Configuration of Distribution Model

BD64

5

Generate Partner Profiles in Source Systems

BD82

6

Configuration of Partner Profile in Source & Target Systems

WE20

7

Define Consolidation System for Bank Data Distribution

SPRO

Step-1- Configurations and checking of RFC Connection

Source System-‘ID2’ Client 100

Target System-‘IST’ Client 100

Log in to the Source System (ID2) and go to Transaction Code ‘SM59’

Select the “ABAP Connections” and click on “Create” Icon.

The following values needs to be filled in-

Field

Value

Description

RFC Destination

IST100

Target System

Description 1

RFC Destination for IST 100

—-

Target Host

AB14.abcloud14.int

Target System Server Details

System Number

14

Target System’s Number

Note-The values used are specific to the Target system used in here.It will be different for different for different systems.

Once the values are filled in, click on the ‘Logon &Security’ tab to set up the ‘User’ and ‘Password’ for the same.The ‘User’ should be a ‘Communication user’ and should exists in the Target System as well.

Once the details are entered, press “Save” so that the RFC destination is saved.

Now ,click on the “Connection Test” button to test the connection from ID2 to IST. For successful connection between the two systems, the following screen should appear.

If the above screen is not coming, then some error has happened in the configuration and it is better to contact the SAP BASIS team for the rectification of the same.

Step-2- Configurations of t-RFC port

In the Source System (ID2), go to Transaction Code ‘WE21’. Select the ‘Transactional RFC’ folder and Click on the Create Icon.

On clicking the create icon, a Pop-up comes asking for a port name

Select the ‘Own Port Name’ option and give name as ‘IST-100’ and press enter.

Choose ‘RFC destination’ as ‘IST-100’ from the drop down and ‘Version’ as ‘IDoc record Types SAP Release 4.x’.

Press “Save” to save the port details.

Step-3- Creation of Source & Target Systems as Logical Systems

For configuring the Partner Profile in the Source System, the ‘Target System’ has to be defined as a logical system.

In the Source System (ID2-100), go to Transaction Code ‘BD54’ and click on New Entries .

Maintain the Target System (IST-100) and press “Save” to save the details.

For configuring the Partner Profile in the Target System, the ‘Source System’ has to be defined as a logical system.

In the Target System (IST-100), go to Transaction Code ‘BD54’ and click on New Entries.

Maintain the Target System (ID2-100) and press “Save” to save the details.

Step-4- Configuration of Distribution Model

In the Source System (ID2-100) go to Transaction Code ‘BD64’. Click on Change icon to go to the ‘Change Distribution Model’ view and click on the ‘Create Model View’ icon.

A new screen pops-up and the following details are to be entered as shown in the figure

After the ‘Distribution Model’ is created, the message type needs to be added to the same.

Click on the ‘Add BAPI’ icon.

A new screen pops-up, and the following values needs to be filled in for each of the object one after another by clicking on the ‘Add BAPI’ icon.

(a) Bank.Create

(b) Bank.Change

(c) AddessOrg.Savereplica

For Bank Master Creation

For Changing Bank Master

For Address Org

Press enter and the following distribution model appears.

Step-5- Generate Partner Profiles in Source System

In the Source System (ID2-100), go to transaction Code ‘BD82’ and give the following parameters and execute.

Model View-Created in Step 3 (in this scenario, BNKA)

Partner System-Target System (In this Scenario, IST-100)

Authorized User-Type-US and ID-SAP User ID

On execution, the following log should appear as a confirmation that the Partner profile has been successfully generated in the Source System.

Step-6- Configurations of Partner Profiles in Source & Target Systems

For Configuring the partner profile in Source System, go to Transaction Code ‘WE20’ in the Source System (ID2).

Select the ‘Partner Type LS’ folder and select the Target System.

The message type related to the Bank master Save Replica, i.e-‘BANK_SAVEREPLICA’ needs to be maintained in the ‘Outbound Parameters’ Section, as the Bank Master created in the Source System will be moving automatically to the Target Systems.

Click on the “Add” icon for adding the ‘Outbound parameter’. A new screen opens up and following values needs to be feed in the screen-

Field

Value

Partner No.

IST-100

Partner Type

LS

Message Type

BANK_SAVEREPLICA

Receiver Port

IST-100

Output Mode

Transfer IDOC Immediately

IDOC Type (Basic Type)

BANK_SAVEREPLICA01

Press to save the ‘Outbound parameters’ and the Partner profile.

For Configuring the partner profile in Target System, go to Transaction Code ‘WE20’ in the Target System (IST-100).

Select the ‘Partner Type LS’ folder and and select the Source System

The message type related to the Bank master Save Replica, i.e-‘BANK_SAVEREPLICA’ needs to be maintained in the ‘Inbound Parameters’ Section., as the Bank Master created in the Source System will be moving automatically to the Target Systems.

Click on the “Add” icon for adding the ‘Inbound parameters’.A new screen opens up and following values needs to be feed in the screen-

Field

Value

Partner No.

ID2-100

Partner Type

LS

Message Type

BANK_SAVEREPLICA

Process Code

BAPI

Processing by Function Module

Trigger Immediately

Press “Save” to save the ‘Inbound parameters’ and the Partner profile.

Step-7- Define Consolidation System for Bank Data Distribution

The significance of the Consolidation System is that if you do not enter a consolidation system, or you enter more than one, the banks are not distributed, they are only saved locally.

Select “Define Consolidation System for Bank Data Distribution” and maintain the Target System as the Consolidation System and press “Save” to save.

Execution-FI08

On execution, the transaction ‘FI08’ works in the following manner-

(a) If the Bank master does not yet exist in the target system but exists in the source System, it is newly created in the Target System.

(b) If the Bank master exists both in the Source as well as in the target system, then only the changed data (if any) is updated in the Target System.

(c) If the Bank master exists only in the target system and not in the source system, then it remains unchanged.

Go to Transaction code ‘FI08’ in Source System (ID2-100) and enter the following details as given-

Bank Country-Select the Country for which you want to perform the transfer.

Bank Key-Here you can give the specific bank key(s), or you can give *. This means all the Bank Keys under the specific country will be selected for transfer.

Receiving System– Target System

If you execute the transaction, with the“Test run” field as ticked, then it will not transfer the Bank master, but will only display a list of bank masters which would possibly get transferred.

On executing the transaction with un-ticking the ‘Test Run’, the transfer of Bank Master takes place from the Source System to the Target System and list gets displayed of the Bank masters that were sent.

Status Check of IDOCS

To check the status of the IDOCs, go to transaction code “BD87” in the Source System and enter the following details as shown and click on “Execute“

The IDOCs Status ‘03’ indicates that the IDOCs has been processed successfully and is sent to the Target System

To check the status of the IDOCS in the Target System (IST-100), Go to Transaction Code ‘BD87’ and the enter the following details as shown and click on ‘Execute’

The IDOC Status ‘53’, indicates that the IDOC has been received successfully in the Target System and the Bank Master has been created in IST-100 system.

Note-Step 1 to Step 7 mentioned above needs to be done only once for a given Source System and given Receiver System.

Transaction FI08 bridges the gap between the bank master data across SAP systems which were created in the Source System only and does not exists in Target System.

However, after the configuration step(s) that have been mentioned above are executed successfully, you don’t have to run FI08 for managing the Bank master. It would automatically get created in the Target System, once you create the same in the Source System

List of Transactions for transferring other SAP Business Objects

Apart from the Bank master, there are other SAP objects which can be transferred using the IDOC functionality from the Source system to a receiver system.The only difference would be in the IDOC message types for each of these SAP objects.

Here is a consolidated list of the transaction codes which can be used along with their purposes.

Wonderful article.. has all the details very nicely captured.. Can you please clarify on the following that has been written in your article for execution of FI08?

“Transaction FI08 bridges the gap between the bank master data across SAP systems which were created in the Source System only and does not exists in Target System.

However, after the configuration step(s) that have been mentioned above are executed successfully, you don’t have to run FI08 for managing the Bank master. It would automatically get created in the Target System, once you create the same in the Source System.”

If my understanding is correct, once the above steps have been followed we don’t have to set up a periodic job to execute FI08.. the idoc will trigger whenever there is a change to the bank master data.. (or do we have to set the frequency of idoc)?

You are correct…once the steps have been configured, you don’t have to execute FI08 on a periodic basis. Having said that, you have to execute FI08 as one-off (kind of migration activity) so that both the SAP systems are in sync with respect to all the bank master data .

Any changes going forward will be replicated to target system automatically as per the configuration steps mentioned in the article.

Thank you for this article! It helped us implement Bank Master distribution.

One question – we need to filter the bank data that is sent to only US banks. For a message type, we would do this by creating a filter object (BD59), link the filter object (BD95) then create the data filter in BD64. How do we accomplish data filtering using this scenario?