I_MaintNotifActivityBasic

DDL: I_MAINTNOTIFACTIVITYBASIC Type: view_entity BASIC Package: VDM_EAM_NTF

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.

2 data source(s) 26 fields

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
KEY MaintNotificationActivity qmma manum
MaintenanceNotificationItem qmma fenum
MaintNotifActivitySortNumber qmma qmanum
MaintNotifActivityCodeVersNmbr qmma mnver
MaintNotifActivityCodeCatalog qmma mnkat
MaintNotifActivityCodeGroup qmma mngrp
MaintNotificationActivityCode qmma mncod
MaintNotifActyTxt qmma matxt
NotificationHasLongText qmma indtx
MaintNotifActivityTxtLanguage qmma kzmla
MaintNotifActivityStartDate qmma pster
MaintNotifActivityStartTime qmma pstur
MaintNotifActivityEndDate qmma peter
MaintNotifActivityEndTime qmma petur
MaintNotifActyQtyFactor qmma mngfa
MaintNotifActyIsCreatedByCopy qmma autkz
IsDeleted qmma kzloesch
NotificationTimeZone qmel tzonso
CreatedByUser qmma ernam
CreationDate qmma erdat
CreationTime qmma erzeit
LastChangedByUser qmma aenam
LastChangeDate qmma aedat
LastChangeTime qmma aezeit
LastChangeDateTime qmma changeddatetime 
@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Maintenance Notification Activity'

@ObjectModel.semanticKey: [ 'MaintenanceNotification', 'MaintNotificationActivity' ]
@ObjectModel.usageType: { dataClass: #TRANSACTIONAL, serviceQuality: #A, sizeCategory: #L }

@VDM.viewType: #BASIC

define view entity I_MaintNotifActivityBasic
  as select from qmma as NotificationActivity

    inner join   qmel as Notification         on NotificationActivity.qmnum = Notification.qmnum

{
  key NotificationActivity.qmnum           as MaintenanceNotification,
  key NotificationActivity.manum           as MaintNotificationActivity,

      NotificationActivity.fenum           as MaintenanceNotificationItem,

      // Activity Data

      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,

      // Admintrative Data

      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
}

where

  // ** Only PM relevant Notifications

      (   Notification.herkz = '01' // General Maintenance Notification

       or Notification.herkz = '02' // Malfunction Report

       or Notification.herkz = '03' // Activity Report

      )

Learn More