I_EHSLocationGeoPoint

DDL: I_EHSLOCATIONGEOPOINT Type: view_entity COMPOSITE
8 Fields 2 Data Sources 1 Associations

Location map position

I_EHSLocationGeoPoint (Composite)

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

Cross Applications

I_EHSLocationGeoPoint is a Composite CDS View (Dimension) that provides data about "Location map position" in SAP S/4HANA. It reads from 2 data sources (I_EHSLocationRevision, I_EHSLocationRoot) and exposes 8 fields with key fields EHSLocationID, RevisionEndDate. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentEHS-SUS-FND-EHS
CapabilitiesData Source in SQL Select, Association Target for Defining CDS Entities, Analytical Dimension, Data Source for Defining CDS Entities
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (2)

SourceAliasJoin Type
I_EHSLocationRevision EHSLocationRevision from
I_EHSLocationRoot EHSLocationRoot inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_EHSLocNameByIdentifierText _Text EHSLocationRoot.EHSLocationID = _Text.EHSLocationID and EHSLocationRevision.EHSLocationRevisionUUID = _Text.EHSLocationRevisionUUID

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled false view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey EHSLocationID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Location map position view
VDM.viewType #COMPOSITE view
Metadata.allowExtensions true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY EHSLocationID I_EHSLocationRoot EHSLocationID Location ID
KEY RevisionEndDate I_EHSLocationRevision RevisionEndDate Revision End Date
EHSLocationRevisionUUID I_EHSLocationRevision EHSLocationRevisionUUID EHS Location - Revision UUID
RevisionStartDate I_EHSLocationRevision RevisionStartDate Revision Start Date
EHSLocationUUID I_EHSLocationRevision EHSLocationUUID Location
EHSLocationGeoPoint LocGeoPosition EHSLocationGeoPoint
EHSLocationName _Text EHSLocationName Location
_Text _Text

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_EHSLocationGeoPoint.
-- 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_EHSLocationGeoPoint AS
SELECT
  EHSLocationRoot.EHSLocationID AS EHSLocationID,
  EHSLocationRevision.RevisionEndDate AS RevisionEndDate,
  EHSLocationRevision.EHSLocationRevisionUUID AS EHSLocationRevisionUUID,
  EHSLocationRevision.RevisionStartDate AS RevisionStartDate,
  EHSLocationRevision.EHSLocationUUID AS EHSLocationUUID,
  LocGeoPosition.EHSLocationGeoPoint AS EHSLocationGeoPoint,
  _Text.EHSLocationName AS EHSLocationName
FROM I_EHSLocationRevision AS EHSLocationRevision
INNER JOIN I_EHSLocationRoot AS EHSLocationRoot ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EHSLocNameByIdentifierText AS _Text ON EHSLocationRoot.EHSLocationID = _Text.EHSLocationID AND EHSLocationRevision.EHSLocationRevisionUUID = _Text.EHSLocationRevisionUUID  -- association [0..*]
;

Learn More