I_HierRuntimeRprstnNode

DDL: I_HIERRUNTIMERPRSTNNODE SQL: IHRRPNODE Type: view BASIC Package: FINS_FI_HRRP
80 Fields 1 Data Sources 2 Associations

Hierarchy Node

I_HierRuntimeRprstnNode (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Public Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

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 80 fields with key fields RuntimeHierarchy, ValidityEndDate, HierarchyNode, HierarchyNodeClass, ParentNode. It has 2 associations to related views. Part of development package FINS_FI_HRRP.

SAP Help Documentation

CategoryCDS 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 a role with the following restriction types set to read access: Restriction Type ID Restriction Type HRYTYPE_HRYID_OH Hierarchy Type/ID for Overhead Accounting HRYTYPE_HRYID_LI Hierarchy Type/ID for Liquidity Item HRYTYPE_HRYID_BS Hierarchy Type/ID for Budget Specialist HRYTYPE_HRYID_SA Hierarchy Type/ID for Sales Accounting HRYTYPE_HRYID Hierarchy Type/ID HRYTYPE_HRYID_BAM Hierarchy Type/ID for Bank Account Management HRYTYPE_HRYID_CS Hierarchy Type/ID for Consolidation HRYTYPE_HRYID_DV Hierarchy Type/ID for Profit Center Accounting HRYTYPE_HRYID_GL Hierarchy Type/ID for General Ledger Accounting HRYTYPE_HRYID_GM Hierarchy Type/ID for Grants Management HRYTYPE_HRYID_FA Hierarchy Type/ID for Fund Accounting HRYTYPE_HRYID_FFS Hierarchy Type/ID for Financial Services Enhancements HRYTYPE_HRYID_PM Hierarchy Type/ID for Master Data - Product Master HRYTYPE_HRYID_CIT Hierarchy Type/ID for Corporate Income Tax HRYTYPE_HRYID_CS_AND_REF Hierarchy Type/ID for Consolidation including references These restriction types are edited in the Maintain Business Roles app.

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 FINANCIALSTATE

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-FIO-GL-HIE-2CL
CapabilitiesAssociation Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Not Released
Release State (Developer)Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>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.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the details of each hierarchy node within a specific runtime hierarchy?</p></li> <li><p>What is the validity period for each hierarchy node?</p></li> <li><p>How are hierarchy nodes classified and what are their parent-child relationships?</p></li> <li><p>What financial attributes are associated with each hierarchy node, such as GL account, cost center, and profit center?</p></li> <li><p>How can hierarchy nodes be analyzed in terms of their financial transaction types and business transaction types?</p></li> <li><p>What organizational attributes, such as company code, segment, and controlling area, are linked to each hierarchy node?</p></li> <li><p>How do hierarchy nodes relate to specific projects, materials, and business partners?</p></li> <li><p>What are the characteristics of hierarchy nodes in terms of their time dependency and node type?</p></li> <li><p>How can hierarchy nodes be utilized for consolidation purposes, including elimination characteristics and consolidation units?</p></li> </ul> <p>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.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
hrrp_node_n hrrp_node_n from

Associations (2)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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 (80)

KeyFieldSource TableSource FieldDescription
KEY RuntimeHierarchy hryid Hierarchy ID
KEY ValidityEndDate Validity End Date
KEY HierarchyNode hrynode Hierarchy node
KEY HierarchyNodeClass nodecls Node Class
KEY ParentNode parnode Hierarchy parent node
HierarchyType hrytyp Hierarchy Type
ValidityStartDate Validity Start Date
DebitCreditCode balind Balance indicator
NodeType nodetype Hierarchy node type
HierarchyNodeVal nodevalue Node value
HierarchyNodeSequence hryseqnbr Hierarchy Sequence Number
HierarchyNodeLevel hrylevel Hierarchy Level
ControllingArea kokrs Controlling Area
ChartOfAccounts ktopl G/L Chart of Accounts
ConsolidationChartOfAccounts itclg Consolidation Chart of Accounts
SubItemCategory sityp Trip Schedule Type
ValidationScenarioID scen_id Validation Scenario
FinancialManagementArea fikrs Financial Management Area
FinMgmtAreaFiscalYear fma_fisyear Fiscal Year for Financial Management Area
GLAccount saknr G/L Account Number
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 Company Code
Segment segment Segment for Segmental Reporting
BusinessTransactionType cbttype Business Transaction Type
OrderID aufnr SettlementOrder
Fund fincode Fund
GrantID grant_nbr Receiver Grant
BudgetPeriod budget_pd Budget Period
SponsoredClass sponsored_class Sponsored Class
FundCenterText fictr Funds Center
SponsoredProgram sponsored_prog Sponsored Program
FundedProgram measure Funded Program
BusinessPartnerNumber partner Business Partner Number
BankAccountInternalID acc_id Bank Account Technical ID
LiquidityItem lqpos Liquidity Item
AssetBusinessArea gsber Business Area
FinancialTransactionType trtyp Transaction Type
CustomerNum kunnr Customer Number
AssetSupplier lifnr Account Number of Supplier
Project Std. proj. def.
Material matnr Material Number
CustomerGroup kdgrp Customer group
CountryOrRegion land1 Country/Region Key
FinancialStatementItemTemplate item Financial Statement Item
ConsolidationUnit Consolidation Unit
SubItem sitem Subitem
ConsolidationDocumentType docty Document Type
Company rcomp Trading Partner
MaterialGroup matkl Product Sold Group
ValidationRuleID rule_num Rule Identifier
SalesDistrict bzirk Sales District
BillingDocumentType fkart Ship. cost type
Division spart Source supplier
SalesOrganization vkorg Sales Organization
DistributionChannel vtweg Distribution Channel
Plant werks Receiving Plant
Industry brsch Industry Key
CommitmentItem fipex Commitment Item
PostingLevel plevl Posting Level
FinancialServicesProductGroup fs_product_group Product Group (Financial Services)
PricingIsRelevant pricingrelevant Relevant for price determination ID
SignIsInverted Type of SIGN component in row type of a Ranges type
GeneralLedgerAgingIncrement regrouping Aging Increment
FinancialStatementLeafItem fs_leafitem FS Leaf Item
FinancialStatementNodeType fs_nodetype Financial Statement Node Type
FinStmntNodeFormattedID hrynodeext Hierarchy Node for Extraction
BankAccountGroupingIsSet banksplit Bank Account Grouping
HierarchyNodeIsTimeDependent node_timedep Indicator: Node is time-dependent
HierarchyNodeType node_typelem Node Type Element
CnsldtnEliminationCharcValue eliminationmember Consolidation Elimination Member
UniversalHierNodeID uhnodeid Node ID
UniversalHierNodeParentID par_uhnodeid Node Parent ID
ConsolidationGroup congr Consolidation Group
_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,
  congr AS ConsolidationGroup
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..*]
;

Learn More