I_WorkflowStatusDetails

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_WorkflowStatusDetails.
-- 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: IWRKFLWSTTSDTLS

CREATE VIEW I_WorkflowStatusDetails AS
SELECT
  I_WorkflowTask.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  TopLevelWorkflowTask AS WorkflowInternalID,
  WorkflowTaskStatus AS WorkflowTaskExternalStatus,
  WorkflowTaskDefinition,
  WorkflowTaskCurrentUser AS WorkflowTaskProcessor,
  WorkflowTaskProcessorRole,
  WrkflwTskCreationUTCDateTime,
  WrkflwTskCompletionUTCDateTime,
  WorkflowTaskStepType,
  TopLevelWorkflowTaskDefinition AS WorkflowScenarioDefinition,
  WorkflowTaskDefinitionVersion AS WorkflowScenarioDefinitionVers,
  WorkflowTaskResult.WorkflowTaskResult AS WorkflowTaskResult
FROM I_WorkflowTask
LEFT OUTER JOIN I_WorkflowTaskResult AS WorkflowTaskResult ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkflowTaskExternalStatus AS _WorkflowTaskExternalStatus ON WorkflowTaskExternalStatus = _WorkflowTaskExternalStatus.WorkflowTaskExternalStatus  -- association [0..1]
LEFT OUTER JOIN I_BusinessUser AS _WorkflowTaskProcessor ON WorkflowTaskProcessor = _WorkflowTaskProcessor.UserID  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _WorkflowTaskProcessor_2 ON WorkflowTaskProcessor = _WorkflowTaskProcessor_2.UserID  -- association [0..1]
LEFT OUTER JOIN I_WorkflowStepType AS _WorkflowTaskStepType ON WorkflowScenarioDefinition = _WorkflowTaskStepType.WrkflwScen AND WorkflowScenarioDefinitionVers = _WorkflowTaskStepType.WrkflwScenVers AND WorkflowTaskStepType = _WorkflowTaskStepType.WorkflowStepType  -- association [0..1]
LEFT OUTER JOIN I_WorkflowRecipients AS _WorkflowRecipients ON WorkflowInternalID = _WorkflowRecipients.WorkflowInternalID AND WorkflowTaskInternalID = _WorkflowRecipients.WorkflowTaskInternalID  -- association [0..*]
LEFT OUTER JOIN I_WORKFLOWRECIPIENTS_V2 AS _WorkflowRecipients_2 ON WorkflowInternalID = _WorkflowRecipients_2.WorkflowInternalID AND WorkflowTaskInternalID = _WorkflowRecipients_2.WorkflowTaskInternalID  -- association [0..*]
LEFT OUTER JOIN I_WorkflowStepResult AS _WorkflowTaskStepResult ON WorkflowScenarioDefinition = _WorkflowTaskStepResult.WorkflowScenarioDefinition AND WorkflowScenarioDefinitionVers = _WorkflowTaskStepResult.WorkflowScenarioDefinitionVers AND WorkflowTaskStepType = _WorkflowTaskStepResult.WorkflowStepType AND WorkflowTaskResult = _WorkflowTaskStepResult.WorkflowStepResult  -- association [0..1]
LEFT OUTER JOIN I_WorkflowAgentRule AS _WorkflowAgentRule ON WorkflowScenarioDefinition = _WorkflowAgentRule.WorkflowScenarioDefinition AND WorkflowScenarioDefinitionVers = _WorkflowAgentRule.WorkflowScenarioDefinitionVers AND WorkflowTaskProcessorRole = _WorkflowAgentRule.WorkflowAgentRule  -- association [0..1]
;