I_EHSLocationIdentifier

DDL: I_EHSLOCATIONIDENTIFIER Type: view_entity BASIC
4 Fields 2 Data Sources

EHS Location Identifier

I_EHSLocationIdentifier is a Basic CDS View (Dimension) that provides data about "EHS Location Identifier" in SAP S/4HANA. It reads from 2 data sources (I_EHSLocationRevision, I_EHSLocationRoot) and exposes 4 fields with key fields EHSLocationID, RevisionEndDate.

Data Sources (2)

SourceAliasJoin Type
I_EHSLocationRevision EHSLocationRevision from
I_EHSLocationRoot EHSLocationRoot inner

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 #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label EHS Location Identifier view
VDM.viewType #BASIC view
Metadata.allowExtensions true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY EHSLocationID I_EHSLocationRoot EHSLocationID WorklistID
KEY RevisionEndDate I_EHSLocationRevision RevisionEndDate
EHSLocationRevisionUUID I_EHSLocationRevision EHSLocationRevisionUUID
RevisionStartDate I_EHSLocationRevision RevisionStartDate

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_EHSLocationIdentifier.
-- 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_EHSLocationIdentifier AS
SELECT
  EHSLocationRoot.EHSLocationID AS EHSLocationID,
  EHSLocationRevision.RevisionEndDate AS RevisionEndDate,
  EHSLocationRevision.EHSLocationRevisionUUID AS EHSLocationRevisionUUID,
  EHSLocationRevision.RevisionStartDate AS RevisionStartDate
FROM I_EHSLocationRevision AS EHSLocationRevision
INNER JOIN I_EHSLocationRoot AS EHSLocationRoot ON /* join condition not captured in parsed metadata */
;

Learn More