C_EHSRiskControlTaskDefAndInst

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_EHSRiskControlTaskDefAndInst.
-- 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 C_EHSRiskControlTaskDefAndInst AS
SELECT
  EHSTaskDefinitionUUID,
  WorkflowTaskInternalID,
  EHSPlannedTaskUUID,
  EHSTaskHostObjectInstance,
  EHSTaskHostObjectInstanceUUID,
  EHSTaskHostObjectAdapterClass,
  cast('' as ehfnd_semantic_object) AS EHSTaskHostSemanticObject,
  EHSPlannedTaskID,
  EHSTaskTitle,
  EHSTaskDefinitionType,
  cast ( '' as abap.char( 100 ) ) AS EHSTaskStatusName,
  EHSTaskDefinitionIsPaused,
  EHSTaskDefinitionStatus,
  EHSTaskDueDate,
  EHSTaskStartDate,
  EHSTaskInstceCompletionDate,
  EHSTaskTimeZone,
  WorkflowTaskStatus,
  EHSTaskIsRecurrent,
  IsDraftEntity,
  cast('' as sdraft_last_changed_by_me) AS DraftIsLastChangedByMe,
  cast('' as sdraft_in_process_by) AS InProcessByUser,
  cast('' as sdraft_in_process_by_desc) AS InProcessByUserDescription,
  cast('' as sdraft_last_changed_by_desc) AS LastChangedByUserDescription,
  cast('0' as sdraft_last_changed_at) AS DraftEntityLastChangeDateTime,
  CreatedByUser,
  HasActiveEntity,
  EHSTaskHasWorkflow,
  cast('' as ehfnd_wff_task_manage_action) AS EHSTaskDefinitionManageAction,
  cast('' as ehfnd_wff_task_display_action) AS EHSTaskInstanceDisplayAction,
  DraftUUID
FROM I_EHSRiskControlTaskDefAndInst
;