I_CollectionsEmail

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_CollectionsEmail.
-- 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 I_CollectionsEmail AS
SELECT
  EmailUUID,
  objectkey AS CollectionsEmailObject,
  objecttype AS CollectionsEmailObjectType,
  template_id AS EmailTemplateID,
  tmpl_language AS Language,
  subject AS EmailSubjectText,
  body_html AS EmailBodyText,
  recipient AS CollsRecipientEmailAddrString,
  cc_recipient AS CollsCCRcpntEmailAddrString,
  bcc_recipient AS CollsBCCRcpntEmailAddrString,
  sender AS CollsSenderEmailAddressString,
  email_sent_at AS EmailSentDateTime,
  email_sent_by AS EmailSentByUser,
  sending_triggered_by AS TriggeredByUser,
  email_status AS CollectionsEmailStatus,
  application_log_number AS ApplicationLog,
  zip_attachments AS EmailAttachmentIsZIPFile,
  created_at AS EmailCreationDateTime,
  created_by AS EmailCreatedByUser,
  last_changed_at AS EmailLastChangeDateTime,
  last_changed_by AS EmailLastChangedByUser
FROM colls_email
;