I_GLAccountHierarchyStdVH

DDL: I_GLACCOUNTHIERARCHYSTDVH SQL: IFIGLAH__VH Type: view COMPOSITE Package: FINS_GL_ACCOUNT_HIER

General Ledger Account Hierarchy

I_GLAccountHierarchyStdVH (Composite)

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_GLAccountHierarchyStdVH is a Composite CDS View that provides data about "General Ledger Account Hierarchy" in SAP S/4HANA. It reads from 1 data source (I_GLAccountHierarchy) and exposes 4 fields with key fields GLAccountHierarchy, ValidityEndDate. It is exposed through 14 OData services (ASQL_F0997, ASQL_F1564, ASQL_F1758, ...). Part of development package FINS_GL_ACCOUNT_HIER.

SAP Help Documentation

CategoryCDS Views for Master Data
Purpose
This CDS view is designed to provide a structured representation of the General Ledger Account Hierarchy, which serves as a value help for users seeking information about GL account hierarchies. It facilitates efficient searching and retrieval of GL account hierarchy data, ensuring that users can access relevant information quickly and accurately. This view provides value help for GLAccountHierarchy . This view should be used for value help purposes only. This CDS view provides the data to answer the following business questions: What are the available General Ledger Account Hierarchies within the system? What are the validity periods for each General Ledger Account Hierarchy? How can users access descriptive text information related to specific GL account hierarchies? How can users perform searches on GL account hierarchies with enhanced search capabilities, such as fuzziness and ranking? 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 You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Description GLAccountHierarchy G/L Account Hierarchy ValidityStartDate Valid From ValidityEndDate Valid To

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-GL-GL-N-2CL
CapabilitiesData Source for Defining CDS Entities,Data Source for Search,Data Provider for Value Help
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view is designed to provide a structured representation of the General Ledger Account Hierarchy, which serves as a value help for users seeking information about GL account hierarchies. It facilitates efficient searching and retrieval of GL account hierarchy data, ensuring that users can access relevant information quickly and accurately.</p> <p>This view provides value help for GLAccountHierarchy. This view should be used for value help purposes only.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the available General Ledger Account Hierarchies within the system?</p></li> <li><p>What are the validity periods for each General Ledger Account Hierarchy?</p></li> <li><p>How can users access descriptive text information related to specific GL account hierarchies?</p></li> <li><p>How can users perform searches on GL account hierarchies with enhanced search capabilities, such as fuzziness and ranking?</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
I_GLAccountHierarchy I_GLAccountHierarchy from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IFIGLAH__VH view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey GLAccountHierarchy view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
Consumption.ranked true view
EndUserText.label General Ledger Account Hierarchy view

OData Services (14)

ServiceBindingVersionContractRelease
ASQL_F0997 ASQL_F0997 C2 NOT_RELEASED
ASQL_F1564 ASQL_F1564 C2 NOT_RELEASED
ASQL_F1758 ASQL_F1758 C2 NOT_RELEASED
ASQL_F1759 ASQL_F1759 C2 NOT_RELEASED
ASQL_F2794 ASQL_F2794 C2 NOT_RELEASED
ASQL_F2935 ASQL_F2935 C2 NOT_RELEASED
ASQL_F2964 ASQL_F2964 C2 NOT_RELEASED
ASQL_F3016 ASQL_F3016 C2 NOT_RELEASED
ASQL_F3417 ASQL_F3417 C2 NOT_RELEASED
ASQL_F4022 ASQL_F4022 C2 NOT_RELEASED
ASQL_F4603 ASQL_F4603 C2 NOT_RELEASED
ASQL_F4866 ASQL_F4866 C2 NOT_RELEASED
ASQL_F5274 ASQL_F5274 C2 NOT_RELEASED
ASQL_F6061 ASQL_F6061 C2 NOT_RELEASED

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY GLAccountHierarchy GLAccountHierarchy G/L Account Hierarchy
KEY ValidityEndDate ValidityEndDate Valid To Date
ValidityStartDate ValidityStartDate Validity Start Date
_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_GLAccountHierarchyStdVH.
-- 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: IFIGLAH__VH

CREATE VIEW I_GLAccountHierarchyStdVH AS
SELECT
  GLAccountHierarchy,
  ValidityEndDate,
  ValidityStartDate
FROM I_GLAccountHierarchy
;