ACMHEX_HIERS4DIM3

DDL: ACMHEX_HIERS4DIM3 SQL: ACMHEXSV_HI4DIM3 Type: view Package: SACMHIEREX
9 Fields 1 Data Sources 4 Associations

ACMHEX: Single Hierarchy for Dimension-3

ACMHEX_HIERS4DIM3 is a CDS View that provides data about "ACMHEX: Single Hierarchy for Dimension-3" in SAP S/4HANA. It reads from 1 data source (acmhexdb_hi4dim3) and exposes 9 fields with key field nodeid. It has 4 associations to related views. Part of development package SACMHIEREX.

Data Sources (1)

SourceAliasJoin Type
acmhexdb_hi4dim3 acmhexdb_hi4dim3 from

Associations (4)

CardinalityTargetAliasCondition
[0..1] ACMHEX_HIERS4DIM3 _parent $projection.parentid = _parent.nodeid --
[1] ACMHEX_HIERS4DIM3_DIRECTORY _dir $projection.city is not null --= _dir.last_changed --Keine Ahnung, was ich da eintragen soll!
[1] ACMHEX_SREGION _sregion $projection.region = _sregion.region_code and $projection.country = '' and $projection.cityto = ''
[1] ACMHEX_SCITY _scity $projection.region = '' and $projection.country = _scity.country and $projection.cityto = _scity.city

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ACMHEXSV_HI4DIM3 view
EndUserText.label ACMHEX: Single Hierarchy for Dimension-3 view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.dataCategory #HIERARCHY view
Hierarchy.parentChild.name HierarchyForDim3 view
Hierarchy.parentChild.label ConnId view
Hierarchy.parentChild.recurseBy _parent view
Hierarchy.parentChild.directory _dir view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY nodeid acmhexdb_hi4dim3 nodeid Workflow Step
parentid acmhexdb_hi4dim3 parentid UUID
region acmhexdb_hi4dim3 region Venue Region
country acmhexdb_hi4dim3 country Venue: Ctry/Reg
cityto acmhexdb_hi4dim3 cityto Destination City
_parent _parent
_dir
_sregion _sregion
_scity _scity

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_HIERS4DIM3.
-- 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_HI4DIM3

CREATE VIEW ACMHEX_HIERS4DIM3 AS
SELECT
  acmhexdb_hi4dim3.nodeid AS nodeid,
  acmhexdb_hi4dim3.parentid AS parentid,
  acmhexdb_hi4dim3.region AS region,
  acmhexdb_hi4dim3.country AS country,
  acmhexdb_hi4dim3.cityto AS cityto
FROM acmhexdb_hi4dim3
LEFT OUTER JOIN ACMHEX_HIERS4DIM3 AS _parent ON parentid = _parent.nodeid  -- association [0..1]
LEFT OUTER JOIN ACMHEX_HIERS4DIM3_DIRECTORY AS _dir ON /* condition not available in parsed metadata */  -- association [1]
LEFT OUTER JOIN ACMHEX_SREGION AS _sregion ON region = _sregion.region_code AND country = '' AND cityto = ''  -- association [1]
LEFT OUTER JOIN ACMHEX_SCITY AS _scity ON region = '' AND country = _scity.country AND cityto = _scity.city  -- association [1]
;

Learn More