SAP Table TBCHAIN0

Definition bank chains

TBCHAIN0 (Definition bank chains) 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 TBCHAIN0 to other SAP tables.

TBCHAIN0 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
CHAINID ID for bank chain CHAINID CHAR 10 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
ERDAT Date on which the record was created ERDAT_BF DATS 8 0
ERNAM Name of person who created the object ERNAM_BF CHAR 12 0
IBAN IBAN (International Bank Account Number) IBAN CHAR 34 0

TBCHAIN0 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TBCHAIN0 CHAINBANKK TBCHAIN0 MANDT BNKA Bank master record MANDT
TBCHAIN0 CHAINBANKK TBCHAIN0 CHAINBANKS BNKA Bank master record BANKS
TBCHAIN0 CHAINBANKK TBCHAIN0 CHAINBANKK BNKA Bank master record BANKL
TBCHAIN0 CHAINBANKS TBCHAIN0 MANDT T005 Countries MANDT
TBCHAIN0 CHAINBANKS TBCHAIN0 CHAINBANKS T005 Countries LAND1
TBCHAIN0 MANDT TBCHAIN0 MANDT T000 Clients MANDT