I_EHSLOCHIERARCHYPATH

CDS View
4 Fields 15 CDS Views

Location Hierarchy Path

I_EHSLOCHIERARCHYPATH is a CDS View in S/4HANA. Location Hierarchy Path. It contains 4 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
C_EHSLocHierarchyPathDEX view_entity from CONSUMPTION EHS Location Hierarchy Path
C_SafetyInstrnEquipmentFltrVH view from CONSUMPTION SI: Equipment Value Help for Filter Bar
C_SafetyInstructionEquipmentVH view from CONSUMPTION SI: Equipment Value Help
I_AprvdChemicalsForRskAtLocVH view inner COMPOSITE Approved Chemical for Location
I_CurrentEHSLocationPath view from COMPOSITE Current EHS Location Structure Path
I_CurrentEHSParentLocation view from COMPOSITE Current EHS Parent Location
I_EHSLocationExpanded view from COMPOSITE EHS Location and Sublocations
I_EHSLocationForFiltering view from COMPOSITE EHS Location and Sublocations for Filtering
I_EHSLocEnvrnmtlDtaRespInhtd view_entity inner COMPOSITE Location Environmental Data Responsible Inherited
I_EHSLocRespManagerInherited view inner COMPOSITE Location Responsible Manager Inherited
I_EHSLocRespMgrAndTechnInhtd view inner COMPOSITE Loc Responisble Manager and Operator
I_EHSLocRespTechnInherited view inner COMPOSITE Location Responsible Technician Inheritd
I_FavoriteEHSLocationExpanded view inner COMPOSITE Favorite EHS Location and Sublocations
I_MyEHSLocationExpanded view inner COMPOSITE My EHS Location and Sublocations
P_EHSLocationHierarchyLevel view from COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY EHSLocationUUID EHSLocationUUID 5
KEY EHSLocHierarchyPathUUID EHSLocHierarchyPathUUID 1
KEY EHSParentLocationUUID EHSParentLocationUUID 5
_EHSLocation _EHSLocation 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 Path
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EHSLOCHIERARCHYPATH (
    EHSLOCATIONUUID,
    EHSLOCHIERARCHYPATHUUID,
    EHSPARENTLOCATIONUUID,
    _EHSLOCATION,
    PRIMARY KEY (EHSLOCATIONUUID, EHSLOCHIERARCHYPATHUUID, EHSPARENTLOCATIONUUID)
);

Learn More