I_WorkflowStatusOverview

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_WorkflowStatusOverview.
-- 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: IWRKFLWSTTSVW

CREATE VIEW I_WorkflowStatusOverview AS
SELECT
  WorkflowHeader.WorkflowTaskInternalID AS WorkflowInternalID,
  WorkflowTaskStatus AS WorkflowExternalStatus,
  WorkflowTaskDefinition AS WorkflowScenarioDefinition,
  WorkflowTaskDefinitionVersion AS WorkflowScenarioDefinitionVers,
  WrkflwTskCreationUTCDateTime,
  WrkflwTskCompletionUTCDateTime,
  WorkflowTaskApplObject.SAPObjectNodeRepresentation AS SAPObjectNodeRepresentation,
  WorkflowTaskApplObject.SAPBusinessObjectNodeKey1 AS SAPBusinessObjectNodeKey1,
  WorkflowTaskApplObject.SAPBusinessObjectNodeKey2 AS SAPBusinessObjectNodeKey2,
  WorkflowTaskApplObject.SAPBusinessObjectNodeKey3 AS SAPBusinessObjectNodeKey3,
  WorkflowTaskApplObject.SAPBusinessObjectNodeKey4 AS SAPBusinessObjectNodeKey4,
  WorkflowTaskApplObject.SAPBusinessObjectNodeKey5 AS SAPBusinessObjectNodeKey5,
  WorkflowTaskApplObject.SAPBusinessObjectNodeKey6 AS SAPBusinessObjectNodeKey6
FROM I_WorkflowTask AS WorkflowHeader
INNER JOIN I_WorkflowTaskApplObject AS WorkflowTaskApplObject ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkflowTaskCount AS Tasks ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkflowExternalStatus AS _WorkflowExternalStatus ON WorkflowExternalStatus = _WorkflowExternalStatus.WorkflowExternalStatus  -- association [0..1]
LEFT OUTER JOIN I_WorkflowScenarioDefinition AS _WorkflowScenarioDefinition ON WorkflowScenarioDefinition = _WorkflowScenarioDefinition.WorkflowScenarioDefinition  -- association [0..1]
LEFT OUTER JOIN I_WorkflowStatusDetails AS _WorkflowStatusDetails ON WorkflowInternalID = _WorkflowStatusDetails.WorkflowInternalID  -- association [0..*]
LEFT OUTER JOIN I_WorkflowResult AS _WorkflowResult ON WorkflowInternalID = _WorkflowResult.WorkflowInternalID  -- association [0..1]
;