I_MAINTNOTIFACTIVITYTECHOBJ

CDS View

Maint. Notif. Activity /w Tech. Obj.

I_MAINTNOTIFACTIVITYTECHOBJ is a CDS View in S/4HANA. Maint. Notif. Activity /w Tech. Obj.. It contains 15 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 15 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_MaintNotifActivityTP view from TRANSACTIONAL Maint. Notif. Activity /w Tech. Obj.
I_MaintNotificationActyData view from COMPOSITE Maintenance Notification Activity Data
R_MaintNotifItemActivityTP view_entity from TRANSACTIONAL Maintenance Notification Item Activity

Fields (15)

KeyField CDS FieldsUsed in Views
KEY MaintenanceNotification MaintenanceNotification 1
KEY MaintNotificationActivity MaintNotifActivityForEdit,MaintNotificationActivity 1
CreatedByUser CreatedByUser 1
IsDeleted IsDeleted 1
MaintenanceNotificationItem MaintenanceNotificationItem 1
MaintNotifActivityCodeCatalog MaintNotifActivityCodeCatalog 1
MaintNotifActivityCodeGroup MaintNotifActivityCodeGroup 1
MaintNotifActivitySortNumber MaintNotifActivitySortNumber 1
MaintNotifActyQtyFactor MaintNotifActyQtyFactor 1
MaintNotifActyTxt MaintNotifActyTxt 1
MaintNotificationActivityCode MaintNotificationActivityCode 1
PlannedEndDate PlannedEndDate 1
PlannedEndTime PlannedEndTime 1
PlannedStartDate PlannedStartDate 1
PlannedStartTime PlannedStartTime 1 
@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
}

Learn More