I_BudgetPeriodHierarchy

DDL: I_BUDGETPERIODHIERARCHY SQL: IBDGTPDH Type: view BASIC
9 Fields 1 Data Sources 1 Associations

Budget Period Hierarchy

I_BudgetPeriodHierarchy (Basic)

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

BudgetPeriodHierarchy · Cross Applications

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

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentPSM-FM-MD
CapabilitiesData Source for Defining CDS Entities, Association Target for Defining CDS Entities, Analytical Dimension, Data Source for Data Extraction
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
hrrp_dir_n hrrp_dir_n from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_BudgetPeriodHierarchyText _Text $projection.BudgetPeriodHierarchy = _Text.BudgetPeriodHierarchy

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IBDGTPDH view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Budget Period Hierarchy view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
ObjectModel.representativeKey BudgetPeriodHierarchy view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Analytics.dataExtraction.enabled true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name BudgetPeriodHierarchy view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BudgetPeriodHierarchy Budget Period Hierarchy
KEY ValidityEndDate Validity End Date
ValidityStartDate Validity Start Date
LastChangedByUser hrrp_dir_n upduser Last Changed By
LastChangeTime hrrp_dir_n updtime Last Updated At (Timestamp)
LastChangeDateTime hrrp_dir_n updtime Last Updated At (Timestamp)
HierarchyShortID hrrp_dir_n hrysid Hierarchy ID
NotAssgdNdeHasBeenSuppressed Suppression of unassigned nodes
_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_BudgetPeriodHierarchy.
-- 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: IBDGTPDH

CREATE VIEW I_BudgetPeriodHierarchy AS
SELECT
  cast(hrrp_dir_n.hryid as fmis_hryid_budgetperiod ) AS BudgetPeriodHierarchy,
  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 LastChangeTime,
  hrrp_dir_n.updtime AS LastChangeDateTime,
  hrrp_dir_n.hrysid AS HierarchyShortID,
  cast( 'X' as rshiernorest ) AS NotAssgdNdeHasBeenSuppressed
FROM hrrp_dir_n
LEFT OUTER JOIN I_BudgetPeriodHierarchyText AS _Text ON BudgetPeriodHierarchy = _Text.BudgetPeriodHierarchy  -- association [1..*]
;

Learn More