I_MaintNotificationCauseTP

DDL: I_MAINTNOTIFICATIONCAUSETP SQL: INTFCAUSETETP Type: view TRANSACTIONAL

Maint. Notification Cause /w Tech. Obj.

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

Data Sources (1)

SourceAliasJoin Type
I_MaintNotifCauseTechObj Document from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_MaintNotificationTP _MaintNotificationTP _MaintNotificationTP.MaintenanceNotification = $projection.MaintenanceNotification
[1..1] I_MaintNotificationItemTP _MaintNotificationItemTP _MaintNotificationItemTP.MaintenanceNotification = $projection.MaintenanceNotification and _MaintNotificationItemTP.MaintenanceNotificationItem = $projection.MaintenanceNotificationItem

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName INTFCAUSETETP view
EndUserText.label Maint. Notification Cause /w Tech. Obj. view
ObjectModel.writeDraftPersistence MAINTNOTIFCAUS_D view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotificationCause I_MaintNotifCauseTechObj MaintenanceNotificationCause
KEY MaintenanceNotificationItem I_MaintNotifCauseTechObj MaintenanceNotificationItem
KEY MaintenanceNotification I_MaintNotifCauseTechObj MaintenanceNotification
MaintNotificationCauseForEdit I_MaintNotifCauseTechObj MaintenanceNotificationCause
MaintNotifCauseText I_MaintNotifCauseTechObj MaintNotifCauseText
MaintNotificationCauseCode I_MaintNotifCauseTechObj MaintNotificationCauseCode
MaintNotifCauseCodeGroup I_MaintNotifCauseTechObj MaintNotifCauseCodeGroup
MaintNotifCauseCodeCatalog I_MaintNotifCauseTechObj MaintNotifCauseCodeCatalog
IsDeleted I_MaintNotifCauseTechObj IsDeleted
MaintNotifCauseSortNumber I_MaintNotifCauseTechObj MaintNotifCauseSortNumber
MaintNotificationRootCause I_MaintNotifCauseTechObj MaintNotificationRootCause
IsMaintNotificationRootCause I_MaintNotifCauseTechObj IsMaintNotificationRootCause
IsMaintNotifItemRootCause I_MaintNotifCauseTechObj IsMaintNotifItemRootCause
_MaintNotificationTP _MaintNotificationTP
_MaintNotificationItemTP _MaintNotificationItemTP
_IsDeleted _IsDeleted
_MaintenanceNotification _MaintenanceNotification
_MaintNotifCauseCodeCatalog _MaintNotifCauseCodeCatalog
_MaintNotifCauseCodeGroup _MaintNotifCauseCodeGroup
_MaintNotificationCauseCode _MaintNotificationCauseCode
@AbapCatalog.sqlViewName: 'INTFCAUSETETP'
@EndUserText.label: 'Maint. Notification Cause /w Tech. Obj.'
@ObjectModel.writeDraftPersistence: 'MAINTNOTIFCAUS_D'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true
@ObjectModel.semanticKey: ['MaintenanceNotificationCause', 'MaintenanceNotificationItem', 'MaintenanceNotification']

@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL 

define view I_MaintNotificationCauseTP
as select from I_MaintNotifCauseTechObj as Document

association [1..1] to I_MaintNotificationTP as _MaintNotificationTP
  on _MaintNotificationTP.MaintenanceNotification = $projection.MaintenanceNotification
  
association [1..1] to I_MaintNotificationItemTP as _MaintNotificationItemTP
  on _MaintNotificationItemTP.MaintenanceNotification = $projection.MaintenanceNotification
  and _MaintNotificationItemTP.MaintenanceNotificationItem = $projection.MaintenanceNotificationItem
   
{
key Document.MaintenanceNotificationCause,
key Document.MaintenanceNotificationItem,
key Document.MaintenanceNotification,

Document.MaintenanceNotificationCause as MaintNotificationCauseForEdit,

Document.MaintNotifCauseText,

Document.MaintNotificationCauseCode,

Document.MaintNotifCauseCodeGroup,

Document.MaintNotifCauseCodeCatalog,

Document.IsDeleted,

Document.MaintNotifCauseSortNumber,
Document.MaintNotificationRootCause,
Document.IsMaintNotificationRootCause,
Document.IsMaintNotifItemRootCause,

@ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
_MaintNotificationTP,
@ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
_MaintNotificationItemTP,

_IsDeleted,

_MaintenanceNotification,

_MaintNotifCauseCodeCatalog,

_MaintNotifCauseCodeGroup,

_MaintNotificationCauseCode
} where Document.IsDeleted != 'X'