TBCHAIN21

Bank chains per business partner account (allocation) | #masterdata | Component: Bank Master Data
Column Name Description
MANDT FK Client
BANKSREC FK Country/Region Key of Recipient Bank
BANKKREC FK Bank Key of Recipient Bank
BANKNREC Account Number at Recipient Bank
WAERS FK Currency Key
BANKSSND FK Country/Region Key of Sending Bank
BANKKSND FK Bank Key of Sender Bank
UZAWE FK Payment method supplement
CHAINNO Current Number of a Bank in Bank Chain Show values
Column Name Description
Column Name Description
Column Name Description
Column Name Description
CHAINNO Current Number of a Bank in Bank Chain Show values
CHAINBANKT Type of Bank in a Bank Chain (Correspondent, Intermediary) Show values
Column Name Description Domain name
CHAINBANKN Account Number at Correspondent Bank BANKN35
IBAN IBAN (International Bank Account Number) IBAN
Master Data Relations Join Conditions
Bank Key of Recipient Bank
  • Bank Key of Recipient Bank
  • Country/Region Key of Recipient Bank
  • TBCHAIN21.MANDT == BNKA.MANDT
  • TBCHAIN21.BANKKREC == BNKA.BANKL
  • TBCHAIN21.BANKSREC == BNKA.BANKS
Bank Key of Sender Bank
  • Bank Key of Sender Bank
  • Country/Region Key of Sending Bank
  • TBCHAIN21.MANDT == BNKA.MANDT
  • TBCHAIN21.BANKKSND == BNKA.BANKL
  • TBCHAIN21.BANKSSND == BNKA.BANKS
Country/Region Key of Recipient Bank
  • Country/Region Key of Recipient Bank
  • Client
  • TBCHAIN21.BANKSREC == T005.LAND1
  • TBCHAIN21.MANDT == T005.MANDT
Country/Region Key of Sending Bank
  • Country/Region Key of Sending Bank
  • Client
  • TBCHAIN21.BANKSSND == T005.LAND1
  • TBCHAIN21.MANDT == T005.MANDT
Bank Key of a Correspondence Bank
  • Bank Key of a Correspondence Bank
  • Country/Region Key of a Correspondence Bank
  • TBCHAIN21.MANDT == BNKA.MANDT
  • TBCHAIN21.CHAINBANKK == BNKA.BANKL
  • TBCHAIN21.CHAINBANKS == BNKA.BANKS
Country/Region Key of a Correspondence Bank
  • Country/Region Key of a Correspondence Bank
  • Client
  • TBCHAIN21.CHAINBANKS == T005.LAND1
  • TBCHAIN21.MANDT == T005.MANDT
Client TBCHAIN21.MANDT == T000.MANDT
Payment method supplement
  • TBCHAIN21.MANDT == T042F.MANDT
  • TBCHAIN21.UZAWE == T042F.UZAWE
Currency Key
  • TBCHAIN21.MANDT == TCURC.MANDT
  • TBCHAIN21.WAERS == TCURC.WAERS