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
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.
On the above screen, double click on the bank account and it will take you to the below screen.
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.
In this screen, we will define the Bank Chain, under “bank Chain Assignment” option. At max, we can create 3 bank chains.
- Number: The Number helps define the serial order of the Intermediary bank.
- 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.
- Corr. Ctry: Here, main the short-code for Country of Correspondence Bank.
- Corr. Bank Key: Maintain the Bank key for the country of correspondence.
- 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 Name||Field – Description|
|REGUH-BTYP1||Bank type in chain. This field will store the first Intermediary Bank details|
|REGUH-BTYP2||Bank type in chain. This field will store the Second Intermediary Bank details.|
|REGUH-BNKS2||Bank 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)
- /CEECV/BTFI_DMEE_EXIT_CADRS1 for Street
- /CEECV/BTFI_DMEE_EXIT_CADRS2 for Region
- SWIFT/BIC (SWIFT)
- /CEECV/BVFI_DMEE_EXIT_SWIFT or
- Receiver bank account in corresp. Bank IBAN from TIBAN
DMEE EXIT for Intermediary Bank 2 (FPAYH-BNKS2 and FPAYH-BNKL2)
- SWIFT/BIC (SWIFT)
- Bank name(BNKA) + Street, City, Country
SAP Bank Chain tables and Intermediary Bank tables
|Table Name||Table Description|
|TBCHAIN0||Definition bank chains|
|TBCHAIN2||Bank Chains per Business Partner Account|
|TBCHAIN21||Bank chains per business partner account (allocation)|
|TBKBC||Bank Chain from Corresponding Banks|
|TBCHAINE0||Definition of the scenarios for bank chain determination|
|TBCHAINE1||Character. value of scenarios for determining bank chain|
|TBCHAINC0||Assign 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.