I_MaintenanceNotificationItem

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_MaintenanceNotificationItem.
-- 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: IMAINTNOTIFITEM

CREATE VIEW I_MaintenanceNotificationItem AS
SELECT
  qmfe.fenum AS MaintenanceNotificationItem,
  qmfe.qmnum AS MaintenanceNotification,
  qmfe.fetxt AS MaintNotifItemText,
  cast( qmfe.fekat as eam_damage_code_catalog ) AS MaintNotifDamageCodeCatalog,
  cast( qmfe.fecod as eam_damage_code ) AS MaintNotificationDamageCode,
  cast( qmfe.fegrp as eam_damage_code_group ) AS MaintNotifDamageCodeGroup,
  cast( qmfe.oteil as eam_object_part_code ) AS MaintNotifObjPrtCode,
  cast( qmfe.otgrp as eam_object_part_code_group ) AS MaintNotifObjPrtCodeGroup,
  cast( qmfe.otkat as eam_object_part_code_catalog ) AS MaintNotifObjPrtCodeCatalog,
  qmfe.feqklas AS DefectClass,
  qmfe.bautl AS Assembly,
  qmfe.anzfehler AS NumberOfDefects,
  concat(qmfe.qmnum, qmfe.fenum) AS ObjectKey,
  qmfe.changeddatetime AS LastChangeDateTime,
  qmfe.kzloesch AS IsDeleted,
  case qmfe.erzeit when '240000' then dats_add_days(qmfe.erdat,1,'NULL') else qmfe.erdat end as CreationDate AS erdatendasCreationDate,
  case qmfe.erzeit when '240000' then '000000' else qmfe.erzeit end as CreationTime AS erzeitendasCreationTime,
  case qmfe.aezeit when '240000' then dats_add_days(qmfe.aedat,1,'NULL') else qmfe.aedat end as LastChangeDate AS aedatendasLastChangeDate,
  case qmfe.aezeit when '240000' then '000000' else qmfe.aezeit end as LastChangeTime AS aezeitendasLastChangeTime
FROM qmfe
LEFT OUTER JOIN I_Material AS _Assembly ON Assembly = _Assembly.Material  -- association [0..1]
LEFT OUTER JOIN I_DefectClass AS _DefectClass ON DefectClass = _DefectClass.DefectClass  -- association [0..1]
;