VIA_HIER_ITEM_DATA

DDL: VIA_HIER_ITEM_DATA Type: view_entity
11 Fields 1 Data Sources

VIA Hierarchy Item Data

VIA_HIER_ITEM_DATA is a CDS View that provides data about "VIA Hierarchy Item Data" in SAP S/4HANA. It reads from 1 data source (kalc_via_hier_i) and exposes 11 fields.

Data Sources (1)

SourceAliasJoin Type
kalc_via_hier_i kalc_via_hier_i from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label VIA Hierarchy Item Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (11)

KeyFieldSource TableSource FieldDescription
guid guid UUID 22 char.
hierarchy_id hierarchy_id NodeID
type type Worklist Type
parent_id parent_id UUID
related_id related_id Hierarchy ID
currency currency Valuation Crcy
value_s_to_r value_s_to_r Value
value_r_to_s value_r_to_s Value
percentage percentage Well Contribution Percentage
recursion recursion Boolean Variable (X = True, - = False, Space = Unknown)
data_guid data_guid Genuine Unique Identifier

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 VIA_HIER_ITEM_DATA.
-- 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 VIA_HIER_ITEM_DATA AS
SELECT
  guid,
  hierarchy_id,
  type,
  parent_id,
  related_id,
  currency,
  value_s_to_r,
  value_r_to_s,
  percentage,
  recursion,
  data_guid
FROM kalc_via_hier_i
;

Learn More