I_EHSLocation

DDL: I_EHSLOCATION Type: view BASIC Package: EHFND_BO_LOC_IMPL
47 Fields 1 Data Sources 2 Associations

EHS Location

I_EHSLocation (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

EHS Location · Cross Applications

I_EHSLocation is a Basic CDS View (Dimension) that provides data about "EHS Location" in SAP S/4HANA. It reads from 1 data source (I_EHSLocationRevision) and exposes 47 fields with key fields EHSLocationUUID, RevisionEndDate. It has 2 associations to related views. Part of development package EHFND_BO_LOC_IMPL.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessCross Applications
Application ComponentEHS-SUS-FND-EHS
CapabilitiesData Source for Data Extraction,Analytical Dimension,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageCross Applications for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view retrieves details about the current (most recent) location revision.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What's the status of my current location revision? What about the location type?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_EHSLocationRevision I_EHSLocationRevision from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_EHSLocationHierarchy _EHSLocationHierarchy $projection.EHSLocationUUID = _EHSLocationHierarchy.EHSLocationUUID
[1..1] I_EHSLocationRoot _EHSLocationRoot $projection.EHSLocationUUID = _EHSLocationRoot.EHSLocationUUID

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName ILOCATION view
AbapCatalog.compiler.compareFilter true view
EndUserText.label EHS Location view
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
ObjectModel.representativeKey EHSLocationUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelingPattern #NONE view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Consumption.filter.businessDate.at true view
ObjectModel.sapObjectNodeType.name EHSLocation view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY EHSLocationUUID I_EHSLocationRevision EHSLocationUUID Location
KEY RevisionEndDate I_EHSLocationRevision RevisionEndDate Revision End Date
RevisionStartDate I_EHSLocationRevision RevisionStartDate Revision Start Date
EHSLocationRevisionUUID I_EHSLocationRevision EHSLocationRevisionUUID EHS Location - Revision UUID
CreationDateTime I_EHSLocationRevision CreationDateTime Created On
CreatedByUser I_EHSLocationRevision CreatedByUser Created By
LastChangeDateTime I_EHSLocationRevision LastChangeDateTime Last Changed On
LastChangedByUser I_EHSLocationRevision LastChangedByUser Last Change By
EHSLocationType I_EHSLocationRevision EHSLocationType Location Type
EHSLocationStatus I_EHSLocationRevision EHSLocationStatus Location Status
Plant I_EHSLocationRevision Plant Valuation Area
EHSLocationPhone I_EHSLocationRevision EHSLocationPhone Telephone Number
CompanyCode I_EHSLocationRevision CompanyCode Receiver Company Code
BusinessArea I_EHSLocationRevision BusinessArea Business Area
CostCenter I_EHSLocationRevision CostCenter Cost Center
ControllingArea I_EHSLocationRevision ControllingArea Controlling Area
OrganizationalUnit I_EHSLocationRevision OrganizationalUnit Organizational Unit ID
StorageLocation I_EHSLocationRevision StorageLocation Storage Location
EHSLocationAuthorizationGroup I_EHSLocationRevision EHSLocationAuthorizationGroup Location Authorization Group
Country I_EHSLocationRevision Country Venue: Ctry/Reg
Region I_EHSLocationRevision Region Venue Region
CityName I_EHSLocationRevision CityName Name
StreetName I_EHSLocationRevision StreetName Street Address
PostalCode I_EHSLocationRevision PostalCode City Postal Code
Equipment I_EHSLocationRevision Equipment Equipment check
FunctionalLocation I_EHSLocationRevision FunctionalLocation Functional Location ID
Latitude I_EHSLocationRevision Latitude Geographic Latitude
Longitude I_EHSLocationRevision Longitude Geographic Longitude
EHSLocationID _EHSLocationRoot EHSLocationID Location ID
_BusinessArea I_EHSLocationRevision _BusinessArea
_CompanyCode I_EHSLocationRevision _CompanyCode
_ControllingArea I_EHSLocationRevision _ControllingArea
_OrganizationalUnit I_EHSLocationRevision _OrganizationalUnit
_StorageLocation I_EHSLocationRevision _StorageLocation
_Country I_EHSLocationRevision _Country
_CreatedByUser I_EHSLocationRevision _CreatedByUser
_EHSLocationRevisionName I_EHSLocationRevision _EHSLocationRevisionName
_EHSLocationAuthGroup I_EHSLocationRevision _EHSLocationAuthGroup
_EHSLocationStatus I_EHSLocationRevision _EHSLocationStatus
_EHSLocationType I_EHSLocationRevision _EHSLocationType
_LastChangedByUser I_EHSLocationRevision _LastChangedByUser
_Plant I_EHSLocationRevision _Plant
_Region I_EHSLocationRevision _Region
_Equipment I_EHSLocationRevision _Equipment
_FunctionalLocation I_EHSLocationRevision _FunctionalLocation
_EHSLocationRoot _EHSLocationRoot
_EHSLocationHierarchy _EHSLocationHierarchy

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_EHSLocation.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_EHSLocation AS
SELECT
  I_EHSLocationRevision.EHSLocationUUID AS EHSLocationUUID,
  I_EHSLocationRevision.RevisionEndDate AS RevisionEndDate,
  I_EHSLocationRevision.RevisionStartDate AS RevisionStartDate,
  I_EHSLocationRevision.EHSLocationRevisionUUID AS EHSLocationRevisionUUID,
  I_EHSLocationRevision.CreationDateTime AS CreationDateTime,
  I_EHSLocationRevision.CreatedByUser AS CreatedByUser,
  I_EHSLocationRevision.LastChangeDateTime AS LastChangeDateTime,
  I_EHSLocationRevision.LastChangedByUser AS LastChangedByUser,
  I_EHSLocationRevision.EHSLocationType AS EHSLocationType,
  I_EHSLocationRevision.EHSLocationStatus AS EHSLocationStatus,
  I_EHSLocationRevision.Plant AS Plant,
  I_EHSLocationRevision.EHSLocationPhone AS EHSLocationPhone,
  I_EHSLocationRevision.CompanyCode AS CompanyCode,
  I_EHSLocationRevision.BusinessArea AS BusinessArea,
  I_EHSLocationRevision.CostCenter AS CostCenter,
  I_EHSLocationRevision.ControllingArea AS ControllingArea,
  I_EHSLocationRevision.OrganizationalUnit AS OrganizationalUnit,
  I_EHSLocationRevision.StorageLocation AS StorageLocation,
  I_EHSLocationRevision.EHSLocationAuthorizationGroup AS EHSLocationAuthorizationGroup,
  I_EHSLocationRevision.Country AS Country,
  I_EHSLocationRevision.Region AS Region,
  I_EHSLocationRevision.CityName AS CityName,
  I_EHSLocationRevision.StreetName AS StreetName,
  I_EHSLocationRevision.PostalCode AS PostalCode,
  I_EHSLocationRevision.Equipment AS Equipment,
  I_EHSLocationRevision.FunctionalLocation AS FunctionalLocation,
  I_EHSLocationRevision.Latitude AS Latitude,
  I_EHSLocationRevision.Longitude AS Longitude,
  _EHSLocationRoot.EHSLocationID AS EHSLocationID,
  I_EHSLocationRevision._BusinessArea AS _BusinessArea,
  I_EHSLocationRevision._CompanyCode AS _CompanyCode,
  I_EHSLocationRevision._ControllingArea AS _ControllingArea,
  I_EHSLocationRevision._OrganizationalUnit AS _OrganizationalUnit,
  I_EHSLocationRevision._StorageLocation AS _StorageLocation,
  I_EHSLocationRevision._Country AS _Country,
  I_EHSLocationRevision._CreatedByUser AS _CreatedByUser,
  I_EHSLocationRevision._EHSLocationRevisionName AS _EHSLocationRevisionName,
  I_EHSLocationRevision._EHSLocationAuthGroup AS _EHSLocationAuthGroup,
  I_EHSLocationRevision._EHSLocationStatus AS _EHSLocationStatus,
  I_EHSLocationRevision._EHSLocationType AS _EHSLocationType,
  I_EHSLocationRevision._LastChangedByUser AS _LastChangedByUser,
  I_EHSLocationRevision._Plant AS _Plant,
  I_EHSLocationRevision._Region AS _Region,
  I_EHSLocationRevision._Equipment AS _Equipment,
  I_EHSLocationRevision._FunctionalLocation AS _FunctionalLocation
FROM I_EHSLocationRevision
LEFT OUTER JOIN I_EHSLocationHierarchy AS _EHSLocationHierarchy ON EHSLocationUUID = _EHSLocationHierarchy.EHSLocationUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSLocationRoot AS _EHSLocationRoot ON EHSLocationUUID = _EHSLocationRoot.EHSLocationUUID  -- association [1..1]
;

Learn More