C_MaintItemObjPgObjectList

DDL: C_MAINTITEMOBJPGOBJECTLIST SQL: CMNTITMOPOBJLIST Type: view CONSUMPTION
19 Fields 1 Data Sources 6 Associations

Object List for the Maintenance Item Object Page

C_MaintItemObjPgObjectList is a Consumption CDS View that provides data about "Object List for the Maintenance Item Object Page" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceItemObject) and exposes 19 fields with key fields MaintenanceItemObjectList, MaintenanceItemObject. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceItemObject I_MaintenanceItemObject from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_FunctionalLocationLabel _FunctionalLocationLabel _FunctionalLocationLabel.FunctionalLocation = $projection.FunctionalLocation
[0..*] I_FunctionalLocationText _FunctionalLocationText _FunctionalLocationText.FunctionalLocation = $projection.FunctionalLocation
[0..*] I_EquipmentText _EquipmentText _EquipmentText.Equipment = $projection.Equipment
[0..1] I_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc
[0..1] C_TechObjQuickVw _TechnicalObjQuickVw _TechnicalObjQuickVw.TechnicalObject = $projection.TechnicalObject and _TechnicalObjQuickVw.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc and _TechnicalObjQuickVw.TechnicalObjectLabel = $projection.TechnicalObjectLabel
[0..1] C_EAMProductQuickVw _ServiceProduct $projection.Product = _ServiceProduct.Material

Annotations (11)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName CMNTITMOPOBJLIST view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Object List for the Maintenance Item Object Page view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceItemObjectList MaintenanceItemObjectList Object list
KEY MaintenanceItemObject MaintenanceItemObject Object counters
Equipment Equipment Equipment check
EquipmentName
FunctionalLocation FunctionalLocation Object ID
FunctionalLocationLabelName
FunctionalLocationName
Assembly Assembly Assembly
Material Material Vehicle Model
SerialNumber SerialNumber Serial Number
SortField SortField Sort Field
ProductName Product Name
Product Product Product
_Assembly _Assembly
_Material _Material
_ServiceProduct _ServiceProduct
_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc
_TechnicalObjQuickVw _TechnicalObjQuickVw
_MaintenanceItem _MaintenanceItem

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_MaintItemObjPgObjectList.
-- 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: CMNTITMOPOBJLIST

CREATE VIEW C_MaintItemObjPgObjectList AS
SELECT
  MaintenanceItemObjectList,
  MaintenanceItemObject,
  Equipment,
  _EquipmentText[1:Language = $session.system_language].EquipmentName AS EquipmentName,
  FunctionalLocation,
  _FunctionalLocationLabel._FuncLocationLabelSearch.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  _FunctionalLocationText[1:Language = $session.system_language].FunctionalLocationName AS FunctionalLocationName,
  Assembly,
  Material,
  SerialNumber,
  SortField,
  _Product._Text[1:Language = $session.system_language].ProductName AS ProductName,
  Product
FROM I_MaintenanceItemObject
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON _FunctionalLocationLabel.FunctionalLocation = FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON _FunctionalLocationText.FunctionalLocation = FunctionalLocation  -- association [0..*]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON _EquipmentText.Equipment = Equipment  -- association [0..*]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN C_TechObjQuickVw AS _TechnicalObjQuickVw ON _TechnicalObjQuickVw.TechnicalObject = TechnicalObject AND _TechnicalObjQuickVw.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc AND _TechnicalObjQuickVw.TechnicalObjectLabel = TechnicalObjectLabel  -- association [0..1]
LEFT OUTER JOIN C_EAMProductQuickVw AS _ServiceProduct ON Product = _ServiceProduct.Material  -- association [0..1]
;

Learn More