C_MaintOrderObjectListVH

DDL: C_MAINTORDEROBJECTLISTVH Type: view_entity CONSUMPTION Package: VDM_EAM_MAINTJOB_MANAGE_MPD
10 Fields 1 Data Sources 6 Associations

Maintenance Order Objectlist

C_MaintOrderObjectListVH is a Consumption CDS View that provides data about "Maintenance Order Objectlist" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrderObjectList) and exposes 10 fields with key fields MaintenanceOrderObjectList, MaintenanceOrderObjectListItem. It has 6 associations to related views. Part of development package VDM_EAM_MAINTJOB_MANAGE_MPD.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceOrderObjectList I_MaintenanceOrderObjectList from

Associations (6)

CardinalityTargetAliasCondition
[0..*] I_MaintenanceOrder _MaintenanceOrder _MaintenanceOrder.MaintenanceOrderObjectList = $projection.MaintenanceOrderObjectList
[0..1] I_TechnicalObject _TechnicalObject _TechnicalObject.TechnicalObject = $projection.TechnicalObject and _TechnicalObject.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc
[0..1] I_FunctionalLocationLabel _FunctionalLocationLabel _FunctionalLocationLabel.FunctionalLocation = $projection.FunctionalLocation
[0..1] I_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc
[0..*] I_EquipmentText _EquipmentText _EquipmentText.Equipment = $projection.Equipment
[0..*] I_FunctionalLocationText _FunctionalLocationText _FunctionalLocationText.FunctionalLocation = $projection.FunctionalLocation

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
Consumption.ranked true view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey MaintenanceOrderObjectList view
EndUserText.label Maintenance Order Objectlist view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrderObjectList MaintenanceOrderObjectList Object list
KEY MaintenanceOrderObjectListItem MaintenanceOrderObjectListItem Object counters
MaintenanceOrder _MaintenanceOrder MaintenanceOrder Order
Equipment Equipment Equipment
FunctionalLocation FunctionalLocation Functional Location
EquipmentWithLeadingZeros _Equipment Equipment Equipment
FunctionalLocationLabelName Functional Location
_MaintenanceItem _MaintenanceItem
_TechnicalObject _TechnicalObject
_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc

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_MaintOrderObjectListVH.
-- 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_MaintOrderObjectListVH AS
SELECT
  MaintenanceOrderObjectList,
  MaintenanceOrderObjectListItem,
  _MaintenanceOrder.MaintenanceOrder AS MaintenanceOrder,
  Equipment,
  FunctionalLocation,
  _Equipment.Equipment AS EquipmentWithLeadingZeros,
  _FunctionalLocation._FunctionalLocationLabel._FuncLocationLabelSearch.FunctionalLocationLabelName AS FunctionalLocationLabelName
FROM I_MaintenanceOrderObjectList
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrderObjectList = MaintenanceOrderObjectList  -- association [0..*]
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObject ON _TechnicalObject.TechnicalObject = TechnicalObject AND _TechnicalObject.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON _FunctionalLocationLabel.FunctionalLocation = FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON _EquipmentText.Equipment = Equipment  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON _FunctionalLocationText.FunctionalLocation = FunctionalLocation  -- association [0..*]
;

Learn More