I_CurrentEHSLocPathWithSelfRef

DDL: I_CURRENTEHSLOCPATHWITHSELFREF Type: view COMPOSITE
6 Fields 2 Data Sources

Union of current location path with self reference

I_CurrentEHSLocPathWithSelfRef is a Composite CDS View that provides data about "Union of current location path with self reference" in SAP S/4HANA. It reads from 2 data sources (I_CurrentEHSLocationPath, I_EHSLocationRoot) and exposes 6 fields with key fields EHSLocationUUID, EHSSuperiorLocationUUID, EHSSuperiorLocationUUID.

Data Sources (2)

SourceAliasJoin Type
I_CurrentEHSLocationPath I_CurrentEHSLocationPath from
I_EHSLocationRoot I_EHSLocationRoot union

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICURLOCPTHWSLF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Union of current location path with self reference view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey EHSLocationUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY EHSLocationUUID EHSLocationUUID NodeID
KEY EHSSuperiorLocationUUID EHSSuperiorLocationUUID NodeID
EHSLocationHierarchyLevel EHSLocationHierarchyLevel
KEY EHSSuperiorLocationUUID EHSLocationUUID NodeID
EHSLocationHierarchyLevel 9999
IsOriginalEHSLocation

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_CurrentEHSLocPathWithSelfRef.
-- 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_CurrentEHSLocPathWithSelfRef AS
SELECT
  EHSLocationUUID,
  EHSSuperiorLocationUUID,
  EHSLocationHierarchyLevel,
  'X' AS IsOriginalEHSLocation
FROM I_CurrentEHSLocationPath
-- UNION with additional select branch(es): I_EHSLocationRoot
;

Learn More