R_MaintenanceNotificationTP

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_MaintenanceNotificationTP.
-- 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_MaintenanceNotificationTP AS
SELECT
  cast( _GenericPriorityData.GenericPriorityColorCode as abap.int1) AS GenericPriorityColorCode,
  cast (dats_tims_to_tstmp( CreationDate, CreationTime, abap_system_timezone( $session.client,'NULL' ) , $session.client, 'NULL') as tzntstmps preserving type ) AS CreationDateTime,
  cast (dats_tims_to_tstmp( MalfunctionStartDate, MalfunctionStartTime, I_MaintNotificationTechObj.NotificationTimeZone, $session.client, 'NULL') as tzntstmps preserving type ) AS MalfunctionStartDateTime,
  cast (dats_tims_to_tstmp( MalfunctionEndDate, MalfunctionEndTime, I_MaintNotificationTechObj.NotificationTimeZone, $session.client, 'NULL') as tzntstmps preserving type ) AS MalfunctionEndDateTime,
  cast (dats_tims_to_tstmp( NotificationCreationDate, NotificationCreationTime, I_MaintNotificationTechObj.NotificationTimeZone , $session.client, 'NULL') as tzntstmps preserving type ) AS NotificationCreationDateTime,
  cast (dats_tims_to_tstmp( RequiredStartDate, RequiredStartTime, I_MaintNotificationTechObj.NotificationTimeZone , $session.client, 'NULL') as tzntstmps preserving type ) AS MaintNotifRqdStartDateTime,
  cast (dats_tims_to_tstmp( RequiredEndDate, RequiredEndTime,I_MaintNotificationTechObj.NotificationTimeZone, $session.client, 'NULL') as tzntstmps preserving type ) AS MaintNotifRqdEndDateTime,
  cast( 'LTXT' as tdid preserving type ) AS TextObjectType,
  cast('' as eams_ltext ) AS MaintNotifLongTextForEdit,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  I_MaintNotificationTechObj._LocationAccountAssignment.PlantSection AS PlantSection,
  I_MaintNotificationTechObj._LocationAccountAssignment.ABCIndicator AS ABCIndicator,
  I_MaintNotificationTechObj._LocationAccountAssignment.MaintObjectFreeDefinedAttrib AS MaintObjectFreeDefinedAttrib,
  cast(I_MaintNotificationTechObj.FunctionalLocation as eams_ui_oid_name preserving type ) AS FunctionalLocation,
  I_MaintNotificationTechObj._LocationAccountAssignment.AssetLocation AS AssetLocation,
  I_MaintNotificationTechObj._LocationAccountAssignment._Location.LocationName AS LocationName,
  I_MaintNotificationTechObj._LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  I_MaintNotificationTechObj._LocationAccountAssignment._WorkCenter.Plant AS MaintenanceWorkCenterPlant,
  I_MaintNotificationTechObj._MainWorkCenter.WorkCenter AS MainWorkCenter,
  I_MaintNotificationTechObj._MainWorkCenter.Plant AS MainWorkCenterPlant,
  cast ( 0 as eam_open_notifications ) AS NumberOfOrders,
  cast('' as objky) AS MaintWorkRequestAttchKey,
  cast(I_MaintNotificationTechObj.MaintenanceNotification as char12 preserving type ) AS MaintNotifWithLeadingZeros,
  cast('' as pm_source_appl) AS MaintNotifSourceApplication,
  cast(I_MaintNotificationTechObj._NotificationType.NotifPartnerRoleResponsible as parvw_unv) AS MaintNotifRespPartnerFunction,
  cast('' as eams_person_responsible_name) AS PersonResponsibleName,
  I_MaintNotificationTechObj._MaintOrdMstrData.OrderType AS MaintenanceOrderType,
  cast('' as abap_boolean preserving type) AS MaintEvtIsCreatedByCurrentUser,
  I_MaintNotificationTechObj._LocationAccountAssignment.AssetRoom AS AssetRoom,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintNotifProcessPhaseCode AS MaintNotifProcessPhaseCode,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintNotifProcessSubPhaseCode AS MaintNotifProcessSubPhaseCode,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintNotifRejectionReasonCode AS MaintNotifRejectionReasonCode,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintenanceTaskListType AS MaintenanceTaskListType,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.TaskListGroup AS TaskListGroup,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.TaskListGroupCounter AS TaskListGroupCounter,
  case ltrim( I_MaintNotificationTechObj._PMNotifMaintenanceData.TaskListGroup, '0') when '' then case ltrim( I_MaintNotificationTechObj._PMNotifMaintenanceData.TaskListGroupCounter, '0') when '' then concat( I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintenanceTaskListType, '' ) else concat( concat( I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintenanceTaskListType, '/0/' ), ltrim( I_MaintNotificationTechObj._PMNotifMaintenanceData.TaskListGroupCounter, '0') ) end else case ltrim( I_MaintNotificationTechObj._PMNotifMaintenanceData.TaskListGroupCounter, '0') when '' then concat( concat( concat( I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintenanceTaskListType, '/' ), ltrim( I_MaintNotificationTechObj._PMNotifMaintenanceData.TaskListGroup, '0') ), '/0' ) else concat( concat( concat( concat( I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintenanceTaskListType, '/' ), ltrim(I_MaintNotificationTechObj._PMNotifMaintenanceData.TaskListGroup, '0') ), '/' ), ltrim( I_MaintNotificationTechObj._PMNotifMaintenanceData.TaskListGroupCounter, '0') ) end end as TaskList AS TaskListGroupCounter0endendasTaskList,
  $session.system_date AS TaskListKeyDate,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintNotifDetectionCatalog AS MaintNotifDetectionCatalog,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintNotifDetectionCodeGroup AS MaintNotifDetectionCodeGroup,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintNotifDetectionCode AS MaintNotifDetectionCode,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintNotifProcessingContext AS MaintNotifProcessingContext,
  cast ( '' as eam_techobj_installation_loc ) AS TechObjInstallationLocation,
  cast ( '' as ilom_level_kz_kz2_desc) AS IdentifyingLabel,
  cast ( '' as eam_ltxt_tmplt_desc ) AS WorkRequestTextTemplate,
  cast ( '' as abap_boolean ) AS MaintNotifProcgCntxtIsAllwd,
  cast ( '000000' as hrylevel) AS HierarchyNodeLevel,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.PreviousFinalDueDate AS PreviousFinalDueDate,
  cast (dats_tims_to_tstmp( NotificationReferenceDate, NotificationReferenceTime, abap_system_timezone( $session.client,'NULL' ) , $session.client, 'NULL') as tzntstmps preserving type ) AS MaintNotifReferenceDateTime,
  cast (dats_tims_to_tstmp( NotificationCompletionDate, CompletionTime, I_MaintNotificationTechObj.NotificationTimeZone, $session.client, 'NULL') as tzntstmps preserving type ) AS MaintNotifCompletionDateTime,
  MaintenanceRevision,
  I_MaintNotificationTechObj.MaintenanceNotification AS MaintenanceNotification,
  I_MaintNotificationTechObj.MaintNotifInternalID AS MaintNotifInternalID,
  I_MaintNotificationTechObj.NotificationText AS NotificationText,
  I_MaintNotificationTechObj.MaintPriority AS MaintPriority,
  I_MaintNotificationTechObj.MaintPriorityType AS MaintPriorityType,
  I_MaintNotificationTechObj.NotificationType AS NotificationType,
  I_MaintNotificationTechObj.NotifProcessingPhase AS NotifProcessingPhase,
  I_MaintNotificationTechObj.CreatedByUser AS CreatedByUser,
  I_MaintNotificationTechObj.LastChangedByUser AS LastChangedByUser,
  I_MaintNotificationTechObj.CreationDate AS CreationDate,
  I_MaintNotificationTechObj.LastChangeTime AS LastChangeTime,
  I_MaintNotificationTechObj.LastChangeDate AS LastChangeDate,
  I_MaintNotificationTechObj.LastChangeDateTime AS LastChangeDateTime,
  I_MaintNotificationTechObj.CreationTime AS CreationTime,
  I_MaintNotificationTechObj.ReportedByUser AS ReportedByUser,
  I_MaintNotificationTechObj.ReporterFullName AS ReporterFullName,
  I_MaintNotificationTechObj.PersonResponsible AS PersonResponsible,
  I_MaintNotificationTechObj.MalfunctionEffect AS MalfunctionEffect,
  I_MaintNotificationTechObj.MalfunctionStartDate AS MalfunctionStartDate,
  I_MaintNotificationTechObj.MalfunctionStartTime AS MalfunctionStartTime,
  I_MaintNotificationTechObj.MalfunctionEndDate AS MalfunctionEndDate,
  I_MaintNotificationTechObj.MalfunctionEndTime AS MalfunctionEndTime,
  I_MaintNotificationTechObj.MaintNotificationCatalog AS MaintNotificationCatalog,
  I_MaintNotificationTechObj.MaintNotificationCode AS MaintNotificationCode,
  I_MaintNotificationTechObj.MaintNotificationCodeGroup AS MaintNotificationCodeGroup,
  I_MaintNotificationTechObj.CatalogProfile AS CatalogProfile,
  I_MaintNotificationTechObj.NotificationCreationDate AS NotificationCreationDate,
  I_MaintNotificationTechObj.NotificationCreationTime AS NotificationCreationTime,
  I_MaintNotificationTechObj.NotificationTimeZone AS NotificationTimeZone,
  I_MaintNotificationTechObj.RequiredStartDate AS RequiredStartDate,
  I_MaintNotificationTechObj.RequiredStartTime AS RequiredStartTime,
  I_MaintNotificationTechObj.RequiredEndDate AS RequiredEndDate,
  I_MaintNotificationTechObj.RequiredEndTime AS RequiredEndTime,
  I_MaintNotificationTechObj.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
  I_MaintNotificationTechObj.MaintenanceObjectIsDown AS MaintenanceObjectIsDown,
  I_MaintNotificationTechObj.TechnicalObject AS TechnicalObject,
  I_MaintNotificationTechObj.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  I_MaintNotificationTechObj.WorkCenterInternalID AS WorkCenterInternalID,
  I_MaintNotificationTechObj.WorkCenterTypeCode AS WorkCenterTypeCode,
  I_MaintNotificationTechObj.LocationDescription AS LocationDescription,
  I_MaintNotificationTechObj.TechnicalObject AS ActiveTechnicalObject,
  I_MaintNotificationTechObj.TechObjIsEquipOrFuncnlLoc AS ActiveTechnicalObjectType,
  I_MaintNotificationTechObj.MaintenanceOrder AS MaintenanceOrder,
  I_MaintNotificationTechObj.MaintenanceActivityType AS MaintenanceActivityType,
  I_MaintNotificationTechObj.MaintObjDowntimeDurationUnit AS MaintObjDowntimeDurationUnit,
  I_MaintNotificationTechObj.NotificationReferenceDate AS NotificationReferenceDate,
  I_MaintNotificationTechObj.NotificationReferenceTime AS NotificationReferenceTime,
  I_MaintNotificationTechObj.NotificationCompletionDate AS NotificationCompletionDate,
  I_MaintNotificationTechObj.CompletionTime AS CompletionTime,
  I_MaintNotificationTechObj.MaintNotifExtReferenceNumber AS MaintNotifExtReferenceNumber,
  I_MaintNotificationTechObj.MaintNotifDowntimeDuration AS MaintNotifDowntimeDuration,
  I_MaintNotificationTechObj.InspectionLot AS InspectionLot,
  I_MaintNotificationTechObj._MaintenanceOrder AS _MaintenanceOrder,
  I_MaintNotificationTechObj._MaintNotificationCode AS _MaintNotificationCode,
  I_MaintNotificationTechObj._MaintNotificationCodeGroup AS _MaintNotificationCodeGroup,
  _NumberOfOpnNotifByTechObj.NmbrOfOpenMaintNotifications AS NmbrOfOpenMaintNotifications
FROM I_MaintNotificationTechObj
LEFT OUTER JOIN I_NumberOfOpnNotifByTechObj AS _NumberOfOpnNotifByTechObj ON _NumberOfOpnNotifByTechObj.TechnicalObject = TechnicalObject AND _NumberOfOpnNotifByTechObj.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_TechnicalObjectCategoryT AS _TechnicalObjectCategoryT ON _TechnicalObjectCategoryT.TechnicalObjectCategory = TechnicalObjectCategory AND _TechnicalObjectCategoryT.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..*]
LEFT OUTER JOIN C_TechObjCstmHierVH AS _TechObjHier ON _TechObjHier.TechnicalObject = TechnicalObject AND _TechObjHier.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc AND _TechObjHier.ValidityEndDate = MalfunctionStartDate AND _TechObjHier.ValidityEndTime = MalfunctionStartTime AND _TechObjHier.TechnicalObjectLabel = TechnicalObjectLabel  -- association [0..*]
LEFT OUTER JOIN I_PMContactCardUser AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _MaintPlant ON _MaintPlant.Plant = MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlannerGroup AS _MaintPlantGroup ON _MaintPlantGroup.MaintenancePlannerGroup = MaintenancePlannerGroup AND _MaintPlantGroup.MaintenancePlanningPlant = MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN I_GenericPriorityData AS _GenericPriorityData ON _GenericPriorityData.GenericPriorityType = MaintPriorityType AND _GenericPriorityData.PriorityCode = MaintPriority  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectActiveStatus AS _ActiveSystemStatus ON _ActiveSystemStatus.StatusObject = MaintNotifInternalID AND _ActiveSystemStatus.IsUserStatus = ''  -- association [0..*]
LEFT OUTER JOIN I_StatusObjectActiveStatus AS _SystemStatus ON _SystemStatus.StatusObject = MaintNotifInternalID AND _SystemStatus.IsUserStatus = '' AND ( _SystemStatus.StatusCode = 'I052R' OR _SystemStatus.StatusCode = 'I0527' )  -- association [0..*]
LEFT OUTER JOIN I_TextObjectPlainLongText AS _TextObjectPlainLongText ON _TextObjectPlainLongText.TextObjectKey = I_MaintNotificationTechObj.MaintenanceNotification AND _TextObjectPlainLongText.TextObjectType = 'LTXT' AND _TextObjectPlainLongText.TextObjectCategory = 'QMEL' AND _TextObjectPlainLongText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaintNotifRejectionReasonTxt AS _MaintNotifRejectionReasonTxt ON _MaintNotifRejectionReasonTxt.MaintNotifRejectionReasonCode = maintnotifrejectionreasoncode  -- association [0..*]
LEFT OUTER JOIN I_TechObjWorkReqQuickVw AS _TechnicalObjQuickVw ON _TechnicalObjQuickVw.TechnicalObject = TechnicalObject AND _TechnicalObjQuickVw.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc AND _TechnicalObjQuickVw.TechnicalObjectLabel = TechnicalObjectLabel  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _SupFunctionalLocationText ON _SupFunctionalLocationText.FunctionalLocation = FunctionalLocation  -- association [0..*]
LEFT OUTER JOIN I_MaintenanceTaskList AS _TaskListDesc ON _TaskListDesc.TaskListType = maintenancetasklisttype AND _TaskListDesc.TaskListGroup = tasklistgroup AND _TaskListDesc.TaskListGroupCounter = tasklistgroupcounter  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLocT AS _TechObjIsEquipOrFuncnlLocDesc ON TechObjIsEquipOrFuncnlLoc = _TechObjIsEquipOrFuncnlLocDesc.TechObjIsEquipOrFuncnlLoc  -- association [0..*]
LEFT OUTER JOIN I_TechnicalObjectText AS _TechnicalObjectText ON _TechnicalObjectText.TechnicalObject = TechnicalObject AND _TechnicalObjectText.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..*]
LEFT OUTER JOIN I_EAMProcessSubPhase AS _SubPhase ON maintnotifprocesssubphasecode = _SubPhase.EAMProcessSubPhaseCode  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessPhase AS _Phase ON maintnotifprocessphasecode = _Phase.EAMProcessPhaseCode  -- association [0..1]
LEFT OUTER JOIN I_MaintNotifDetectionCodeText AS _MaintNotifDetectCodeTxt ON maintnotifdetectioncode = _MaintNotifDetectCodeTxt.MaintNotifDetectionCode  -- association [0..*]
LEFT OUTER JOIN I_MaintNotifDetectCodeGroupTxt AS _MaintNotifDetectCodeGroupTxt ON _MaintNotifDetectCodeGroupTxt.MaintNotifDetectionCodeGroup = maintnotifdetectioncodegroup  -- association [0..*]
LEFT OUTER JOIN I_MaintNotifProcgContextText AS _MaintNotifProcgContextTxt ON _MaintNotifProcgContextTxt.MaintNotifProcessingContext = maintnotifprocessingcontext AND _MaintNotifProcgContextTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_OrderType AS _MaintOrderType ON _MaintOrderType.OrderType = MaintenanceOrderType  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _SupFunctionalLocationLabel ON SuperiorFunctionalLocation = _SupFunctionalLocationLabel.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _SuperiorFuncLocText ON SuperiorFunctionalLocation = _SuperiorFuncLocText.FunctionalLocation  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _MaintenanceWorkCenterPlant ON MaintenanceWorkCenterPlant = _MaintenanceWorkCenterPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_UserDescription AS _CreatedByUserSimpl ON _CreatedByUserSimpl.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_ABCIndicatorText AS _ABCIndicatorText ON ABCIndicator = _ABCIndicatorText.ABCIndicator  -- association [0..*]
LEFT OUTER JOIN I_TechnicalReportText AS _TechnicalReportText ON CatalogProfile = _TechnicalReportText.CatalogProfile  -- association [0..*]
LEFT OUTER JOIN E_PMNotifMaintenanceData AS _NotifMaintenanceDataExtension ON _NotifMaintenanceDataExtension.MaintenanceNotification = MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN R_MaintNotificationItemTP AS _Item ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MaintNotifEventPrioznTP AS _EventPrio ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MaintNotificationPartnerTP AS _Partner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MaintNotificationTaskTP AS _Task ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MaintNotificationActivityTP AS _Activity ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MaintNotifEffectCodeTP AS _FailureEffect ON /* condition not available in parsed metadata */  -- association [0..1]
;