I_MaintNotifActivityBasic

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

Maintenance Notification Activity

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

Data Sources (2)

SourceAliasJoin Type
qmel Notification inner
qmma NotificationActivity from

Annotations (6)

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

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification qmma qmnum Notification
KEY MaintNotificationActivity qmma manum Task
MaintenanceNotificationItem qmma fenum Number of days
MaintNotifActivitySortNumber qmma qmanum Sort Number
MaintNotifActivityCodeVersNmbr qmma mnver Version
MaintNotifActivityCodeCatalog qmma mnkat Catalog type
MaintNotifActivityCodeGroup qmma mngrp Code Group
MaintNotificationActivityCode qmma mncod Task Code
MaintNotifActyTxt qmma matxt Task Text
NotificationHasLongText qmma indtx Long text
MaintNotifActivityTxtLanguage qmma kzmla Primary lang.
MaintNotifActivityStartDate qmma pster Start
MaintNotifActivityStartTime qmma pstur Time
MaintNotifActivityEndDate qmma peter Planned End
MaintNotifActivityEndTime qmma petur Time
MaintNotifActyQtyFactor qmma mngfa Quantity Factor
MaintNotifActyIsCreatedByCopy qmma autkz Object autom.
IsDeleted qmma kzloesch Delete
NotificationTimeZone qmel tzonso Notif.Time.Zone
CreatedByUser qmma ernam User Name
CreationDate qmma erdat Entered On
CreationTime qmma erzeit Time created
LastChangedByUser qmma aenam User Name
LastChangeDate qmma aedat Obsolete
LastChangeTime qmma aezeit Time changed
LastChangeDateTime qmma 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_MaintNotifActivityBasic.
-- 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_MaintNotifActivityBasic AS
SELECT
  NotificationActivity.qmnum AS MaintenanceNotification,
  NotificationActivity.manum AS MaintNotificationActivity,
  NotificationActivity.fenum AS MaintenanceNotificationItem,
  NotificationActivity.qmanum AS MaintNotifActivitySortNumber,
  NotificationActivity.mnver AS MaintNotifActivityCodeVersNmbr,
  NotificationActivity.mnkat AS MaintNotifActivityCodeCatalog,
  NotificationActivity.mngrp AS MaintNotifActivityCodeGroup,
  NotificationActivity.mncod AS MaintNotificationActivityCode,
  NotificationActivity.matxt AS MaintNotifActyTxt,
  NotificationActivity.indtx AS NotificationHasLongText,
  NotificationActivity.kzmla AS MaintNotifActivityTxtLanguage,
  NotificationActivity.pster AS MaintNotifActivityStartDate,
  NotificationActivity.pstur AS MaintNotifActivityStartTime,
  NotificationActivity.peter AS MaintNotifActivityEndDate,
  NotificationActivity.petur AS MaintNotifActivityEndTime,
  NotificationActivity.mngfa AS MaintNotifActyQtyFactor,
  NotificationActivity.autkz AS MaintNotifActyIsCreatedByCopy,
  NotificationActivity.kzloesch AS IsDeleted,
  Notification.tzonso AS NotificationTimeZone,
  NotificationActivity.ernam AS CreatedByUser,
  NotificationActivity.erdat AS CreationDate,
  NotificationActivity.erzeit AS CreationTime,
  NotificationActivity.aenam AS LastChangedByUser,
  NotificationActivity.aedat AS LastChangeDate,
  NotificationActivity.aezeit AS LastChangeTime,
  NotificationActivity.changeddatetime AS LastChangeDateTime
FROM qmma AS NotificationActivity
INNER JOIN qmel AS Notification ON /* join condition not captured in parsed metadata */
;

Learn More