I_MaintenanceObjectListItem

DDL: I_MAINTENANCEOBJECTLISTITEM SQL: IMTOBJLTITM Type: view BASIC

Maintenance Object List Item

I_MaintenanceObjectListItem is a Basic CDS View that provides data about "Maintenance Object List Item" in SAP S/4HANA. It reads from 1 data source (objk) and exposes 22 fields with key fields MaintenanceObjectList, MaintenanceObjectListItem. It has 8 associations to related views.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
objk objk from

Associations (8)

CardinalityTargetAliasCondition
[0..1] I_LocationAccountAssignment _LocationAccountAssignment _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr = $projection.MaintObjectLocAcctAssgmtNmbr
[0..1] I_PMNotifMaintenanceData _PMNotifMaintenanceData _PMNotifMaintenanceData.MaintenanceNotification = $projection.MaintenanceNotification
[0..1] I_Equipment _Equipment _Equipment.Equipment = $projection.Equipment
[0..1] I_Equipment _SerialNumber _SerialNumber.Material = $projection.Material and _SerialNumber.SerialNumber = $projection.SerialNumber
[0..1] I_Equipment _UniqueItemIdentifier _UniqueItemIdentifier.UniqueItemIdentifier = $projection.UniqueItemIdentifier
[0..1] I_Material _Assembly _Assembly.Material = $projection.Assembly
[0..1] I_Product _Product _Product.Product = $projection.Material
[0..1] I_Product _ServiceReferenceProduct _ServiceReferenceProduct.Product = $projection.ServiceReferenceProduct

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMTOBJLTITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Maintenance Object List Item view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceObjectList obknr
KEY MaintenanceObjectListItem obzae
MaintenanceObjectListUsageCode objvw
Equipment equnr
MaintenanceNotification ihnum
Assembly bautl
MaintObjectLocAcctAssgmtNmbr iloan
Material matnr
SerialNumber sernr
UniqueItemIdentifier uii
CreationDate datum
MaintObjectListItemSequence sortf
MaintObjListEntryIsProcessed
ServiceReferenceProduct product
_Assembly _Assembly
_Equipment _Equipment
_LocationAccountAssignment _LocationAccountAssignment
_PMNotifMaintenanceData _PMNotifMaintenanceData
_Product _Product
_SerialNumber _SerialNumber
_UniqueItemIdentifier _UniqueItemIdentifier
_ServiceReferenceProduct _ServiceReferenceProduct 
@AbapCatalog.sqlViewName: 'IMTOBJLTITM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@EndUserText.label: 'Maintenance Object List Item'

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

define view I_MaintenanceObjectListItem
  as select from objk

  association [0..1] to I_LocationAccountAssignment as _LocationAccountAssignment on _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr = $projection.MaintObjectLocAcctAssgmtNmbr
  association [0..1] to I_PMNotifMaintenanceData    as _PMNotifMaintenanceData    on _PMNotifMaintenanceData.MaintenanceNotification = $projection.MaintenanceNotification
  association [0..1] to I_Equipment                 as _Equipment                 on _Equipment.Equipment = $projection.Equipment
  association [0..1] to I_Equipment                 as _SerialNumber              on _SerialNumber.Material   = $projection.Material and _SerialNumber.SerialNumber = $projection.SerialNumber
  association [0..1] to I_Equipment                 as _UniqueItemIdentifier      on _UniqueItemIdentifier.UniqueItemIdentifier = $projection.UniqueItemIdentifier
  association [0..1] to I_Material                  as _Assembly                  on _Assembly.Material = $projection.Assembly
  association [0..1] to I_Product                   as _Product                   on _Product.Product = $projection.Material
  association [0..1] to I_Product                   as _ServiceReferenceProduct   on _ServiceReferenceProduct.Product = $projection.ServiceReferenceProduct

{


  key obknr                                       as MaintenanceObjectList,
  key obzae                                       as MaintenanceObjectListItem,
      objvw                                       as MaintenanceObjectListUsageCode,
      @ObjectModel.foreignKey.association: '_Equipment'
      equnr                                       as Equipment,
      @ObjectModel.foreignKey.association: '_PMNotifMaintenanceData'
      ihnum                                       as MaintenanceNotification,
      @ObjectModel.foreignKey.association: '_Assembly'
      bautl                                       as Assembly,
      @ObjectModel.foreignKey.association: '_LocationAccountAssignment'
      iloan                                       as MaintObjectLocAcctAssgmtNmbr,
      @ObjectModel.foreignKey.association: '_Product'
      matnr                                       as Material,
      sernr                                       as SerialNumber,
      uii                                         as UniqueItemIdentifier,
      datum                                       as CreationDate,
      sortf                                       as MaintObjectListItemSequence,
      cast( objk.bearb as xfeld preserving type ) as MaintObjListEntryIsProcessed,
      @ObjectModel.foreignKey.association: '_ServiceReferenceProduct'
      product                                     as ServiceReferenceProduct ,
      _Assembly,
      _Equipment,
      _LocationAccountAssignment,
      _PMNotifMaintenanceData,
      _Product,
      _SerialNumber,
      _UniqueItemIdentifier,
      _ServiceReferenceProduct
}

Learn More