C_MakeBkTransfWthTmplItmTP

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_MakeBkTransfWthTmplItmTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_MakeBkTransfWthTmplItmTP AS
SELECT
  base.MakeBankTransferRunID AS MakeBankTransferRunID,
  base.MakeBankTransferItemID AS MakeBankTransferItemID,
  RepetitiveCode,
  CompanyCode,
  _bkaccnum1.BankAccountNumber AS BankAccount,
  _aclink1.Bank AS Bank,
  HouseBank,
  HouseBankAccount,
  _aclink1.BankAccountInternalID AS BankAccountInternalID,
  _aclink1.BankAccountDescription AS BankAccountDescription,
  base.PayeeCompanyCode AS PayeeCompanyCode,
  _bkaccnum2.BankAccountNumber AS PayeeBankAccount,
  _aclink2.Bank AS PayeeBank,
  PayeeHouseBank,
  PayeeHouseBankAccount,
  _aclink2.BankAccountInternalID AS PayeeBankAccountInternalID,
  _aclink2.BankAccountDescription AS PayeeBankAccountDescription,
  base.PaymentMethod AS PaymentMethod,
  ValueDate,
  base.PaymentRequestAmountInPaytCrcy AS PaymentRequestAmountInPaytCrcy,
  base.Currency AS Currency,
  base.Note AS Note,
  base.DataExchangeInstructionKey AS DataExchangeInstructionKey,
  base.DataExchangeInstruction1 AS DataExchangeInstruction1,
  base.DataExchangeInstruction2 AS DataExchangeInstruction2,
  base.DataExchangeInstruction3 AS DataExchangeInstruction3,
  base.DataExchangeInstruction4 AS DataExchangeInstruction4,
  base.IsSinglePayment AS IsSinglePayment,
  base.BankTransferReleaseAndPay AS BankTransferReleaseAndPay,
  StateCentralBankPaymentReason,
  SupplierCountry,
  PaymentMethodSupplement,
  PaymentReference,
  BankAccountRevision,
  base.PaymentRequest AS PaymentRequest,
  BankCountry,
  PaymentMethodName,
  _CoCode1.CompanyCodeName AS CompanyCodeName,
  cast(_CoCode2.CompanyCodeName as fclm_payee_cocodename preserving type ) AS PayeeCompanyCodeName,
  _aclink1.BankName AS BankName,
  cast(_aclink2.BankName as fclm_payee_bankname preserving type ) AS PayeeBankName
FROM I_MakeBkTransfWthTmplItmTP AS base
LEFT OUTER JOIN C_MakeBkTransfWithTmplTP AS _mbtlist ON MakeBankTransferRunID = _mbtlist.MakeBankTransferRunID  -- association [1..1]
LEFT OUTER JOIN I_BkAcctAndHsBkAcctLinkage AS _aclink1 ON base.CompanyCode = _aclink1.CompanyCode AND base.HouseBank = _aclink1.HouseBank AND base.HouseBankAccount = _aclink1.HouseBankAccount AND _aclink1.BankAccountStatus = '02'  -- association [1..1]
LEFT OUTER JOIN I_BkAcctAndHsBkAcctLinkage AS _aclink2 ON base.PayeeCompanyCode = _aclink2.CompanyCode AND base.PayeeHouseBank = _aclink2.HouseBank AND base.PayeeHouseBankAccount = _aclink2.HouseBankAccount AND _aclink2.BankAccountStatus = '02'  -- association [1..1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _bkaccnum1 ON base.CompanyCode = _bkaccnum1.CompanyCode AND base.HouseBank = _bkaccnum1.HouseBank AND base.HouseBankAccount = _bkaccnum1.HouseBankAccount  -- association [1..1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _bkaccnum2 ON base.PayeeCompanyCode = _bkaccnum2.CompanyCode AND base.PayeeHouseBank = _bkaccnum2.HouseBank AND base.PayeeHouseBankAccount = _bkaccnum2.HouseBankAccount  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CoCode1 ON base.CompanyCode = _CoCode1.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CoCode2 ON base.PayeeCompanyCode = _CoCode2.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON base.Currency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN C_PaytRequestInstructionKeyVH AS _InstructionKeyVH ON base.BankCountry = _InstructionKeyVH.BankCountryKey AND base.PaymentMethod = _InstructionKeyVH.PaymentMethod AND base.DataExchangeInstructionKey = _InstructionKeyVH.DataExchangeInstructionKey  -- association [1..1]
;