I_MakeBankTransferTemplateTP

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 I_MakeBankTransferTemplateTP.
-- 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.
-- SQL view name: IMBKWITHTMPL

CREATE VIEW I_MakeBankTransferTemplateTP AS
SELECT
  RepetitiveCodeFlowID,
  a.RepetitiveCode AS RepetitiveCode,
  a.PayingCompanyCode AS PayingCompanyCode,
  _PayingBankAccount.BankAccountNumber AS PayingBankAccount,
  _PayingHouseBank.BankAccountInternalID AS PayingBankAccountInternalID,
  _PayingHouseBank.BankAccountDescription AS PayingBankAccountDescription,
  a.PayeeCompanyCode AS PayeeCompanyCode,
  _PayeeBankAccount.BankAccountNumber AS PayeeBankAccount,
  _PayeeHouseBank.BankAccountInternalID AS PayeeBankAccountInternalID,
  _PayeeHouseBank.BankAccountDescription AS PayeeBankAccountDescription,
  a.PaymentMethod AS PaymentMethod,
  a.Currency AS Currency,
  a.RepetitiveCodeReferenceText AS RepetitiveCodeReferenceText,
  a.HouseBank AS HouseBank,
  a.PayingHouseBank AS PayingHouseBank,
  a.PayingHouseBankAccount AS PayingHouseBankAccount,
  a.BankCountry AS BankCountry,
  a.PayingBankKey AS PayingBankKey,
  _PayeeBankAccount.Bank AS PayeeBankKey,
  a.PayeeHouseBank AS PayeeHouseBank,
  a.PayeeHouseBankAccount AS PayeeHouseBankAccount,
  a.HouseBankAccount AS HouseBankAccount,
  c.Country AS Country
FROM P_MakeBankTransferTemplate AS a
INNER JOIN I_CompanyCode AS c ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _PayingCompanyCode ON PayingCompanyCode = _PayingCompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _PayeeCompanyCode ON PayeeCompanyCode = _PayeeCompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PaymentMethod AS _PaymentMethod ON Country = _PaymentMethod.Country AND PaymentMethod = _PaymentMethod.PaymentMethod  -- association [0..1]
;