C_TechObjLabelHierarchyVH

DDL: C_TECHOBJLABELHIERARCHYVH Type: view_entity CONSUMPTION
15 Fields 1 Data Sources

Search by Technical Object Hierarchy

C_TechObjLabelHierarchyVH is a Consumption CDS View that provides data about "Search by Technical Object Hierarchy" in SAP S/4HANA. It reads from 1 data source (I_TechnicalObjectNode) and exposes 15 fields with key fields TechnicalObject, TechObjIsEquipOrFuncnlLoc.

Data Sources (1)

SourceAliasJoin Type
I_TechnicalObjectNode I_TechnicalObjectNode projection

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Search by Technical Object Hierarchy view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey TechnicalObject view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
Search.searchable true view
AccessControl.personalData.blocking #REQUIRED view
Metadata.allowExtensions true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY TechnicalObject TechnicalObject Technical Object
KEY TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
TechObjIsEquipOrFuncnlLocDesc TechObjIsEquipOrFuncnlLocDesc TObj.Type Desc.
SuperiorTechnicalObject SuperiorTechnicalObject
TechnicalObjectCategory TechnicalObjectCategory Tech. Obj. Category
SuperiorObjIsEquipOrFuncnlLoc SuperiorObjIsEquipOrFuncnlLoc
TechnicalObjectLabel TechnicalObjectLabel Tech. Object
FunctionalLocationLabelName FunctionalLocationLabelName Functional Loc.
Equipment Equipment Equipment check
TechnicalObjectDescription TechnicalObjectDescription Tech. Obj. Desc
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlanningPlantName MaintenancePlanningPlantName Plant Name
SuperiorTechnicalObjectName SuperiorTechnicalObjectName
Material Material Vehicle Model
SerialNumber SerialNumber Serial Number

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_TechObjLabelHierarchyVH.
-- 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_TechObjLabelHierarchyVH AS
SELECT
  TechnicalObject,
  TechObjIsEquipOrFuncnlLoc,
  TechObjIsEquipOrFuncnlLocDesc,
  SuperiorTechnicalObject,
  TechnicalObjectCategory,
  SuperiorObjIsEquipOrFuncnlLoc,
  TechnicalObjectLabel,
  FunctionalLocationLabelName,
  Equipment,
  TechnicalObjectDescription,
  MaintenancePlanningPlant,
  MaintenancePlanningPlantName,
  SuperiorTechnicalObjectName,
  Material,
  SerialNumber
FROM I_TechnicalObjectNode
;

Learn More