I_MaintNotificationActivity

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_MaintNotificationActivity.
-- 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: IMAINTNOTIFACTV

CREATE VIEW I_MaintNotificationActivity AS
SELECT
  qmma.manum AS MaintNotificationActivity,
  qmma.qmnum AS MaintenanceNotification,
  qmma.fenum AS MaintenanceNotificationItem,
  qmma.matxt AS MaintNotifActyTxt,
  qmma.qmanum AS MaintNotifActivitySortNumber,
  cast( qmma.mnkat as eam_activity_code_catalog ) AS MaintNotifActivityCodeCatalog,
  cast( qmma.mncod as eam_activity_code ) AS MaintNotificationActivityCode,
  cast( qmma.mngrp as eam_activity_code_group ) AS MaintNotifActivityCodeGroup,
  qmma.kzloesch AS IsDeleted,
  qmma.ernam AS CreatedByUser,
  case qmma.pstur when '240000' then dats_add_days(qmma.pster,1,'NULL') else qmma.pster end as PlannedStartDate AS psterendasPlannedStartDate,
  case qmma.pstur when '240000' then '000000' else qmma.pstur end as PlannedStartTime AS psturendasPlannedStartTime,
  case qmma.petur when '240000' then dats_add_days(qmma.peter,1,'NULL') else qmma.peter end as PlannedEndDate AS peterendasPlannedEndDate,
  case qmma.petur when '240000' then '000000' else qmma.petur end as PlannedEndTime AS peturendasPlannedEndTime,
  case qmma.erzeit when '240000' then dats_add_days(qmma.erdat,1,'NULL') else qmma.erdat end as CreationDate AS erdatendasCreationDate,
  case qmma.erzeit when '240000' then '000000' else qmma.erzeit end as CreationTime AS erzeitendasCreationTime,
  case qmma.aezeit when '240000' then dats_add_days(qmma.aedat,1,'NULL') else qmma.aedat end as LastChangeDate AS aedatendasLastChangeDate,
  case qmma.aezeit when '240000' then '000000' else qmma.aezeit end as LastChangeTime AS aezeitendasLastChangeTime,
  qmma.mngfa AS MaintNotifActyQtyFactor,
  qmma.changeddatetime AS LastChangeDateTime,
  qmma.aenam AS LastChangedByUser,
  qmma.peter AS MaintNotifActivityEndDate,
  qmma.indtx AS NotificationHasLongText
FROM qmma
LEFT OUTER JOIN I_MaintenanceNotification AS _MaintenanceNotification ON MaintenanceNotification = _MaintenanceNotification.MaintenanceNotification  -- association [1..1]
LEFT OUTER JOIN I_MaintenanceNotificationItem AS _MaintenanceNotificationItem ON MaintenanceNotification = _MaintenanceNotificationItem.MaintenanceNotification AND MaintenanceNotificationItem = _MaintenanceNotificationItem.MaintenanceNotificationItem  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsDeleted ON IsDeleted = _IsDeleted.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Inspectioncatalog AS _MaintNotifActivityCodeCatalog ON MaintNotifActivityCodeCatalog = _MaintNotifActivityCodeCatalog.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_InspectionCodeGroup AS _MaintNotifActivityCodeGroup ON MaintNotifActivityCodeGroup = _MaintNotifActivityCodeGroup.InspectionCodeGroup AND MaintNotifActivityCodeCatalog = _MaintNotifActivityCodeGroup.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_InspectionCode AS _MaintNotificationActivityCode ON MaintNotificationActivityCode = _MaintNotificationActivityCode.InspectionCode AND MaintNotifActivityCodeCatalog = _MaintNotificationActivityCode.InspectionCatalog AND MaintNotifActivityCodeGroup = _MaintNotificationActivityCode.InspectionCodeGroup  -- association [0..1]
;