I_BudgetCostCenterHierNode

DDL: I_BUDGETCOSTCENTERHIERNODE Type: view_entity COMPOSITE Package: FINS_CO_ANALYTICS
10 Fields

Budget Cost Center Hierarchy Node

I_BudgetCostCenterHierNode is a Composite CDS View (Dimension) that provides data about "Budget Cost Center Hierarchy Node" in SAP S/4HANA. Part of development package FINS_CO_ANALYTICS.

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Budget Cost Center Hierarchy Node view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataCategory #DIMENSION view
Metadata.allowExtensions true view
Analytics.internalName #LOCAL view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey Nodename view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY BudgetCostCenterHierarchyId Base BudgetCostCenterHierarchyId
KEY NodeName Base NodeName Node Text
ValidityEndDate Base ValidityEndDate ValidTo
ValidityStartDate Base ValidityStartDate Validity Start Date
_Dir Base _Dir
ControllingArea Base ControllingArea Controlling Area
CostCenter Base CostCenter Cost Center
CostCenterDescription _TextCostCenter CostCenterDescription Description
CostCenterName _TextCostCenter CostCenterName Name
_TextCostCenter _TextCostCenter

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_BudgetCostCenterHierNode.
-- 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 I_BudgetCostCenterHierNode AS
SELECT
  Base.BudgetCostCenterHierarchyId AS BudgetCostCenterHierarchyId,
  Base.NodeName AS NodeName,
  Base.ValidityEndDate AS ValidityEndDate,
  Base.ValidityStartDate AS ValidityStartDate,
  Base._Dir AS _Dir,
  Base.ControllingArea AS ControllingArea,
  Base.CostCenter AS CostCenter,
  _TextCostCenter.CostCenterDescription AS CostCenterDescription,
  _TextCostCenter.CostCenterName AS CostCenterName
;

Learn More