I_PlantMaintObjectListData

DDL: I_PLANTMAINTOBJECTLISTDATA SQL: IPMOBJLDATA Type: view COMPOSITE Package: IPRM
24 Fields 1 Data Sources 2 Associations

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. Part of development package IPRM.

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 Object list
KEY MaintenanceItemObject MaintenanceItemObject Object counters
Equipment Equipment Equipment check
FunctionalLocation FunctionalLocation Object ID
Assembly Assembly Pegged Reqmt
SerialNumber SerialNumber Serial Number
Material Material Vehicle Model
MaintenanceNotification MaintenanceNotification Notification
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr Loc/AccAssmt
SortField SortField Sort Field
CreationDate CreationDate Time Stamp
MaintObjListEntryIsProcessed MaintObjListEntryIsProcessed Checkbox
Product Product Product Sold
MaintenanceItem _MaintenanceItem MaintenanceItem MaintItem
MaintenanceOrder _MaintenanceOrder MaintenanceOrder Order
_MaintenanceItem _MaintenanceItem
_MaintenanceOrder _MaintenanceOrder
_Assembly _Assembly
_Equipment _Equipment
_FunctionalLocation _FunctionalLocation
_LocationAccountAssignment _LocationAccountAssignment
_MaintenanceNotification _MaintenanceNotification
_Material _Material
_Product _Product

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_PlantMaintObjectListData.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IPMOBJLDATA

CREATE VIEW I_PlantMaintObjectListData AS
SELECT
  MaintenanceItemObjectList,
  MaintenanceItemObject,
  Equipment,
  FunctionalLocation,
  Assembly,
  SerialNumber,
  Material,
  MaintenanceNotification,
  MaintObjectLocAcctAssgmtNmbr,
  SortField,
  CreationDate,
  MaintObjListEntryIsProcessed,
  Product,
  _MaintenanceItem.MaintenanceItem AS MaintenanceItem,
  _MaintenanceOrder.MaintenanceOrder AS MaintenanceOrder
FROM I_MaintenanceItemObject
LEFT OUTER JOIN I_MaintenanceItem AS _MaintenanceItem ON _MaintenanceItem.MaintenanceItemObjectList = MaintenanceItemObjectList  -- association [1..*]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceItemObjectList = MaintenanceItemObjectList  -- association [1..*]
;

Learn More