I_BankChainHeaderTP

TP for Bank Chain per BP Account | view: IFABCHHEADERTP | Extraction: Not supported | Component: Master Data

Tables used: TBCHAIN2, TIBAN

🔑 Keys (7)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical
Other (5)
🔗 Relations (12)

Column Name	Description
BkChnCountryKeyOfRecipientBank FK	Country/Region Key of Recipient Bank
BkChnBankKeyOfRecipientBank FK	Bank Key of Recipient Bank
BkChnAcctNumberAtRecipientBank	Account Number at Recipient Bank
BkChnCurrencyKey FK	Currency
BkChnCountryKeyOfSenderBank FK	Country/Region Key of Sender Bank
BkChnBankKeyOfSenderBank FK	Bank Key of Sender Bank
BkChnPaymentMethodSupplement FK	Payment method supplement

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description	Domain name
BkChnBankAccountNumberForUI	Account Number at Recipient Bank	BANKN35
BkChnAcctNmbrAtRcpntBkForEdit	Account Number at Recipient Bank	BANKN35
IBAN	IBAN (International Bank Account Number)	IBAN
BusinessPartner	Business Partner Number	BU_PARTNER
BkChnBusinessPartnerListReport	Business Partner Number	BU_PARTNER

Master Data Relations	Join Conditions
Bank Key of Recipient Bank Bank Key of Recipient Bank Bank Key of Recipient Bank Client Country/Region Key of Recipient Bank Country/Region Key of Recipient Bank	`I_BANKCHAINHEADERTP.BKCHNBANKKEYOFRECIPIENTBANK == BNKA.BANKL` `I_BANKCHAINHEADERTP.BKCHNBKKEYOFRCPNTBKFOREDIT == BNKA.BANKL` `I_BANKCHAINHEADERTP.MANDT == BNKA.MANDT` `I_BANKCHAINHEADERTP.BKCHNCNTRYKEYOFRCPNTBKFOREDIT == BNKA.BANKS` `I_BANKCHAINHEADERTP.BKCHNCOUNTRYKEYOFRECIPIENTBANK == BNKA.BANKS`
Bank Key of Sender Bank Client Bank Key of Sender Bank Bank Key of Sender Bank Country/Region Key of Sender Bank Country/Region Key of Sender Bank	`I_BANKCHAINHEADERTP.MANDT == BNKA.MANDT` `I_BANKCHAINHEADERTP.BKCHNBKKEYOFSNDRBKFOREDIT == BNKA.BANKL` `I_BANKCHAINHEADERTP.BKCHNBANKKEYOFSENDERBANK == BNKA.BANKL` `I_BANKCHAINHEADERTP.BKCHNCNTRYKEYOFSNDRBKFOREDIT == BNKA.BANKS` `I_BANKCHAINHEADERTP.BKCHNCOUNTRYKEYOFSENDERBANK == BNKA.BANKS`
Bank Key of Recipient Bank Bank Key of Recipient Bank Bank Key of Recipient Bank Client Country/Region Key of Recipient Bank Country/Region Key of Recipient Bank	`I_BANKCHAINHEADERTP.BKCHNBANKKEYOFRECIPIENTBANK == BNKA.BANKL` `I_BANKCHAINHEADERTP.BKCHNBKKEYOFRCPNTBKFOREDIT == BNKA.BANKL` `I_BANKCHAINHEADERTP.MANDT == BNKA.MANDT` `I_BANKCHAINHEADERTP.BKCHNCNTRYKEYOFRCPNTBKFOREDIT == BNKA.BANKS` `I_BANKCHAINHEADERTP.BKCHNCOUNTRYKEYOFRECIPIENTBANK == BNKA.BANKS`
Bank Key of Sender Bank Client Bank Key of Sender Bank Bank Key of Sender Bank Country/Region Key of Sender Bank Country/Region Key of Sender Bank	`I_BANKCHAINHEADERTP.MANDT == BNKA.MANDT` `I_BANKCHAINHEADERTP.BKCHNBKKEYOFSNDRBKFOREDIT == BNKA.BANKL` `I_BANKCHAINHEADERTP.BKCHNBANKKEYOFSENDERBANK == BNKA.BANKL` `I_BANKCHAINHEADERTP.BKCHNCNTRYKEYOFSNDRBKFOREDIT == BNKA.BANKS` `I_BANKCHAINHEADERTP.BKCHNCOUNTRYKEYOFSENDERBANK == BNKA.BANKS`
Country/Region Key of Recipient Bank Client Country/Region Key of Recipient Bank Country/Region Key of Recipient Bank	`I_BANKCHAINHEADERTP.MANDT == T005.MANDT` `I_BANKCHAINHEADERTP.BKCHNCNTRYKEYOFRCPNTBKFOREDIT == T005.LAND1` `I_BANKCHAINHEADERTP.BKCHNCOUNTRYKEYOFRECIPIENTBANK == T005.LAND1`
Country/Region Key of Sender Bank Client Country/Region Key of Sender Bank Country/Region Key of Sender Bank	`I_BANKCHAINHEADERTP.MANDT == T005.MANDT` `I_BANKCHAINHEADERTP.BKCHNCNTRYKEYOFSNDRBKFOREDIT == T005.LAND1` `I_BANKCHAINHEADERTP.BKCHNCOUNTRYKEYOFSENDERBANK == T005.LAND1`
Country/Region Key of Recipient Bank Client Country/Region Key of Recipient Bank Country/Region Key of Recipient Bank	`I_BANKCHAINHEADERTP.MANDT == T005.MANDT` `I_BANKCHAINHEADERTP.BKCHNCNTRYKEYOFRCPNTBKFOREDIT == T005.LAND1` `I_BANKCHAINHEADERTP.BKCHNCOUNTRYKEYOFRECIPIENTBANK == T005.LAND1`
Country/Region Key of Sender Bank Client Country/Region Key of Sender Bank Country/Region Key of Sender Bank	`I_BANKCHAINHEADERTP.MANDT == T005.MANDT` `I_BANKCHAINHEADERTP.BKCHNCNTRYKEYOFSNDRBKFOREDIT == T005.LAND1` `I_BANKCHAINHEADERTP.BKCHNCOUNTRYKEYOFSENDERBANK == T005.LAND1`
Currency Client Currency Currency	`I_BANKCHAINHEADERTP.MANDT == TCURC.MANDT` `I_BANKCHAINHEADERTP.BKCHNCURRENCYKEYFOREDIT == TCURC.WAERS` `I_BANKCHAINHEADERTP.BKCHNCURRENCYKEY == TCURC.WAERS`
Currency Client Currency Currency	`I_BANKCHAINHEADERTP.MANDT == TCURC.MANDT` `I_BANKCHAINHEADERTP.BKCHNCURRENCYKEYFOREDIT == TCURC.WAERS` `I_BANKCHAINHEADERTP.BKCHNCURRENCYKEY == TCURC.WAERS`
Payment method supplement Client Payment method supplement Payment method supplement	`I_BANKCHAINHEADERTP.MANDT == T042F.MANDT` `I_BANKCHAINHEADERTP.BKCHNPAYTMETHSUPLMNTFOREDIT == T042F.UZAWE` `I_BANKCHAINHEADERTP.BKCHNPAYMENTMETHODSUPPLEMENT == T042F.UZAWE`
Payment method supplement Client Payment method supplement Payment method supplement	`I_BANKCHAINHEADERTP.MANDT == T042F.MANDT` `I_BANKCHAINHEADERTP.BKCHNPAYTMETHSUPLMNTFOREDIT == T042F.UZAWE` `I_BANKCHAINHEADERTP.BKCHNPAYMENTMETHODSUPPLEMENT == T042F.UZAWE`