C_ADM_WORKFLOW_TASK

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 C_ADM_WORKFLOW_TASK.
-- 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: CADMWRKFLWTASK

CREATE VIEW C_ADM_WORKFLOW_TASK AS
SELECT
  WorkflowTask.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  WorkflowTask.WorkflowInternalID AS WorkflowInternalID,
  WorkflowTask.WorkflowAgentRuleText AS WorkflowAgentRuleText,
  WorkflowTask.PersonFullName AS PersonFullName,
  WorkflowTask.WrkflwTskCreationUTCDateTime AS WrkflwTskCreationUTCDateTime,
  WorkflowTask.WrkflwTskCompletionUTCDateTime AS WrkflwTskCompletionUTCDateTime,
  case when WorkflowTask.WorkflowTaskName is initial or WorkflowTask.WorkflowTaskName is null then WorkflowTask.WorkflowTaskNameFB else WorkflowTask.WorkflowTaskName end as WorkflowTaskName AS WorkflowTaskNameendasWorkflowTaskName,
  WorkflowTask.WorkflowTaskExternalStatus AS WorkflowTaskExternalStatus,
  WorkflowTask._WorkflowTaskStatus AS _WorkflowTaskStatus,
  WorkflowTask._WorkflowLog AS _WorkflowLog,
  WorkflowTask._StepLog AS _StepLog,
  WorkflowTask.LogName AS LogName,
  _Component.SAPApplicationComponent AS SAPApplicationComponent,
  WorkflowTask.WorkflowScenarioDefinition AS WorkflowScenarioDefinition,
  cast('' as abap.char( 1024 ) ) AS WorkflowTaskStepDefinition
FROM I_ADM_WORKFLOW_TASK AS WorkflowTask
LEFT OUTER JOIN I_WorkflowScenarioApplComp AS _Component ON /* join condition not captured in parsed metadata */
;