I_PlantMaintObjectListData

DDL: I_PLANTMAINTOBJECTLISTDATA SQL: IPMOBJLDATA Type: view COMPOSITE

Object List Data (Extractor)

I_PlantMaintObjectListData is a Composite CDS View (Fact) that provides data about "Object List Data (Extractor)" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceItemObject) and exposes 24 fields with key fields MaintenanceItemObjectList, MaintenanceItemObject. It has 2 associations to related views.

1 data source(s) 24 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceItemObject I_MaintenanceItemObject from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_MaintenanceItem _MaintenanceItem _MaintenanceItem.MaintenanceItemObjectList = $projection.MaintenanceItemObjectList
[1..*] I_MaintenanceOrder _MaintenanceOrder _MaintenanceOrder.MaintenanceItemObjectList = $projection.MaintenanceItemObjectList

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPMOBJLDATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Object List Data (Extractor) view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.byElement.name CreationDate view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceItemObjectList MaintenanceItemObjectList
KEY MaintenanceItemObject MaintenanceItemObject
Equipment Equipment
FunctionalLocation FunctionalLocation
Assembly Assembly
SerialNumber SerialNumber
Material Material
MaintenanceNotification MaintenanceNotification
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr
SortField SortField
CreationDate CreationDate
MaintObjListEntryIsProcessed MaintObjListEntryIsProcessed
Product Product
MaintenanceItem _MaintenanceItem MaintenanceItem
MaintenanceOrder _MaintenanceOrder MaintenanceOrder
_MaintenanceItem _MaintenanceItem
_MaintenanceOrder _MaintenanceOrder
_Assembly _Assembly
_Equipment _Equipment
_FunctionalLocation _FunctionalLocation
_LocationAccountAssignment _LocationAccountAssignment
_MaintenanceNotification _MaintenanceNotification
_Material _Material
_Product _Product 
@AbapCatalog.sqlViewName: 'IPMOBJLDATA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Plant Maintenance Object List Data'

@EndUserText.label: 'Object List Data (Extractor)'
@ObjectModel: {
//    representativeKey: [ 'MaintenanceItemObjectList' ],

    usageType: {
        dataClass: #TRANSACTIONAL,
        serviceQuality: #C,
        sizeCategory: #XL
    }
}

@Metadata.ignorePropagatedAnnotations

@VDM.viewType: #COMPOSITE

@Analytics:{
    dataCategory: #FACT,
    dataExtraction: {
       enabled: true,
          delta: {
            changeDataCapture: {
                mapping:[
                {
                    table: 'objk', role: #MAIN,
                    viewElement: [ 'MaintenanceItemObjectList', 'MaintenanceItemObject'],
                    tableElement: ['obknr', 'obzae']
                }
                    ]

                 }
                 ,
                byElement: {
                name: 'CreationDate'
                }
              }
            }
          }


define view I_PlantMaintObjectListData
  as select from I_MaintenanceItemObject

  association [1..*] to I_MaintenanceItem  as _MaintenanceItem  on _MaintenanceItem.MaintenanceItemObjectList = $projection.MaintenanceItemObjectList
  association [1..*] to I_MaintenanceOrder as _MaintenanceOrder on _MaintenanceOrder.MaintenanceItemObjectList = $projection.MaintenanceItemObjectList
{
  key MaintenanceItemObjectList,

  key MaintenanceItemObject,

      Equipment,

      FunctionalLocation,

      Assembly,

      SerialNumber,

      Material,

      MaintenanceNotification,

      MaintObjectLocAcctAssgmtNmbr,

      SortField,

      CreationDate,

      @Semantics.booleanIndicator
      MaintObjListEntryIsProcessed,

      Product,

      _MaintenanceItem.MaintenanceItem   as MaintenanceItem,

      _MaintenanceOrder.MaintenanceOrder as MaintenanceOrder,

      _MaintenanceItem,
      _MaintenanceOrder,
      _Assembly,
      _Equipment,
      _FunctionalLocation,
      _LocationAccountAssignment,
      _MaintenanceNotification,
      _Material,
      _Product

}

Learn More