C_EHSSimpleTaskDefinition

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_EHSSimpleTaskDefinition.
-- 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: CEHSSIMPLTASKDEF

CREATE VIEW C_EHSSimpleTaskDefinition AS
SELECT
  EHSTaskDefinitionUUID,
  EHSTaskHostObjectInstanceUUID,
  EHSTaskHostObjectInstance,
  EHSTaskHostObjectAdapterClass,
  EHSTaskWorkflowEvent,
  _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,
  EHSTaskAssignedUser,
  _EHSTaskAssignedUserBasic.PersonFullName AS EHSTaskAssignedUserName,
  EHSTaskOwnerUser,
  _EHSTaskOwnerUser.PersonFullName AS EHSTaskOwnerUserName,
  EHSTaskApprovingUser,
  _EHSTaskApprovingUserBasic.PersonFullName AS EHSTaskApprovingUserName,
  EHSTaskDefinitionStatus,
  EHSTaskTitle,
  EHSTaskDescription,
  EHSLocationUUID,
  cast('' as text132) AS EHSLocationIDAndName,
  EHSTaskStartDate,
  EHSTaskDueInValue,
  EHSTaskDueInUnit,
  EHSTaskDueDate,
  EHSTaskIsDueOnSameDay,
  EHSTaskStartBeforeValue,
  EHSTaskStartBeforeUnit,
  EHSTaskRecurrenceIsByDueDate,
  EHSTaskRecurrenceType,
  EHSTaskRecurrenceInterval,
  EHSTaskIsRecurringOnMonday,
  EHSTaskIsRecurringOnTuesday,
  EHSTaskIsRecurringOnWednesday,
  EHSTaskIsRecurringOnThursday,
  EHSTaskIsRecurringOnFriday,
  EHSTaskIsRecurringOnSaturday,
  EHSTaskIsRecurringOnSunday,
  EHSTaskRecurrenceDay,
  EHSTaskRecurrenceMonth,
  EHSTaskRecurrenceOffset,
  EHSTaskRecurrenceWeekDay,
  EHSTaskRecurrenceEndType,
  EHSTaskRecurrenceEndDate,
  EHSTaskRecurrenceFirstDueDate,
  EHSTaskDefinitionIsPaused,
  EHSTaskID,
  EHSTaskDefinitionManageAction,
  EHSTaskInstanceDisplayAction,
  EHSTaskIsEnabledForReferencing,
  cast('' as char1) AS EHSTaskIsRefSectionVisible,
  EHSTaskAssignedType,
  EHSTaskAssignedLocRole,
  _EHSTaskAssignedLocRole._Text[1: Language = $session.system_language].EHSLocationPersonRespRoleName AS EHSTaskAssignedLocRoleName,
  EHSTaskApproverType,
  EHSTaskApproverLocRole,
  _EHSTaskApproverLocRole._Text[1: Language = $session.system_language].EHSLocationPersonRespRoleName AS EHSTaskApproverLocRoleName,
  _EHSTskDefSourceDocument.EHSAttachmentServiceFileID AS EHSAttachmentServiceFileID,
  _EHSTskDefSourceDocument.EHSTskDefSrceDocPageNumber AS EHSTskDefSrceDocPageNumber,
  _EHSTskDefSourceDocument.EHSTskDefSrceDocumentName AS EHSTskDefSrceDocumentName,
  _EHSTskDefSourceDocument.EHSTskDefSourceDocumentURL AS EHSTskDefSourceDocumentURL,
  _EHSTskDefSourceDocument.UICT_EHSTskDefSrcDocIsHidden AS UICT_EHSTskDefSrcDocIsHidden,
  _EHSTskDefSourceDocument.EHSAttachmentServiceObjectType AS EHSAttachmentServiceObjectType,
  _EHSTskDefSourceDocument.EHSAttachmentServiceObjectKey AS EHSAttachmentServiceObjectKey,
  _EHSTskDefSourceDocument.EHSTskDefSrceDocTxtFragmentId AS EHSTskDefSrceDocTxtFragmentId,
  IncidentHasAccessRestriction
FROM I_EHSTaskDefinitionTP AS TaskDefinition
LEFT OUTER JOIN I_EHSTaskAdapterClass AS _EHSTaskAdapterClass ON EHSTaskHostObjectAdapterClass = _EHSTaskAdapterClass.EHSTaskAdapterClass  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskDefinitionTypeText AS _EHSTaskDefinitionTypeText ON EHSTaskWorkflowEvent = _EHSTaskDefinitionTypeText.EHSTaskDefinitionType  -- association [0..*]
LEFT OUTER JOIN C_EHSTaskDefRefSimpleTask AS _EHSTaskDefReference ON EHSTaskDefinitionUUID = _EHSTaskDefReference.EHSTaskDefinitionUUID  -- association [0..*]
LEFT OUTER JOIN C_EHSTaskAssigneeNotifSimpleTP AS _EHSTaskDefAssigneeNotifEvt ON EHSTaskDefinitionUUID = _EHSTaskDefAssigneeNotifEvt.EHSTaskDefinitionUUID  -- association [0..*]
LEFT OUTER JOIN C_EHSTaskApproverNotifSimpleTP AS _EHSTaskDefApproverNotifEvt ON EHSTaskDefinitionUUID = _EHSTaskDefApproverNotifEvt.EHSTaskDefinitionUUID  -- association [0..*]
LEFT OUTER JOIN C_EHSTaskOwnerNotifSimpleTP AS _EHSTaskDefOwnerNotifEvt ON EHSTaskDefinitionUUID = _EHSTaskDefOwnerNotifEvt.EHSTaskDefinitionUUID  -- association [0..*]
LEFT OUTER JOIN C_EHSTskDefSourceDocumentTP AS _EHSTskDefSourceDocument ON EHSTaskDefinitionUUID = _EHSTskDefSourceDocument.EHSTaskDefinitionUUID  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _EHSTaskAssignedUserBasic ON EHSTaskAssignedUser = _EHSTaskAssignedUserBasic.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _EHSTaskOwnerUser ON EHSTaskOwnerUser = _EHSTaskOwnerUser.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _EHSTaskApprovingUserBasic ON EHSTaskApprovingUser = _EHSTaskApprovingUserBasic.BusinessPartner  -- association [0..1]
;