P_TECHNICALOBJECTHIERARCHY

CDS View

P_TECHNICALOBJECTHIERARCHY is a CDS View in S/4HANA. It contains 8 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 8 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_TechnicalObjectHierarchy view from COMPOSITE Technical Object Hierarchy
I_TechobjNumberOfSubobjects view from COMPOSITE Number of Technical Object Sub Object
I_TechobjNumberOfSubobjects view left_outer COMPOSITE Number of Technical Object Sub Object

Fields (8)

KeyField CDS FieldsUsed in Views
KEY SuperiorObjIsEquipOrFuncnlLoc SuperiorObjIsEquipOrFuncnlLoc,TechObjIsEquipOrFuncnlLoc 2
KEY SuperiorTechnicalObject SuperiorTechnicalObject,TechnicalObject 2
KEY TechnicalObject TechnicalObject 1
KEY TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc 1
Equipment Equipment 1
FunctionalLocation FunctionalLocation 1
SuperiorFunctionalLocation SuperiorFunctionalLocation 1
SuperordinateEquipment SuperordinateEquipment 1 
@AbapCatalog.sqlViewName: 'PTECHOBJHIER'
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck:#NOT_REQUIRED

// First Union:  Selection of all Functional Locations assigned to a parent Functional Location

// Second Union: Selection of all Equipments           assigned to a parent Functional Location

// Third Union:  Selection of all Equipments           assigned to a parent Equipment



// First Union:  Selection of all Functional Locations assigned to a parent Functional Location

// Second Union: Selection of all Equipments           assigned to a parent Functional Location

// Third Union:  Selection of all Equipments           assigned to a parent Equipment


define view P_TechnicalObjectHierarchy
  as select from I_Functionallocationhierarchy
  // determination of all connection between functional location and  functional location

{
  key I_Functionallocationhierarchy.TechnicalObject,
  key I_Functionallocationhierarchy.TechObjIsEquipOrFuncnlLoc,
      SuperiorTechnicalObject,
      SuperiorObjIsEquipOrFuncnlLoc,
      FunctionalLocation                                                     as FunctionalLocation,
      SuperiorFunctionalLocation                                             as SuperiorFunctionalLocation,
      cast ( '                  '             as equnr preserving type)      as SuperordinateEquipment,
      cast ( '                  '             as equnr preserving type)      as Equipment
}

union

select from I_FunctionallocationEquipmentH
{
  key I_FunctionallocationEquipmentH.TechnicalObject,
  key I_FunctionallocationEquipmentH.TechObjIsEquipOrFuncnlLoc,
      SuperiorTechnicalObject,
      SuperiorObjIsEquipOrFuncnlLoc,
      cast ( '                              '  as tplnr preserving type)     as FunctionalLocation,
      SuperiorFunctionalLocation                                             as SuperiorFunctionalLocation,
      cast ( '                  '              as equnr preserving type)     as SuperordinateEquipment,
      Equipment                                                              as Equipment
}

union

select from I_Equipmenthierarchy
{
  key I_Equipmenthierarchy.TechnicalObject,
  key I_Equipmenthierarchy.TechObjIsEquipOrFuncnlLoc,
      SuperiorTechnicalObject,
      SuperiorObjIsEquipOrFuncnlLoc,
      cast ( '                              '  as tplnr preserving type)     as FunctionalLocation,
      cast ( '                              '  as tplnr preserving type)     as SuperiorFunctionalLocation,
      SuperordinateEquipment                                                 as SuperordinateEquipment,
      Equipment                                                              as Equipment
}                
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EQUIPMENTHIERARCHY",
"I_FUNCTIONALLOCATIONEQUIPMENTH",
"I_FUNCTIONALLOCATIONHIERARCHY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More