R_EHSTaskDefinitionDraft

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 R_EHSTaskDefinitionDraft.
-- 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 R_EHSTaskDefinitionDraft AS
SELECT
  EHSTaskDefinitionRootDraft.ehstaskdefinitionuuid AS EHSTaskDefinitionUUID,
  EHSTaskDefinitionRootDraft.creationutcdatetime AS CreationUTCDateTime,
  EHSTaskDefinitionRootDraft.createdbyuser AS CreatedByUser,
  EHSTaskDefinitionRootDraft.lastchangeutcdatetime AS LastChangeUTCDateTime,
  EHSTaskDefinitionRootDraft.lastchangedbyuser AS LastChangedByUser,
  EHSTaskDefinitionRootDraft.ehstaskhostobjectinstanceuuid AS EHSTaskHostObjectInstanceUUID,
  EHSTaskDefinitionRootDraft.ehstaskhostobjectinstance AS EHSTaskHostObjectInstance,
  EHSTaskDefinitionRootDraft.ehstaskhostobjectadapterclass AS EHSTaskHostObjectAdapterClass,
  EHSTaskDefinitionRootDraft.ehstaskworkflowevent AS EHSTaskWorkflowEvent,
  EHSTaskDefinitionRootDraft.ehstaskpriority AS EHSTaskPriority,
  EHSTaskDefinitionRootDraft.ehstaskassigneduser AS EHSTaskAssignedUser,
  EHSTaskDefinitionRootDraft.ehstaskowneruser AS EHSTaskOwnerUser,
  EHSTaskDefinitionRootDraft.ehstaskapprovinguser AS EHSTaskApprovingUser,
  EHSTaskDefinitionRootDraft.ehstaskdefinitionstatus AS EHSTaskDefinitionStatus,
  EHSTaskDefinitionRootDraft.ehstasktitle AS EHSTaskTitle,
  EHSTaskDefinitionRootDraft.ehstaskdescription AS EHSTaskDescription,
  EHSTaskDefinitionRootDraft.ehstaskstartdate AS EHSTaskStartDate,
  EHSTaskDefinitionRootDraft.ehstaskdueinvalue AS EHSTaskDueInValue,
  EHSTaskDefinitionRootDraft.ehstaskdueinunit AS EHSTaskDueInUnit,
  EHSTaskDefinitionRootDraft.ehstaskduedate AS EHSTaskDueDate,
  EHSTaskDefinitionRootDraft.ehstaskisdueonsameday AS EHSTaskIsDueOnSameDay,
  EHSTaskDefinitionRootDraft.ehstaskstartbeforevalue AS EHSTaskStartBeforeValue,
  EHSTaskDefinitionRootDraft.ehstaskstartbeforeunit AS EHSTaskStartBeforeUnit,
  EHSTaskDefinitionRootDraft.ehstaskrecurrenceisbyduedate AS EHSTaskRecurrenceIsByDueDate,
  EHSTaskDefinitionRootDraft.ehstaskrecurrencetype AS EHSTaskRecurrenceType,
  EHSTaskDefinitionRootDraft.ehstaskrecurrenceinterval AS EHSTaskRecurrenceInterval,
  EHSTaskDefinitionRootDraft.ehstaskisrecurringonmonday AS EHSTaskIsRecurringOnMonday,
  EHSTaskDefinitionRootDraft.ehstaskisrecurringontuesday AS EHSTaskIsRecurringOnTuesday,
  EHSTaskDefinitionRootDraft.ehstaskisrecurringonwednesday AS EHSTaskIsRecurringOnWednesday,
  EHSTaskDefinitionRootDraft.ehstaskisrecurringonthursday AS EHSTaskIsRecurringOnThursday,
  EHSTaskDefinitionRootDraft.ehstaskisrecurringonfriday AS EHSTaskIsRecurringOnFriday,
  EHSTaskDefinitionRootDraft.ehstaskisrecurringonsaturday AS EHSTaskIsRecurringOnSaturday,
  EHSTaskDefinitionRootDraft.ehstaskisrecurringonsunday AS EHSTaskIsRecurringOnSunday,
  EHSTaskDefinitionRootDraft.ehstaskrecurrenceday AS EHSTaskRecurrenceDay,
  EHSTaskDefinitionRootDraft.ehstaskrecurrencemonth AS EHSTaskRecurrenceMonth,
  EHSTaskDefinitionRootDraft.ehstaskrecurrenceoffset AS EHSTaskRecurrenceOffset,
  EHSTaskDefinitionRootDraft.ehstaskrecurrenceweekday AS EHSTaskRecurrenceWeekDay,
  EHSTaskDefinitionRootDraft.ehstaskrecurrenceendtype AS EHSTaskRecurrenceEndType,
  EHSTaskDefinitionRootDraft.ehstaskrecurrenceenddate AS EHSTaskRecurrenceEndDate,
  EHSTaskDefinitionRootDraft.ehstaskrecurrencefirstduedate AS EHSTaskRecurrenceFirstDueDate,
  EHSTaskDefinitionRootDraft.ehstaskdefinitionispaused AS EHSTaskDefinitionIsPaused,
  EHSTaskDefinitionRootDraft.ehslocationuuid AS EHSLocationUUID,
  EHSTaskDefinitionRootDraft.ehstaskid AS EHSTaskID,
  EHSTaskDefinitionRootDraft.ehstaskmigrationsource AS EHSTaskMigrationSource,
  EHSTaskDefinitionRootDraft.ehstaskassignedtype AS EHSTaskAssignedType,
  EHSTaskDefinitionRootDraft.ehstaskassignedlocrole AS EHSTaskAssignedLocRole,
  EHSTaskDefinitionRootDraft.ehstaskapprovertype AS EHSTaskApproverType,
  EHSTaskDefinitionRootDraft.ehstaskapproverlocrole AS EHSTaskApproverLocRole,
  EHSTaskDefinitionRootDraft.activeuuid AS EHSTaskDefinitionActiveUUID,
  EHSTaskDefinitionRootDraft.hasactiveentity AS HasActiveEntity
FROM ehfndw_tdef_root AS EHSTaskDefinitionRootDraft
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _EHSTaskOwnerUser ON EHSTaskOwnerUser = _EHSTaskOwnerUser.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _EHSTaskAssignedUser ON EHSTaskAssignedUser = _EHSTaskAssignedUser.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _EHSTaskApprovingUser ON EHSTaskApprovingUser = _EHSTaskApprovingUser.BusinessPartner  -- 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_EHSTaskAdapterClass AS _EHSTaskAdapterClass ON EHSTaskHostObjectAdapterClass = _EHSTaskAdapterClass.EHSTaskAdapterClass  -- association [1..1]
LEFT OUTER JOIN I_EHSTaskDefinitionType AS _EHSTaskDefinitionType ON EHSTaskHostObjectAdapterClass = _EHSTaskDefinitionType.EHSTaskAdapterClass AND EHSTaskWorkflowEvent = _EHSTaskDefinitionType.EHSTaskDefinitionType  -- association [1..1]
;