ACMHEX_HIERS4DIM1

DDL: ACMHEX_HIERS4DIM1 SQL: ACMHEXSV_HI4DIM1 Type: view
13 Fields 1 Data Sources 6 Associations

ACMHEX: Hierarchies for Dimension-1

ACMHEX_HIERS4DIM1 is a CDS View that provides data about "ACMHEX: Hierarchies for Dimension-1" in SAP S/4HANA. It reads from 1 data source (acmhexdb_hi4dim1) and exposes 13 fields with key fields hieid, nodeid. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
acmhexdb_hi4dim1 acmhexdb_hi4dim1 from

Associations (6)

CardinalityTargetAliasCondition
[0..1] ACMHEX_HIERS4DIM1 _parent $projection.hieid = _parent.hieid and $projection.parentid = _parent.nodeid
[1] ACMHEX_HIERS4DIM1_DIRECTORY _dir $projection.hieid = _dir.hieid
[1] ACMHEX_SREGION _sregion $projection.region = _sregion.region_code and $projection.continent = '' and $projection.country = '' and $projection.carrid = ''
[1] ACMHEX_SCONTINENT _scontinent $projection.region = _scontinent.region_code and $projection.continent = _scontinent.continent and $projection.country = '' and $projection.carrid = ''
[1] ACMHEX_SCOUNTRY _scountry $projection.region = '' and $projection.continent = '' and $projection.country = _scountry.land1 and $projection.carrid = ''
[1] ACMHEX_SCARR _scarr $projection.region = '' and $projection.continent = '' and $projection.country = '' and $projection.carrid = _scarr.carrid

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ACMHEXSV_HI4DIM1 view
EndUserText.label ACMHEX: Hierarchies for Dimension-1 view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.dataCategory #HIERARCHY view
Hierarchy.parentChild.name HierarchyForDim1 view
Hierarchy.parentChild.label CarrId view
Hierarchy.parentChild.recurseBy _parent view
Hierarchy.parentChild.directory _dir view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY hieid acmhexdb_hi4dim1 hieid R/2 table
KEY nodeid acmhexdb_hi4dim1 nodeid Workflow Step
parentid acmhexdb_hi4dim1 parentid UUID
region acmhexdb_hi4dim1 region Venue Region
continent acmhexdb_hi4dim1 continent Continent
country acmhexdb_hi4dim1 country Venue: Ctry/Reg
carrid acmhexdb_hi4dim1 carrid Carrier
_parent _parent
_dir _dir
_sregion _sregion
_scontinent _scontinent
_scountry _scountry
_scarr _scarr

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 ACMHEX_HIERS4DIM1.
-- 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.
-- SQL view name: ACMHEXSV_HI4DIM1

CREATE VIEW ACMHEX_HIERS4DIM1 AS
SELECT
  acmhexdb_hi4dim1.hieid AS hieid,
  acmhexdb_hi4dim1.nodeid AS nodeid,
  acmhexdb_hi4dim1.parentid AS parentid,
  acmhexdb_hi4dim1.region AS region,
  acmhexdb_hi4dim1.continent AS continent,
  acmhexdb_hi4dim1.country AS country,
  acmhexdb_hi4dim1.carrid AS carrid
FROM acmhexdb_hi4dim1
LEFT OUTER JOIN ACMHEX_HIERS4DIM1 AS _parent ON hieid = _parent.hieid AND parentid = _parent.nodeid  -- association [0..1]
LEFT OUTER JOIN ACMHEX_HIERS4DIM1_DIRECTORY AS _dir ON hieid = _dir.hieid  -- association [1]
LEFT OUTER JOIN ACMHEX_SREGION AS _sregion ON region = _sregion.region_code AND continent = '' AND country = '' AND carrid = ''  -- association [1]
LEFT OUTER JOIN ACMHEX_SCONTINENT AS _scontinent ON region = _scontinent.region_code AND continent = _scontinent.continent AND country = '' AND carrid = ''  -- association [1]
LEFT OUTER JOIN ACMHEX_SCOUNTRY AS _scountry ON region = '' AND continent = '' AND country = _scountry.land1 AND carrid = ''  -- association [1]
LEFT OUTER JOIN ACMHEX_SCARR AS _scarr ON region = '' AND continent = '' AND country = '' AND carrid = _scarr.carrid  -- association [1]
;

Learn More