C_EHSTaskDefMgmtOfChange

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_EHSTaskDefMgmtOfChange.
-- 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: CEHSMOC

CREATE VIEW C_EHSTaskDefMgmtOfChange AS
SELECT
  EHSTaskDefinitionUUID,
  EHSTaskHostObjectInstanceUUID,
  EHSTaskHostObjectInstance,
  EHSTaskHostObjectAdapterClass,
  EHSTaskWorkflowEvent,
  _EHSTaskDefinitionTypeText[1: Language = $session.system_language].EHSTaskDefinitionTypeName AS EHSTaskDefinitionTypeName,
  _EHSTaskAdapterClass.EHSSemanticObject AS EHSTaskHostSemanticObject,
  cast('' as text240) AS EHSTskRelatedObjectDescription,
  cast('' as text1024 ) AS EHSTaskRecurrenceDescription,
  _EHSTaskAdapterClass._SemanticObjectText[1: Language = $session.system_language].EHSSemanticObjectName AS EHSSemanticObjectName,
  EHSTaskPriority,
  EHSTaskOwnerUser,
  EHSTaskDefinitionStatus,
  EHSTaskTitle,
  EHSTaskDescription,
  EHSTaskStartDate,
  EHSTaskRecurrenceIsByDueDate,
  EHSTaskRecurrenceType,
  EHSTaskRecurrenceInterval,
  EHSTaskIsRecurringOnMonday,
  EHSTaskIsRecurringOnTuesday,
  EHSTaskIsRecurringOnWednesday,
  EHSTaskIsRecurringOnThursday,
  EHSTaskIsRecurringOnFriday,
  EHSTaskIsRecurringOnSaturday,
  EHSTaskIsRecurringOnSunday,
  EHSTaskRecurrenceDay,
  EHSTaskRecurrenceMonth,
  EHSTaskRecurrenceOffset,
  EHSTaskRecurrenceWeekDay,
  EHSTaskRecurrenceEndType,
  EHSTaskRecurrenceEndDate,
  EHSTaskRecurrenceFirstDueDate,
  EHSTaskDueInUnit,
  EHSTaskDueInValue,
  EHSTaskIsDueOnSameDay,
  EHSTaskDueDate,
  EHSTaskStartBeforeValue,
  EHSTaskStartBeforeUnit,
  EHSTaskDefinitionIsPaused,
  EHSTaskID,
  EHSTaskDefinitionManageAction,
  EHSTaskInstanceDisplayAction,
  EHSTaskIsEnabledForReferencing,
  cast('' as char1) AS EHSTaskIsRefSectionVisible,
  IncidentHasAccessRestriction
FROM I_EHSTaskDefinitionTP AS TaskDefinition
LEFT OUTER JOIN I_EHSTaskAdapterClass AS _EHSTaskAdapterClass ON EHSTaskHostObjectAdapterClass = _EHSTaskAdapterClass.EHSTaskAdapterClass  -- association [0..1]
LEFT OUTER JOIN C_EHSTaskUserValueHelp AS _EHSTaskOwnerUser ON EHSTaskOwnerUser = _EHSTaskOwnerUser.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_EHSTaskDefMgmtOfChangeInfo AS _EHSTaskDefinitionMoC ON EHSTaskDefinitionUUID = _EHSTaskDefinitionMoC.EHSTaskDefinitionUUID  -- association [1..1]
LEFT OUTER JOIN I_EHSTaskDefinitionTypeText AS _EHSTaskDefinitionTypeText ON EHSTaskWorkflowEvent = _EHSTaskDefinitionTypeText.EHSTaskDefinitionType  -- association [0..*]
LEFT OUTER JOIN C_EHSTaskDefRefMgmtOfChange AS _EHSTaskDefReference ON EHSTaskDefinitionUUID = _EHSTaskDefReference.EHSTaskDefinitionUUID  -- association [0..*]
;