A_BudgetPeriodCoreHierNode

DDL: A_BUDGETPERIODCOREHIERNODE Type: view COMPOSITE
12 Fields 1 Data Sources 1 Associations 1 OData Services

Budget Period Hierarchy Node

A_BudgetPeriodCoreHierNode 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_BUDGETPERIODCOREHIERARCHY).

Data Sources (1)

SourceAliasJoin Type
I_BudgetPeriodHierarchyNode I_BudgetPeriodHierarchyNode from

Associations (1)

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

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ABDGTPDCOREHN 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 BudgetPeriodCoreHierNode_Type view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_BUDGETPERIODCOREHIERARCHY API_BUDGETPERIODCOREHIER 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
_BudgetPeriodCoreHierarchy _BudgetPeriodCoreHierarchy
_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_BudgetPeriodCoreHierNode.
-- 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_BudgetPeriodCoreHierNode AS
SELECT
  BudgetPeriodHierarchy,
  HierarchyNode,
  ValidityEndDate,
  ParentNode,
  HierarchyVersion,
  ValidityStartDate,
  BudgetPeriod,
  HierarchyNodeSequence,
  HierarchyNodeLevel,
  NodeType
FROM I_BudgetPeriodHierarchyNode
LEFT OUTER JOIN A_BudgetPeriodCoreHierNodeT AS _Text ON BudgetPeriodHierarchy = _Text.BudgetPeriodHierarchy AND HierarchyNode = _Text.HierarchyNode AND ValidityEndDate = _Text.ValidityEndDate  -- association [0..*]
;

Learn More