I_EHSLOCATIONHIERARCHYNODE

CDS View

Location Hierarchy Node

I_EHSLOCATIONHIERARCHYNODE is a CDS View in S/4HANA. Location Hierarchy Node. It contains 7 fields. 22 CDS views read from this table.

Used by 22 CDS view(s) 7 fields

CDS Views using this table (22)

ViewTypeJoinVDMDescription
C_EquipSftyInstrnAreaFltrVH view from CONSUMPTION All Factory Area for Safety Instruction for Equipment
C_EquipSftyInstrnFactoryAreaVH view from CONSUMPTION Factory Areas for Safety Instruction for Equipment
C_GnrcSftyInstrnFactoryAreaVH view from CONSUMPTION Factory Areas for Generic Safety Instruction
C_GnrcSftyInstrnFactoryFltrVH view inner CONSUMPTION Factory locations for generic safety instruction
C_HzdsSubstInventoryFltrLocVH view inner CONSUMPTION HSI: Location Filter Value Help
C_HzdsSubstInventoryFreeLoc view inner CONSUMPTION HSI: Set of free locations
C_HzdsSubstInventoryLocVH view inner CONSUMPTION HSI: Location Value Help
C_SafetyInstrnFactoryAreaVH view from CONSUMPTION Factory Areas for Safety Instruction
C_SafetyInstrnFactoryByPlantVH view inner CONSUMPTION Value Help for Factories by SI Structure
C_SafetyInstructionFactoryVH view inner CONSUMPTION HSI: Location Value Help
C_SftyInstrnFactoryAreaFltrVH view from CONSUMPTION All Factory Areas for Safety Instruction
C_SubstSftyInstrnAreaFltrVH view from CONSUMPTION All Factory Areas for Safety Instruction for Substance
C_SubstSftyInstrnFactoryAreaVH view from CONSUMPTION Factory Areas for Safety Instruction for Substance
I_CurEHSLocationInclRoot view inner COMPOSITE Current revision of EHS Locations
I_CurrentEHSLocationHierarchy view from COMPOSITE Current EHS Location Structure Hierarchy
I_CurrentEHSLocHierValueHelp view inner COMPOSITE EHS Location Value Help
I_EHSCmplncAnlysLocTypeTaskC view inner COMPOSITE Compl Analysis Cube of Tasks by Loc type
I_EHSLocationHierarchy view from COMPOSITE EHS Location Hierarchy
I_EHSLocationValueHelp view inner COMPOSITE EHS Location Value Help
I_ReldSftyInstrnFactoryVH view_entity inner COMPOSITE Factories for Safety Instruction
I_ReldSftyInstrnFctryAreaVH view_entity from COMPOSITE Factory Areas for Safety Instruction
P_SftyInstrnTextBlockFactory view inner CONSUMPTION

Fields (7)

KeyField CDS FieldsUsed in Views
KEY EHSLocationUUID EHSLocationUUID 9
KEY EHSLocHierarchyUUID EHSLocHierarchyUUID 1
KEY EHSParentLocationUUID EHSParentLocationUUID 11
_EHSLocation _EHSLocation 8
_EHSParentLocation _EHSParentLocation 8
EHSLocHierarchyNodeUUID EHSLocHierarchyNodeUUID 2
EHSLocHierarchyRevisionUUID EHSLocHierarchyRevisionUUID 1 
@AbapCatalog:{
    sqlViewName: 'IEHSLHRHIER',
    compiler.compareFilter: true
}
@AccessControl.authorizationCheck:  #NOT_ALLOWED
@EndUserText.label: 'Location Hierarchy Node'
@VDM.viewType: #BASIC
@Analytics: { dataCategory: #DIMENSION } //correction 3113514 28.10.2021

// Client handling by session 

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions:true
@ObjectModel:{
    representativeKey: 'EHSLocHierarchyNodeUUID',
// used for BOBF Master Data Object

    usageType:{ serviceQuality: #C,        // < 15 msec   

                         sizeCategory:  #L,         // < 10.000.000

                         dataClass: #ORGANIZATIONAL } 
}
                         
                         
define view I_EHSLocationHierarchyNode as select from ehfndd_lhr_hier
// begin correction 3113514 28.10.2021

  association [0..1] to I_EHSLocationRoot as _EHSLocation       on $projection.EHSLocationUUID = _EHSLocation.EHSLocationUUID
  association [0..1] to I_EHSLocationRoot as _EHSParentLocation on $projection.EHSParentLocationUUID = _EHSParentLocation.EHSLocationUUID
// end correction 3113514 28.10.2021


{

  
  key ehfndd_lhr_hier.db_key as EHSLocHierarchyNodeUUID,

  ehfndd_lhr_hier.root_key as EHSLocHierarchyUUID,

  ehfndd_lhr_hier.parent_key as EHSLocHierarchyRevisionUUID,

  cast( ehfndd_lhr_hier.loc_root_ref_key  as ehfnd_location_uuid_ref preserving type ) as EHSLocationUUID,
  
  cast( ehfndd_lhr_hier.par_root_ref_key as ehfnd_location_uuid_ref preserving type ) as EHSParentLocationUUID,
// begin correction 3113514 28.10.2021

  _EHSLocation,
  _EHSParentLocation
// end correction 3113514 28.10.2021


}

Learn More