I_StstclKeyFigureHierarchy

DDL: I_STSTCLKEYFIGUREHIERARCHY SQL: IFISTSTCLKEYFIGH Type: view BASIC
10 Fields 1 Data Sources 3 Associations

Statistical Key Figure Hierarchy

I_StstclKeyFigureHierarchy (Basic)

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

Statistical Key Figure Hierarchy · Accounting and Financial Close

I_StstclKeyFigureHierarchy is a Basic CDS View (Dimension) that provides data about "Statistical Key Figure Hierarchy" in SAP S/4HANA. It reads from 1 data source (hrrp_dir_n) and exposes 10 fields with key fields ControllingArea, StatisticalKeyFigureHierarchy, ValidityEndDate. It has 3 associations to related views.

SAP Help Documentation

CategoryCDS Views for Master Data
Data CategoryDimension
Purpose
This CDS view is designed to represent the hierarchy of statistical key figures within a controlling area. It provides a structured view of statistical key figures, including their validity periods, associations with controlling areas, and relevant metadata such as the last change details. The view is intended for analytical purposes, allowing users to extract and analyze data related to statistical key figures in a hierarchical format. This CDS view provides the data to answer the following business questions: What are the statistical key figures available within a specific controlling area? How are these statistical key figures organized hierarchically? What are the validity periods for each statistical key figure within the hierarchy? Who last modified the statistical key figures, and when was the modification made? How can the statistical key figures be associated with their respective controlling areas for reporting and analysis purposes? 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 LASTCHANGEDBYUSER Last Changed By CONTROLLINGAREA Controlling Area STATISTICALKEYFIGUREHIERARCHY Hierarchy ID HIERARCHYSHORTID Hierarchy ID VALIDITYENDDATE Validity End Date VALIDITYSTARTDATE Validity Start Date LASTCHANGEDATETIME Updated At

Data Extraction
This CDS view is enabled for data extraction in full mode.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-FIO-GL-IS
CapabilitiesData Source for Defining CDS Entities, Association Target for Defining CDS Entities, Analytical Dimension, Data Source for Data Extraction
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
hrrp_dir_n hrrp_dir_n from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ControllingArea _ControllingAreaText $projection.ControllingArea = _ControllingAreaText.ControllingArea
[1..*] I_StstclKeyFigureHierarchyT _Text $projection.StatisticalKeyFigureHierarchy = _Text.StatisticalKeyFigureHierarchy and $projection.ControllingArea = _Text.ControllingArea and $projection.ValidityEndDate = _Text.ValidityEndDate
[0..1] I_ControllingArea _ControllingArea $projection.ControllingArea = _ControllingArea.ControllingArea

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IFISTSTCLKEYFIGH view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Statistical Key Figure Hierarchy view
ObjectModel.representativeKey StatisticalKeyFigureHierarchy view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
Analytics.dataExtraction.enabled true view
Metadata.allowExtensions true view
Analytics.internalName #LOCAL view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name StatisticalKeyFigureHierarchy view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea Controlling Area
KEY StatisticalKeyFigureHierarchy Statistical Key Figure Hierarchy
KEY ValidityEndDate Validity End Date
ValidityStartDate Validity Start Date
LastChangedByUser hrrp_dir_n upduser Last Changed By
LastChangeDateTime hrrp_dir_n updtime Last Updated At (Timestamp)
HierarchyShortID hrrp_dir_n hrysid Hierarchy ID
_Text _Text
_ControllingArea _ControllingArea
_ControllingAreaText _ControllingAreaText

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_StstclKeyFigureHierarchy.
-- 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: IFISTSTCLKEYFIGH

CREATE VIEW I_StstclKeyFigureHierarchy AS
SELECT
  cast( hrrp_dir_n.kokrs as fis_kokrs preserving type ) AS ControllingArea,
  cast( hrrp_dir_n.hryid_42 as fis_hryid_ststclkeyfigure_42 preserving type ) AS StatisticalKeyFigureHierarchy,
  cast(hrrp_dir_n.hryvalto as fis_datbi preserving type ) AS ValidityEndDate,
  cast(hrrp_dir_n.hryvalfrom as fis_datab preserving type ) AS ValidityStartDate,
  hrrp_dir_n.upduser AS LastChangedByUser,
  hrrp_dir_n.updtime AS LastChangeDateTime,
  hrrp_dir_n.hrysid AS HierarchyShortID
FROM hrrp_dir_n
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_StstclKeyFigureHierarchyT AS _Text ON StatisticalKeyFigureHierarchy = _Text.StatisticalKeyFigureHierarchy AND ControllingArea = _Text.ControllingArea AND ValidityEndDate = _Text.ValidityEndDate  -- association [1..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
;

Learn More