SAP Table TBCHAIN21

Bank chains per business partner account (allocation)

TBCHAIN21 (Bank chains per business partner account (allocation)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TBCHAIN21 to other SAP tables.

TBCHAIN21 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BANKSREC Country key of recipient bank BANKSREC T005 CHAR 3 0
BANKKREC Bank key of recipient bank BANKKREC BNKA CHAR 15 0
BANKNREC Account number at recipient bank BANKNREC CHAR 35 0
WAERS Currency Key WAERS TCURC CUKY 5 0
BANKSSND Country key of sender bank BANKSSND T005 CHAR 3 0
BANKKSND Bank key of sender bank BANKKSND BNKA CHAR 15 0
UZAWE Payment Method Supplement UZAWE T042F CHAR 2 0
CHAINNO Current number of a bank in bank chain CHAINNO NUMC 2 0
01 Intermediary bank 1
02 Intermediary bank 2
03 Intermediary bank 3
CHAINBANKT Type of bank in a bank chain (correspondent, intermediary) CHAINBANKT CHAR 1 0
1 Sender's correspondent bank
2 Intermediary bank
3 Recipient's correspondent bank
4 External house bank (use for in-house cash payments only)
CHAINBANKS Country key of a correspondent bank CHAINBANKS T005 CHAR 3 0
CHAINBANKK Bank key of a correspondence bank CHAINBANKK BNKA CHAR 15 0
CHAINBANKN Account number at correspondent bank CHAINBANKN CHAR 35 0
IBAN IBAN (International Bank Account Number) IBAN CHAR 34 0

TBCHAIN21 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TBCHAIN21 BANKKREC TBCHAIN21 MANDT BNKA Bank master record MANDT
TBCHAIN21 BANKKREC TBCHAIN21 BANKSREC BNKA Bank master record BANKS
TBCHAIN21 BANKKREC TBCHAIN21 BANKKREC BNKA Bank master record BANKL
TBCHAIN21 BANKKSND TBCHAIN21 MANDT BNKA Bank master record MANDT
TBCHAIN21 BANKKSND TBCHAIN21 BANKSSND BNKA Bank master record BANKS
TBCHAIN21 BANKKSND TBCHAIN21 BANKKSND BNKA Bank master record BANKL
TBCHAIN21 BANKSREC TBCHAIN21 MANDT T005 Countries MANDT
TBCHAIN21 BANKSREC TBCHAIN21 BANKSREC T005 Countries LAND1
TBCHAIN21 BANKSSND TBCHAIN21 MANDT T005 Countries MANDT
TBCHAIN21 BANKSSND TBCHAIN21 BANKSSND T005 Countries LAND1
TBCHAIN21 CHAINBANKK TBCHAIN21 CHAINBANKK BNKA Bank master record BANKL
TBCHAIN21 CHAINBANKK TBCHAIN21 MANDT BNKA Bank master record MANDT
TBCHAIN21 CHAINBANKK TBCHAIN21 CHAINBANKS BNKA Bank master record BANKS
TBCHAIN21 CHAINBANKS TBCHAIN21 MANDT T005 Countries MANDT
TBCHAIN21 CHAINBANKS TBCHAIN21 CHAINBANKS T005 Countries LAND1
TBCHAIN21 MANDT TBCHAIN21 MANDT T000 Clients MANDT
TBCHAIN21 UZAWE TBCHAIN21 MANDT T042F Payment method supplements MANDT
TBCHAIN21 UZAWE TBCHAIN21 UZAWE T042F Payment method supplements UZAWE
TBCHAIN21 WAERS TBCHAIN21 WAERS TCURC Currency Codes WAERS
TBCHAIN21 WAERS TBCHAIN21 MANDT TCURC Currency Codes MANDT