R_SWWFLEXPROCMOSTRECENT

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_SWWFLEXPROCMOSTRECENT.
-- 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_SWWFLEXPROCMOSTRECENT AS
SELECT
  head.wf_id AS WorkflowInternalIdentifier,
  head.flex_id AS Guid,
  head.wfd_id AS WorkflowScenarioDefinition,
  proc.change_ts AS WorkflowResourceChangedAt,
  proc.status AS WorkflowInstanceStatus,
  proc.original_id AS WorkflowDefinitionIdentifier,
  proc.scenario_version AS WorkflowScenarioVersion,
  proc.format_version AS WorkflowResourceFormatVersion,
  proc.is_review_flow AS IsReviewFlow,
  proc.appl_obj_id AS WorkflowLeadingObject,
  proc.stream AS OriginalWorkflowResourceXML,
  _steplog.Timestamp AS WorkflowInstanceChangedAt,
  _Component.SAPApplicationComponent AS SAPApplicationComponent,
  proc.local_last_changed_at as LocalLastChangedAt AS wi_idasWorkflowInternalIdentifier,
  proc.local_last_changed_at AS LocalLastChangedAt
FROM swp_header AS head
RIGHT OUTER JOIN swwflexproc AS proc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_StepLogMostRecent AS _steplog ON _steplog.WorkflowInternalIdentifier = head.wf_id  -- association [1..1]
LEFT OUTER JOIN swpsteplog AS steplog ON steplog.wf_id = proc.wi_id  -- association [*]
-- UNION ALL with additional select branch(es): swwflexproc
;