I_EHSLOCATION

CDS View
41 Fields 26 CDS Views

EHS Location

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

CDS Views using this table (26)

ViewTypeJoinVDMDescription
C_EHSChmlUseLocationVH view_entity from CONSUMPTION Chemical Use Location
C_EHSLocation view from CONSUMPTION EHS Location
C_EHSLocationBuildingVH view inner CONSUMPTION Location Building
C_EHSLocationCityVH view from CONSUMPTION Location City Value Help
C_EHSRskAssmt2LocationVH view_entity from CONSUMPTION Risk Assessment Location
C_HzdsSubstInventoryFltrLocVH view from CONSUMPTION HSI: Location Filter Value Help
C_HzdsSubstInventoryFreeLoc view from CONSUMPTION HSI: Set of free locations
C_HzdsSubstInventoryLocVH view from CONSUMPTION HSI: Location Value Help
C_HzdsSubstInvtryInfoCityVH view from CONSUMPTION HSI Info: City Value Help
C_IncidentCatForSafetyInsights view from CONSUMPTION Incident Category for Safety Insights
C_SafetyInstrnBuildingFltrVH view inner CONSUMPTION Building Value Help for Filter Bar
C_SafetyInstrnBuildingVH view inner CONSUMPTION FSI: Buildings Value Help
C_SafetyInstrnFactoryByPlantVH view from CONSUMPTION Value Help for Factories by SI Structure
C_SafetyInstructionFactoryVH view from CONSUMPTION HSI: Location Value Help
I_CurEHSLocationInclRoot view from COMPOSITE Current revision of EHS Locations
I_CurrentEHSLocation view from BASIC Current EHS Location
I_CurrentEHSLocHierValueHelp view from COMPOSITE EHS Location Value Help
I_EHSLocationIncludingRoot view from COMPOSITE EHS Location Including the Root Location
I_EHSLocationValueHelp view from COMPOSITE EHS Location Value Help
I_EnvironmentWasteLocation view from COMPOSITE Environment Waste Location
I_EnvWstTranspDocWasteLocation view_entity from COMPOSITE Waste Transportation Documents Location
I_ReldSftyInstrnFactoryVH view_entity from COMPOSITE Factories for Safety Instruction
I_WasteDisposalChannelGnrtr view from COMPOSITE Waste Generator for Disposal Channel
I_WasteStreamPtOfGnrtnLoc view inner COMPOSITE Waste Stream Pt Of Generation Location
I_WasteStreamStorageLoc view inner COMPOSITE Waste Stream Storage Location
P_SftyInstrnTextBlockFactory view from CONSUMPTION

Fields (41)

KeyField CDS FieldsUsed in Views
KEY EHSLocationUUID EHSLocationUUID,EnvrmtWasteGnrtrUUID 17
_BusinessArea _BusinessArea 3
_CompanyCode _CompanyCode 3
_ControllingArea _ControllingArea 1
_Country _Country 3
_CreatedByUser _CreatedByUser 1
_EHSLocationRevisionName _EHSLocationRevisionName,_Name 2
_EHSLocationRoot _EHSLocationRoot 1
_EHSLocationStatus _EHSLocationStatus 3
_EHSLocationType _EHSLocationType 1
_Equipment _Equipment 1
_LastChangedByUser _LastChangedByUser 1
_OrganizationalUnit _OrganizationalUnit 1
_Plant _Plant 3
_Region _Region 1
_StorageLocation _StorageLocation 1
BusinessArea BusinessArea 12
CityName CityName 2
CompanyCode CompanyCode 12
ControllingArea ControllingArea 2
CostCenter CostCenter 15
Country Country 10
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
EHSLocationID EHSLocationID,WasteStreamPtOfGnrtnLocID,WasteStreamStorageLocID 7
EHSLocationPhone EHSLocationPhone 2
EHSLocationRevisionUUID EHSLocationRevisionUUID 2
EHSLocationStatus EHSLocationStatus 13
EHSLocationType EHSLocationType 7
Equipment Equipment 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
Latitude Latitude 1
Longitude Longitude 1
Plant Plant 15
PostalCode PostalCode 2
Region Region 2
RevisionEndDate RevisionEndDate 3
RevisionStartDate RevisionStartDate 3
StorageLocation StorageLocation 1
StreetName StreetName 2

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_EHSLOCATION (
    EHSLOCATIONUUID,
    _BUSINESSAREA,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _COUNTRY,
    _CREATEDBYUSER,
    _EHSLOCATIONREVISIONNAME,
    _EHSLOCATIONROOT,
    _EHSLOCATIONSTATUS,
    _EHSLOCATIONTYPE,
    _EQUIPMENT,
    _LASTCHANGEDBYUSER,
    _ORGANIZATIONALUNIT,
    _PLANT,
    _REGION,
    _STORAGELOCATION,
    BUSINESSAREA,
    CITYNAME,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRY,
    CREATEDBYUSER,
    CREATIONDATETIME,
    EHSLOCATIONID,
    EHSLOCATIONPHONE,
    EHSLOCATIONREVISIONUUID,
    EHSLOCATIONSTATUS,
    EHSLOCATIONTYPE,
    EQUIPMENT,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LATITUDE,
    LONGITUDE,
    PLANT,
    POSTALCODE,
    REGION,
    REVISIONENDDATE,
    REVISIONSTARTDATE,
    STORAGELOCATION,
    STREETNAME,
    PRIMARY KEY (EHSLOCATIONUUID)
);

Learn More