R_MaintNotificationItemTP

DDL: R_MAINTNOTIFICATIONITEMTP SQL: RMAINTNTFITEMTP Type: view_entity TRANSACTIONAL

Maintenance Notification Item

R_MaintNotificationItemTP is a Transactional CDS View that provides data about "Maintenance Notification Item" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceNotificationItem) and exposes 22 fields with key fields MaintenanceNotification, MaintenanceNotificationItem. It has 3 associations to related views.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceNotificationItem I_MaintenanceNotificationItem from

Associations (3)

CardinalityTargetAliasCondition
[0..*] R_MaintNotificationItemCauseTP _ItemCause
[0..*] R_MaintNotifItemActivityTP _ItemActivity
[0..*] R_MaintNotificationItemTaskTP _ItemTask

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Notification Item 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 MaintenanceNotification MaintenanceNotification
KEY MaintenanceNotificationItem MaintenanceNotificationItem
MaintNotifItemText MaintNotifItemText
MaintNotifDamageCodeGroup MaintNotifDamageCodeGroup
MaintNotificationDamageCode MaintNotificationDamageCode
MaintNotifDamageCodeCatalog MaintNotifDamageCodeCatalog
MaintNotifObjPrtCodeGroup MaintNotifObjPrtCodeGroup
MaintNotifObjPrtCode MaintNotifObjPrtCode
MaintNotifObjPrtCodeCatalog MaintNotifObjPrtCodeCatalog
IsDeleted IsDeleted
MaintNotifItemCreationDateTime
MaintNotifItemChangedDateTime
_Notif _Notif
_ItemCause _ItemCause
_ItemActivity _ItemActivity
_ItemTask _ItemTask
_MaintNotifDamageCodeGroup _MaintNotifDamageCodeGroup
_MaintNotifObjPrtCodeGroup _MaintNotifObjPrtCodeGroup
_MaintNotificationDamageCode _MaintNotificationDamageCode
_MaintNotifObjPrtCode _MaintNotifObjPrtCode
_MaintenanceNotification _MaintenanceNotification
_IsDeleted _IsDeleted 
//@AbapCatalog.sqlViewName: 'RMAINTNTFITEMTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Notification Item'
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true
//@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #TRANSACTIONAL

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

define view entity R_MaintNotificationItemTP
  as select from I_MaintenanceNotificationItem

  //Parent

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

  // Child

  composition [0..*] of R_MaintNotificationItemCauseTP as _ItemCause

  composition [0..*] of R_MaintNotifItemActivityTP     as _ItemActivity

  composition [0..*] of R_MaintNotificationItemTaskTP  as _ItemTask
{

      //   Maintenance Notification

  key MaintenanceNotification,

      //   Maintenance Notification Item

  key MaintenanceNotificationItem,

      //   Damage Description

      MaintNotifItemText,

      // Damage Code Group

      MaintNotifDamageCodeGroup,

      // Damage Code

      MaintNotificationDamageCode,


      @Consumption: { hidden: true }
      //  Damage Code Catalog

      MaintNotifDamageCodeCatalog,

      // Object Part Code Group

      MaintNotifObjPrtCodeGroup,


      // Object Part Code

      MaintNotifObjPrtCode,


      @Consumption: { hidden: true }
      // Object Part Code Catalog

      MaintNotifObjPrtCodeCatalog,
      @Semantics.booleanIndicator: true
      IsDeleted,
       cast (dats_tims_to_tstmp( CreationDate, CreationTime, abap_system_timezone( $session.client,'NULL' ) , $session.client, 'NULL') as  tzntstmps preserving type )         as MaintNotifItemCreationDateTime, 
       cast (dats_tims_to_tstmp( LastChangeDate, LastChangeTime, abap_system_timezone( $session.client,'NULL' ) , $session.client, 'NULL') as  tzntstmps preserving type )         as MaintNotifItemChangedDateTime,                       

      // Root View

      _Notif,

      // Child

      _ItemCause,
      _ItemActivity,
      _ItemTask,

      // Association

      _MaintNotifDamageCodeGroup,
      _MaintNotifObjPrtCodeGroup,
      _MaintNotificationDamageCode,
      _MaintNotifObjPrtCode,
      _MaintenanceNotification,
      _IsDeleted

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCENOTIFICATIONITEM"
],
"ASSOCIATED":
[
"I_INDICATOR",
"I_INSPECTIONCODE",
"I_INSPECTIONCODEGROUP",
"I_MAINTENANCENOTIFICATION",
"R_MAINTENANCENOTIFICATIONTP",
"R_MAINTNOTIFICATIONITEMCAUSETP",
"R_MAINTNOTIFICATIONITEMTASKTP",
"R_MAINTNOTIFITEMACTIVITYTP"
],
"BASE":
[
"I_MAINTENANCENOTIFICATIONITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More