C_MaintOrdObjectListItemDEX

DDL: C_MAINTORDOBJECTLISTITEMDEX Type: view_entity CONSUMPTION Package: IWO1
14 Fields 1 Data Sources 1 Associations

Maintenance Order Object List Item DEX

C_MaintOrdObjectListItemDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

MaintenanceOrderObjectListItem · Asset Management

C_MaintOrdObjectListItemDEX is a Consumption CDS View that provides data about "Maintenance Order Object List Item DEX" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceObjectListItem) and exposes 14 fields with key fields MaintenanceOrderObjectList, MaintenanceObjectListItem. It has 1 association to related views. Part of development package IWO1.

SAP API Hub

CategoryConsumption
StateC1
Line of BusinessAsset Management
Application ComponentPM-WOC-MO-2CL
CapabilitiesData Source for Data Extraction
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageAsset Management for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceObjectListItem ObjectListItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MaintenanceOrder _MaintenanceOrder ObjectListItem.MaintenanceObjectList = _MaintenanceOrder.MaintenanceOrderObjectList

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Maintenance Order Object List Item DEX view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.modelingPattern #ANALYTICAL_FACT view
ObjectModel.sapObjectNodeType.name MaintenanceOrderObjectListItem view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrderObjectList I_MaintenanceObjectListItem MaintenanceObjectList Object list number
KEY MaintenanceObjectListItem I_MaintenanceObjectListItem MaintenanceObjectListItem Object list counters
MaintenanceOrder _MaintenanceOrder MaintenanceOrder Order Number
MaintenanceObjectListUsageCode I_MaintenanceObjectListItem MaintenanceObjectListUsageCode Object list usage
MaintenanceNotification I_MaintenanceObjectListItem MaintenanceNotification Notification Number
Equipment I_MaintenanceObjectListItem Equipment Equipment Number
Assembly I_MaintenanceObjectListItem Assembly Pegged Reqmt
Material I_MaintenanceObjectListItem Material Material Number
SerialNumber I_MaintenanceObjectListItem SerialNumber Serial Number
UniqueItemIdentifier I_MaintenanceObjectListItem UniqueItemIdentifier Unique Item Identifier
CreationDate I_MaintenanceObjectListItem CreationDate Time Stamp
MaintObjectListItemSequence I_MaintenanceObjectListItem MaintObjectListItemSequence Object list sort field
MaintObjListEntryIsProcessed I_MaintenanceObjectListItem MaintObjListEntryIsProcessed Processing indicator
_MaintenanceOrder _MaintenanceOrder

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 C_MaintOrdObjectListItemDEX.
-- 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.

CREATE VIEW C_MaintOrdObjectListItemDEX AS
SELECT
  ObjectListItem.MaintenanceObjectList AS MaintenanceOrderObjectList,
  ObjectListItem.MaintenanceObjectListItem AS MaintenanceObjectListItem,
  _MaintenanceOrder.MaintenanceOrder AS MaintenanceOrder,
  ObjectListItem.MaintenanceObjectListUsageCode AS MaintenanceObjectListUsageCode,
  ObjectListItem.MaintenanceNotification AS MaintenanceNotification,
  ObjectListItem.Equipment AS Equipment,
  ObjectListItem.Assembly AS Assembly,
  ObjectListItem.Material AS Material,
  ObjectListItem.SerialNumber AS SerialNumber,
  ObjectListItem.UniqueItemIdentifier AS UniqueItemIdentifier,
  ObjectListItem.CreationDate AS CreationDate,
  ObjectListItem.MaintObjectListItemSequence AS MaintObjectListItemSequence,
  ObjectListItem.MaintObjListEntryIsProcessed AS MaintObjListEntryIsProcessed
FROM I_MaintenanceObjectListItem AS ObjectListItem
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON ObjectListItem.MaintenanceObjectList = _MaintenanceOrder.MaintenanceOrderObjectList  -- association [1..1]
;

Learn More