A_BudgetPeriodHierNode

DDL: A_BUDGETPERIODHIERNODE Type: view COMPOSITE Package: PSM_FM_API
12 Fields 1 Data Sources 1 Associations 1 OData Services

Budget Period Hierarchy Node

A_BudgetPeriodHierNode is a Composite CDS View that provides data about "Budget Period Hierarchy Node" in SAP S/4HANA. It reads from 1 data source (I_BudgetPeriodHierarchyNode) and exposes 12 fields with key fields BudgetPeriodHierarchy, HierarchyNode, ValidityEndDate. It has 1 association to related views. It is exposed through 1 OData service (API_BUDGETPERIODHIERARCHY). Part of development package PSM_FM_API.

Data Sources (1)

SourceAliasJoin Type
I_BudgetPeriodHierarchyNode I_BudgetPeriodHierarchyNode from

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_BudgetPeriodHierNodeT _Text $projection.BudgetPeriodHierarchy = _Text.BudgetPeriodHierarchy and $projection.HierarchyNode = _Text.HierarchyNode and $projection.ValidityEndDate = _Text.ValidityEndDate

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ABDGTPDHN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Budget Period Hierarchy Node view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
OData.entityType.name BudgetPeriodHierarchyNode_Type view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_BUDGETPERIODHIERARCHY API_BUDGETPERIODHIERARCHY V2 C2 C1

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY BudgetPeriodHierarchy BudgetPeriodHierarchy
KEY HierarchyNode HierarchyNode Node
KEY ValidityEndDate ValidityEndDate ValidTo
ParentNode ParentNode Parent Node
HierarchyVersion HierarchyVersion Version
ValidityStartDate ValidityStartDate Validity Start Date
BudgetPeriod BudgetPeriod Budget Period
HierarchyNodeSequence HierarchyNodeSequence Sequence Number
HierarchyNodeLevel HierarchyNodeLevel Hierarchy Node Level
NodeType NodeType Object Type
_BudgetPeriodHierarchy _BudgetPeriodHierarchy
_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 A_BudgetPeriodHierNode.
-- 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 A_BudgetPeriodHierNode AS
SELECT
  BudgetPeriodHierarchy,
  HierarchyNode,
  ValidityEndDate,
  ParentNode,
  HierarchyVersion,
  ValidityStartDate,
  BudgetPeriod,
  HierarchyNodeSequence,
  HierarchyNodeLevel,
  NodeType
FROM I_BudgetPeriodHierarchyNode
LEFT OUTER JOIN A_BudgetPeriodHierNodeT AS _Text ON BudgetPeriodHierarchy = _Text.BudgetPeriodHierarchy AND HierarchyNode = _Text.HierarchyNode AND ValidityEndDate = _Text.ValidityEndDate  -- association [0..*]
;

Learn More