What is I_CostCtrActivityTypeHierNode in SAP S/4HANA?

I_CostCtrActivityTypeHierNode is a basic CDS view in SAP S/4HANA. Cost Center Activity Type Hierarchy Node It contains 18 fields.

Which tables does I_CostCtrActivityTypeHierNode read from?

I_CostCtrActivityTypeHierNode reads data from: hrrp_node_n.

What VDM layer is I_CostCtrActivityTypeHierNode?

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

I_CostCtrActivityTypeHierNode

DDL: I_COSTCTRACTIVITYTYPEHIERNODE SQL: IFICOSTCTRACTYHN Type: view BASIC Package: FINS_FIS_FICO

18 Fields 1 Data Sources 5 Associations

Cost Center Activity Type Hierarchy Node

I_CostCtrActivityTypeHierNode (Basic)

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

CostCtrActivityTypeHierNode · Accounting and Financial Close

I_CostCtrActivityTypeHierNode is a Basic CDS View that provides data about "Cost Center Activity Type Hierarchy Node" in SAP S/4HANA. It reads from 1 data source (hrrp_node_n) and exposes 18 fields with key fields ControllingArea, CostCtrActivityTypeHierarchy, HierarchyNode, ValidityEndDate. It has 5 associations to related views. Part of development package FINS_FIS_FICO.

SAP Help Documentation

Category	CDS Views for Master Data

Purpose
This CDS view defines a hierarchical structure for cost center activity types within a controlling area. It is designed to provide a structured representation of cost center activity types, allowing for analysis and reporting based on hierarchical relationships. The view includes associations to other entities such as controlling areas and cost center activities, enabling comprehensive data extraction and analysis. This CDS view provides the data to answer the following business questions: What is the hierarchical structure of cost center activity types within a specific controlling area? How are cost center activity types organized in terms of parent-child relationships? What are the validity periods for each hierarchy node within the cost center activity type hierarchy? How can I access detailed information about specific cost center activity types and their associations? What are the sequence and level details of hierarchy nodes for cost center activity types? How can I filter and analyze cost center activity types based on specific criteria such as controlling area or validity dates? 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. Users who want to use this CDS view must have the following authorization objects assigned:

Structure
Fields used for Filtering Field Name Label ControllingArea Controlling Area CostCtrActivityTypeHierarchy Cctr Acttype Hryid ValidityEndDate Validity End Date Important Fields Important fields in this view include the following: Field Name Description HIERARCHYNODE Node PARENTNODE Par. Node HIERARCHYNODEVAL Value CONTROLLINGAREA Controlling Area COSTCTRACTIVITYTYPEHIERARCHY Cctr Acttype Hryid COSTCTRACTIVITYTYPE Activity Type NODETYPE Node Type SEQUENCENUMBER VALIDITYENDDATE Validity End Date VALIDITYSTARTDATE Validity Start Date HIERARCHYNODELEVEL Hierarchy Level HIERARCHYVERSION Version HIERARCHYNODESEQUENCE Sequence Number

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

View on SAP Help Portal →

SAP API Hub

Category	Basic
State	C1
Line of Business	Accounting and Financial Close
Application Component	CO-OM-2CL
Capabilities	Data Source for Data Extraction,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities,Data Source for Hierarchies in Analytics
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Accounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view defines a hierarchical structure for cost center activity types within a controlling area. It is designed to provide a structured representation of cost center activity types, allowing for analysis and reporting based on hierarchical relationships. The view includes associations to other entities such as controlling areas and cost center activities, enabling comprehensive data extraction and analysis.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What is the hierarchical structure of cost center activity types within a specific controlling area?</p></li> <li><p>How are cost center activity types organized in terms of parent-child relationships?</p></li> <li><p>What are the validity periods for each hierarchy node within the cost center activity type hierarchy?</p></li> <li><p>How can I access detailed information about specific cost center activity types and their associations?</p></li> <li><p>What are the sequence and level details of hierarchy nodes for cost center activity types?</p></li> <li><p>How can I filter and analyze cost center activity types based on specific criteria such as controlling area or validity dates?</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

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
hrrp_node_n	hrrp_node_n	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..1]	I_ControllingArea	_ControllingAreaText	`$projection.ControllingArea = _ControllingAreaText.ControllingArea`
[0..*]	I_CostCtrActivityTypeHierNodeT	_Text	`$projection.CostCtrActivityTypeHierarchy = _Text.CostCtrActivityTypeHierarchy and $projection.HierarchyNode = _Text.HierarchyNode and $projection.ControllingArea = _Text.ControllingArea and $projection.CostCtrActivityType = ''`
[0..*]	I_CostCenterActivityType	_CostCenterActivity	`$projection.CostCtrActivityType = _CostCenterActivity.CostCtrActivityType and $projection.ControllingArea = _CostCenterActivity.ControllingArea`
[1..1]	I_CostCtrActivityTypeHierarchy	_Hierarchy	`$projection.CostCtrActivityTypeHierarchy = _Hierarchy.CostCtrActivityTypeHierarchy and $projection.ControllingArea = _Hierarchy.ControllingArea and $projection.ValidityEndDate = _Hierarchy.ValidityEndDate`
[0..1]	I_ControllingArea	_ControllingArea	`$projection.ControllingArea = _ControllingArea.ControllingArea`

Annotations (21)

Name	Value	Level
AbapCatalog.sqlViewName	IFICOSTCTRACTYHN	view
Hierarchy.parentChild.recurse.parent	ParentNode	view
Hierarchy.parentChild.recurse.child	HierarchyNode	view
Hierarchy.parentChild.siblingsOrder.by	HierarchyNodeSequence	view
Hierarchy.parentChild.siblingsOrder.direction	ASC	view
Hierarchy.parentChild.directory	_Hierarchy	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.dataCategory	#HIERARCHY	view
VDM.viewType	#BASIC	view
Analytics.dataExtraction.enabled	true	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
ObjectModel.representativeKey	HierarchyNode	view
ObjectModel.modelingPattern	#ANALYTICAL_PARENT_CHILD_HIERARCHY_NODE	view
EndUserText.label	Cost Center Activity Type Hierarchy Node	view
ObjectModel.sapObjectNodeType.name	CostCtrActivityTypeHierNode	view

Fields (18)

Key	Field	Source Table	Source Field	Description
KEY	ControllingArea			Controlling Area
KEY	CostCtrActivityTypeHierarchy			Cost Center Activity Type Hierarchy
KEY	HierarchyNode	hrrp_node_n	hrynode	Hierarchy node
KEY	ValidityEndDate			Validity End Date
	ParentNode	hrrp_node_n	parnode	Hierarchy parent node
	HierarchyVersion			Hierarchy version
	ValidityStartDate			Validity Start Date
	CostCtrActivityType	hrrp_node_n	lstar	Activity Type
	SequenceNumber
	HierarchyNodeSequence	hrrp_node_n	hryseqnbr	Hierarchy Sequence Number
	HierarchyNodeLevel	hrrp_node_n	hrylevel	Hierarchy Level
	NodeType	hrrp_node_n	nodetype	Hierarchy node type
	HierarchyNodeVal	hrrp_node_n	nodevalue	Node value
	_Text		_Text
	_CostCenterActivity		_CostCenterActivity
	_Hierarchy		_Hierarchy
	_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_CostCtrActivityTypeHierNode.
-- 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: IFICOSTCTRACTYHN

CREATE VIEW I_CostCtrActivityTypeHierNode AS
SELECT
  cast( hrrp_node_n.kokrs as fis_kokrs preserving type ) AS ControllingArea,
  cast(hrrp_node_n.hryid as fis_hryid_cctracttytpe preserving type ) AS CostCtrActivityTypeHierarchy,
  hrrp_node_n.hrynode AS HierarchyNode,
  cast(hrrp_node_n.hryvalto as fis_datbi preserving type ) AS ValidityEndDate,
  hrrp_node_n.parnode AS ParentNode,
  cast( '000000000000001' as hryversn ) AS HierarchyVersion,
  cast(hrrp_node_n.hryvalfrom as fis_datab preserving type ) AS ValidityStartDate,
  hrrp_node_n.lstar AS CostCtrActivityType,
  concat(hrrp_node_n.hryseqnbr, hrrp_node_n.hrynode) AS SequenceNumber,
  hrrp_node_n.hryseqnbr AS HierarchyNodeSequence,
  hrrp_node_n.hrylevel AS HierarchyNodeLevel,
  hrrp_node_n.nodetype AS NodeType,
  hrrp_node_n.nodevalue AS HierarchyNodeVal
FROM hrrp_node_n
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCtrActivityTypeHierNodeT AS _Text ON CostCtrActivityTypeHierarchy = _Text.CostCtrActivityTypeHierarchy AND HierarchyNode = _Text.HierarchyNode AND ControllingArea = _Text.ControllingArea AND CostCtrActivityType = ''  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _CostCenterActivity ON CostCtrActivityType = _CostCenterActivity.CostCtrActivityType AND ControllingArea = _CostCenterActivity.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_CostCtrActivityTypeHierarchy AS _Hierarchy ON CostCtrActivityTypeHierarchy = _Hierarchy.CostCtrActivityTypeHierarchy AND ControllingArea = _Hierarchy.ControllingArea AND ValidityEndDate = _Hierarchy.ValidityEndDate  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
;

Depth:

I_CostCtrActivityTypeHierNode view

hrrp_node_n