What is I_PlantHierarchy in SAP S/4HANA?

I_PlantHierarchy is a basic CDS view in SAP S/4HANA. Plant Hierarchy It contains 7 fields.

Which tables does I_PlantHierarchy read from?

I_PlantHierarchy reads data from: hrrp_dir_n.

What VDM layer is I_PlantHierarchy?

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

I_PlantHierarchy

DDL: I_PLANTHIERARCHY Type: view_entity BASIC

7 Fields 1 Data Sources 1 Associations

Plant Hierarchy

I_PlantHierarchy (Basic)

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

Plant Hierarchy · Accounting and Financial Close

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

SAP Help Documentation

Category	CDS Views for Master Data
Data Category	Dimension

Purpose
This CDS view is designed to represent the hierarchy of plants within an organization. It provides a structured view of plant data, including validity dates, user information, and associated text descriptions. The view is intended for use in analytical scenarios, allowing users to extract and analyze plant hierarchy data efficiently. This CDS view provides the data to answer the following business questions: What are the hierarchical relationships between different plants within the organization? What are the validity periods for each plant hierarchy? Who was the last user to change the plant hierarchy data, and when was it changed? What are the text descriptions associated with each plant hierarchy? How can plant hierarchy data be extracted for analytical 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 PLANTHIERARCHY Plant Hierarchy 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

State	C1
Line of Business	Accounting and Financial Close
Application Component	FI-FIO-GL-IS
Capabilities	Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source for Data Extraction, Analytical Dimension
Package	Accounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

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

Data Sources (1)

Source	Alias	Join Type
hrrp_dir_n	hrrp_dir_n	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..*]	I_PlantHierarchyText	_Text	`$projection.PlantHierarchy = _Text.PlantHierarchy and $projection.ValidityEndDate = _Text.ValidityEndDate`

Annotations (14)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Plant Hierarchy	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MASTER	view
VDM.viewType	#BASIC	view
Analytics.dataCategory	#DIMENSION	view
Analytics.dataExtraction.enabled	true	view
ObjectModel.sapObjectNodeType.name	PlantHierarchy	view
ObjectModel.modelingPattern	#ANALYTICAL_DIMENSION	view
Metadata.allowExtensions	true	view
ObjectModel.representativeKey	PlantHierarchy	view
Analytics.internalName	#LOCAL	view

Fields (7)

Key	Field	Source Table	Source Field	Description
KEY	PlantHierarchy			Plant Hierarchy ID
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

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_PlantHierarchy.
-- 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.

CREATE VIEW I_PlantHierarchy AS
SELECT
  cast(hrrp_dir_n.hryid as fis_hryid_plant preserving type ) AS PlantHierarchy,
  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_PlantHierarchyText AS _Text ON PlantHierarchy = _Text.PlantHierarchy AND ValidityEndDate = _Text.ValidityEndDate  -- association [1..*]
;

Depth:

I_PlantHierarchy view_entity

hrrp_dir_n