C_EHSTaskDefinitionWithDraft

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_EHSTaskDefinitionWithDraft.
-- 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: CEHSTASKWTHDRFT

CREATE VIEW C_EHSTaskDefinitionWithDraft AS
SELECT
  EHSTaskDefinitionUUID,
  EHSTaskHostObjectInstanceUUID,
  EHSTaskHostObjectInstance,
  EHSTaskHostObjectAdapterClass,
  _EHSTaskAdapterClass.EHSSemanticObject AS EHSTaskHostSemanticObject,
  EHSTaskTitle,
  cast('' as char1024) AS EHSTaskRecurrenceDescription,
  IsDraftEntity,
  HasActiveEntity,
  EHSTaskDefinitionActiveUUID,
  EHSTaskID,
  EHSTaskDefinitionType,
  EHSTaskPriority,
  _EHSTaskPriority.EHSTaskPriorityName AS EHSTaskPriorityName,
  EHSTaskOwnerBP,
  _EHSTaskOwnerUser.PersonFullName AS EHSTaskOwnerUserName,
  EHSTaskApprovingBP,
  _EHSTaskApprovingUser.PersonFullName AS EHSTaskApprovingUserName,
  EHSTaskAssignedBP,
  _EHSTaskAssigneeUser.PersonFullName AS EHSTaskAssignedUserName,
  EHSTaskApproverLocRole,
  _EHSTaskApproverRoleT.EHSLocationPersonRespRoleName AS EHSTaskApproverLocRoleName,
  EHSTaskAssignedLocRole,
  _EHSTaskAssigneeRoleT.EHSLocationPersonRespRoleName AS EHSTaskAssignedLocRoleName,
  EHSTaskDefinitionStatus,
  _EHSTaskDefinitionType.EHSTaskDefinitionManageAction AS EHSTaskDefinitionManageAction,
  _EHSTaskDefinitionType.EHSTaskInstanceDisplayAction AS EHSTaskInstanceDisplayAction,
  EHSTaskStartDate,
  EHSTaskDueInValue,
  EHSTaskDueInUnit,
  EHSTaskDueDate,
  EHSTaskRecurrenceType,
  EHSTaskIsDueOnSameDay,
  EHSTaskStartBeforeValue,
  EHSTaskStartBeforeUnit,
  EHSTaskRecurrenceIsByDueDate,
  EHSTaskRecurrenceOffset,
  EHSTaskIsRecurringOnMonday,
  EHSTaskIsRecurringOnTuesday,
  EHSTaskIsRecurringOnWednesday,
  EHSTaskIsRecurringOnThursday,
  EHSTaskIsRecurringOnFriday,
  EHSTaskIsRecurringOnSaturday,
  EHSTaskIsRecurringOnSunday,
  EHSTaskRecurrenceWeekDay,
  EHSTaskRecurrenceInterval,
  EHSTaskRecurrenceEndDate,
  EHSTaskRecurrenceFirstDueDate,
  EHSTaskRecurrenceDay,
  _DraftAdministrativeData.LastChangeDateTime AS DraftEntityLastChangeDateTime,
  _DraftAdministrativeData.DraftIsLastChangedByMe AS DraftIsLastChangedByMe,
  _DraftAdministrativeData.LastChangedByUserDescription AS LastChangedByUserDescription,
  _DraftAdministrativeData.DraftIsProcessedByMe AS DraftIsProcessedByMe,
  _DraftAdministrativeData.InProcessByUser AS InProcessByUser,
  _DraftAdministrativeData.InProcessByUserDescription AS InProcessByUserDescription,
  _IncidentTaskRefAccRestricted.IncidentHasAccessRestriction AS IncidentHasAccessRestriction
FROM I_EHSTaskDefWithDraftUnion
LEFT OUTER JOIN I_EHSTaskDefinitionTypeText AS _EHSTaskDefinitionTypeText ON EHSTaskDefinitionType = _EHSTaskDefinitionTypeText.EHSTaskDefinitionType  -- association [0..*]
LEFT OUTER JOIN I_EHSTaskRecurrenceTypeText AS _EHSTaskRecurrenceTypeText ON EHSTaskRecurrenceType = _EHSTaskRecurrenceTypeText.EHSTaskRecurrenceType  -- association [0..*]
LEFT OUTER JOIN I_BusinessUserBasic AS _EHSTaskOwnerUser ON EHSTaskOwnerBP = _EHSTaskOwnerUser.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _EHSTaskAssigneeUser ON EHSTaskAssignedBP = _EHSTaskAssigneeUser.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _EHSTaskApprovingUser ON EHSTaskApprovingBP = _EHSTaskApprovingUser.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_EHSTaskDefinitionType AS _EHSTaskDefinitionType ON EHSTaskHostObjectAdapterClass = _EHSTaskDefinitionType.EHSTaskAdapterClass AND EHSTaskDefinitionType = _EHSTaskDefinitionType.EHSTaskDefinitionType  -- association [1..1]
LEFT OUTER JOIN I_EHSTaskDefinitionStatusText AS _EHSTaskDefinitionStatusText ON EHSTaskDefinitionStatus = _EHSTaskDefinitionStatusText.EHSTaskDefinitionStatus AND _EHSTaskDefinitionStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DraftAdministrativeData AS _DraftAdministrativeData ON EHSTaskDefinitionUUID = _DraftAdministrativeData.DraftUUID AND _DraftAdministrativeData.DraftEntityType = 'I_EHSTASKDEFINITIONTP'  -- association [0..1]
LEFT OUTER JOIN I_EHSLocationPersonRespRoleT AS _EHSTaskAssigneeRoleT ON EHSTaskAssignedLocRole = _EHSTaskAssigneeRoleT.EHSLocationPersonRespRole AND _EHSTaskAssigneeRoleT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_EHSLocationPersonRespRoleT AS _EHSTaskApproverRoleT ON EHSTaskApproverLocRole = _EHSTaskApproverRoleT.EHSLocationPersonRespRole AND _EHSTaskApproverRoleT.Language = $session.system_language  -- association [0..1]
;