R_MaintOrdObjectListItemTP

DDL: R_MAINTORDOBJECTLISTITEMTP Type: view_entity TRANSACTIONAL

Maintenance Order Object List Item

R_MaintOrdObjectListItemTP is a Transactional CDS View that provides data about "Maintenance Order Object List Item" in SAP S/4HANA. It reads from 1 data source (I_MaintOrderObjectListItem) and exposes 21 fields with key fields MaintenanceOrder, MaintenanceOrderObjectList, MaintenanceObjectListItem.

Data Sources (1)

SourceAliasJoin Type
I_MaintOrderObjectListItem I_MaintOrderObjectListItem from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Maintenance Order Object List Item view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder
KEY MaintenanceOrderObjectList MaintenanceOrderObjectList
KEY MaintenanceObjectListItem MaintenanceObjectListItem
MaintOrderObjectListForEdit
MaintObjectListItemForEdit
Equipment Equipment
MaintenanceNotification MaintenanceNotification
Assembly Assembly
Material Material
SerialNumber SerialNumber
UniqueItemIdentifier UniqueItemIdentifier
FunctionalLocation
MaintObjectListItemSequence MaintObjectListItemSequence
NotificationText
_Assembly _Assembly
_Equipment _Equipment
_FunctionalLocation _FunctionalLocation
_MaintenanceNotification _MaintenanceNotification
_Product _Product
_MaintenanceOrder _MaintenanceOrder
_AssignedMaintOrderOperations _AssignedMaintOrderOperations
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Maintenance Order Object List Item'
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}

define view entity R_MaintOrdObjectListItemTP
  as select from I_MaintOrderObjectListItem
  composition of exact one to many R_MaintOrdOpObjListLinkTP as _AssignedMaintOrderOperations
  association              to parent R_MaintenanceOrderTP    as _MaintenanceOrder   on $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
  association of one       to one I_FunctionalLocation       as _FunctionalLocation on _FunctionalLocation.FunctionalLocation = $projection.FunctionalLocation

{
  key MaintenanceOrder,
  key MaintenanceOrderObjectList,
  key MaintenanceObjectListItem,
      @ObjectModel.editableFieldFor: 'MaintenanceOrderObjectList'
      cast( MaintenanceOrderObjectList    as objknr preserving type ) as MaintOrderObjectListForEdit,
      @ObjectModel.editableFieldFor: 'MaintenanceObjectListItem'
      cast( MaintenanceObjectListItem as objza preserving type )      as MaintObjectListItemForEdit,
      Equipment,
      MaintenanceNotification,
      Assembly,
      Material,
      SerialNumber,
      UniqueItemIdentifier,
      cast ( FunctionalLocation as vdm_eam_tplnr )                    as FunctionalLocation,
      MaintObjectListItemSequence,
      _MaintenanceOrder._MaintenanceNotification.NotificationText     as NotificationText,
      /* Associations */
      _Assembly,
      _Equipment,
      _FunctionalLocation,
      _MaintenanceNotification,
      _Product,
      _MaintenanceOrder,
      _AssignedMaintOrderOperations
}