A_BudgetAccountCoreHierNode

DDL: A_BUDGETACCOUNTCOREHIERNODE Type: view COMPOSITE Package: PSM_S4C_API
13 Fields 1 Data Sources 1 Associations 1 OData Services

Budget Account Hierarchy Node

A_BudgetAccountCoreHierNode is a Composite CDS View that provides data about "Budget Account Hierarchy Node" in SAP S/4HANA. It reads from 1 data source (I_BudgetAccountHierarchyNode) and exposes 13 fields with key fields BudgetAccountHierarchy, HierarchyNode, ValidityEndDate. It has 1 association to related views. It is exposed through 1 OData service (API_BUDGETACCOUNTCOREHIERARCHY). Part of development package PSM_S4C_API.

Data Sources (1)

SourceAliasJoin Type
I_BudgetAccountHierarchyNode I_BudgetAccountHierarchyNode from

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_BudgetAccountCoreHierNodeTxt _Text $projection.BudgetAccountHierarchy = _Text.BudgetAccountHierarchy and $projection.ValidityEndDate = _Text.ValidityEndDate and $projection.HierarchyNode = _Text.HierarchyNode

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ABDGTACCCOREHN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Budget Account 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 BudgetAccountCoreHierNode_Type view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_BUDGETACCOUNTCOREHIERARCHY API_BUDGETACCOUNTCOREHIER V2 C2 C1

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BudgetAccountHierarchy BudgetAccountHierarchy
KEY HierarchyNode HierarchyNode Node
KEY ValidityEndDate ValidityEndDate ValidTo
ParentNode ParentNode Parent Node
HierarchyVersion HierarchyVersion Version
ValidityStartDate ValidityStartDate Validity Start Date
PubSecBudgetAccount PubSecBudgetAccount Budget Account
ChartOfAccounts ChartOfAccounts Node Class
HierarchyNodeSequence HierarchyNodeSequence Sequence Number
HierarchyNodeLevel HierarchyNodeLevel Hierarchy Node Level
NodeType NodeType Object Type
_Hierarchy _Hierarchy
_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_BudgetAccountCoreHierNode.
-- 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_BudgetAccountCoreHierNode AS
SELECT
  BudgetAccountHierarchy,
  HierarchyNode,
  ValidityEndDate,
  ParentNode,
  HierarchyVersion,
  ValidityStartDate,
  PubSecBudgetAccount,
  ChartOfAccounts,
  HierarchyNodeSequence,
  HierarchyNodeLevel,
  NodeType
FROM I_BudgetAccountHierarchyNode
LEFT OUTER JOIN A_BudgetAccountCoreHierNodeTxt AS _Text ON BudgetAccountHierarchy = _Text.BudgetAccountHierarchy AND ValidityEndDate = _Text.ValidityEndDate AND HierarchyNode = _Text.HierarchyNode  -- association [0..*]
;

Learn More