R_OutputRequestItemEmail

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 R_OutputRequestItemEmail.
-- 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 R_OutputRequestItemEmail AS
SELECT
  apoc_d_or_item_e.db_key AS OutputRequestItemEmailUUID,
  apoc_d_or_item_e.parent_key AS OutputRequestItemUUID,
  apoc_d_or_item_e.root_key AS OutputRequestUUID,
  apoc_d_or_item_e.appl_object_type AS OutputControlApplObjectType,
  apoc_d_or_item_e.appl_object_id AS OutputControlApplicationObject,
  apoc_d_or_item_e.item_id AS OutputRequestItem,
  apoc_d_or_item_e.counter AS OutputRequestItemEmailID,
  apoc_d_or_item_e.email_role AS OutputRequestItemEmailRole,
  apoc_d_or_item_e.email_uri AS OutputRequestItemEmailAddress,
  apoc_d_or_item_e.email_origin AS OutputRequestItemEmailOrigin
FROM apoc_d_or_item_e
LEFT OUTER JOIN R_OutputRequest AS _OutputRequest ON OutputRequestUUID = _OutputRequest.OutputRequestUUID  -- association [1..1]
LEFT OUTER JOIN R_OutputRequestItem AS _OutputRequestItem ON OutputRequestItemUUID = _OutputRequestItem.OutputRequestItemUUID  -- association [1..1]
LEFT OUTER JOIN I_OutputControlApplObjectType AS _OutputControlApplObjectType ON OutputControlApplObjectType = _OutputControlApplObjectType.OutputControlApplObjectType  -- association [0..1]
LEFT OUTER JOIN I_OCEmRecRole AS _EmRecRole ON OutputRequestItemEmailRole = _EmRecRole.OutputRequestItemEmailRole  -- association [0..1]
;