I_HierRuntimeRepresentation

DDL: I_HIERRUNTIMEREPRESENTATION SQL: IHRRPDIR Type: view BASIC
34 Fields 1 Data Sources 1 Associations

Hierarchy Directory

I_HierRuntimeRepresentation is a Basic CDS View that provides data about "Hierarchy Directory" in SAP S/4HANA. It reads from 1 data source (hrrp_dir_n) and exposes 34 fields with key fields RuntimeHierarchy, ValidityEndDate. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Master Data
Purpose
This CDS view is designed to provide a structured representation of hierarchy directories within a system. It captures various attributes related to hierarchies, including their validity periods, types, and associated metadata such as creation and last change details. The view also includes associations to text descriptions for hierarchies, enhancing the interpretability of the data. This CDS view provides the data to answer the following business questions: What are the different hierarchies available in the system, and what are their types? What are the validity periods for each hierarchy, and when were they last changed? Who created or last modified a particular hierarchy, and at what date and time? What are the key financial and organizational attributes associated with each hierarchy, such as controlling area, chart of accounts, and financial management area? How are hierarchies related to sales organizations, distribution channels, and divisions? What are the financial statement items linked to each hierarchy, including assets, liabilities, net loss, net profit, and profit and loss items? Is a hierarchy node time-dependent, and are functional areas or semantic tags used within the hierarchy? What language is used for the hierarchy descriptions, and is a group chart of accounts utilized? 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 Label RuntimeHierarchy Hierarchy ID ValidityEndDate Validity End Date HierarchyType Hierarchy Type ValidityStartDate Validity Start Date LastChangedByUser Last Changed By LastChangeDateTime Updated At HierarchyClass Hierarchy Class HierarchyShortID Hierarchy ID FromCreationDateTime Created At CreatedByUser Created by ControllingArea Controlling Area ChartOfAccounts Chart of Accounts ConsolidationChartOfAccounts Consolidation COA SubItemCategory Subitem Category ValidationScenarioID Scenario FinancialManagementArea FM Area FinMgmtAreaFiscalYear FMA Fiscal Year SalesOrganization Sales Organization DistributionChannel Distribution Channel Division Division Language Language Key GroupChartOfAccountIsUsed Group Account Number FinancialStatementAssetsItem Assets FinStatementLiabilitiesItem Liabilities & Equity FinancialStatementNetLossItem Net Loss FinStatementNetProfitItem Net Profit/Year FinStatementProfitAndLossItem P+L Profit FinancialStatementOrphansItem Not Assignable FinancialStatementNotesItem Fin. Statement Notes GeneralLedgerAgingScope Aging FunctionalAreaIsUsed Functional Area SemanticTagIsUsed Sem. Tag Assigned HierarchyNodeIsTimeDependent Time-Dependent Node

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
hrrp_dir_n hrrp_dir_n from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_HierRuntimeRprstnText _Text $projection.RuntimeHierarchy = _Text.RuntimeHierarchy and $projection.ValidityEndDate = _Text.ValidityEndDate

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IHRRPDIR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Hierarchy Directory view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY RuntimeHierarchy hryid Hierarchy ID
KEY ValidityEndDate Valid To
HierarchyType hrytyp Hierarchy Type
ValidityStartDate Valid From
LastChangedByUser upduser Changed By
LastChangeDateTime updtime Updated At
HierarchyClass hrycls Hierarchy Class
HierarchyShortID hrysid Hierarchy ID
FromCreationDateTime cretime Time
CreatedByUser creuser Sett.Doc.Creat.
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
SalesOrganization salesorganization Sales Organization
DistributionChannel distributionchannel RefDistCh-Cust/Mat.
Division division Internal Division ID
Language dspra Maint. Language
GroupChartOfAccountIsUsed xergs Group Account Number
FinancialStatementAssetsItem aktva Assets
FinStatementLiabilitiesItem pssva Liabilities
FinancialStatementNetLossItem ergak Net Loss
FinStatementNetProfitItem ergpa Net Profit/Year
FinStatementProfitAndLossItem erggv P+L Profit
FinancialStatementOrphansItem zuord Not Assignable
FinancialStatementNotesItem anhng Fin.Stmt Notes
GeneralLedgerAgingScope aging Aging
FunctionalAreaIsUsed funareaassigned Functional Area
SemanticTagIsUsed semtagassigned Sem. Tag Assigned
HierarchyNodeIsTimeDependent node_timedep
_Text _Text

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_HierRuntimeRepresentation.
-- 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: IHRRPDIR

CREATE VIEW I_HierRuntimeRepresentation AS
SELECT
  hryid AS RuntimeHierarchy,
  cast(hryvalto as fis_datbi preserving type ) AS ValidityEndDate,
  hrytyp AS HierarchyType,
  cast(hryvalfrom as fis_datab preserving type ) AS ValidityStartDate,
  upduser AS LastChangedByUser,
  updtime AS LastChangeDateTime,
  hrycls AS HierarchyClass,
  hrysid AS HierarchyShortID,
  cretime AS FromCreationDateTime,
  creuser AS CreatedByUser,
  kokrs AS ControllingArea,
  ktopl AS ChartOfAccounts,
  itclg AS ConsolidationChartOfAccounts,
  sityp AS SubItemCategory,
  scen_id AS ValidationScenarioID,
  fikrs AS FinancialManagementArea,
  fma_fisyear AS FinMgmtAreaFiscalYear,
  SalesOrganization,
  DistributionChannel,
  Division,
  dspra AS Language,
  xergs AS GroupChartOfAccountIsUsed,
  aktva AS FinancialStatementAssetsItem,
  pssva AS FinStatementLiabilitiesItem,
  ergak AS FinancialStatementNetLossItem,
  ergpa AS FinStatementNetProfitItem,
  erggv AS FinStatementProfitAndLossItem,
  zuord AS FinancialStatementOrphansItem,
  anhng AS FinancialStatementNotesItem,
  aging AS GeneralLedgerAgingScope,
  funareaassigned AS FunctionalAreaIsUsed,
  semtagassigned AS SemanticTagIsUsed,
  node_timedep AS HierarchyNodeIsTimeDependent
FROM hrrp_dir_n
LEFT OUTER JOIN I_HierRuntimeRprstnText AS _Text ON RuntimeHierarchy = _Text.RuntimeHierarchy AND ValidityEndDate = _Text.ValidityEndDate  -- association [0..*]
;

Learn More