I_EHSLOCATIONROOT

CDS View
4 Fields 14 CDS Views

EHS Location

I_EHSLOCATIONROOT is a CDS View in S/4HANA. EHS Location. It contains 4 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
C_EHSLocationDEX view_entity from CONSUMPTION EHS Location
I_CurrentEHSLocPathWithSelfRef view union COMPOSITE Union of current location path with self reference
I_EHSJobForIdentifyRisks view from COMPOSITE Interface view for the Jobs used in the EHS Risks
I_EHSLocationByIdentifier view_entity inner BASIC Location by identifier
I_EHSLocationForFiltering view union COMPOSITE EHS Location and Sublocations for Filtering
I_EHSLocationGeoPoint view_entity inner COMPOSITE Location map position
I_EHSLocationIdentifier view_entity inner BASIC EHS Location Identifier
I_EHSLocationImageURL view from COMPOSITE Image URLs for Locations
I_LocationMigrationValueHelp view_entity from COMPOSITE Location Migration
I_MyEHSLocation view inner BASIC Determine the defined MyLocation
I_OptionalMyEHSLocationFilter view from COMPOSITE Optional My EHS Location Filter
P_EHSJobStepForIdentifyRisks view union CONSUMPTION
P_LOCMANAGERSCOUNT view from COMPOSITE
P_LOCTECHNICIANSCOUNT view from COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY EHSLocationID EHSLocationID 4
KEY EHSLocationUUID EHSLocationUUID 4
_EHSLocationRevision _EHSLocationRevision 1
_EHSLocNameCurrentRevision _EHSLocationName 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.

-- EHS Location
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EHSLOCATIONROOT (
    EHSLOCATIONID,
    EHSLOCATIONUUID,
    _EHSLOCATIONREVISION,
    _EHSLOCNAMECURRENTREVISION,
    PRIMARY KEY (EHSLOCATIONID, EHSLOCATIONUUID)
);

Learn More