I_MakeBkTransfWthTmplItmTP

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

Tables used: FCLM_CPL_FLOW_IT, PAYRQ, T042Z, T042ZT, FIBL_RPCODE, FIBL_RPCODE_TDEF

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

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
IsSinglePayment	Indicator: Individual Payment	Show values
BankTransferReleaseAndPay	Boolean values TRUE (='X') and FALSE (= ' ')	Show values

Column Name	Description	Domain name
RepetitiveCode	Payment code	RFTTRN_BF
PayeeHouseBank	Reference to Business Partner Receiving Payment	CHAR16
PayeeHouseBankAccount	Short Key for Partner's Bank Details	CHAR6
PaymentMethodName	Payment Method Name	TEXT30
PaymentRequest	Key Number for Payment Request	PRQ_KEYNO
Note	Item Text	TEXT50
BankAccountRevision	Revision Number	FCLM_REVISION
PaymentReference	Payment Reference	CHAR30

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