I_MaintNotificationTaskBasic

DDL: I_MAINTNOTIFICATIONTASKBASIC Type: view_entity BASIC Package: VDM_EAM_NTF
26 Fields 2 Data Sources

Maintenance Notification Tasks

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

Data Sources (2)

SourceAliasJoin Type
qmel Notification inner
qmsm NotificationTask from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Maintenance Notification Tasks view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification qmsm qmnum Notification
KEY MaintenanceNotificationTask qmsm manum Task
MaintenanceNotificationItem qmsm fenum Number of days
MaintNotifTaskCodeCatalog qmsm mnkat Catalog type
MaintNotifTaskCodeGroup qmsm mngrp Code Group
MaintNotifTaskCode qmsm mncod Task Code
MaintNotifTaskTxt qmsm matxt Task Text
ResponsiblePersonFunctionCode
ResponsiblePerson
NotificationTaskSortNumber qmsm qsmnum Sort Number
PlannedStartDate qmsm pster Start
PlannedStartTime qmsm pstur Time
PlannedEndDate qmsm peter Planned End
PlannedEndTime qmsm petur Time
CompletionDate qmsm erldat Completed On
CompletionTime qmsm erlzeit Completion Time
CompletedByUser qmsm erlnam Completed By
IsDeleted qmsm kzloesch Delete
MaintNotifTaskInternalID qmsm objnr Val. Obj. No.
CreatedByUser qmsm ernam User Name
CreationDate qmsm erdat Entered On
CreationTime qmsm erzeit Time created
LastChangedByUser qmsm aenam User Name
LastChangeDate qmsm aedat Obsolete
LastChangeTime qmsm aezeit Time changed
NotificationTimeZone qmel tzonso Notif.Time.Zone

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_MaintNotificationTaskBasic.
-- 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_MaintNotificationTaskBasic AS
SELECT
  NotificationTask.qmnum AS MaintenanceNotification,
  NotificationTask.manum AS MaintenanceNotificationTask,
  NotificationTask.fenum AS MaintenanceNotificationItem,
  NotificationTask.mnkat AS MaintNotifTaskCodeCatalog,
  NotificationTask.mngrp AS MaintNotifTaskCodeGroup,
  NotificationTask.mncod AS MaintNotifTaskCode,
  NotificationTask.matxt AS MaintNotifTaskTxt,
  cast(NotificationTask.parvw as parvw_unv) AS ResponsiblePersonFunctionCode,
  cast(NotificationTask.parnr as ps_vernr) AS ResponsiblePerson,
  NotificationTask.qsmnum AS NotificationTaskSortNumber,
  NotificationTask.pster AS PlannedStartDate,
  NotificationTask.pstur AS PlannedStartTime,
  NotificationTask.peter AS PlannedEndDate,
  NotificationTask.petur AS PlannedEndTime,
  NotificationTask.erldat AS CompletionDate,
  NotificationTask.erlzeit AS CompletionTime,
  NotificationTask.erlnam AS CompletedByUser,
  NotificationTask.kzloesch AS IsDeleted,
  NotificationTask.objnr AS MaintNotifTaskInternalID,
  NotificationTask.ernam AS CreatedByUser,
  NotificationTask.erdat AS CreationDate,
  NotificationTask.erzeit AS CreationTime,
  NotificationTask.aenam AS LastChangedByUser,
  NotificationTask.aedat AS LastChangeDate,
  NotificationTask.aezeit AS LastChangeTime,
  Notification.tzonso AS NotificationTimeZone
FROM qmsm AS NotificationTask
INNER JOIN qmel AS Notification ON /* join condition not captured in parsed metadata */
;

Learn More