C_EHSMaintenanceNotification

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_EHSMaintenanceNotification.
-- 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: CEHSMAINTNOTIF

CREATE VIEW C_EHSMaintenanceNotification 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,
  _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,
  IncidentHasAccessRestriction
FROM I_EHSTaskDefinitionTP AS TaskDefinition
LEFT OUTER JOIN I_EHSTaskAdapterClass AS _EHSTaskAdapterClass ON EHSTaskHostObjectAdapterClass = _EHSTaskAdapterClass.EHSTaskAdapterClass  -- association [1..1]
LEFT OUTER JOIN C_EHSMaintenanceInfo AS _EHSTaskDefMaintenance ON EHSTaskDefinitionUUID = _EHSTaskDefMaintenance.EHSTaskDefinitionUUID  -- association [1..1]
LEFT OUTER JOIN C_EHSTaskDefRefMaintNotif AS _EHSTaskDefReference ON EHSTaskDefinitionUUID = _EHSTaskDefReference.EHSTaskDefinitionUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSTaskDefinitionTypeText AS _EHSTaskDefinitionTypeText ON EHSTaskWorkflowEvent = _EHSTaskDefinitionTypeText.EHSTaskDefinitionType  -- association [0..*]
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]
;