I_MaintNotifItemTechObj

DDL: I_MAINTNOTIFITEMTECHOBJ SQL: INOTIFITTECHOBJ Type: view COMPOSITE

Maint. Notification Item /w Tech. Obj.

I_MaintNotifItemTechObj is a Composite CDS View (Dimension) that provides data about "Maint. Notification Item /w Tech. Obj." in SAP S/4HANA. It reads from 1 data source (I_MaintenanceNotificationItem) and exposes 30 fields with key fields MaintenanceNotificationItem, MaintenanceNotification. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceNotificationItem I_MaintenanceNotificationItem from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_MaintNotifCauseTechObj _MaintNotifCauseTechObj $projection.MaintenanceNotification = _MaintNotifCauseTechObj.MaintenanceNotification and $projection.MaintenanceNotificationItem = _MaintNotifCauseTechObj.MaintenanceNotificationItem
[1..1] I_MaintNotificationTechObj _MaintNotificationTechObj $projection.MaintenanceNotification = _MaintNotificationTechObj.MaintenanceNotification
[0..1] I_LinearAssetManagementData _LinearAssetManagementData $projection.ObjectKey = _LinearAssetManagementData.LinearDataObjectKey and _LinearAssetManagementData.LinearDataObjectType = 'QN'

Annotations (11)

NameValueLevelField
EndUserText.label Maint. Notification Item /w Tech. Obj. view
Analytics.dataCategory #DIMENSION view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName INOTIFITTECHOBJ view
ObjectModel.representativeKey MaintenanceNotificationItem view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotificationItem I_MaintenanceNotificationItem MaintenanceNotificationItem
KEY MaintenanceNotification I_MaintenanceNotificationItem MaintenanceNotification
MaintNotifItemText I_MaintenanceNotificationItem MaintNotifItemText
MaintNotifDamageCodeCatalog I_MaintenanceNotificationItem MaintNotifDamageCodeCatalog
MaintNotificationDamageCode I_MaintenanceNotificationItem MaintNotificationDamageCode
MaintNotifDamageCodeGroup I_MaintenanceNotificationItem MaintNotifDamageCodeGroup
MaintNotifObjPrtCode I_MaintenanceNotificationItem MaintNotifObjPrtCode
MaintNotifObjPrtCodeGroup I_MaintenanceNotificationItem MaintNotifObjPrtCodeGroup
MaintNotifObjPrtCodeCatalog I_MaintenanceNotificationItem MaintNotifObjPrtCodeCatalog
DefectClass I_MaintenanceNotificationItem DefectClass
Assembly I_MaintenanceNotificationItem Assembly
ObjectKey I_MaintenanceNotificationItem ObjectKey
NumberOfDefects I_MaintenanceNotificationItem NumberOfDefects
LastChangeDateTime I_MaintenanceNotificationItem LastChangeDateTime
IsDeleted I_MaintenanceNotificationItem IsDeleted
_MaintNotificationTechObj _MaintNotificationTechObj
_IsDeleted I_MaintenanceNotificationItem _IsDeleted
_MaintenanceNotification I_MaintenanceNotificationItem _MaintenanceNotification
_MaintNotifCauseTechObj _MaintNotifCauseTechObj
_LinearAssetManagementData _LinearAssetManagementData
_MaintenanceNotificationTask I_MaintenanceNotificationItem _MaintenanceNotificationTask
_MaintNotifDamageCodeCatalog I_MaintenanceNotificationItem _MaintNotifDamageCodeCatalog
_MaintNotifDamageCodeGroup I_MaintenanceNotificationItem _MaintNotifDamageCodeGroup
_MaintNotificationActivity I_MaintenanceNotificationItem _MaintNotificationActivity
_MaintNotificationDamageCode I_MaintenanceNotificationItem _MaintNotificationDamageCode
_MaintNotifObjPrtCode I_MaintenanceNotificationItem _MaintNotifObjPrtCode
_MaintNotifObjPrtCodeCatalog I_MaintenanceNotificationItem _MaintNotifObjPrtCodeCatalog
_MaintNotifObjPrtCodeGroup I_MaintenanceNotificationItem _MaintNotifObjPrtCodeGroup
_Assembly I_MaintenanceNotificationItem _Assembly
_DefectClass I_MaintenanceNotificationItem _DefectClass
@EndUserText.label: 'Maint. Notification Item /w Tech. Obj.' //same as DDL description

--@Analytics: { dataCategory: #DIMENSION }
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'INOTIFITTECHOBJ'

@ObjectModel.representativeKey: 'MaintenanceNotificationItem'
@ObjectModel.semanticKey:  [ 'MaintenanceNotificationItem','MaintenanceNotification' ]


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


define view I_MaintNotifItemTechObj
  as select from I_MaintenanceNotificationItem
  association [0..*] to I_MaintNotifCauseTechObj   as _MaintNotifCauseTechObj   on  $projection.MaintenanceNotification     = _MaintNotifCauseTechObj.MaintenanceNotification
                                                                                and $projection.MaintenanceNotificationItem = _MaintNotifCauseTechObj.MaintenanceNotificationItem
  association [1..1] to I_MaintNotificationTechObj as _MaintNotificationTechObj on  $projection.MaintenanceNotification = _MaintNotificationTechObj.MaintenanceNotification
  association [0..1] to I_LinearAssetManagementData as _LinearAssetManagementData on  $projection.ObjectKey = _LinearAssetManagementData.LinearDataObjectKey
                                                                                  and _LinearAssetManagementData.LinearDataObjectType = 'QN'
{

      @ObjectModel.text.element:  [ 'MaintNotifItemText' ]
  key I_MaintenanceNotificationItem.MaintenanceNotificationItem,
      @ObjectModel.foreignKey.association: '_MaintenanceNotification'
  key I_MaintenanceNotificationItem.MaintenanceNotification,

      @Semantics.text: true
      I_MaintenanceNotificationItem.MaintNotifItemText,

      @ObjectModel.foreignKey.association: '_MaintNotifDamageCodeCatalog'
      I_MaintenanceNotificationItem.MaintNotifDamageCodeCatalog,
      @ObjectModel.foreignKey.association: '_MaintNotificationDamageCode'
      I_MaintenanceNotificationItem.MaintNotificationDamageCode,
      @ObjectModel.foreignKey.association: '_MaintNotifDamageCodeGroup'
      I_MaintenanceNotificationItem.MaintNotifDamageCodeGroup,

      @ObjectModel.foreignKey.association: '_MaintNotifObjPrtCode'
      I_MaintenanceNotificationItem.MaintNotifObjPrtCode,
      @ObjectModel.foreignKey.association: '_MaintNotifObjPrtCodeGroup'
      I_MaintenanceNotificationItem.MaintNotifObjPrtCodeGroup,
      @ObjectModel.foreignKey.association: '_MaintNotifObjPrtCodeCatalog'
      I_MaintenanceNotificationItem.MaintNotifObjPrtCodeCatalog,
      
      @ObjectModel.foreignKey.association: '_DefectClass'
      I_MaintenanceNotificationItem.DefectClass,
    
      @ObjectModel.foreignKey.association: '_Assembly'
      I_MaintenanceNotificationItem.Assembly,
      I_MaintenanceNotificationItem.ObjectKey,
            
      I_MaintenanceNotificationItem.NumberOfDefects, 
      I_MaintenanceNotificationItem.LastChangeDateTime,        
      
      @ObjectModel.foreignKey.association: '_IsDeleted'
      I_MaintenanceNotificationItem.IsDeleted,


      /* Associations */
      _MaintNotificationTechObj, // #COMPOSITE Maintenance Notification including Technical Object

      I_MaintenanceNotificationItem._IsDeleted,
      I_MaintenanceNotificationItem._MaintenanceNotification, // #BASIC Maintenance Notification

      _MaintNotifCauseTechObj,
      _LinearAssetManagementData,
      I_MaintenanceNotificationItem._MaintenanceNotificationTask,
      I_MaintenanceNotificationItem._MaintNotifDamageCodeCatalog,
      I_MaintenanceNotificationItem._MaintNotifDamageCodeGroup,
      I_MaintenanceNotificationItem._MaintNotificationActivity,
      I_MaintenanceNotificationItem._MaintNotificationDamageCode,
      I_MaintenanceNotificationItem._MaintNotifObjPrtCode,
      I_MaintenanceNotificationItem._MaintNotifObjPrtCodeCatalog,
      I_MaintenanceNotificationItem._MaintNotifObjPrtCodeGroup,
      I_MaintenanceNotificationItem._Assembly,
      I_MaintenanceNotificationItem._DefectClass
}                                
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCENOTIFICATIONITEM"
],
"ASSOCIATED":
[
"I_DEFECTCLASS",
"I_INDICATOR",
"I_INSPECTIONCATALOG",
"I_INSPECTIONCODE",
"I_INSPECTIONCODEGROUP",
"I_LINEARASSETMANAGEMENTDATA",
"I_MAINTENANCENOTIFICATION",
"I_MAINTENANCENOTIFICATIONTASK",
"I_MAINTNOTIFCAUSETECHOBJ",
"I_MAINTNOTIFICATIONACTIVITY",
"I_MAINTNOTIFICATIONTECHOBJ",
"I_MATERIAL"
],
"BASE":
[
"I_MAINTENANCENOTIFICATIONITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/