C_EHSLearningTaskDefinitionTP

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_EHSLearningTaskDefinitionTP.
-- 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_EHSLearningTaskDefinitionTP AS
SELECT
  EHSTaskDefinitionUUID,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser,
  EHSTaskHostObjectInstanceUUID,
  EHSTaskHostObjectInstance,
  EHSTaskHostObjectAdapterClass,
  cast('' as text240) AS EHSTskRelatedObjectDescription,
  cast('' as text1024 ) AS EHSTaskRecurrenceDescription,
  EHSTaskPriority,
  EHSTaskAssignedUser,
  _EHSTaskAssignedUser.PersonFullName AS EHSTaskAssignedUserName,
  EHSTaskOwnerUser,
  _EHSTaskOwnerUser.PersonFullName AS EHSTaskOwnerUserName,
  EHSTaskApprovingUser,
  _EHSTaskApprovingUser.PersonFullName AS EHSTaskApprovingUserName,
  _EHSTaskAdapterClass.EHSSemanticObject AS EHSTaskHostSemanticObject,
  EHSLocationUUID,
  cast('' as text132) AS EHSLocationIDAndName,
  cast('' as char1024 ) AS EHSLocationURL,
  EHSTaskWorkflowEvent,
  EHSTaskDefinitionStatus,
  EHSTaskTitle,
  EHSTaskDescription,
  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,
  EHSTaskMigrationSource,
  EHSTaskAssignedType,
  EHSTaskAssignedLocRole,
  EHSTaskApproverType,
  EHSTaskApproverLocRole,
  EHSTaskIsEnabledForReferencing,
  IncidentHasAccessRestriction,
  _EHSTaskDefinitionTypeText[1: Language = $session.system_language].EHSTaskDefinitionTypeName AS EHSTaskDefinitionTypeName
FROM I_EHSTaskDefinitionTP AS TaskDefinition
LEFT OUTER JOIN I_EHSTaskAdapterClass AS _EHSTaskAdapterClass ON EHSTaskHostObjectAdapterClass = _EHSTaskAdapterClass.EHSTaskAdapterClass  -- 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_EHSTaskDefinitionTypeText AS _EHSTaskDefinitionTypeText ON EHSTaskWorkflowEvent = _EHSTaskDefinitionTypeText.EHSTaskDefinitionType  -- association [0..*]
LEFT OUTER JOIN I_EHSTaskPriorityText AS _EHSTaskPriorityText ON EHSTaskPriority = _EHSTaskPriorityText.EHSTaskPriority  -- association [0..*]
LEFT OUTER JOIN C_EHSTaskLearningTP AS _EHSTaskLearning ON EHSTaskDefinitionUUID = _EHSTaskLearning.EHSTaskDefinitionUUID  -- association [0..1]
;