R_MaintNotificationItemCauseTP

DDL: R_MAINTNOTIFICATIONITEMCAUSETP SQL: RNOTIFITEMCAUSE Type: view_entity TRANSACTIONAL

Maintenance Notification Item Cause

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

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintNotifCauseTechObj I_MaintNotifCauseTechObj from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_MaintenanceNotificationTP _Notif $projection.MaintenanceNotification = _Notif.MaintenanceNotification
[0..1] I_EAMRootCause _MaintNotificationRootCause $projection.MaintNotificationRootCause = _MaintNotificationRootCause.MaintNotificationRootCause

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Notification Item Cause 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 (18)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification MaintenanceNotification
KEY MaintenanceNotificationItem MaintenanceNotificationItem
KEY MaintenanceNotificationCause MaintenanceNotificationCause
MaintNotifCauseText MaintNotifCauseText
MaintNotifCauseCodeGroup MaintNotifCauseCodeGroup
MaintNotificationCauseCode MaintNotificationCauseCode
MaintNotifCauseCodeCatalog MaintNotifCauseCodeCatalog
MaintNotificationRootCause MaintNotificationRootCause
IsDeleted IsDeleted
MaintNotifItmCauseCrtnDateTime
MaintNotifItmCauseChgdDateTime
_Item _Item
_Notif _Notif
_IsDeleted _IsDeleted
_MaintNotifCauseCodeGroup _MaintNotifCauseCodeGroup
_MaintNotificationCauseCode _MaintNotificationCauseCode
_MaintenanceNotification _MaintenanceNotification
_MaintNotificationRootCause _MaintNotificationRootCause 
//@AbapCatalog.sqlViewName: 'RNOTIFITEMCAUSE'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Notification Item Cause'
@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_MaintNotificationItemCauseTP as select from I_MaintNotifCauseTechObj 

// Root 

   association [1..1] to R_MaintenanceNotificationTP    as _Notif         on  $projection.MaintenanceNotification = _Notif.MaintenanceNotification
//Parent

    association to parent R_MaintNotificationItemTP as _Item on _Item.MaintenanceNotification = $projection.MaintenanceNotification
                                                                    and _Item.MaintenanceNotificationItem = $projection.MaintenanceNotificationItem

     association [0..1] to I_EAMRootCause                as _MaintNotificationRootCause  on  $projection.MaintNotificationRootCause = _MaintNotificationRootCause.MaintNotificationRootCause

{
    
//  Maintenance Notification   

    key MaintenanceNotification, 
    
//  Maintenance Notification Item 

    key MaintenanceNotificationItem, 
    
//  Maintenance Notification Cause

    key MaintenanceNotificationCause, 
    
//  Cause Text  

    MaintNotifCauseText, 

//  Cause Code Group

    MaintNotifCauseCodeGroup,
    
//  Cause Code  

    MaintNotificationCauseCode,
    
    
//  Cause Code Catalog  

@Consumption: { hidden: true }
    MaintNotifCauseCodeCatalog,
    
    MaintNotificationRootCause,
    @Semantics.booleanIndicator: true
    IsDeleted,
    cast (dats_tims_to_tstmp( CreationDate, TimeOfCreation, abap_system_timezone( $session.client,'NULL' ) , $session.client, 'NULL') as  tzntstmps preserving type )         as MaintNotifItmCauseCrtnDateTime,
     cast (dats_tims_to_tstmp( LastChangeDate, LastChangeTime, abap_system_timezone( $session.client,'NULL' ) , $session.client, 'NULL') as  tzntstmps preserving type )         as MaintNotifItmCauseChgdDateTime,                       
    
    
// Root View 

    _Item,
    _Notif,
    
// Association 

   _IsDeleted,
   _MaintNotifCauseCodeGroup,
   _MaintNotificationCauseCode,
   _MaintenanceNotification,
   _MaintNotificationRootCause
       
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTNOTIFCAUSETECHOBJ"
],
"ASSOCIATED":
[
"I_EAMROOTCAUSE",
"I_INDICATOR",
"I_INSPECTIONCODE",
"I_INSPECTIONCODEGROUP",
"I_MAINTENANCENOTIFICATION",
"R_MAINTENANCENOTIFICATIONTP",
"R_MAINTNOTIFICATIONITEMTP"
],
"BASE":
[
"I_MAINTNOTIFCAUSETECHOBJ"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More