Define Bank Chains for Customer or Vendor

This page is the continuation of the article “Bank Chain Setup in SAP“. Prerequisites: Customer or vendor Master data is already defined, and the Business Partners has Bank Account maintained.

How to define a bank chain for a customer or a vendor?

We can define a bank chain for a customer or vendor via:

Tcode: FIBPU and FIBPS
Menu Path: SAP Easy Access > SAP Menu > Accounting > Financial Accounting > Banks > Master Data > Bank Chains > Business Partners > Edit

Bank Chain in SAP for Customer or Vendor TCode FIBPU

Next, enter the customer or vendor account number and select the indicator for the payment direction (incoming or outgoing payment) and lastly, execute it.

After execution, the system displays a list of partner banks. Here, we have to choose the bank account details, for which a bank chain is to be maintained.

Business Partner Bank Chain Bank details

On the above screen, double click on the bank account and it will take you to the below screen.

Business Partner Bank Chain Bank details Image 2

Once you land to the above screen, we have to define the selection criteria for the Intermediary Bank.

The selection criteria are the ones which will help to determine the intermediary bank. During payment run for this Business Partner and for this bank account, when the selection criteria will get true, the corresponding Intermediary bank account created for it will get called. Let us take this with an example.

Let’s say, we are making two payments for Vendor 99 (the one shown in the screenshot above), one in RUB currency and one in EUR currency. And we want to use the intermediary bank for transaction in RUB currency only. In this case, we will define the criteria for RUB currency under selection details for this vendor. And later, we will define the Intermediary bank under “Bank Chain Assignment“.

To define the “Bank Chain Assignment”, select any row under Selection and double click on the “Bank Chain Assignment” option on the left side menu. This will take you to te below screenshot.

Business Partner Bank Chain Bank details Image 3

In this screen, we will define the Bank Chain, under “bank Chain Assignment” option. At max, we can create 3 bank chains.

  1. Number: The Number helps define the serial order of the Intermediary bank.
  2. Type of Bank in a Bank Chain: This option helps in defining the type of bank chain, like Correspondent Bank, Intermediary Bank or External House Bank.
  3. Corr. Ctry: Here, main the short-code for Country of Correspondence Bank.
  4. Corr. Bank Key: Maintain the Bank key for the country of correspondence.
  5. Bank Account: Here, maintain the Bank Account of the intermediary bank.

With all these steps, we have now created a bank chain for a customer or vendor partner bank for outgoing or incoming payments.

Next, we can execute a Payment run, and check if the selection criteria defined matches then we can see the Intermediary Bank details under the following field of REGUH Bank

Field NameField – Description
REGUH-BTYP1Bank type in chain. This field will store the first Intermediary Bank details
REGUH-BNKS1Bank Country.
REGUH-BNKN1Bank Account
REGUH-BTYP2Bank type in chain. This field will store the Second Intermediary Bank details.
REGUH-BNKS2Bank Country of Second Intermediary Bank.

If, after payment run, data is not coming in these fields than this could be because of mismatch in selection criteria or because of incorrect Business Partner Bank account selection during the payment run.

Once we have data in these fields, we can work on DMEE to include the Intermediary Bank details in the DME structure. Following exits will help in fetching necessary information for the DME structure depending upon the bank requirements.

DMEE EXIT for Intermediary Bank 1 (FPAYH-BNKS1 and FPAYH-BNKL1)

  • Bank name (BNKA): Following DME Exits can be used to get bank name of the intermediary bank. These DME Exits are SAP standard FMs.
  • Street (STRAS) and Region (ORT01)
    1. /CEECV/BTFI_DMEE_EXIT_CADRS1 for Street
    2. /CEECV/BTFI_DMEE_EXIT_CADRS2 for Region
  • Receiver bank account in corresp. Bank IBAN from TIBAN

DMEE EXIT for Intermediary Bank 2 (FPAYH-BNKS2 and FPAYH-BNKL2)

  • Bank name(BNKA) + Street, City, Country

SAP Bank Chain tables and Intermediary Bank tables

Table NameTable Description
TBCHAIN0Definition bank chains
TBCHAIN1Bank chains
TBCHAIN2Bank Chains per Business Partner Account
TBCHAIN21Bank chains per business partner account (allocation)
TBKBCBank Chain from Corresponding Banks
TBCHAINE0Definition of the scenarios for bank chain determination
TBCHAINE1Character. value of scenarios for determining bank chain
TBCHAINC0Assign Scenario for Bank Chain Determination to Client

With this, we have come to the end of Bank Chain and Intermediary Bank setup process. Do let us know your feedback and suggestion in the comment section below.

%d bloggers like this: