R_MaintNotificationActivityTP

DDL: R_MAINTNOTIFICATIONACTIVITYTP Type: view_entity TRANSACTIONAL

Maintenance Notification Activity

R_MaintNotificationActivityTP is a Transactional CDS View that provides data about "Maintenance Notification Activity" in SAP S/4HANA. It reads from 1 data source (I_MaintNotificationActivity) and exposes 22 fields with key fields MaintNotificationActivity, MaintenanceNotification.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintNotificationActivity I_MaintNotificationActivity from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Notification Activity view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY MaintNotificationActivity MaintNotificationActivity
KEY MaintenanceNotification MaintenanceNotification
MaintenanceNotificationItem MaintenanceNotificationItem
MaintNotifActivitySortNumber MaintNotifActivitySortNumber
MaintNotifActyTxt MaintNotifActyTxt
MaintNotifActivityCodeCatalog MaintNotifActivityCodeCatalog
MaintNotificationActivityCode MaintNotificationActivityCode
MaintNotifActivityCodeGroup MaintNotifActivityCodeGroup
IsDeleted IsDeleted
PlannedStartDate PlannedStartDate
PlannedStartTime PlannedStartTime
PlannedEndDate PlannedEndDate
PlannedEndTime PlannedEndTime
MaintNotifActyStartDateTime
MaintNotifActivityEndDateTime
MaintNotifActivityCrtnDateTime
MaintNotifActivityChgdDateTime
_Notif _Notif
_MaintenanceNotification _MaintenanceNotification
_MaintenanceNotificationItem _MaintenanceNotificationItem
_MaintNotifActivityCodeGroup _MaintNotifActivityCodeGroup
_MaintNotificationActivityCode _MaintNotificationActivityCode 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Notification Activity'
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #TRANSACTIONAL

@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MASTER}

define view entity R_MaintNotificationActivityTP
  as select from I_MaintNotificationActivity

  //Parent

  association to parent R_MaintenanceNotificationTP as _Notif on _Notif.MaintenanceNotification = $projection.MaintenanceNotification

{

  key MaintNotificationActivity,
  key MaintenanceNotification,
      MaintenanceNotificationItem,   //Damages Number (Sort number for Item)

      MaintNotifActivitySortNumber,  //Activity Number (Sort number for Activity)

      MaintNotifActyTxt,             //Activity Description

      MaintNotifActivityCodeCatalog,
      MaintNotificationActivityCode, //Activity Code

      MaintNotifActivityCodeGroup,   //Code Group - Activities

      @Semantics.booleanIndicator: true
      IsDeleted,
      PlannedStartDate, //Activity Start Date

      PlannedStartTime, //Start Time of Activity

      PlannedEndDate,   //Activity End Date

      PlannedEndTime,   //End Time of Activity

      cast (dats_tims_to_tstmp( PlannedStartDate, PlannedStartTime, I_MaintNotificationActivity._MaintenanceNotification.NotificationTimeZone , $session.client, 'NULL') as  tzntstmps preserving type ) as MaintNotifActyStartDateTime,
      cast (dats_tims_to_tstmp( PlannedEndDate, PlannedEndTime, I_MaintNotificationActivity._MaintenanceNotification.NotificationTimeZone , $session.client, 'NULL') as  tzntstmps preserving type )     as MaintNotifActivityEndDateTime,
      cast (dats_tims_to_tstmp( CreationDate, CreationTime, abap_system_timezone( $session.client,'NULL' ) , $session.client, 'NULL') as  tzntstmps preserving type )         as MaintNotifActivityCrtnDateTime,
      cast (dats_tims_to_tstmp( LastChangeDate, LastChangeTime,abap_system_timezone( $session.client,'NULL' ) , $session.client, 'NULL') as  tzntstmps preserving type )     as MaintNotifActivityChgdDateTime,

      // Parent View

      _Notif,

      //Associations

      _MaintenanceNotification,
      _MaintenanceNotificationItem,
      //      _MaintNotifActivityCodeCatalog,

      _MaintNotifActivityCodeGroup,
      _MaintNotificationActivityCode
      //      _IsDeleted

}
where
  MaintenanceNotificationItem is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCENOTIFICATION",
"I_MAINTNOTIFICATIONACTIVITY"
],
"ASSOCIATED":
[
"I_INSPECTIONCODE",
"I_INSPECTIONCODEGROUP",
"I_MAINTENANCENOTIFICATION",
"I_MAINTENANCENOTIFICATIONITEM",
"R_MAINTENANCENOTIFICATIONTP"
],
"BASE":
[
"I_MAINTNOTIFICATIONACTIVITY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More