R_MaintenanceWorkRequestTP

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_MaintenanceWorkRequestTP.
-- 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_MaintenanceWorkRequestTP AS
SELECT
  I_MaintNotificationTechObj.MaintenanceNotification AS MaintenanceNotification,
  I_MaintNotificationTechObj.NotificationType AS NotificationType,
  I_MaintNotificationTechObj.MaintNotifInternalID AS MaintNotifInternalID,
  I_MaintNotificationTechObj.MaintenanceOrder AS MaintenanceOrder,
  I_MaintNotificationTechObj._MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  I_MaintNotificationTechObj.MaintPriority AS MaintPriority,
  I_MaintNotificationTechObj.MaintPriorityType AS MaintPriorityType,
  I_MaintNotificationTechObj._PMNotificationPriority.MaintPriorityColorCode AS MaintPriorityColorCode,
  I_MaintNotificationTechObj._PMNotificationPriority._Text[1: Language = $session.system_language ].MaintPriorityDesc AS MaintPriorityDesc,
  I_MaintNotificationTechObj.TechnicalObject AS TechnicalObject,
  I_MaintNotificationTechObj._TechObjIsEquipOrFuncnlLoc._Text[1: Language = $session.system_language ].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
  I_MaintNotificationTechObj.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  I_MaintNotificationTechObj.Equipment AS Equipment,
  I_MaintNotificationTechObj._FunctionalLocation.FunctionalLocation AS FunctionalLocation,
  I_MaintNotificationTechObj._TechnicalObject._TechnicalObjectText[1: Language = $session.system_language ].TechnicalObjectDescription AS TechnicalObjectDescription,
  I_MaintNotificationTechObj.PersonResponsible AS PersonResponsible,
  I_MaintNotificationTechObj.CreatedByUser AS CreatedByUser,
  I_MaintNotificationTechObj.CreationDateTime AS CreationDateTime,
  I_MaintNotificationTechObj.CreationDate AS CreationDate,
  I_MaintNotificationTechObj.NotificationText AS NotificationText,
  I_MaintNotificationTechObj.NotificationCreationDate AS NotificationCreationDate,
  I_MaintNotificationTechObj.NotificationCreationTime AS NotificationCreationTime,
  I_MaintNotificationTechObj.NotificationTimeZone AS NotificationTimeZone,
  I_MaintNotificationTechObj.MalfunctionEffect AS MalfunctionEffect,
  I_MaintNotificationTechObj.MaintNotificationCatalog AS MaintNotificationCatalog,
  I_MaintNotificationTechObj.MaintNotificationCode AS MaintNotificationCode,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.LocationDescription AS LocationDescription,
  I_MaintNotificationTechObj.ReportedByUser AS ReportedByUser,
  I_MaintNotificationTechObj.ReporterFullName AS ReporterFullName,
  I_MaintNotificationTechObj.MalfunctionStartDate AS MalfunctionStartDate,
  I_MaintNotificationTechObj.MalfunctionStartTime AS MalfunctionStartTime,
  I_MaintNotificationTechObj.MalfunctionEndDate AS MalfunctionEndDate,
  I_MaintNotificationTechObj.MalfunctionEndTime AS MalfunctionEndTime,
  I_MaintNotificationTechObj._TechnicalObject._LocationAccountAssignment.AssetLocation AS AssetLocation,
  I_MaintNotificationTechObj._TechnicalObject._LocationAccountAssignment._Location.LocationName AS LocationName,
  I_MaintNotificationTechObj._MaintNotifLongText.MaintNotificationLongText AS MaintNotificationLongText,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintenanceObjectIsDown AS MaintenanceObjectIsDown,
  cast( case when _StatusObjectStatus[ StatusCode = 'I3350' and StatusIsInactive = '' ].StatusObject is not null then 'F2023' else '' end as pm_source_appl) AS MaintNotifSourceApplication,
  _OverallJobStatus.EAMOverallObjectStatus AS EAMOverallObjectStatus,
  _OverallJobStatus._OverallStatus._Text[Language = $session.system_language].EAMOverallStatusDescription AS EAMOverallStatusDescription,
  _OverallJobStatus.EAMOverallObjectStatusProfile AS EAMOverallObjectStatusProfile,
  I_MaintNotificationTechObj.NotifProcessingPhase AS NotifProcessingPhase,
  cast('' as objky) AS MaintWorkRequestAttchKey,
  I_MaintNotificationTechObj._TechnicalObject.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  I_MaintNotificationTechObj._TechnicalObject._LocationAccountAssignment.PlantSection AS PlantSection,
  I_MaintNotificationTechObj._TechnicalObject._LocationAccountAssignment.BusinessArea AS BusinessArea,
  I_MaintNotificationTechObj._TechnicalObject.CatalogProfile AS CatalogProfile,
  I_MaintNotificationTechObj._TechnicalObject._LocationAccountAssignment.CompanyCode AS CompanyCode,
  cast( I_MaintNotificationTechObj._TechnicalObject._WorkCenter.WorkCenter as gewrk ) AS MainWorkCenter,
  I_MaintNotificationTechObj._TechnicalObject._LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  I_MaintNotificationTechObj._TechnicalObject.TechnicalObjectCategory AS TechnicalObjectCategory,
  I_MaintNotificationTechObj._TechnicalObject.TechnicalObjectType AS TechnicalObjectType
FROM I_MaintNotificationTechObj
LEFT OUTER JOIN I_StatusObjectStatus AS _StatusObjectStatus ON MaintNotifInternalID = _StatusObjectStatus.StatusObject  -- association [1..*]
LEFT OUTER JOIN I_MaintenanceJobOverallStatus AS _OverallJobStatus ON MaintNotifInternalID = _OverallJobStatus.MaintenanceJobInternalID  -- association [0..1]
LEFT OUTER JOIN E_PMNotifMaintenanceData AS _NotifMaintenanceDataExtension ON MaintenanceNotification = _NotifMaintenanceDataExtension.MaintenanceNotification  -- association [0..1]
;