A_BudgetAccountCoreHierarchy

DDL: A_BUDGETACCOUNTCOREHIERARCHY Type: view COMPOSITE
6 Fields 1 Data Sources 2 Associations

Budget Account Hierarchy

A_BudgetAccountCoreHierarchy is a Composite CDS View that provides data about "Budget Account Hierarchy" in SAP S/4HANA. It reads from 1 data source (I_BudgetAccountHierarchy) and exposes 6 fields with key fields BudgetAccountHierarchy, ValidityEndDate. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BudgetAccountHierarchy I_BudgetAccountHierarchy from

Associations (2)

CardinalityTargetAliasCondition
[0..*] A_BudgetAccountCoreHierarchyT _Text $projection.BudgetAccountHierarchy = _Text.BudgetAccountHierarchy and $projection.ValidityEndDate = _Text.ValidityEndDate
[0..*] A_BudgetAccountCoreHierNode _BudgetAccountCoreHierNode

Annotations (13)

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

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BudgetAccountHierarchy BudgetAccountHierarchy
KEY ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
ChartOfAccounts ChartOfAccounts Node Class
_Text _Text
_BudgetAccountCoreHierNode _BudgetAccountCoreHierNode

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_BudgetAccountCoreHierarchy.
-- 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_BudgetAccountCoreHierarchy AS
SELECT
  BudgetAccountHierarchy,
  ValidityEndDate,
  ValidityStartDate,
  ChartOfAccounts
FROM I_BudgetAccountHierarchy
LEFT OUTER JOIN A_BudgetAccountCoreHierarchyT AS _Text ON BudgetAccountHierarchy = _Text.BudgetAccountHierarchy AND ValidityEndDate = _Text.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN A_BudgetAccountCoreHierNode AS _BudgetAccountCoreHierNode ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More