What is I_HierRuntimeRprstnNode in SAP S/4HANA?

I_HierRuntimeRprstnNode is a basic CDS view in SAP S/4HANA. Hierarchy Node It contains 79 fields.

Which tables does I_HierRuntimeRprstnNode read from?

I_HierRuntimeRprstnNode reads data from: hrrp_node_n.

What VDM layer is I_HierRuntimeRprstnNode?

I_HierRuntimeRprstnNode is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_HierRuntimeRprstnNode

DDL: I_HIERRUNTIMERPRSTNNODE SQL: IHRRPNODE Type: view BASIC

79 Fields 1 Data Sources 2 Associations

Hierarchy Node

I_HierRuntimeRprstnNode is a Basic CDS View that provides data about "Hierarchy Node" in SAP S/4HANA. It reads from 1 data source (hrrp_node_n) and exposes 79 fields with key fields RuntimeHierarchy, ValidityEndDate, HierarchyNode, HierarchyNodeClass, ParentNode. It has 2 associations to related views.

SAP Help Documentation

Category	CDS Views for Master Data

Purpose
This CDS view is designed to represent hierarchy nodes within a runtime hierarchy structure. It provides detailed information about each node, including its validity period, type, and various financial and organizational attributes. The view is essential for managing and analyzing hierarchical data structures in financial and controlling contexts. This CDS view provides the data to answer the following business questions: What are the details of each hierarchy node within a specific runtime hierarchy? What is the validity period for each hierarchy node? How are hierarchy nodes classified and what are their parent-child relationships? What financial attributes are associated with each hierarchy node, such as GL account, cost center, and profit center? How can hierarchy nodes be analyzed in terms of their financial transaction types and business transaction types? What organizational attributes, such as company code, segment, and controlling area, are linked to each hierarchy node? How do hierarchy nodes relate to specific projects, materials, and business partners? What are the characteristics of hierarchy nodes in terms of their time dependency and node type? How can hierarchy nodes be utilized for consolidation purposes, including elimination characteristics and consolidation units? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: Authorization Object ID Authorization Object Text F_UNI_HIER Universal Hierarchy Access

Structure
Important Fields Important fields in this view include the following: Field Name Description CHARTOFACCOUNTS Chart of Accounts MATERIALGROUP Material Group DIVISION Division POSTINGLEVEL Posting Level CONSOLIDATIONCHARTOFACCOUNTS Consolidation COA NODETYPE Node Type SUBITEMCATEGORY Subitem Category ACTIVITYTYPE Activity Type PRICINGISRELEVANT Price determination FINANCIALSTATEMENTNODETYPE Node Type HIERARCHYNODEISTIMEDEPENDENT Time-Dependent Node FINANCIALSERVICESPRODUCTGROUP Product Group (FS) RUNTIMEHIERARCHY Hierarchy ID VALIDATIONSCENARIOID Scenario VALIDITYENDDATE Validity End Date VALIDITYSTARTDATE Validity Start Date BANKACCOUNTINTERNALID Technical ID HIERARCHYNODELEVEL Hierarchy Level HIERARCHYNODESEQUENCE Sequence Number MATERIAL Material GLACCOUNT G/L Account PROFITCENTER Profit Center COSTCENTER Cost Center ORDERID Order SEGMENT Segment GRANTID Grant CONSOLIDATIONUNIT Consolidation Unit COMPANY Company COMMITMENTITEM Commitment Item BUSINESSPARTNERNUMBER Business Partner LIQUIDITYITEM Liquidity Item ASSETSUPPLIER Supplier CUSTOMERNUM Customer FINANCIALSTATEMENTITEMTEMPLATE FS Item VALIDATIONRULEID Rule ID FINMGMTAREAFISCALYEAR FMA Fiscal Year CNSLDTNELIMINATIONCHARCVALUE Cons. Elim. Member HIERARCHYTYPE Hierarchy Type DEBITCREDITCODE Balance HIERARCHYNODE Node PARENTNODE Par. Node BANKACCOUNTGROUPINGISSET Bank Account Grouping HIERARCHYNODEVAL Value FINANCIALSTATEMENTLEAFITEM FS Leaf Item HIERARCHYNODECLASS Node Class CONTROLLINGAREA Controlling Area FUNCTIONALAREA Functional Area FUND Fund BUSINESSTRANSACTIONTYPE Bus. Trans. Type CUSTOMERGROUP Customer Group FINANCIALMANAGEMENTAREA FM Area SALESDISTRICT Sales District BUDGETPERIOD Budget Period FINANCIALTRANSACTIONTYPE Transaction Type BILLINGDOCUMENTTYPE Billing Type PROJECT Project WBSELEMENT WBS Element SPONSOREDPROGRAM Sponsored Program FUNDEDPROGRAM Funded Program SPONSOREDCLASS Sponsored Class SUBITEM Subitem CONSOLIDATIONDOCUMENTTYPE Document Type ASSETBUSINESSAREA Business Area INDUSTRY Industry UNIVERSALHIERNODEID N

View on SAP Help Portal →

Data Sources (1)

Source	Alias	Join Type
hrrp_node_n	hrrp_node_n	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_HierRuntimeRepresentation	_Hierarchy	`$projection.RuntimeHierarchy = _Hierarchy.RuntimeHierarchy and $projection.ValidityEndDate = _Hierarchy.ValidityEndDate`
[0..*]	I_HierRuntimeRprstnNodeText	_Text	`$projection.RuntimeHierarchy = _Text.RuntimeHierarchy and $projection.ValidityEndDate = _Text.ValidityEndDate and $projection.HierarchyNode = _Text.HierarchyNode and $projection.HierarchyNodeClass = _Text.HierarchyNodeClass and $projection.ParentNode = _Text.ParentNode`

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	IHRRPNODE	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Hierarchy Node	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (79)

Key	Field	Source Field	Description
KEY	RuntimeHierarchy	hryid	Hierarchy ID
KEY	ValidityEndDate		Valid To
KEY	HierarchyNode	hrynode	Node
KEY	HierarchyNodeClass	nodecls	Node Class
KEY	ParentNode	parnode	Par. Node
	HierarchyType	hrytyp	Hierarchy Type
	ValidityStartDate		Valid From
	DebitCreditCode	balind	Balance
	NodeType	nodetype	Object Type
	HierarchyNodeVal	nodevalue	Value
	HierarchyNodeSequence	hryseqnbr	Sequence Number
	HierarchyNodeLevel	hrylevel	Hierarchy Level
	ControllingArea	kokrs	Org. Value
	ChartOfAccounts	ktopl	G/L Chart of Accounts
	ConsolidationChartOfAccounts	itclg	Consolidation COA
	SubItemCategory	sityp	Trip Schedule Type
	ValidationScenarioID	scen_id	Scenario
	FinancialManagementArea	fikrs	FM Area
	FinMgmtAreaFiscalYear	fma_fisyear	FMA Fiscal Year
	GLAccount	saknr	G/L Account
	CostCenter	kostl	Substitute CC
	ProfitCenter	prctr	Profit Centers
	StatisticalKeyFigure	stagr	Statistical Key Figure
	ActivityType	lstar	Activity Type
	WBSElement		WBS Element
	FunctionalArea	fkber	Functional Area
	CompanyCode	bukrs	Value
	Segment	segment	Segment number
	BusinessTransactionType	cbttype	Bus. Trans. Type
	OrderID	aufnr	SettlementOrder
	Fund	fincode	Fund
	GrantID	grant_nbr	Receiver Grant
	BudgetPeriod	budget_pd	Rec BudPer
	SponsoredClass	sponsored_class	Sponsored Class
	FundCenterText	fictr	Funds Center
	SponsoredProgram	sponsored_prog	Sponsored Program
	FundedProgram	measure	obsolete
	BusinessPartnerNumber	partner	With Partner
	BankAccountInternalID	acc_id	Technical ID
	LiquidityItem	lqpos	Liquidity Item
	AssetBusinessArea	gsber	Business Area
	FinancialTransactionType	trtyp	Transact. type
	CustomerNum	kunnr	Stock customer
	AssetSupplier	lifnr	Vendor no.
	Project		Std. proj. def.
	Material	matnr	Vehicle Model
	CustomerGroup	kdgrp	Customer group
	CountryOrRegion	land1	Trip Ctry/Reg
	FinancialStatementItemTemplate	item	Task ID
	ConsolidationUnit		Consolidation Unit
	SubItem	sitem	Subitem
	ConsolidationDocumentType	docty	Document Type
	Company	rcomp	Trading Partner
	MaterialGroup	matkl	Product Sold Group
	ValidationRuleID	rule_num	Rule ID
	SalesDistrict	bzirk	Sales District
	BillingDocumentType	fkart	Ship. cost type
	Division	spart	Source supplier
	SalesOrganization	vkorg	SD Sales Org.
	DistributionChannel	vtweg	RefDistCh-Cust/Mat.
	Plant	werks	Receiving Plant
	Industry	brsch	Industry
	CommitmentItem	fipex	obsolete
	PostingLevel	plevl	Posting Level
	FinancialServicesProductGroup	fs_product_group	Product Group (FS)
	PricingIsRelevant	pricingrelevant	Price determin.
	SignIsInverted		Type of SIGN component in row type of a Ranges type
	GeneralLedgerAgingIncrement	regrouping	Increment
	FinancialStatementLeafItem	fs_leafitem	FS Leaf Item
	FinancialStatementNodeType	fs_nodetype	Node Type
	FinStmntNodeFormattedID	hrynodeext	Node for Extraction
	BankAccountGroupingIsSet	banksplit	Bank Account Grouping
	HierarchyNodeIsTimeDependent	node_timedep
	HierarchyNodeType	node_typelem	Node Type Element
	CnsldtnEliminationCharcValue	eliminationmember
	UniversalHierNodeID	uhnodeid	Node ID
	UniversalHierNodeParentID	par_uhnodeid	Node Parent ID
	_Text	_Text
	_Hierarchy	_Hierarchy

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_HierRuntimeRprstnNode.
-- 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: IHRRPNODE

CREATE VIEW I_HierRuntimeRprstnNode AS
SELECT
  hryid AS RuntimeHierarchy,
  cast(hryvalto as fis_datbi preserving type ) AS ValidityEndDate,
  hrynode AS HierarchyNode,
  nodecls AS HierarchyNodeClass,
  parnode AS ParentNode,
  hrytyp AS HierarchyType,
  cast(hryvalfrom as fis_datab preserving type ) AS ValidityStartDate,
  balind AS DebitCreditCode,
  NodeType,
  nodevalue AS HierarchyNodeVal,
  hryseqnbr AS HierarchyNodeSequence,
  hrylevel AS HierarchyNodeLevel,
  kokrs AS ControllingArea,
  ktopl AS ChartOfAccounts,
  itclg AS ConsolidationChartOfAccounts,
  sityp AS SubItemCategory,
  scen_id AS ValidationScenarioID,
  fikrs AS FinancialManagementArea,
  fma_fisyear AS FinMgmtAreaFiscalYear,
  saknr AS GLAccount,
  kostl AS CostCenter,
  prctr AS ProfitCenter,
  stagr AS StatisticalKeyFigure,
  lstar AS ActivityType,
  cast( posid as fis_wbs_no_conv preserving type ) AS WBSElement,
  fkber AS FunctionalArea,
  bukrs AS CompanyCode,
  Segment,
  cbttype AS BusinessTransactionType,
  aufnr AS OrderID,
  fincode AS Fund,
  grant_nbr AS GrantID,
  budget_pd AS BudgetPeriod,
  sponsored_class AS SponsoredClass,
  fictr AS FundCenterText,
  sponsored_prog AS SponsoredProgram,
  measure AS FundedProgram,
  partner AS BusinessPartnerNumber,
  acc_id AS BankAccountInternalID,
  lqpos AS LiquidityItem,
  gsber AS AssetBusinessArea,
  trtyp AS FinancialTransactionType,
  kunnr AS CustomerNum,
  lifnr AS AssetSupplier,
  cast( pspid as fis_project_no_conv preserving type ) AS Project,
  matnr AS Material,
  kdgrp AS CustomerGroup,
  land1 AS CountryOrRegion,
  item AS FinancialStatementItemTemplate,
  cast ( bunit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
  sitem AS SubItem,
  docty AS ConsolidationDocumentType,
  rcomp AS Company,
  matkl AS MaterialGroup,
  rule_num AS ValidationRuleID,
  bzirk AS SalesDistrict,
  fkart AS BillingDocumentType,
  spart AS Division,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  werks AS Plant,
  brsch AS Industry,
  fipex AS CommitmentItem,
  plevl AS PostingLevel,
  fs_product_group AS FinancialServicesProductGroup,
  pricingrelevant AS PricingIsRelevant,
  cast( sign as rr_rsign preserving type ) AS SignIsInverted,
  regrouping AS GeneralLedgerAgingIncrement,
  fs_leafitem AS FinancialStatementLeafItem,
  fs_nodetype AS FinancialStatementNodeType,
  hrynodeext AS FinStmntNodeFormattedID,
  banksplit AS BankAccountGroupingIsSet,
  node_timedep AS HierarchyNodeIsTimeDependent,
  node_typelem AS HierarchyNodeType,
  eliminationmember AS CnsldtnEliminationCharcValue,
  uhnodeid AS UniversalHierNodeID,
  par_uhnodeid AS UniversalHierNodeParentID
FROM hrrp_node_n
LEFT OUTER JOIN I_HierRuntimeRepresentation AS _Hierarchy ON RuntimeHierarchy = _Hierarchy.RuntimeHierarchy AND ValidityEndDate = _Hierarchy.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_HierRuntimeRprstnNodeText AS _Text ON RuntimeHierarchy = _Text.RuntimeHierarchy AND ValidityEndDate = _Text.ValidityEndDate AND HierarchyNode = _Text.HierarchyNode AND HierarchyNodeClass = _Text.HierarchyNodeClass AND ParentNode = _Text.ParentNode  -- association [0..*]
;

Depth:

I_HierRuntimeRprstnNode view

hrrp_node_n

I_FinSubstnValdtnHierNode view_entity
P_CnsldtnTemporalElimHierNode view_entity
P_CnsldtnTemporalElimHierNodeT view_entity
P_CnsldtnTemporalHierarchyNode view_entity
P_CnsldtnTemporalHierNodeText view_entity
P_CNSLDTNTNHNODE view_entity
P_MATRIX_TNH_LEAF view_entity