I_NotificationActivity

DDL: I_NOTIFICATIONACTIVITY Type: view_entity BASIC Package: VDM_QM_NOTIFICATION
28 Fields 1 Data Sources

Notification Activity

I_NotificationActivity is a Basic CDS View that provides data about "Notification Activity" in SAP S/4HANA. It reads from 1 data source (qmma) and exposes 28 fields with key fields Notification, NotificationActivity. Part of development package VDM_QM_NOTIFICATION.

Data Sources (1)

SourceAliasJoin Type
qmma qmma from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #BASIC view
EndUserText.label Notification Activity view
ObjectModel.representativeKey NotificationActivity view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
Analytics.technicalName INOTIFACT view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY Notification qmnum Notification
KEY NotificationActivity manum Task
NotificationItem fenum Number of days
NotificationActivitySortNumber qmanum Sort Number
IsDeleted kzloesch Delete
MasterLanguage kzmla Primary lang.
NotifActivityCatalog mnkat Catalog type
NotifActivityCodeGroup mngrp Code Group
NotifActivityCode mncod Task Code
NotifActivityText matxt Task Text
NotifActivityStartDate pster Start
NotifActivityStartTime pstur Time
NotifActivityEndDate peter Planned End
NotifActivityEndTime petur Time
CreatedByUser ernam User Name
CreationDate erdat Entered On
CreationTime erzeit Time created
LastChangedByUser aenam User Name
LastChangeDate aedat Obsolete
LastChangeTime aezeit Time changed
IsBusinessPurposeCompleted _Notification IsBusinessPurposeCompleted Purpose Completed
_Notification _Notification
_CreatedByUserContactCard _CreatedByUserContactCard
_LastChangedByUserContactCard _LastChangedByUserContactCard
_Language _Language
_NotifActivityCatalog _NotifActivityCatalog
_NotifActivityCodeGroup _NotifActivityCodeGroup
_NotifActivityCode _NotifActivityCode

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_NotificationActivity.
-- 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_NotificationActivity AS
SELECT
  qmnum AS Notification,
  manum AS NotificationActivity,
  fenum AS NotificationItem,
  qmanum AS NotificationActivitySortNumber,
  kzloesch AS IsDeleted,
  kzmla AS MasterLanguage,
  mnkat AS NotifActivityCatalog,
  mngrp AS NotifActivityCodeGroup,
  mncod AS NotifActivityCode,
  matxt AS NotifActivityText,
  pster AS NotifActivityStartDate,
  pstur AS NotifActivityStartTime,
  peter AS NotifActivityEndDate,
  petur AS NotifActivityEndTime,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  erzeit AS CreationTime,
  aenam AS LastChangedByUser,
  aedat AS LastChangeDate,
  aezeit AS LastChangeTime,
  _Notification.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM qmma
;

Learn More