I_BankAcctReqEmailTemplate

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_BankAcctReqEmailTemplate.
-- 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: IBAMREQEMAIL

CREATE VIEW I_BankAcctReqEmailTemplate AS
SELECT
  BankAccountChangeRequest,
  BankAccountAction,
  BankAccountActionText,
  BankAccountChangeRequestStatus,
  BankAccountChangeRequestStep,
  BankAccountReqStatusText,
  BankAcctChangeReqHeadingText,
  BankAcctChangeRequestDueDate,
  CreatedByUser,
  _Contact.FullName AS CreatedByUserFullName,
  CreationDate,
  LastChangedByUser,
  _LastChangedByUser.FullName AS LastChangedByUserFullName,
  cast (' ' as fclm_bam_bank_country_key ) AS BankCountry,
  cast (' ' as fclm_bam_bank_key ) AS Bank,
  cast (' ' as fclm_bam_acc_num ) AS BankAccountNumber,
  cast (' ' as waers_curc ) AS BankAccountCurrency,
  cast( ' ' as fclm_bam_acc_url) AS BankAccountURL
FROM I_BankAcctChangeRequest AS BankAcctCR
LEFT OUTER JOIN I_UserContactCard AS _Contact ON CreatedByUser = _Contact.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.ContactCardID  -- association [0..1]
;