I_MaintNotificationItemBasic

DDL: I_MAINTNOTIFICATIONITEMBASIC Type: view_entity BASIC Package: VDM_EAM_NTF
22 Fields 2 Data Sources

Maintenance Notification Basic

I_MaintNotificationItemBasic is a Basic CDS View that provides data about "Maintenance Notification Basic" in SAP S/4HANA. It reads from 2 data sources (qmel, qmfe) and exposes 22 fields with key fields MaintenanceNotification, MaintenanceNotificationItem. Part of development package VDM_EAM_NTF.

Data Sources (2)

SourceAliasJoin Type
qmel Notification inner
qmfe NotificationItem from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Maintenance Notification Basic view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification qmfe qmnum Notification
KEY MaintenanceNotificationItem qmfe fenum Number of days
MaintNotifItemText qmfe fetxt Text
MaintNotifItemTxtLanguage qmfe kzmla Primary lang.
MaintNotifDamageCodeCatalog
MaintNotifDamageCodeGroup
MaintNotificationDamageCode
MaintNotifDamageCodeVersNumber qmfe fever Version
MaintNotifObjPrtCodeCatalog
MaintNotifObjPrtCodeGroup
MaintNotifObjPrtCode
MaintNotifObjectCodeVersNmbr qmfe otver Version
Assembly qmfe bautl Cause Assembly
IsDeleted qmfe kzloesch Delete
NotificationItemExternalID qmfe posnr WBS Element
CreatedByUser qmfe ernam User Name
CreationDate qmfe erdat Entered On
CreationTime qmfe erzeit Time created
LastChangedByUser qmfe aenam User Name
LastChangeDate qmfe aedat Obsolete
LastChangeTime qmfe aezeit Time changed
LastChangeDateTime qmfe changeddatetime Time Stamp

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_MaintNotificationItemBasic.
-- 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_MaintNotificationItemBasic AS
SELECT
  NotificationItem.qmnum AS MaintenanceNotification,
  NotificationItem.fenum AS MaintenanceNotificationItem,
  NotificationItem.fetxt AS MaintNotifItemText,
  NotificationItem.kzmla AS MaintNotifItemTxtLanguage,
  cast(NotificationItem.fekat as eam_damage_code_catalog preserving type) AS MaintNotifDamageCodeCatalog,
  cast(NotificationItem.fegrp as eam_damage_code_group preserving type) AS MaintNotifDamageCodeGroup,
  cast(NotificationItem.fecod as eam_damage_code preserving type) AS MaintNotificationDamageCode,
  NotificationItem.fever AS MaintNotifDamageCodeVersNumber,
  cast(NotificationItem.otkat as eam_object_part_code_catalog preserving type) AS MaintNotifObjPrtCodeCatalog,
  cast(NotificationItem.otgrp as eam_object_part_code_group preserving type) AS MaintNotifObjPrtCodeGroup,
  cast(NotificationItem.oteil as eam_object_part_code preserving type) AS MaintNotifObjPrtCode,
  NotificationItem.otver AS MaintNotifObjectCodeVersNmbr,
  NotificationItem.bautl AS Assembly,
  NotificationItem.kzloesch AS IsDeleted,
  NotificationItem.posnr AS NotificationItemExternalID,
  NotificationItem.ernam AS CreatedByUser,
  NotificationItem.erdat AS CreationDate,
  NotificationItem.erzeit AS CreationTime,
  NotificationItem.aenam AS LastChangedByUser,
  NotificationItem.aedat AS LastChangeDate,
  NotificationItem.aezeit AS LastChangeTime,
  NotificationItem.changeddatetime AS LastChangeDateTime
FROM qmfe AS NotificationItem
INNER JOIN qmel AS Notification ON /* join condition not captured in parsed metadata */
;

Learn More