C_MakeBkTransfWthTmplItmTP

Consumption View for MBTs with Template Items | view: CMBTTMPLITMTP | Extraction: Not supported | Component: Fiori UI for Cash and Liquidity Management

Tables used: FCLM_CPL_FLOW_IT, PAYRQ, FCLM_BAM_AMD, FCLM_BAM_AMD_T, FCLM_BAM_AC_TYPE, FCLM_BAM_ACLINK2, T001, TKA02, T042Z, T042ZT, FIBL_RPCODE, FIBL_RPCODE_TDEF, T012K

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities
📅 Dates (1)
☰ Categorical
Other (18)
🔗 Relations (19)

Column Name	Description
MakeBankTransferRunID FK	Cash Concentration ID
MakeBankTransferItemID	UUID in X form (binary)

Column Name	Description
💲 Currency Key (Currency):
PaymentRequestAmountInPaytCrcy	Payment Request Amount in Payment Currency

Column Name	Description

Column Name	Description
ValueDate	Value Date for the Sending Bank

Column Name	Description

Column Name	Description	Domain name
RepetitiveCode	Payment code
BankAccount	Bank Account Number
BankAccountDescription	Account Description
PayeeBankAccount	Bank Account Number
PayeeHouseBank	Reference to Business Partner Receiving Payment
PayeeHouseBankAccount	Short Key for Partner's Bank Details
PayeeBankAccountDescription	Account Description
Note	Item Text
IsSinglePayment	Indicator: Individual Payment
BankTransferReleaseAndPay	Boolean values TRUE (='X') and FALSE (= ' ')
PaymentReference	Payment Reference
BankAccountRevision	Revision Number	FCLM_REVISION
PaymentRequest	Key Number for Payment Request
PaymentMethodName	Payment Method Name	TEXT30
CompanyCodeName	Name of Company Code or Company	TEXT25
PayeeCompanyCodeName	Name of Company Code or Company	TEXT25
BankName	Name of Financial Institution	TEXT60
PayeeBankName	Name of Financial Institution	TEXT60

Master Data Relations	Join Conditions
Bank Key Bank Key Bank Key Client Country/Region Key of Bank	`C_MAKEBKTRANSFWTHTMPLITMTP.PAYEEBANK == BNKA.BANKL` `C_MAKEBKTRANSFWTHTMPLITMTP.BANK == BNKA.BANKL` `C_MAKEBKTRANSFWTHTMPLITMTP.MANDT == BNKA.MANDT` `C_MAKEBKTRANSFWTHTMPLITMTP.BANKCOUNTRY == BNKA.BANKS`
Bank Account Technical ID ? Bank Account Technical ID Bank Account Technical ID Client	`C_MAKEBKTRANSFWTHTMPLITMTP.[column in domain "FCLM_REVISION"] == FCLM_BAM_AMD.REVISION` `C_MAKEBKTRANSFWTHTMPLITMTP.BANKACCOUNTINTERNALID == FCLM_BAM_AMD.ACC_ID` `C_MAKEBKTRANSFWTHTMPLITMTP.PAYEEBANKACCOUNTINTERNALID == FCLM_BAM_AMD.ACC_ID` `C_MAKEBKTRANSFWTHTMPLITMTP.MANDT == FCLM_BAM_AMD.MANDT`
Country/Region Key of Bank Client Country/Region Key of Bank	`C_MAKEBKTRANSFWTHTMPLITMTP.MANDT == T005.MANDT` `C_MAKEBKTRANSFWTHTMPLITMTP.BANKCOUNTRY == T005.LAND1`
Paying Company Code for this Payment Request Paying Company Code for this Payment Request Client	`C_MAKEBKTRANSFWTHTMPLITMTP.COMPANYCODE == T001.BUKRS` `C_MAKEBKTRANSFWTHTMPLITMTP.MANDT == T001.MANDT`
Instruction Key 1 ? ? Instruction Key 1	`C_MAKEBKTRANSFWTHTMPLITMTP.[column in domain "DTWSF"] == T015W1.DTWSF` `C_MAKEBKTRANSFWTHTMPLITMTP.[column in domain "DTWSC"] == T015W1.DTWSC` `C_MAKEBKTRANSFWTHTMPLITMTP.DATAEXCHANGEINSTRUCTION1 == T015W1.DTWSX`
Instruction Key 2 ? ? Instruction Key 2	`C_MAKEBKTRANSFWTHTMPLITMTP.[column in domain "DTWSF"] == T015W1.DTWSF` `C_MAKEBKTRANSFWTHTMPLITMTP.[column in domain "DTWSC"] == T015W1.DTWSC` `C_MAKEBKTRANSFWTHTMPLITMTP.DATAEXCHANGEINSTRUCTION2 == T015W1.DTWSX`
Instruction Key 3 Instruction Key 3 ? ?	`C_MAKEBKTRANSFWTHTMPLITMTP.DATAEXCHANGEINSTRUCTION3 == T015W1.DTWSX` `C_MAKEBKTRANSFWTHTMPLITMTP.[column in domain "DTWSF"] == T015W1.DTWSF` `C_MAKEBKTRANSFWTHTMPLITMTP.[column in domain "DTWSC"] == T015W1.DTWSC`
Instruction Key 4 ? ? Instruction Key 4	`C_MAKEBKTRANSFWTHTMPLITMTP.[column in domain "DTWSF"] == T015W1.DTWSF` `C_MAKEBKTRANSFWTHTMPLITMTP.[column in domain "DTWSC"] == T015W1.DTWSC` `C_MAKEBKTRANSFWTHTMPLITMTP.DATAEXCHANGEINSTRUCTION4 == T015W1.DTWSX`
Instruction key for data medium exchange ? Client ? Instruction key for data medium exchange	`C_MAKEBKTRANSFWTHTMPLITMTP.[column in domain "DZLSCH"] == T015W.ZLSCH` `C_MAKEBKTRANSFWTHTMPLITMTP.MANDT == T015W.MANDT` `C_MAKEBKTRANSFWTHTMPLITMTP.[column in domain "BANKS"] == T015W.BANKS` `C_MAKEBKTRANSFWTHTMPLITMTP.DATAEXCHANGEINSTRUCTIONKEY == T015W.DTAWS`
Short Key for a House Bank Short Key for a House Bank Paying Company Code for this Payment Request Client	`C_MAKEBKTRANSFWTHTMPLITMTP.HOUSEBANK == T012.HBKID` `C_MAKEBKTRANSFWTHTMPLITMTP.COMPANYCODE == T012.BUKRS` `C_MAKEBKTRANSFWTHTMPLITMTP.MANDT == T012.MANDT`
ID for Account Details ? ID for Account Details Short Key for a House Bank Client	`C_MAKEBKTRANSFWTHTMPLITMTP.[column in domain "BUKRS"] == T012K.BUKRS` `C_MAKEBKTRANSFWTHTMPLITMTP.HOUSEBANKACCOUNT == T012K.HKTID` `C_MAKEBKTRANSFWTHTMPLITMTP.HOUSEBANK == T012K.HBKID` `C_MAKEBKTRANSFWTHTMPLITMTP.MANDT == T012K.MANDT`
Bank Key Bank Key Bank Key Client Country/Region Key of Bank	`C_MAKEBKTRANSFWTHTMPLITMTP.PAYEEBANK == BNKA.BANKL` `C_MAKEBKTRANSFWTHTMPLITMTP.BANK == BNKA.BANKL` `C_MAKEBKTRANSFWTHTMPLITMTP.MANDT == BNKA.MANDT` `C_MAKEBKTRANSFWTHTMPLITMTP.BANKCOUNTRY == BNKA.BANKS`
Bank Account Technical ID ? Bank Account Technical ID Bank Account Technical ID Client	`C_MAKEBKTRANSFWTHTMPLITMTP.[column in domain "FCLM_REVISION"] == FCLM_BAM_AMD.REVISION` `C_MAKEBKTRANSFWTHTMPLITMTP.BANKACCOUNTINTERNALID == FCLM_BAM_AMD.ACC_ID` `C_MAKEBKTRANSFWTHTMPLITMTP.PAYEEBANKACCOUNTINTERNALID == FCLM_BAM_AMD.ACC_ID` `C_MAKEBKTRANSFWTHTMPLITMTP.MANDT == FCLM_BAM_AMD.MANDT`
Target Company Code Target Company Code Client	`C_MAKEBKTRANSFWTHTMPLITMTP.PAYEECOMPANYCODE == T001.BUKRS` `C_MAKEBKTRANSFWTHTMPLITMTP.MANDT == T001.MANDT`
Payment Method ? Payment Method Client	`C_MAKEBKTRANSFWTHTMPLITMTP.[column in domain "DZBUKR"] == T042E.ZBUKR` `C_MAKEBKTRANSFWTHTMPLITMTP.PAYMENTMETHOD == T042E.ZLSCH` `C_MAKEBKTRANSFWTHTMPLITMTP.MANDT == T042E.MANDT`
Payment Method Supplement Payment Method Supplement Client	`C_MAKEBKTRANSFWTHTMPLITMTP.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE` `C_MAKEBKTRANSFWTHTMPLITMTP.MANDT == T042F.MANDT`
State Central Bank Indicator Client State Central Bank Indicator	`C_MAKEBKTRANSFWTHTMPLITMTP.MANDT == T015L.MANDT` `C_MAKEBKTRANSFWTHTMPLITMTP.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ`
Country/Region Key Client Country/Region Key	`C_MAKEBKTRANSFWTHTMPLITMTP.MANDT == T005.MANDT` `C_MAKEBKTRANSFWTHTMPLITMTP.SUPPLIERCOUNTRY == T005.LAND1`