I_TechnicalObjectNode

DDL: I_TECHNICALOBJECTNODE Type: view_entity COMPOSITE
21 Fields 1 Associations

Technical Object Node

I_TechnicalObjectNode is a Composite CDS View that provides data about "Technical Object Node" in SAP S/4HANA. It has 1 association to related views.

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Equipment _EquipmentSearch $projection.EquipmentWithLeadingZeros = _EquipmentSearch.Equipment

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Technical Object Node view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY TechnicalObject TechnicalObject Technical Object
KEY TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
TechObjIsEquipOrFuncnlLocDesc
SuperiorTechnicalObject SuperiorTechnicalObject
SuperiorObjIsEquipOrFuncnlLoc
TechnicalObjectCategory I_TechnicalObject TechnicalObjectCategory Tech. Obj. Category
TechnicalObjectDescription
SuperiorTechnicalObjectName I_TechnicalObject SuperiorTechnicalObjectName
FunctionalLocationLabelName
SuperiorFuncnlLocLabelName
EquipmentWithLeadingZeros I_TechnicalObject Equipment Equipment check
Equipment _EquipmentSearch Equipment Equipment check
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlanningPlantName _MaintenancePlanPlant PlantName1
Material I_TechnicalObject Material Vehicle Model
SerialNumber I_TechnicalObject SerialNumber Serial Number
AuthorizationGroup I_TechnicalObject AuthorizationGroup AuthorizGroup
MaintObjectLocAcctAssgmtNmbr I_TechnicalObject MaintObjectLocAcctAssgmtNmbr Loc/AccAssmt
_LocationAccountAssignment _LocationAccountAssignment
_MaintenancePlanningPlant _MaintenancePlanningPlant
_ParentNode _ParentNode

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_TechnicalObjectNode.
-- 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 I_TechnicalObjectNode AS
SELECT
  TechnicalObject,
  TechObjIsEquipOrFuncnlLoc,
  _TechObjIsEquipOrFuncnlLoc._Text[1:Language = $session.system_language].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
  SuperiorTechnicalObject,
  cast(I_TechnicalObject.SuperiorObjIsEquipOrFuncnlLoc as eams_tec_obj_type) AS SuperiorObjIsEquipOrFuncnlLoc,
  I_TechnicalObject.TechnicalObjectCategory AS TechnicalObjectCategory,
  I_TechnicalObject._TechnicalObjectText[1: Language = $session.system_language].TechnicalObjectDescription AS TechnicalObjectDescription,
  I_TechnicalObject.SuperiorTechnicalObjectName AS SuperiorTechnicalObjectName,
  I_TechnicalObject._FunctionalLocationLabel._FuncLocationLabelSearch.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  I_TechnicalObject._SuperFunctionalLocationLabel._FuncLocationLabelSearch.FunctionalLocationLabelName AS SuperiorFuncnlLocLabelName,
  I_TechnicalObject.Equipment AS EquipmentWithLeadingZeros,
  _EquipmentSearch.Equipment AS Equipment,
  MaintenancePlanningPlant,
  _MaintenancePlanPlant.PlantName1 AS MaintenancePlanningPlantName,
  I_TechnicalObject.Material AS Material,
  I_TechnicalObject.SerialNumber AS SerialNumber,
  I_TechnicalObject.AuthorizationGroup AS AuthorizationGroup,
  I_TechnicalObject.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr
LEFT OUTER JOIN I_Equipment AS _EquipmentSearch ON EquipmentWithLeadingZeros = _EquipmentSearch.Equipment  -- association [0..1]
;

Learn More