I_EHSLOCATIONHIERARCHYNODE

CDS View
7 Fields 25 CDS Views

Location Hierarchy Node

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

CDS Views using this table (25)

ViewTypeJoinVDMDescription
C_EHSChmlUseLocationVH view_entity inner CONSUMPTION Chemical Use Location
C_EHSRskAssmt2LocationVH view_entity inner CONSUMPTION Risk Assessment Location
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_MyEHSLocationExpanded view inner COMPOSITE My EHS Location and Sublocations
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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Location Hierarchy Node
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EHSLOCATIONHIERARCHYNODE (
    EHSLOCATIONUUID,
    EHSLOCHIERARCHYUUID,
    EHSPARENTLOCATIONUUID,
    _EHSLOCATION,
    _EHSPARENTLOCATION,
    EHSLOCHIERARCHYNODEUUID,
    EHSLOCHIERARCHYREVISIONUUID,
    PRIMARY KEY (EHSLOCATIONUUID, EHSLOCHIERARCHYUUID, EHSPARENTLOCATIONUUID)
);

Learn More