C_MaintNotificationTP

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_MaintNotificationTP.
-- 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: CMAINTNOTIFTP

CREATE VIEW C_MaintNotificationTP AS
SELECT
  _MaintNotificationTP.MaintenanceNotification AS MaintenanceNotification,
  _MaintNotificationTP.MaintNotificationForEdit AS MaintNotificationForEdit,
  _MaintNotificationTP.TechnicalObject AS TechnicalObject,
  _MaintNotificationTP.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  _MaintNotificationTP.HierarchyNodeLevel AS HierarchyNodeLevel,
  _MaintNotificationTP.Equipment AS Equipment,
  _MaintNotificationTP.FunctionalLocation AS FunctionalLocation,
  _MaintNotificationTP.TechnicalObjectForEdit AS TechnicalObjectForEdit,
  _MaintNotificationTP.MaintPriority AS MaintPriority,
  _MaintNotificationTP._PMNotificationPriority._Text[1: Language = $session.system_language ].MaintPriorityDesc AS MaintPriorityDesc,
  _MaintNotificationTP.MaintPriorityType AS MaintPriorityType,
  _MaintNotificationTP._PMNotificationPriority.MaintPriorityColorCode AS MaintPriorityColorCode,
  _MaintNotificationTP.NotificationType AS NotificationType,
  _MaintNotificationTP.NotifProcessingPhase AS NotifProcessingPhase,
  _MaintNotificationTP.CreatedByUser AS CreatedByUser,
  _MaintNotificationTP.LastChangedByUser AS LastChangedByUser,
  _MaintNotificationTP.CreationDate AS CreationDate,
  _MaintNotificationTP.LastChangeTime AS LastChangeTime,
  _MaintNotificationTP.LastChangeDate AS LastChangeDate,
  _MaintNotificationTP.CreationTime AS CreationTime,
  _MaintNotificationTP.ReportedByUser AS ReportedByUser,
  _MaintNotificationTP.NotificationText AS NotificationText,
  _MaintNotificationTP.MaintenanceOrder AS MaintenanceOrder,
  _MaintNotificationTP.RequiredStartDate AS RequiredStartDate,
  _MaintNotificationTP.RequiredStartTime AS RequiredStartTime,
  _MaintNotificationTP.RequiredEndDate AS RequiredEndDate,
  _MaintNotificationTP.RequiredEndTime AS RequiredEndTime,
  _MaintNotificationTP.NotificationCreationDate AS NotificationCreationDate,
  _MaintNotificationTP.NotificationCreationTime AS NotificationCreationTime,
  NotificationCreationDateTime,
  _MaintNotificationTP.NotificationReferenceDate AS NotificationReferenceDate,
  _MaintNotificationTP.NotificationReferenceTime AS NotificationReferenceTime,
  _MaintNotificationTP.NotificationCompletionDate AS NotificationCompletionDate,
  _MaintNotificationTP.CompletionTime AS CompletionTime,
  _MaintNotificationTP.MaintNotifInternalID AS MaintNotifInternalID,
  _MaintNotificationTP.NotificationTimeZone AS NotificationTimeZone,
  _MaintNotificationTP.WorkCenterInternalID AS WorkCenterInternalID,
  _MaintNotificationTP.MaintenanceWorkCenterPlant AS MaintenanceWorkCenterPlant,
  _MaintNotificationTP.WorkCenterTypeCode AS WorkCenterTypeCode,
  _MaintNotificationTP.MaintNotificationCatalog AS MaintNotificationCatalog,
  _MaintNotificationTP.MaintNotificationCode AS MaintNotificationCode,
  _MaintNotificationTP.MaintNotificationCodeGroup AS MaintNotificationCodeGroup,
  _MaintNotificationTP.IsDeleted AS IsDeleted,
  _MaintNotificationTP.IsCompleted AS IsCompleted,
  _MaintNotificationTP.MalfunctionEffect AS MalfunctionEffect,
  _MaintNotificationTP.LocationDescription AS LocationDescription,
  MaintNotifSourceApplication,
  _MaintNotificationTP.MalfunctionStartDate AS MalfunctionStartDate,
  _MaintNotificationTP.MalfunctionStartTime AS MalfunctionStartTime,
  cast( '000000000000' as timestamp ) AS MalfunctionStartDateTime,
  _MaintNotificationTP.MalfunctionEndDate AS MalfunctionEndDate,
  _MaintNotificationTP.MalfunctionEndTime AS MalfunctionEndTime,
  cast( '000000000000' as timestamp ) AS MalfunctionEndDateTime,
  _MaintNotificationTP.MaintenanceObjectIsDown AS MaintenanceObjectIsDown,
  _MaintNotificationTP.MaintObjectDowntimeDuration AS MaintObjectDowntimeDuration,
  _MaintNotificationTP.MaintObjDowntimeDurationUnit AS MaintObjDowntimeDurationUnit,
  _MaintNotificationTP.CatalogProfile AS CatalogProfile,
  _MaintNotificationTP._PMNotificationType.MaintNotifCodgCatalogTypeCode AS MaintNotifCodgCatalogTypeCode,
  _MaintNotificationTP._PMNotificationType.MaintNotifActivityCodeCatalog AS MaintNotifActivityCodeCatalog,
  _MaintNotificationTP._PMNotificationType.MaintNotifCauseCodeCatalog AS MaintNotifCauseCodeCatalog,
  _MaintNotificationTP._PMNotificationType.MaintNotifDamageCodeCatalog AS MaintNotifDamageCodeCatalog,
  _MaintNotificationTP._PMNotificationType.MaintNotifObjPrtCodeCatalog AS MaintNotifObjPrtCodeCatalog,
  _MaintNotificationTP.MaintenanceWorkCenter AS MaintenanceWorkCenter,
  _MaintNotificationTP.ReporterFullName AS ReporterFullName,
  _MaintNotificationTP.LastChangeDateTime AS LastChangeDateTime,
  _MaintNotificationTP._CreatedByUser AS _CreatedByUser,
  _MaintNotificationTP._IsCompleted AS _IsCompleted,
  _MaintNotificationTP._IsDeleted AS _IsDeleted,
  _MaintNotificationTP._LastChangedByUser AS _LastChangedByUser,
  _MaintNotificationTP._MaintenancePartner AS _MaintenancePartner,
  _MaintNotificationTP._MaintenanceWorkCenterPlant AS _MaintenanceWorkCenterPlant,
  _MaintNotificationTP._MaintNotificationCatalog AS _MaintNotificationCatalog,
  _MaintNotificationTP._MaintNotificationCode AS _MaintNotificationCode,
  _MaintNotificationTP._MaintNotificationCodeGroup AS _MaintNotificationCodeGroup,
  _MaintNotificationTP._MainWorkCenter AS _MainWorkCenter,
  _MaintNotificationTP._PMNotificationPhase AS _PMNotificationPhase,
  _MaintNotificationTP._PMNotificationPriority AS _PMNotificationPriority,
  _MaintNotificationTP._PMNotificationPriorityType AS _PMNotificationPriorityType,
  _MaintNotificationTP._PMNotificationType AS _PMNotificationType,
  _MaintNotificationTP._PMNotifMaintenanceData AS _PMNotifMaintenanceData,
  _MaintNotificationTP._ReportedByUser AS _ReportedByUser,
  _MaintNotificationTP._StatusObject AS _StatusObject,
  _MaintNotificationTP._TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc,
  _MaintNotificationTP._MaintenanceOrder AS _MaintenanceOrder,
  _MaintNotificationTP._MalfunctionEffect AS _MalfunctionEffect,
  cast( _MaintNotificationTP.PersonResponsible as eams_person_responsible preserving type ) AS PersonResponsible
FROM I_MaintNotificationTP AS _MaintNotificationTP
LEFT OUTER JOIN I_MaintenanceJobOverallStatus AS _OverallJobStatus ON MaintNotifInternalID = _OverallJobStatus.MaintenanceJobInternalID  -- association [0..1]
LEFT OUTER JOIN I_PMContactCardEmployee AS _PersonResponsible ON PersonResponsible = _PersonResponsible.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN C_MaintNotifLongTextTP AS _MaintNotifLongTextTP ON _MaintNotifLongTextTP.MaintenanceNotification = MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN C_TechnicalObjectForEditVH AS _TechnicalObject ON TechnicalObjectForEdit = _TechnicalObject.TechnicalObjectLabel AND TechnicalObject = _TechnicalObject.TechnicalObject AND TechObjIsEquipOrFuncnlLoc = _TechnicalObject.TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN C_MalfunctionDetailCodesVH AS _MaintNotificationCodeVH ON MaintNotificationCatalog = _MaintNotificationCodeVH.InspectionCatalog AND MaintNotificationCodeGroup = _MaintNotificationCodeVH.InspectionCodeGroup AND MaintNotificationCode = _MaintNotificationCodeVH.InspectionCode  -- association [0..1]
LEFT OUTER JOIN C_MaintNotificationDateMonitor AS _MaintNotificationDateMonitor ON MaintenanceNotification = _MaintNotificationDateMonitor.MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN C_MaintNotificationItemTP AS _MaintNotificationItemTP ON MaintenanceNotification = _MaintNotificationItemTP.MaintenanceNotification  -- association [0..*]
LEFT OUTER JOIN C_MaintNotifActivityTP AS _MaintNotifActivityTP ON MaintenanceNotification = _MaintNotifActivityTP.MaintenanceNotification  -- association [0..*]
LEFT OUTER JOIN C_MaintOrderTP AS _MaintOrderTP ON MaintenanceOrder = _MaintOrderTP.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_Inspectioncodegrouptext AS _MaintNotifCodeGroupText ON MaintNotificationCatalog = _MaintNotifCodeGroupText.InspectionCatalog AND MaintNotificationCodeGroup = _MaintNotifCodeGroupText.InspectionCodeGroup  -- association [0..*]
LEFT OUTER JOIN I_InspectionCodeText AS _MaintNotifCodeText ON MaintNotificationCode = _MaintNotifCodeText.InspectionCode AND MaintNotificationCatalog = _MaintNotifCodeText.InspectionCatalog AND MaintNotificationCodeGroup = _MaintNotifCodeText.InspectionCodeGroup  -- association [0..*]
LEFT OUTER JOIN C_TechObjQuickVw AS _TechnicalObjectQuickVw ON TechObjIsEquipOrFuncnlLoc = _TechnicalObjectQuickVw.TechObjIsEquipOrFuncnlLoc AND TechnicalObject = _TechnicalObjectQuickVw.TechnicalObject  -- association [1]
LEFT OUTER JOIN I_PMTimeUnitVH AS _BreakdownUnitOfMeasure ON MaintObjDowntimeDurationUnit = _BreakdownUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_GenericPriorityText AS _PriorityText ON _PriorityText.GenericPriorityType = MaintPriorityType AND _PriorityText.PriorityCode = MaintPriority  -- association [0..*]
LEFT OUTER JOIN E_PMNotifMaintenanceData AS _NotifMaintenanceDataExtension ON _NotifMaintenanceDataExtension.MaintenanceNotification = MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement ON PersonResponsible = _PersonWorkAgreement.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _BusUser ON _BusUser.UserID = $session.user  -- association [0..1]
;