SAP table TBCHAIN0 (Definition bank chains)

SAP table TBCHAIN0 has 3 primary key fields being MANDT,CHAINID,CHAINNO.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
CHAINID ID for Bank Chain CHAR 10 0 CHAINID
CHAINNO Current Number of a Bank in Bank Chain NUMC 2 0 CHAINNO
01 Intermediary bank 1
02 Intermediary bank 2
03 Intermediary bank 3
CHAINBANKT Type of Bank in a Bank Chain (Correspondent, Intermediary) CHAR 1 0 CHAINBANKT
CHAINBANKS Country/Region Key of a Correspondence Bank CHAR 3 0 T005 CHAINBANKS
CHAINBANKK Bank Key of a Correspondence Bank CHAR 15 0 BNKA CHAINBANKK
CHAINBANKN Account Number at Correspondent Bank CHAR 35 0 CHAINBANKN
ERDAT Date on which the record was created DATS 8 0 ERDAT_BF
ERNAM Name of person who created the object CHAR 12 0 ERNAM_BF
IBAN IBAN (International Bank Account Number) CHAR 34 0 IBAN

TBCHAIN0 foreign key relationships

Table Field Check Table Check Field
0 TBCHAIN0 CHAINBANKK BNKA Bank master record BANKS
1 TBCHAIN0 CHAINBANKS T005 Countries MANDT
1 TBCHAIN0 CHAINBANKS T005 Countries LAND1