I_MaintNotificationTechObj

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 I_MaintNotificationTechObj.
-- 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: IMAINTNTFTECOBJ

CREATE VIEW I_MaintNotificationTechObj AS
SELECT
  I_MaintenanceNotification.MaintenanceNotification AS MaintenanceNotification,
  I_MaintenanceNotification.MaintPriority AS MaintPriority,
  I_MaintenanceNotification.MaintPriorityType AS MaintPriorityType,
  I_MaintenanceNotification.NotificationType AS NotificationType,
  I_MaintenanceNotification.NotifProcessingPhase AS NotifProcessingPhase,
  I_MaintenanceNotification.CreatedByUser AS CreatedByUser,
  I_MaintenanceNotification.LastChangedByUser AS LastChangedByUser,
  case _PMNotifMaintenanceData.MaintenanceTaskListType when '' then '' else concat( concat( concat( concat(_PMNotifMaintenanceData.MaintenanceTaskListType,'/'), ltrim(_PMNotifMaintenanceData.TaskListGroup,'0') ),'/' ), ltrim( _PMNotifMaintenanceData.TaskListGroupCounter,'0') ) end as TaskList AS TaskListGroupCounter0endasTaskList,
  case LastChangeTime when '240000' then dats_add_days(I_MaintenanceNotification.LastChangeDate,1,'NULL') else I_MaintenanceNotification.LastChangeDate end as LastChangeDate AS LastChangeDateendasLastChangeDate,
  case LastChangeTime when '240000' then '000000' else I_MaintenanceNotification.LastChangeTime end as LastChangeTime AS LastChangeTimeendasLastChangeTime,
  case CreationTime when '240000' then dats_add_days(I_MaintenanceNotification.CreationDate,1,'NULL') else I_MaintenanceNotification.CreationDate end as CreationDate AS CreationDateendasCreationDate,
  case CreationTime when '240000' then '000000' else I_MaintenanceNotification.CreationTime end as CreationTime AS CreationTimeendasCreationTime,
  I_MaintenanceNotification.LastChangeDateTime AS LastChangeDateTime,
  I_MaintenanceNotification.CreationDateTime AS CreationDateTime,
  I_MaintenanceNotification.ReportedByUser AS ReportedByUser,
  _PMNotifMaintenanceData.NotificationPersonResponsible AS PersonResponsible,
  I_MaintenanceNotification.NotificationText AS NotificationText,
  I_MaintenanceNotification.MaintenanceOrder AS MaintenanceOrder,
  case RequiredStartTime when '240000' then dats_add_days(I_MaintenanceNotification.RequiredStartDate,1,'NULL') else I_MaintenanceNotification.RequiredStartDate end as RequiredStartDate AS RequiredStartDateendasRequiredStartDate,
  case RequiredStartTime when '240000' then '000000' else I_MaintenanceNotification.RequiredStartTime end as RequiredStartTime AS RequiredStartTimeendasRequiredStartTime,
  case RequiredEndTime when '240000' then dats_add_days(I_MaintenanceNotification.RequiredEndDate,1,'NULL') else I_MaintenanceNotification.RequiredEndDate end as RequiredEndDate AS RequiredEndDateendasRequiredEndDate,
  case RequiredEndTime when '240000' then '000000' else I_MaintenanceNotification.RequiredEndTime end as RequiredEndTime AS RequiredEndTimeendasRequiredEndTime,
  I_MaintenanceNotification.MaintNotifInternalID AS MaintNotifInternalID,
  I_MaintenanceNotification.NotificationTimeZone AS NotificationTimeZone,
  I_MaintenanceNotification.WorkCenterInternalID AS WorkCenterInternalID,
  I_MaintenanceNotification.WorkCenterTypeCode AS WorkCenterTypeCode,
  I_MaintenanceNotification.MaintenanceWorkCenterPlant AS MaintenanceWorkCenterPlant,
  I_MaintenanceNotification.MaintNotificationCatalog AS MaintNotificationCatalog,
  I_MaintenanceNotification.MaintNotificationCode AS MaintNotificationCode,
  I_MaintenanceNotification.MaintNotificationCodeGroup AS MaintNotificationCodeGroup,
  I_MaintenanceNotification.IsDeleted AS IsDeleted,
  I_MaintenanceNotification.IsCompleted AS IsCompleted,
  I_MaintenanceNotification.CatalogProfile AS CatalogProfile,
  I_MaintenanceNotification.NotificationOrigin AS NotificationOrigin,
  _PMNotifMaintenanceData.MaintenanceTaskListType AS MaintenanceTaskListType,
  _PMNotifMaintenanceData.TaskListGroup AS TaskListGroup,
  _PMNotifMaintenanceData.TaskListGroupCounter AS TaskListGroupCounter,
  I_MaintenanceNotification._PMNotifMaintenanceData.MalfunctionEffect AS MalfunctionEffect,
  I_MaintenanceNotification._PMNotifMaintenanceData.LocationDescription AS LocationDescription,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintenanceObjectIsDown AS MaintenanceObjectIsDown,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintObjectDowntimeDuration AS MaintObjectDowntimeDuration,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintObjDowntimeDurationUnit AS MaintObjDowntimeDurationUnit,
  I_MaintenanceNotification._PMNotifMaintenanceData._LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  I_MaintenanceNotification._PMNotifMaintenanceData.Equipment AS Equipment,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintenanceItem AS MaintenanceItem,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintenancePlan AS MaintenancePlan,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintenanceActivityType AS MaintenanceActivityType,
  cast('' as pm_source_appl) AS MaintNotifSourceApplication,
  NotificationHasLongText,
  I_MaintenanceNotification._PMNotifMaintenanceData.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
  I_MaintenanceNotification._PMNotifMaintenanceData.PreviousFinalDueDate AS PreviousFinalDueDate,
  I_MaintenanceNotification.MaintNotifExtReferenceNumber AS MaintNotifExtReferenceNumber,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  I_MaintenanceNotification._CreatedByUser AS _CreatedByUser,
  I_MaintenanceNotification._IsCompleted AS _IsCompleted,
  I_MaintenanceNotification._IsDeleted AS _IsDeleted,
  I_MaintenanceNotification._StatusObject AS _StatusObject,
  I_MaintenanceNotification._LastChangedByUser AS _LastChangedByUser,
  I_MaintenanceNotification._MaintenanceOrder AS _MaintenanceOrder,
  I_MaintenanceNotification._MaintenanceWorkCenterPlant AS _MaintenanceWorkCenterPlant,
  I_MaintenanceNotification._MaintNotificationCatalog AS _MaintNotificationCatalog,
  I_MaintenanceNotification._MaintNotificationCode AS _MaintNotificationCode,
  I_MaintenanceNotification._MaintNotificationCodeGroup AS _MaintNotificationCodeGroup,
  I_MaintenanceNotification._MainWorkCenter AS _MainWorkCenter,
  I_MaintenanceNotification._PMNotificationPhase AS _PMNotificationPhase,
  I_MaintenanceNotification._PMNotificationPriority AS _PMNotificationPriority,
  I_MaintenanceNotification._PMNotificationPriorityType AS _PMNotificationPriorityType,
  I_MaintenanceNotification._PMNotificationType AS _PMNotificationType,
  I_MaintenanceNotification._PMNotifMaintenanceData AS _PMNotifMaintenanceData,
  I_MaintenanceNotification._ReportedByUser AS _ReportedByUser,
  I_MaintenanceNotification._MaintenancePartner AS _MaintenancePartner,
  I_MaintenanceNotification._PMNotifMaintenanceData._MalfunctionEffect AS _MalfunctionEffect,
  I_MaintenanceNotification._PMNotifMaintenanceData._LocationAccountAssignment._FunctionalLocation AS _FunctionalLocation,
  I_MaintenanceNotification._PMNotifMaintenanceData._Equipment AS _Equipment,
  I_MaintenanceNotification._WorkCenterType AS _WorkCenterType,
  I_MaintenanceNotification._StatusObjectActiveStatus AS _StatusObjectActiveStatus,
  I_MaintenanceNotification._PMNotifMaintenanceData._LocationAccountAssignment AS _LocationAccountAssignment
FROM I_MaintenanceNotification
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObject ON _TechnicalObject.TechnicalObject = TechnicalObject AND _TechnicalObject.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_MaintNotifItemTechObj AS _MaintenanceNotificationItem ON _MaintenanceNotificationItem.MaintenanceNotification = MaintenanceNotification  -- association [0..*]
LEFT OUTER JOIN I_MaintNotifActivityTechObj AS _MaintNotificationActivity ON _MaintNotificationActivity.MaintenanceNotification = MaintenanceNotification  -- association [0..*]
LEFT OUTER JOIN I_MaintNotifTaskTechObj AS _MaintenanceNotificationTask ON _MaintenanceNotificationTask.MaintenanceNotification = MaintenanceNotification  -- association [0..*]
LEFT OUTER JOIN I_MaintNotifLongText AS _MaintNotifLongText ON _MaintNotifLongText.MaintenanceNotification = MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceItemTechObj AS _MaintenanceItemTechObj ON _MaintenanceItemTechObj.MaintenanceItem = maintenanceitem  -- association [0..1]
LEFT OUTER JOIN I_PMContactCardUser AS _PMContactCardUser ON _PMContactCardUser.UserID = ReportedByUser  -- association [0..1]
LEFT OUTER JOIN I_WorkforcePerson AS _MaintNotifPersonResponsible ON _MaintNotifPersonResponsible.PersonExternalID = PersonResponsible  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON _FunctionalLocationLabel.FunctionalLocation = functionallocation  -- association [0..1]
LEFT OUTER JOIN I_NotificationType AS _NotificationType ON NotificationType = _NotificationType.NotificationType  -- association [1..1]
LEFT OUTER JOIN I_UserDescription AS _UserDescription ON _UserDescription.UserID = ReportedByUser  -- association [0..1]
LEFT OUTER JOIN I_OrdMstrData AS _MaintOrdMstrData ON _MaintOrdMstrData.OrderID = MaintenanceOrder  -- association [0..1]
;