C_MakeBankTransferTemplate

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_MakeBankTransferTemplate.
-- 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_MakeBankTransferTemplate AS
SELECT
  a.RepetitiveCodeFlowID AS RepetitiveCodeFlowID,
  a.RepetitiveCode AS RepetitiveCode,
  a.PayingBankAccount AS PayingBankAccount,
  a.PayingBankAccountInternalID AS PayingBankAccountInternalID,
  a.PayingBankAccountDescription AS PayingBankAccountDescription,
  a.PayingCompanyCode AS PayingCompanyCode,
  a._PayingCompanyCode.CompanyCodeName AS PayingCompanyCodeName,
  a.PayingHouseBank AS PayingHouseBank,
  a.PayingHouseBankAccount AS PayingHouseBankAccount,
  a.PayeeBankAccount AS PayeeBankAccount,
  a.PayeeBankAccountInternalID AS PayeeBankAccountInternalID,
  a.PayeeBankAccountDescription AS PayeeBankAccountDescription,
  a.PayeeCompanyCode AS PayeeCompanyCode,
  a._PayeeCompanyCode.CompanyCodeName AS PayeeCompanyCodeName,
  a.HouseBank AS PayeeHouseBank,
  a.HouseBankAccount AS PayeeHouseBankAccount,
  a.PaymentMethod AS PaymentMethod,
  a._PaymentMethod.PaymentMethodName AS PaymentMethodName,
  a.Currency AS Currency,
  a.RepetitiveCodeReferenceText AS RepetitiveCodeReferenceText,
  a.PayingBankKey AS PayingBankKey,
  a.PayeeBankKey AS PayeeBankKey,
  a.BankCountry AS BankCountry
FROM I_MakeBankTransferTemplateTP AS a
LEFT OUTER JOIN I_CurrencyStdVH AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CompanyCodeVH AS _PayingCompanyCode ON PayingCompanyCode = _PayingCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCodeVH AS _TargetCompanyCode ON PayeeCompanyCode = _TargetCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _PayingBankAcctVH ON PayingBankAccountInternalID = _PayingBankAcctVH.BankAccountInternalID AND PayingBankAccount = _PayingBankAcctVH.BankAccount AND PayingCompanyCode = _PayingBankAcctVH.CompanyCode AND PayingHouseBank = _PayingBankAcctVH.HouseBank AND PayingHouseBankAccount = _PayingBankAcctVH.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _TargetBankAcctVH ON PayeeBankAccountInternalID = _TargetBankAcctVH.BankAccountInternalID AND PayeeBankAccount = _TargetBankAcctVH.BankAccount AND PayeeCompanyCode = _TargetBankAcctVH.CompanyCode AND PayeeHouseBank = _TargetBankAcctVH.HouseBank AND PayeeHouseBankAccount = _TargetBankAcctVH.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _PayingHouseBankVH ON PayingBankAccountInternalID = _PayingHouseBankVH.BankAccountInternalID AND PayingBankAccount = _PayingHouseBankVH.BankAccount AND PayingCompanyCode = _PayingHouseBankVH.CompanyCode AND PayingHouseBank = _PayingHouseBankVH.HouseBank AND PayingHouseBankAccount = _PayingHouseBankVH.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _PayeeHouseBankVH ON PayeeBankAccountInternalID = _PayeeHouseBankVH.BankAccountInternalID AND PayeeBankAccount = _PayeeHouseBankVH.BankAccount AND PayeeCompanyCode = _PayeeHouseBankVH.CompanyCode AND PayeeHouseBank = _PayeeHouseBankVH.HouseBank AND PayeeHouseBankAccount = _PayeeHouseBankVH.HouseBankAccount  -- association [0..1]
;