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
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,
cast( _GenericPriorityData.GenericPriorityColorCode as abap.int1) AS GenericPriorityColorCode,
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,
cast (dats_tims_to_tstmp( CreationDate, CreationTime, abap_system_timezone( $session.client,'NULL' ) , $session.client, 'NULL') as tzntstmps preserving type ) AS CreationDateTime,
I_MaintNotificationTechObj.ReportedByUser AS ReportedByUser,
I_MaintNotificationTechObj.ReporterFullName AS ReporterFullName,
I_MaintNotificationTechObj.PersonResponsible AS PersonResponsible,
I_MaintNotificationTechObj.MalfunctionStartDate AS MalfunctionStartDate,
I_MaintNotificationTechObj.MalfunctionStartTime AS MalfunctionStartTime,
cast (dats_tims_to_tstmp( MalfunctionStartDate, MalfunctionStartTime, I_MaintNotificationTechObj.NotificationTimeZone, $session.client, 'NULL') as tzntstmps preserving type ) AS MalfunctionStartDateTime,
I_MaintNotificationTechObj.MalfunctionEndDate AS MalfunctionEndDate,
I_MaintNotificationTechObj.MalfunctionEndTime AS MalfunctionEndTime,
cast (dats_tims_to_tstmp( MalfunctionEndDate, MalfunctionEndTime, I_MaintNotificationTechObj.NotificationTimeZone, $session.client, 'NULL') as tzntstmps preserving type ) AS MalfunctionEndDateTime,
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,
cast (dats_tims_to_tstmp( NotificationCreationDate, NotificationCreationTime, I_MaintNotificationTechObj.NotificationTimeZone , $session.client, 'NULL') as tzntstmps preserving type ) AS NotificationCreationDateTime,
I_MaintNotificationTechObj.NotificationTimeZone AS NotificationTimeZone,
I_MaintNotificationTechObj.RequiredStartDate AS RequiredStartDate,
I_MaintNotificationTechObj.RequiredStartTime AS RequiredStartTime,
cast (dats_tims_to_tstmp( RequiredStartDate, RequiredStartTime, I_MaintNotificationTechObj.NotificationTimeZone , $session.client, 'NULL') as tzntstmps preserving type ) AS MaintNotifRqdStartDateTime,
I_MaintNotificationTechObj.RequiredEndDate AS RequiredEndDate,
I_MaintNotificationTechObj.RequiredEndTime AS RequiredEndTime,
cast (dats_tims_to_tstmp( RequiredEndDate, RequiredEndTime,I_MaintNotificationTechObj.NotificationTimeZone, $session.client, 'NULL') as tzntstmps preserving type ) AS MaintNotifRqdEndDateTime,
I_MaintNotificationTechObj.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
I_MaintNotificationTechObj.MaintenanceObjectIsDown AS MaintenanceObjectIsDown,
cast( 'QMEL' as tdobject ) AS TextObjectCategory,
cast( 'LTXT' as tdid preserving type ) AS TextObjectType,
cast('' as eams_ltext ) AS MaintNotifLongTextForEdit,
I_MaintNotificationTechObj.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintenancePlanningPlant AS MaintenancePlanningPlant,
I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintenancePlannerGroup AS MaintenancePlannerGroup,
I_MaintNotificationTechObj._LocationAccountAssignment.PlantSection AS PlantSection,
I_MaintNotificationTechObj._LocationAccountAssignment.ABCIndicator AS ABCIndicator,
cast(I_MaintNotificationTechObj.FunctionalLocation as eams_ui_oid_name preserving type ) AS FunctionalLocation,
I_MaintNotificationTechObj._FunctionalLocation._FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
I_MaintNotificationTechObj._LocationAccountAssignment.AssetLocation AS AssetLocation,
I_MaintNotificationTechObj._LocationAccountAssignment._Location.LocationName AS LocationName,
I_MaintNotificationTechObj._LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
I_MaintNotificationTechObj.WorkCenterInternalID AS WorkCenterInternalID,
I_MaintNotificationTechObj._LocationAccountAssignment._WorkCenter.Plant AS MaintenanceWorkCenterPlant,
I_MaintNotificationTechObj._MainWorkCenter.WorkCenter AS MainWorkCenter,
I_MaintNotificationTechObj._LocationAccountAssignment._WorkCenter.WorkCenter AS MaintenanceWorkCenter,
I_MaintNotificationTechObj.WorkCenterTypeCode AS WorkCenterTypeCode,
I_MaintNotificationTechObj._MainWorkCenter.Plant AS MainWorkCenterPlant,
I_MaintNotificationTechObj.LocationDescription AS LocationDescription,
cast ( 0 as eam_open_notifications ) AS NmbrOfOpenMaintNotifications,
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,
I_MaintNotificationTechObj.TechnicalObject AS ActiveTechnicalObject,
I_MaintNotificationTechObj.TechObjIsEquipOrFuncnlLoc AS ActiveTechnicalObjectType,
cast(I_MaintNotificationTechObj._NotificationType.NotifPartnerRoleResponsible as parvw_unv) AS MaintNotifRespPartnerFunction,
cast('' as eams_person_responsible_name) AS PersonResponsibleName,
I_MaintNotificationTechObj.MaintenanceOrder AS MaintenanceOrder,
I_MaintNotificationTechObj._MaintOrdMstrData.OrderType AS MaintenanceOrderType,
cast('' as abap_boolean preserving type) AS MaintEvtIsCreatedByCurrentUser,
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._LocationAccountAssignment.AssetRoom AS AssetRoom,
I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintNotifProcessPhaseCode AS MaintNotifProcessPhaseCode,
I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintNotifProcessSubPhaseCode AS MaintNotifProcessSubPhaseCode,
I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintNotifRejectionReasonCode AS MaintNotifRejectionReasonCode,
I_MaintNotificationTechObj.MaintNotifExtReferenceNumber AS MaintNotifExtReferenceNumber,
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,
I_MaintNotificationTechObj.MaintNotifDowntimeDuration AS MaintNotifDowntimeDuration,
I_MaintNotificationTechObj._MaintenanceOrder AS _MaintenanceOrder,
I_MaintNotificationTechObj._MaintNotificationCode AS _MaintNotificationCode,
I_MaintNotificationTechObj._MaintNotificationCodeGroup AS _MaintNotificationCodeGroup
FROM I_MaintNotificationTechObj
LEFT OUTER JOIN P_OpenMaintNotifForEquipment AS _OpenMaintNotifForEquipment ON _OpenMaintNotifForEquipment.Equipment = I_MaintNotificationTechObj.Equipment -- association [0..1]
LEFT OUTER JOIN P_OpenMaintNotifForFuncnlLoc AS _OpenMaintNotifForFuncnlLoc ON _OpenMaintNotifForFuncnlLoc.FunctionalLocation = FunctionalLocation AND FunctionalLocation is not initial AND I_MaintNotificationTechObj.Equipment is initial -- 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 -- 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_MaintNotifFuncLocEquipment AS _MaintNotifFuncLocEquipment ON _MaintNotifFuncLocEquipment.MaintenanceNotification = MaintenanceNotification -- association [0..1]
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..*]
;