I_MaintenanceNotificationTask

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_MaintenanceNotificationTask.
-- 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 I_MaintenanceNotificationTask AS
SELECT
  qmsm.manum AS MaintenanceNotificationTask,
  qmsm.qmnum AS MaintenanceNotification,
  qmsm.fenum AS MaintenanceNotificationItem,
  qmsm.urnum AS MaintenanceNotificationCause,
  qmsm.matxt AS MaintNotifTaskTxt,
  qmsm.mnkat AS MaintNotifTaskCodeCatalog,
  qmsm.mngrp AS MaintNotifTaskCodeGroup,
  qmsm.mncod AS MaintNotifTaskCode,
  case qmsm.pstur when '240000' then dats_add_days(qmsm.pster,1,'NULL') else qmsm.pster end as PlannedStartDate AS psterendasPlannedStartDate,
  case qmsm.pstur when '240000' then '000000' else qmsm.pstur end as PlannedStartTime AS psturendasPlannedStartTime,
  case qmsm.petur when '240000' then dats_add_days(qmsm.peter,1,'NULL') else qmsm.peter end as PlannedEndDate AS peterendasPlannedEndDate,
  case qmsm.petur when '240000' then '000000' else qmsm.petur end as PlannedEndTime AS peturendasPlannedEndTime,
  case qmsm.erzeit when '240000' then dats_add_days(qmsm.erdat,1,'NULL') else qmsm.erdat end as CreationDate AS erdatendasCreationDate,
  case qmsm.erzeit when '240000' then '000000' else qmsm.erzeit end as CreationTime AS erzeitendasCreationTime,
  case qmsm.aezeit when '240000' then dats_add_days(qmsm.aedat,1,'NULL') else qmsm.aedat end as LastChangeDate AS aedatendasLastChangeDate,
  case qmsm.aezeit when '240000' then '000000' else qmsm.aezeit end as LastChangeTime AS aezeitendasLastChangeTime,
  case qmsm.erlzeit when '240000' then dats_add_days(qmsm.erldat,1,'NULL') else qmsm.erldat end as CompletionDate AS erldatendasCompletionDate,
  case qmsm.erlzeit when '240000' then '000000' else qmsm.erlzeit end as CompletionTime AS erlzeitendasCompletionTime,
  qmsm.erlnam AS CompletedByUser,
  qmsm.parvw AS ResponsiblePersonFunctionCode,
  qmsm.parnr AS ResponsiblePerson,
  qmsm.objnr AS MaintNotifTaskInternalID,
  qmsm.kzloesch AS IsDeleted,
  qmsm.changeddatetime AS LastChangeDateTime,
  qmsm.ernam AS CreatedByUser,
  qmsm.aenam AS LastChangedByUser,
  qmsm.folgeact AS MaintNotifTaskFollowUpAction,
  qmsm.folactprot AS MaintNotifTaskHasFollowUpActn,
  qmsm.kzloesch AS MaintNotificationTaskIsDeleted,
  qmsm.wdvzeit AS MaintNotifTaskResubmissionTime,
  qmsm.qsmnum AS MaintNotifTaskSortNumber
FROM qmsm
LEFT OUTER JOIN I_MaintenanceNotification AS _MaintenanceNotification ON MaintenanceNotification = _MaintenanceNotification.MaintenanceNotification  -- association [1..1]
LEFT OUTER JOIN I_MaintenanceNotificationItem AS _MaintenanceNotificationItem ON _MaintenanceNotificationItem.MaintenanceNotification = MaintenanceNotification AND _MaintenanceNotificationItem.MaintenanceNotificationItem = MaintenanceNotificationItem  -- association [0..1]
LEFT OUTER JOIN I_StatusObject AS _StatusObject ON MaintNotifTaskInternalID = _StatusObject.StatusObject  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsDeleted ON IsDeleted = _IsDeleted.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatus AS _StatusObjectStatus ON MaintNotifTaskInternalID = _StatusObjectStatus.StatusObject  -- association [0..*]
LEFT OUTER JOIN I_InspectionCode AS _MaintNotificationTaskCode ON MaintNotifTaskCode = _MaintNotificationTaskCode.InspectionCode AND MaintNotifTaskCodeCatalog = _MaintNotificationTaskCode.InspectionCatalog AND MaintNotifTaskCodeGroup = _MaintNotificationTaskCode.InspectionCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_Inspectioncatalog AS _MaintNotifTaskCodeCatalog ON MaintNotifTaskCodeCatalog = _MaintNotifTaskCodeCatalog.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_InspectionCodeGroup AS _MaintNotifTaskCodeGroup ON MaintNotifTaskCodeGroup = _MaintNotifTaskCodeGroup.InspectionCodeGroup AND MaintNotifTaskCodeCatalog = _MaintNotifTaskCodeGroup.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON ResponsiblePersonFunctionCode = _PartnerFunction.PartnerFunction  -- association [0..1]
LEFT OUTER JOIN I_ContactPerson AS _ContactPerson ON _ContactPerson.ContactPerson = ResponsiblePerson  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON _Customer.Customer = ResponsiblePerson  -- association [0..1]
LEFT OUTER JOIN I_WorkforcePerson AS _Employee ON _Employee.PersonExternalID = ResponsiblePerson  -- association [0..1]
LEFT OUTER JOIN I_OrganizationalUnitText AS _OrganizationalUnitText ON _OrganizationalUnitText.OrganizationalUnit = ResponsiblePerson AND _OrganizationalUnitText.Language = $session.system_language AND _OrganizationalUnitText.StartDate <= $session.system_date AND _OrganizationalUnitText.EndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_PMPositionText AS _PositionText ON _PositionText.PositionID = ResponsiblePerson AND _PositionText.Language = $session.system_language AND _PositionText.StartDate <= $session.system_date AND _PositionText.EndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = ResponsiblePerson  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON _User.UserID = ResponsiblePerson  -- association [0..1]
;