R_CostCenterHierarchyNodeText

DDL: R_COSTCENTERHIERARCHYNODETEXT Type: view_entity TRANSACTIONAL Package: FINS_FI_UH_INBOUND
9 Fields 3 Data Sources

Cost Center Hierarchy Node Text

R_CostCenterHierarchyNodeText is a Transactional CDS View that provides data about "Cost Center Hierarchy Node Text" in SAP S/4HANA. It reads from 3 data sources (I_UniversalHierNode, I_UniversalHierNodeText, I_UniversalHierVersion) and exposes 9 fields with key fields CostCenterHierarchyShortID, ValidityEndDate, ValidityStartDate, UniversalHierNodeType, CostCtrHierarchyNodeShortID. Part of development package FINS_FI_UH_INBOUND.

Data Sources (3)

SourceAliasJoin Type
I_UniversalHierNode node inner
I_UniversalHierNodeText nodet from
I_UniversalHierVersion version inner

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Cost Center Hierarchy Node Text view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CostCenterHierarchyShortID I_UniversalHierVersion UniversalHierHierarchyID Hierarchy ID
KEY ValidityEndDate I_UniversalHierVersion UniversalHierVersValidTo Valid To
KEY ValidityStartDate I_UniversalHierVersion UniversalHierVersValidFrom Valid From
KEY UniversalHierNodeType I_UniversalHierNode UniversalHierNodeType Type
KEY CostCtrHierarchyNodeShortID I_UniversalHierNode UniversalHierNodeLowValue Node Low Value
KEY Language I_UniversalHierNodeText Language Report Text Language
HierarchyNodeText I_UniversalHierNodeText UniversalHierNodeLowValueTxt Node Text
_CostCtrHierarchyNode _CostCtrHierarchyNode
_CostCtrHierarchy _CostCtrHierarchy

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 R_CostCenterHierarchyNodeText.
-- 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 R_CostCenterHierarchyNodeText AS
SELECT
  version.UniversalHierHierarchyID AS CostCenterHierarchyShortID,
  version.UniversalHierVersValidTo AS ValidityEndDate,
  version.UniversalHierVersValidFrom AS ValidityStartDate,
  node.UniversalHierNodeType AS UniversalHierNodeType,
  node.UniversalHierNodeLowValue AS CostCtrHierarchyNodeShortID,
  nodet.Language AS Language,
  nodet.UniversalHierNodeLowValueTxt AS HierarchyNodeText
FROM I_UniversalHierNodeText AS nodet
INNER JOIN I_UniversalHierVersion AS version ON /* join condition not captured in parsed metadata */
INNER JOIN I_UniversalHierNode AS node ON /* join condition not captured in parsed metadata */
;

Learn More