I_MaintNotifActivityTechObj

DDL: I_MAINTNOTIFACTIVITYTECHOBJ SQL: INOTIFACTVTECOBJ Type: view COMPOSITE

Maint. Notif. Activity /w Tech. Obj.

I_MaintNotifActivityTechObj is a Composite CDS View (Dimension) that provides data about "Maint. Notif. Activity /w Tech. Obj." in SAP S/4HANA. It reads from 1 data source (I_MaintNotificationActivity) and exposes 27 fields with key fields MaintNotificationActivity, MaintenanceNotification. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintNotificationActivity I_MaintNotificationActivity from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MaintNotificationTechObj _MaintNotificationTechObj $projection.MaintenanceNotification = _MaintNotificationTechObj.MaintenanceNotification

Annotations (11)

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

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY MaintNotificationActivity I_MaintNotificationActivity MaintNotificationActivity
KEY MaintenanceNotification I_MaintNotificationActivity MaintenanceNotification
MaintenanceNotificationItem I_MaintNotificationActivity MaintenanceNotificationItem
MaintNotifActyTxt I_MaintNotificationActivity MaintNotifActyTxt
MaintNotifActivitySortNumber I_MaintNotificationActivity MaintNotifActivitySortNumber
MaintNotifActivityCodeCatalog I_MaintNotificationActivity MaintNotifActivityCodeCatalog
MaintNotificationActivityCode I_MaintNotificationActivity MaintNotificationActivityCode
MaintNotifActivityCodeGroup I_MaintNotificationActivity MaintNotifActivityCodeGroup
IsDeleted I_MaintNotificationActivity IsDeleted
CreatedByUser I_MaintNotificationActivity CreatedByUser
PlannedStartDate I_MaintNotificationActivity PlannedStartDate
PlannedStartTime I_MaintNotificationActivity PlannedStartTime
MaintNotifActyQtyFactor I_MaintNotificationActivity MaintNotifActyQtyFactor
PlannedEndDate I_MaintNotificationActivity PlannedEndDate
PlannedEndTime I_MaintNotificationActivity PlannedEndTime
LastChangeDateTime I_MaintNotificationActivity LastChangeDateTime
CreationDate I_MaintNotificationActivity CreationDate
CreationTime I_MaintNotificationActivity CreationTime
LastChangeDate I_MaintNotificationActivity LastChangeDate
LastChangeTime I_MaintNotificationActivity LastChangeTime
_MaintNotificationTechObj _MaintNotificationTechObj
_IsDeleted I_MaintNotificationActivity _IsDeleted
_MaintenanceNotification I_MaintNotificationActivity _MaintenanceNotification
_MaintenanceNotificationItem I_MaintNotificationActivity _MaintenanceNotificationItem
_MaintNotifActivityCodeCatalog I_MaintNotificationActivity _MaintNotifActivityCodeCatalog
_MaintNotifActivityCodeGroup I_MaintNotificationActivity _MaintNotifActivityCodeGroup
_MaintNotificationActivityCode I_MaintNotificationActivity _MaintNotificationActivityCode
@AbapCatalog.sqlViewName: 'INOTIFACTVTECOBJ'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
--@Analytics: { dataCategory: #DIMENSION }
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Maint. Notif. Activity /w Tech. Obj.'
@ObjectModel.representativeKey: 'MaintNotificationActivity'
@ObjectModel.semanticKey:  [ 'MaintNotificationActivity', 'MaintenanceNotification' ]
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #COMPOSITE


define view I_MaintNotifActivityTechObj
  as select from I_MaintNotificationActivity
  association [1..1] to I_MaintNotificationTechObj as _MaintNotificationTechObj on $projection.MaintenanceNotification = _MaintNotificationTechObj.MaintenanceNotification
{

      @ObjectModel.text.element:  [ 'MaintNotifActyTxt' ]
  key I_MaintNotificationActivity.MaintNotificationActivity,

      @ObjectModel.foreignKey.association: '_MaintenanceNotification'
  key I_MaintNotificationActivity.MaintenanceNotification,

      @ObjectModel.foreignKey.association: '_MaintenanceNotificationItem'
      I_MaintNotificationActivity.MaintenanceNotificationItem,

      @Semantics.text: true
      I_MaintNotificationActivity.MaintNotifActyTxt,

      I_MaintNotificationActivity.MaintNotifActivitySortNumber,

      @ObjectModel.foreignKey.association: '_MaintNotifActivityCodeCatalog'
      I_MaintNotificationActivity.MaintNotifActivityCodeCatalog,
      @ObjectModel.foreignKey.association: '_MaintNotificationActivityCode'
      I_MaintNotificationActivity.MaintNotificationActivityCode,
      @ObjectModel.foreignKey.association: '_MaintNotifActivityCodeGroup'
      I_MaintNotificationActivity.MaintNotifActivityCodeGroup,

      @ObjectModel.foreignKey.association: '_IsDeleted'
      I_MaintNotificationActivity.IsDeleted,

      I_MaintNotificationActivity.CreatedByUser,
      I_MaintNotificationActivity.PlannedStartDate,
      I_MaintNotificationActivity.PlannedStartTime,
      I_MaintNotificationActivity.MaintNotifActyQtyFactor,
      I_MaintNotificationActivity.PlannedEndDate,
      I_MaintNotificationActivity.PlannedEndTime,      
      I_MaintNotificationActivity.LastChangeDateTime,
      I_MaintNotificationActivity.CreationDate,
      I_MaintNotificationActivity.CreationTime,
      I_MaintNotificationActivity.LastChangeDate,
      I_MaintNotificationActivity.LastChangeTime,

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

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

      I_MaintNotificationActivity._MaintenanceNotificationItem,
      I_MaintNotificationActivity._MaintNotifActivityCodeCatalog,
      I_MaintNotificationActivity._MaintNotifActivityCodeGroup,
      I_MaintNotificationActivity._MaintNotificationActivityCode
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTNOTIFICATIONACTIVITY"
],
"ASSOCIATED":
[
"I_INDICATOR",
"I_INSPECTIONCATALOG",
"I_INSPECTIONCODE",
"I_INSPECTIONCODEGROUP",
"I_MAINTENANCENOTIFICATION",
"I_MAINTENANCENOTIFICATIONITEM",
"I_MAINTNOTIFICATIONTECHOBJ"
],
"BASE":
[
"I_MAINTNOTIFICATIONACTIVITY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/