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_ObjPgMaintNotification.
-- 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: COBJPGMAINTNOTIF
CREATE VIEW C_ObjPgMaintNotification AS
SELECT
_MaintNotificationTP._PMNotificationType._Text[1:Language=$session.system_language].NotificationTypeName AS NotificationTypeName,
_MaintNotificationTP._TechObjIsEquipOrFuncnlLoc._Text[1:Language=$session.system_language].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
_MaintNotificationTP._MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
_MaintNotificationTP._MainWorkCenter.WorkCenter AS MainWorkCenter,
_MaintNotificationTP._MainWorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS MainWorkCenterText,
_MaintNotificationTP._MainWorkCenter.Plant AS MainWorkCenterPlant,
_MaintNotificationTP._MainWorkCenter._Plant.PlantName AS MainWorkCenterPlantName,
_MaintNotificationTP._PMNotifMaintenanceData.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
_MaintNotificationTP._PMNotificationPriority.MaintPriorityColorCode AS MaintPriorityColorCode,
_MaintNotificationTP._PMNotificationPriority._Text[1:Language=$session.system_language].MaintPriorityDesc AS MaintPriorityDesc,
_MaintNotificationTP._PMNotificationPhase._Text[1:Language=$session.system_language].NotifProcessingPhaseDesc AS NotifProcessingPhaseDesc,
_MaintNotificationTP._PMNotifMaintenanceData.MaintenancePlanningPlant AS MaintenancePlanningPlant,
_MaintNotificationTP._PMNotifMaintenanceData._MaintenancePlanningPlant.PlantName AS MaintenancePlanningPlantName,
_MaintNotificationTP._PMNotifMaintenanceData.MaintenancePlannerGroup AS MaintenancePlannerGroup,
_MaintNotificationTP._PMNotifMaintenanceData._MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
_MaintNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment._WorkCenter.WorkCenter AS MaintenanceWorkCenter,
_MaintNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment._WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS MaintenanceWorkCenterText,
cast(_MaintNotificationTP.PersonResponsible as eam_personresp_char8) AS PersonResponsible,
cast('' as eams_person_responsible_name) AS PersonResponsibleName,
_MaintNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment.ABCIndicator AS ABCIndicator,
_MaintNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment._ABCIndicator._Text[1:Language = $session.system_language].ABCIndicatorDesc AS ABCIndicatorDesc,
_MaintNotificationTP._PMNotifMaintenanceData.InspectedByUser AS InspectedByUser,
_MaintNotificationTP._PMNotifMaintenanceData._InspectedByUser.UserDescription AS InspectedByUserDescription,
_MaintNotificationTP._PMNotifMaintenanceData.InspectionDate AS InspectionDate,
_MaintNotificationTP._ReportedByUser.UserDescription AS ReportedByUserDescription,
_MaintNotificationTP._CreatedByUser.UserDescription AS CreatedByUserDescription,
_MaintNotificationTP._PMNotifMaintenanceData.Assembly AS Assembly,
_MaintNotificationTP._PMNotifMaintenanceData._Assembly._Text[1:Language=$session.system_language].MaterialName AS AssemblyName,
_MaintNotificationTP._PMNotifMaintenanceData.MaintenanceObjectIsDown AS MaintenanceObjectIsDown,
_MaintNotificationTP._PMNotifMaintenanceData.MalfunctionStartDate AS MalfunctionStartDate,
_MaintNotificationTP._PMNotifMaintenanceData.MalfunctionStartTime AS MalfunctionStartTime,
_MaintNotificationTP._PMNotifMaintenanceData.MalfunctionEndDate AS MalfunctionEndDate,
_MaintNotificationTP._PMNotifMaintenanceData.MalfunctionEndTime AS MalfunctionEndTime,
_MaintNotificationTP._PMNotifMaintenanceData.MaintObjDowntimeDurationUnit AS MaintObjDowntimeDurationUnit,
_MaintNotificationTP._PMNotifMaintenanceData.MaintenanceRevision AS MaintenanceRevision,
_MaintNotificationTP._PMNotifMaintenanceData._MaintenanceRevision.MaintenanceRevisionDesc AS MaintenanceRevisionDesc,
_MaintNotificationTP._PMNotifMaintenanceData.MaintenanceActivityType AS MaintenanceActivityType,
_MaintNotificationTP._PMNotifMaintenanceData._MaintenanceActivityType._Text[1:Language=$session.system_language].MaintenanceActivityTypeName AS MaintenanceActivityTypeName,
_MaintNotificationTP._MaintenanceWorkCenterPlant.PlantName AS MaintenanceWorkCenterPlantName,
_MaintNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment.AssetLocation AS AssetLocation,
_MaintNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment._Location.LocationName AS AssetLocationName,
_MaintNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment.AssetRoom AS AssetRoom,
_MaintNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
_MaintNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment._MaintenancePlant.PlantName AS MaintenancePlantName,
_MaintNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment.PlantSection AS PlantSection,
_MaintNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment._PlantSection.PlantSectionPersonRespName AS PlantSectionPersonRespName,
_MaintNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment._PlantSection.PlantSectionPersonRespPhone AS PlantSectionPersonRespPhone,
_MaintNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment.MaintObjectFreeDefinedAttrib AS MaintObjectFreeDefinedAttrib,
_MaintNotificationTP._PMNotifMaintenanceData.MaintenancePlan AS MaintenancePlan,
_MaintNotificationTP._PMNotifMaintenanceData._MaintenancePlan.MaintenancePlanDesc AS MaintenancePlanDesc,
_MaintNotificationTP._PMNotifMaintenanceData.MaintenanceItem AS MaintenanceItem,
_MaintNotificationTP._PMNotifMaintenanceData._MaintenanceItem.MaintenanceItemDescription AS MaintenanceItemDescription,
_MaintNotificationTP._PMNotifMaintenanceData._MaintenanceItem.MaintenancePlanCategory AS MaintenancePlanCategory,
_MaintNotificationTP._PMNotifMaintenanceData._MaintenanceItem._MaintenancePlanCatParam._Text[1:Language=$session.system_language].MaintenancePlanCategoryDesc AS MaintenancePlanCategoryDesc,
cast ('' as vdm_j_system_status_concat_t) AS MaintPlanCnctntdActvSystSts,
_MaintNotificationTP._PMNotifMaintenanceData._MaintenancePlan.BasicStartDate AS BasicStartDate,
_MaintNotificationTP._MaintenanceItemTechObj.TechnicalObjectDescription AS MaintPlanTechnicalObjectDesc,
_MaintNotificationTP._MaintenanceItemTechObj.TechObjIsEquipOrFuncnlLoc AS MaintPlanTechObjIsEquipment,
_MaintNotificationTP._MaintenanceItemTechObj._TechObjIsEquipOrFuncnlLoc._Text[1:Language=$session.system_language].TechObjIsEquipOrFuncnlLocDesc AS MaintPlanTechObjIsEquipDesc,
_MaintNotificationTP._PMNotifMaintenanceData._MaintenanceItem._MaintenanceNotification.NotificationText AS LastSchedldMaintNotifText,
case when(_MaintNotificationItemCount.NumberOfMaintNotifItems is null) then 0 else _MaintNotificationItemCount.NumberOfMaintNotifItems end AS NumberOfMaintNotifItems,
case when(_MaintNotificationTaskCount.NumberOfMaintNotifTasks is null) then 0 else _MaintNotificationTaskCount.NumberOfMaintNotifTasks end AS NumberOfMaintNotifTasks,
case when(_MaintNotifActivityCount.NumberOfMaintNotifActivities is null) then 0 else _MaintNotifActivityCount.NumberOfMaintNotifActivities end AS NumberOfMaintNotifActivities,
_MaintNotificationTP._PMNotificationPriorityType._Text[1:Language=$session.system_language].MaintPriorityTypeDesc AS MaintPriorityTypeDesc,
cast(IsCompleted as xfeld) AS IsCompleted,
cast(IsDeleted as xfeld) AS IsDeleted,
_MaintNotificationTP._MaintNotificationCode.InspectionCode AS MaintNotificationCode,
_MaintNotificationTP._MaintNotificationCodeGroup.InspectionCodeGroup AS MaintNotificationCodeGroup,
_MaintNotificationTP._PMNotifMaintenanceData._MaintenancePlan.MaintenancePlanInternalID AS MaintenancePlanInternalID,
_MaintNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment.CostCenter AS CostCenter,
_MaintNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment.ControllingArea AS ControllingArea,
cast(_MaintNotificationTP.MaintenanceNotification as char12 preserving type ) AS MaintNotifWithLeadingZeros,
_MaintNotificationTP._MaintNotificationCode.InspectionCatalog AS MaintNotificationCatalog,
_MaintNotificationTP._MaintNotificationCode.InspectionCodeGroup AS InspectionCodeGroup,
_MaintNotificationTP._MaintNotificationCodeGroup.InspectionCatalog AS InspectionCatalog,
_MaintNotificationTP._MaintenanceOrder._MaintenanceOrderType.OrderType AS MaintenanceOrderType,
_MaintNotificationTP._PMNotificationType.MaintNotifRespPartnerFunction AS MaintNotifRespPartnerFunction,
_MaintNotificationTP._PMNotificationType.NotificationCategory AS NotificationCategory,
cast(coalesce(_ActiveUserStatusWthStsNmbr.StatusProfile,'') as j_stsma preserving type ) AS StatusProfile,
cast ('' as eam_date_adjustment ) AS RequiredStartEndDateAdjust,
cast( concat( '/sap/opu/odata/sap/EAM_OBJPG_MAINTNOTIFICATION_SRV/' , concat( concat( 'NotificationTypeImageSet(MaintenanceNotification=''', MaintenanceNotification ), ''')/$value') ) as string128 ) AS MaintNotificationThumbnailURL,
'MELDUNG' AS ChangeDocObjectClass,
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( CreationDate, CreationTime, abap_system_timezone( $session.client,'NULL' ) , $session.client, 'NULL') as tzntstmps preserving type ) AS CreationDateTime,
cast (dats_tims_to_tstmp( MalfunctionStartDate, MalfunctionStartTime, _MaintNotificationTP.NotificationTimeZone, $session.client, 'NULL') as tzntstmps preserving type ) AS MalfunctionStartDateTime,
cast (dats_tims_to_tstmp( MalfunctionEndDate, MalfunctionEndTime, _MaintNotificationTP.NotificationTimeZone, $session.client, 'NULL') as tzntstmps preserving type ) AS MalfunctionEndDateTime,
cast (dats_tims_to_tstmp( NotificationCreationDate, NotificationCreationTime, _MaintNotificationTP.NotificationTimeZone , $session.client, 'NULL') as tzntstmps preserving type ) AS NotificationCreationDateTime,
MaintNotifRqdStartDateTime,
cast (dats_tims_to_tstmp( NotificationCompletionDate, CompletionTime, _MaintNotificationTP.NotificationTimeZone, $session.client, 'NULL') as tzntstmps preserving type ) AS MaintNotifCompletionDateTime,
MaintNotifRqdEndDateTime,
TaskList,
_PMNotifMaintenanceData._SubPhase._EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc AS EAMProcessSubPhaseCodeDesc,
_PMNotifMaintenanceData._Phase._EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc AS EAMProcessPhaseCodeDesc,
_PMNotifMaintenanceData._MalfunctionEffect._Text[ 1:Language = $session.system_language ].MalfunctionEffectText AS MalfunctionEffectText,
MaintNotifProcessingContext,
_MaintNotifEffectCode._MaintNotifEffectCodeGroup._Text[1: Language = $session.system_language ].InspSpecAddlCodeGroupText AS MaintNotifEffectCodeGrpText,
_MaintNotifEffectCode._MaintNotificationEffectCode._Text[1: Language = $session.system_language ].InspectionCodeText AS MaintNotifEffectCtlgCodeText,
cast( '' as abap.char(255) ) AS MaintNotifCodingCodeLongText,
cast( '' as abap.char(255) ) AS MaintNotifCodgCodeGrpLongTxt,
cast( '' as abap.char(255) ) AS MaintNotifEffectCodeLongText,
cast( '' as abap.char(255) ) AS MaintNotifEffctCodeGrpLongTxt,
_MaintNotificationTP._MainWorkCenter._Plant AS _Plant,
_MaintNotificationTP._PMNotifMaintenanceData._Assembly AS _Assembly,
_MaintNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment._MaintenancePlant AS _MaintenancePlant,
_MaintNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment._PlantSection AS _PlantSection,
_MaintNotificationTP._PMNotifMaintenanceData._MaintenanceActivityType AS _MaintenanceActivityType,
_MaintNotificationTP._PMNotifMaintenanceData._MaintenanceItem AS _MaintenanceItem,
_MaintNotificationTP._PMNotifMaintenanceData._MaintenanceItem._MaintenancePlanCatParam AS _MaintenancePlanCatParam,
_MaintNotificationTP._PMNotifMaintenanceData._MaintenancePlan AS _MaintenancePlan,
_MaintNotificationTP._PMNotifMaintenanceData._MaintenancePlannerGroup AS _MaintenancePlannerGroup,
_MaintNotificationTP._PMNotifMaintenanceData._MaintenancePlanningPlant AS _MaintenancePlanningPlant,
_MaintNotificationTP._MaintenanceOrder._MaintenanceOrderType._Text AS _OrderTypeText,
_MaintNotificationTP._MaintNotificationCode._Text AS _InspectionCodeText,
_MaintNotificationTP._MaintNotificationCodeGroup._Text AS _InspectionCodeGroupText,
_MaintNotificationTP.MaintenanceNotification AS MaintenanceNotification,
_MaintNotificationTP.NotificationText AS NotificationText,
_MaintNotificationTP.NotificationType AS NotificationType,
_MaintNotificationTP.MaintenanceOrder AS MaintenanceOrder,
_MaintNotificationTP.WorkCenterTypeCode AS WorkCenterTypeCode,
_MaintNotificationTP.MaintPriority AS MaintPriority,
_MaintNotificationTP.NotifProcessingPhase AS NotifProcessingPhase,
_MaintNotificationTP.PersonResponsible AS PersonResponsible_H,
_MaintNotificationTP.CreationDate AS CreationDate,
_MaintNotificationTP.CreationTime AS CreationTime,
_MaintNotificationTP.CompletionTime AS CompletionTime,
_MaintNotificationTP.NotificationCompletionDate AS NotificationCompletionDate,
_MaintNotificationTP.NotificationReferenceTime AS NotificationReferenceTime,
_MaintNotificationTP.NotificationReferenceDate AS NotificationReferenceDate,
_MaintNotificationTP.ReportedByUser AS ReportedByUser,
_MaintNotificationTP.CreatedByUser AS CreatedByUser,
_MaintNotificationTP.RequiredStartDate AS RequiredStartDate,
_MaintNotificationTP.RequiredStartTime AS RequiredStartTime,
_MaintNotificationTP.RequiredEndDate AS RequiredEndDate,
_MaintNotificationTP.RequiredEndTime AS RequiredEndTime,
_MaintNotificationTP.MaintenanceWorkCenterPlant AS MaintenanceWorkCenterPlant,
_MaintNotificationTP.MaintPriorityType AS MaintPriorityType,
_MaintNotificationTP.FunctionalLocation AS FunctionalLocation,
_MaintNotificationTP.Equipment AS Equipment,
_MaintNotificationTP.MaintNotifInternalID AS MaintNotifInternalID,
_MaintNotificationTP.NotificationHasLongText AS NotificationHasLongText,
_MaintNotificationTP.TechnicalObject AS TechnicalObject,
_MaintNotificationTP.NotificationTimeZone AS NotificationTimeZone,
_MaintNotificationTP._MaintenanceOrder AS _MaintenanceOrder,
_MaintNotificationTP._MainWorkCenter AS _MainWorkCenter,
_MaintNotificationTP._PMNotificationPhase AS _PMNotificationPhase,
_MaintNotificationTP._PMNotificationPriority AS _PMNotificationPriority,
_MaintNotificationTP._PMNotificationPriorityType AS _PMNotificationPriorityType,
_MaintNotificationTP._TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc,
_EquipmentText.EquipmentName AS EquipmentName,
_FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
_FunctionalLocationText.FunctionalLocationName AS FunctionalLocationName,
_MaintNotifEffectCode.MaintNotifEffectCodeGroup AS MaintNotifEffectCodeGroup,
_MaintNotifEffectCode.MaintNotifEffectCode AS MaintNotifEffectCode,
_MaintNotifEffectCode.MaintNotifEffectCatalog AS MaintNotifEffectCatalog,
_MaintNotifProcgContextTxt.MaintNotifProcgContextText AS MaintNotifProcgContextText,
_NotifNmbrOfAttachedDocuments.NotifNmbrOfAttachedDocuments AS NotifNmbrOfAttachedDocuments,
_PMNotifMaintenanceData.MaintNotifProcessPhaseCode AS MaintNotifProcessPhaseCode,
_PMNotifMaintenanceData.MaintNotifProcessSubPhaseCode AS MaintNotifProcessSubPhaseCode,
_PMNotifMaintenanceData.MaintNotifDetectionCatalog AS MaintNotifDetectionCatalog,
_PMNotifMaintenanceData.MaintNotifDetectionCode AS MaintNotifDetectionCode,
_PMNotifMaintenanceData.MaintNotifDetectionCodeGroup AS MaintNotifDetectionCodeGroup,
_TaskListDesc.TaskListDesc AS TaskListDesc,
_TextObjectPlainLongText.PlainLongText AS MaintNotificationLongText
FROM I_MaintNotificationTP AS _MaintNotificationTP
LEFT OUTER JOIN C_ObjPgMaintNotifActivity AS _ObjPgMaintNotifActivity ON _ObjPgMaintNotifActivity.MaintenanceNotification = MaintenanceNotification AND _ObjPgMaintNotifActivity.MaintenanceNotificationItem = '0000' -- association [0..*]
LEFT OUTER JOIN C_ObjPgMaintNotificationTask AS _ObjPgMaintNotificationTask ON _ObjPgMaintNotificationTask.MaintenanceNotification = MaintenanceNotification AND _ObjPgMaintNotificationTask.MaintenanceNotificationItem = '0000' AND _ObjPgMaintNotificationTask.IsDeleted = '' -- association [0..*]
LEFT OUTER JOIN I_TextObjectPlainLongText AS _TextObjectPlainLongText ON _TextObjectPlainLongText.TextObjectKey = MaintenanceNotification AND _TextObjectPlainLongText.TextObjectType = 'LTXT' AND _TextObjectPlainLongText.TextObjectCategory = 'QMEL' AND _TextObjectPlainLongText.Language = $session.system_language -- association [0..1]
LEFT OUTER JOIN C_MaintNotificationChgHistory AS _MaintNotificationChgHistory ON MaintNotifWithLeadingZeros = _MaintNotificationChgHistory.ChangeDocObject -- association [0..*]
LEFT OUTER JOIN C_ObjPgMaintNotificationItem AS _ObjPgMaintNotificationItem ON _ObjPgMaintNotificationItem.MaintenanceNotification = MaintenanceNotification -- association [0..*]
LEFT OUTER JOIN C_MaintNotificationTypeVH AS _MaintNotificationTypeVH ON _MaintNotificationTypeVH.NotificationType = NotificationType -- association [1..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenterBySemanticKey ON _WorkCenterBySemanticKey.WorkCenter = MainWorkCenter AND _WorkCenterBySemanticKey.Plant = MainWorkCenterPlant -- association [0..1]
LEFT OUTER JOIN I_MaintenanceNotification AS _MaintenanceNotification ON _MaintenanceNotification.MaintenanceNotification = MaintenanceNotification -- association [1..1]
LEFT OUTER JOIN C_MaintNotificationItemCount AS _MaintNotificationItemCount ON _MaintNotificationItemCount.MaintenanceNotification = MaintenanceNotification -- association [0..1]
LEFT OUTER JOIN C_MaintNotificationTaskCount AS _MaintNotificationTaskCount ON _MaintNotificationTaskCount.MaintenanceNotification = MaintenanceNotification AND _MaintNotificationTaskCount.MaintenanceNotificationItem = '0000' -- association [0..1]
LEFT OUTER JOIN C_MaintNotifActivityCount AS _MaintNotifActivityCount ON _MaintNotifActivityCount.MaintenanceNotification = MaintenanceNotification AND _MaintNotifActivityCount.MaintenanceNotificationItem = '0000' -- association [0..1]
LEFT OUTER JOIN C_TechnicalObjectLabelVH AS _MaintenancePlanTechObj ON _MaintenancePlanTechObj.TechnicalObjectLabel = MaintPlanTechnicalObjectLabel AND _MaintenancePlanTechObj.TechObjIsEquipOrFuncnlLoc = MaintPlanTechObjIsEquipment AND _MaintenancePlanTechObj.TechnicalObject = MaintenancePlanTechnicalObject -- association [0..1]
LEFT OUTER JOIN C_TechnicalObjectLabelVH AS _TechnicalObjectLabelVH ON _TechnicalObjectLabelVH.TechnicalObjectLabel = TechnicalObjectLabel AND _TechnicalObjectLabelVH.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc AND _TechnicalObjectLabelVH.TechnicalObject = TechnicalObject -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _MaintPlanTechObjIsEquipment ON _MaintPlanTechObjIsEquipment.TechObjIsEquipOrFuncnlLoc = MaintPlanTechObjIsEquipment -- association [0..1]
LEFT OUTER JOIN C_MaintenanceNotificationVH AS _MaintenanceNotificationVH ON _MaintenanceNotificationVH.MaintenanceNotification = MaintenanceNotification -- association [0..1]
LEFT OUTER JOIN I_PMContactCardUser AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser -- association [0..1]
LEFT OUTER JOIN I_PMContactCardEmployee AS _InspectedByUser ON _InspectedByUser.PersonnelNumber = inspectedbyuser -- association [0..1]
LEFT OUTER JOIN I_PMContactCardEmployee AS _PlantSectionResponsible ON _PlantSectionResponsible.PersonnelNumber = plantsectionpersonrespname -- association [0..1]
LEFT OUTER JOIN I_PMContactCardEmployee AS _PersonResponsible ON _PersonResponsible.PersonnelNumber = PersonResponsible -- association [0..1]
LEFT OUTER JOIN I_WorkforcePerson AS _MaintNotifPersonResponsible ON _MaintNotifPersonResponsible.PersonExternalID = PersonResponsible_H -- association [0..1]
LEFT OUTER JOIN I_NumberOfOpnNotifByTechObj AS _NumberOfOpnNotifByTechObj ON _NumberOfOpnNotifByTechObj.TechnicalObject = TechnicalObject AND _NumberOfOpnNotifByTechObj.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc -- association [0..1]
LEFT OUTER JOIN P_OpenMaintNotifForEquipment AS _OPENMAINTNOTIFFOREQUIPMENT ON _OPENMAINTNOTIFFOREQUIPMENT.Equipment = Equipment -- association [0..1]
LEFT OUTER JOIN P_OpenMaintNotifForFuncnlLoc AS _OPENMAINTNOTIFFORFUNCNLLOC ON _OPENMAINTNOTIFFORFUNCNLLOC.FunctionalLocation = FunctionalLocation -- association [0..1]
LEFT OUTER JOIN I_PMContactCardUser AS _ReportedByUser ON _ReportedByUser.UserID = ReportedByUser -- association [0..1]
LEFT OUTER JOIN I_MaintNotifAssignOrderInput AS _MaintNotifAssignOrderInput ON _MaintNotifAssignOrderInput.MaintenanceNotification = MaintenanceNotification -- association [0..1]
LEFT OUTER JOIN C_PMAssetLocationVH AS _AssetLocationVH ON _AssetLocationVH.Location = assetlocation AND _AssetLocationVH.Plant = maintenanceplant -- association [0..1]
LEFT OUTER JOIN I_MaintenanceRevisionStdVH AS _MaintenanceRevisionVH ON _MaintenanceRevisionVH.MaintenancePlanningPlant = maintenanceplanningplant AND _MaintenanceRevisionVH.MaintenanceRevision = maintenancerevision -- association [0..1]
LEFT OUTER JOIN C_TechObjQuickVw AS _TechnicalObjQuickVw ON _TechnicalObjQuickVw.TechnicalObject = TechnicalObject AND _TechnicalObjQuickVw.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc AND _TechnicalObjQuickVw.TechnicalObjectLabel = TechnicalObjectLabel -- association [0..1]
LEFT OUTER JOIN C_MaintOrderQuickVw AS _MaintenanceOrderQuickView ON _MaintenanceOrderQuickView.MaintenanceOrder = MaintenanceOrder -- association [0..1]
LEFT OUTER JOIN C_MaintPrioSmltdDates AS _MaintPrioSmltdDates ON _MaintPrioSmltdDates.MaintPriority = MaintPriority AND _MaintPrioSmltdDates.MaintPriorityType = MaintPriorityType -- association [0..1]
LEFT OUTER JOIN C_MaintenancePlanQuickVw AS _MaintenancePlanQuickVw ON _MaintenancePlanQuickVw.MaintenancePlan = maintenanceplan -- association [0..1]
LEFT OUTER JOIN C_StsObjActiveStatusCodeText AS _ActiveSystemStatus ON _ActiveSystemStatus.StatusObject = MaintNotifInternalID AND _ActiveSystemStatus.IsUserStatus = '' -- association [0..*]
LEFT OUTER JOIN C_StsObjActiveStatusCodeText AS _ActiveUserStatus ON _ActiveUserStatus.StatusObject = MaintNotifInternalID AND _ActiveUserStatus.IsUserStatus = 'X' -- association [0..*]
LEFT OUTER JOIN I_ABCIndicator AS _ABCIndicator ON abcindicator = _ABCIndicator.ABCIndicator -- association [0..1]
LEFT OUTER JOIN P_MaintUsrStsWithSqncNumber AS _ActiveUserStatusWthStsNmbr ON _ActiveUserStatusWthStsNmbr.StatusObject = MaintNotifInternalID -- association [0..1]
LEFT OUTER JOIN I_StatusProfile AS _StatusProfile ON _StatusProfile.StatusProfile = StatusProfile -- association [0..1]
LEFT OUTER JOIN C_MaintenanceObjectStatus AS _SystemStatus ON _SystemStatus.StatusObject = MaintNotifInternalID AND _SystemStatus.IsUserStatus = ' ' -- association [0..*]
LEFT OUTER JOIN C_MaintenanceObjectStatus AS _UserStatusWthoutStsNmbr ON _UserStatusWthoutStsNmbr.StatusObject = MaintNotifInternalID AND _UserStatusWthoutStsNmbr.StatusSequenceNumber = '00' AND _UserStatusWthoutStsNmbr.IsUserStatus = 'X' -- association [0..*]
LEFT OUTER JOIN C_MaintObjUserStatusWthStsNmbr AS _UserStatusWithStatusNumber ON _UserStatusWithStatusNumber.StatusObject = MaintNotifInternalID AND _UserStatusWithStatusNumber.StatusSequenceNumber != '00' AND _UserStatusWithStatusNumber.IsUserStatus = 'X' -- association [0..1]
LEFT OUTER JOIN C_EAMProductQuickVw AS _EAMProductQuickVw ON _EAMProductQuickVw.Material = assembly -- association [0..1]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON _EquipmentText.Equipment = Equipment AND _EquipmentText.Language = $session.system_language -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON _FunctionalLocationLabel.FunctionalLocation = FunctionalLocation -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON _FunctionalLocationText.FunctionalLocation = FunctionalLocation AND _FunctionalLocationText.Language = $session.system_language -- association [0..1]
LEFT OUTER JOIN I_PMNotifMaintenanceData AS _PMNotifMaintenanceData ON _PMNotifMaintenanceData.MaintenanceNotification = MaintenanceNotification -- association [0..1]
LEFT OUTER JOIN P_NotifNmbrOfAttachedDocuments AS _NotifNmbrOfAttachedDocuments ON _NotifNmbrOfAttachedDocuments.LinkedSAPObjectKey = MaintenanceNotification -- association [0..1]
LEFT OUTER JOIN C_MaintOrderTypeVH AS _MaintOrderTypeVH ON _MaintOrderTypeVH.MaintenanceOrderType = MaintenanceOrderType -- association [0..1]
LEFT OUTER JOIN C_MaintWorkReqEventPrioznTP AS _EventPrio ON MaintenanceNotification = _EventPrio.MaintenanceNotification -- association [0..*]
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_MaintNotifEffectCode AS _MaintNotifEffectCode ON _MaintNotifEffectCode.MaintenanceNotification = MaintenanceNotification AND _MaintNotifEffectCode.MaintenanceNotificationEffect = '0001' -- association [0..1]
LEFT OUTER JOIN E_PMNotifMaintenanceData AS _NotifMaintenanceDataExtension ON _NotifMaintenanceDataExtension.MaintenanceNotification = MaintenanceNotification -- association [0..1]
;