I_MaintNotifActivityTP

DDL: I_MAINTNOTIFACTIVITYTP SQL: IMAINTNOTIF002TP Type: view TRANSACTIONAL

Maint. Notif. Activity /w Tech. Obj.

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

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintNotifActivityTechObj Document from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MaintNotificationTP _MaintNotificationTP _MaintNotificationTP.MaintenanceNotification = $projection.MaintenanceNotification

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IMAINTNOTIF002TP view
EndUserText.label Maint. Notif. Activity /w Tech. Obj. view
ObjectModel.writeDraftPersistence MAINTNOTIFACTV_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 (23)

KeyFieldSource TableSource FieldDescription
KEY MaintNotificationActivity I_MaintNotifActivityTechObj MaintNotificationActivity
KEY MaintenanceNotification I_MaintNotifActivityTechObj MaintenanceNotification
MaintNotifActivityForEdit I_MaintNotifActivityTechObj MaintNotificationActivity
MaintenanceNotificationItem I_MaintNotifActivityTechObj MaintenanceNotificationItem
MaintNotifActyTxt I_MaintNotifActivityTechObj MaintNotifActyTxt
MaintNotifActivityCodeCatalog I_MaintNotifActivityTechObj MaintNotifActivityCodeCatalog
MaintNotificationActivityCode I_MaintNotifActivityTechObj MaintNotificationActivityCode
MaintNotifActivityCodeGroup I_MaintNotifActivityTechObj MaintNotifActivityCodeGroup
IsDeleted I_MaintNotifActivityTechObj IsDeleted
CreatedByUser I_MaintNotifActivityTechObj CreatedByUser
PlannedStartDate I_MaintNotifActivityTechObj PlannedStartDate
PlannedStartTime I_MaintNotifActivityTechObj PlannedStartTime
MaintNotifActyQtyFactor I_MaintNotifActivityTechObj MaintNotifActyQtyFactor
PlannedEndDate I_MaintNotifActivityTechObj PlannedEndDate
PlannedEndTime I_MaintNotifActivityTechObj PlannedEndTime
MaintNotifActivitySortNumber I_MaintNotifActivityTechObj MaintNotifActivitySortNumber
_MaintNotificationTP _MaintNotificationTP
_IsDeleted _IsDeleted
_MaintenanceNotification _MaintenanceNotification
_MaintenanceNotificationItem _MaintenanceNotificationItem
_MaintNotifActivityCodeCatalog _MaintNotifActivityCodeCatalog
_MaintNotifActivityCodeGroup _MaintNotifActivityCodeGroup
_MaintNotificationActivityCode _MaintNotificationActivityCode 
@AbapCatalog.sqlViewName: 'IMAINTNOTIF002TP'
@EndUserText.label: 'Maint. Notif. Activity /w Tech. Obj.'
@ObjectModel.writeDraftPersistence: 'MAINTNOTIFACTV_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: ['MaintNotificationActivity', 'MaintenanceNotification']

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

define view I_MaintNotifActivityTP
  as select from I_MaintNotifActivityTechObj as Document
  association [1..1] to I_MaintNotificationTP         as _MaintNotificationTP           on  _MaintNotificationTP.MaintenanceNotification = $projection.MaintenanceNotification
 
{
  key Document.MaintNotificationActivity,
  key Document.MaintenanceNotification,

      Document.MaintNotificationActivity as MaintNotifActivityForEdit,

      Document.MaintenanceNotificationItem,

      Document.MaintNotifActyTxt,

      Document.MaintNotifActivityCodeCatalog,

      Document.MaintNotificationActivityCode,

      Document.MaintNotifActivityCodeGroup,

      Document.IsDeleted,

      Document.CreatedByUser,

      Document.PlannedStartDate,

      Document.PlannedStartTime,

      Document.MaintNotifActyQtyFactor,

      Document.PlannedEndDate,

      Document.PlannedEndTime,
      
      Document.MaintNotifActivitySortNumber,

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

      _MaintenanceNotification,

      _MaintenanceNotificationItem,

      _MaintNotifActivityCodeCatalog,

      _MaintNotifActivityCodeGroup,

      _MaintNotificationActivityCode
} where Document.IsDeleted != 'X'

Learn More