I_FinStmntExpandedHierNode

DDL: I_FINSTMNTEXPANDEDHIERNODE SQL: IFISTMNTEXPND Type: view COMPOSITE
17 Fields 4 Data Sources 5 Associations

Financial Statement Expanded Hier Node

I_FinStmntExpandedHierNode is a Composite CDS View that provides data about "Financial Statement Expanded Hier Node" in SAP S/4HANA. It reads from 4 data sources (R_HierRuntimeRprstnNodeAttrib, I_FinancialStatementHier, R_HierRuntimeRprstnNode, R_HierRuntimeRprstnAttrib) and exposes 17 fields with key fields FinancialStatementHierarchy, HierarchyVersion, HierarchyNode, ParentNode, ValidityEndDate. It has 5 associations to related views.

Data Sources (4)

SourceAliasJoin Type
R_HierRuntimeRprstnNodeAttrib attrib left_outer
I_FinancialStatementHier hier from
R_HierRuntimeRprstnNode node left_outer
R_HierRuntimeRprstnAttrib source left_outer

Associations (5)

CardinalityTargetAliasCondition
[0..*] I_FinancialStatementHierNodeT _Text $projection.FinancialStatementHierarchy = _Text.FinancialStatementHierarchy and $projection.ValidityEndDate = _Text.ValidityEndDate and $projection.HierarchyNode = _Text.HierarchyNode
[0..*] I_FinancialStatementHierNodeT _ParentText $projection.FinancialStatementHierarchy = _ParentText.FinancialStatementHierarchy and $projection.ValidityEndDate = _ParentText.ValidityEndDate and $projection.HierarchyNode = _ParentText.HierarchyNode
[0..1] I_FinancialStatementHier _Hierarchy $projection.FinancialStatementHierarchy = _Hierarchy.FinancialStatementHierarchy and $projection.ValidityEndDate = _Hierarchy.ValidityEndDate
[0..1] I_FinancialStatementLeafItem _FinancialStatementLeafItem $projection.FinancialStatementLeafItem = _FinancialStatementLeafItem.FinancialStatementLeafItem
[0..*] P_HRRP_NODE_ATTR _NodeAttribute $projection.FinancialStatementHierarchy = _NodeAttribute.HierarchyID and $projection.HierarchyVersion = _NodeAttribute.HierarchyVersion and $projection.ValidityEndDate = _NodeAttribute.ValidityEndDate and $projection.ChartOfAccounts = _NodeAttribute.NodeClass and $projection.HierarchyNode = _NodeAttribute.HierarchyNode and $projection.ParentNode = _NodeAttribute.ParentNode

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IFISTMNTEXPND view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #HIERARCHY view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.buffering.status #NOT_ALLOWED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Financial Statement Expanded Hier Node view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY FinancialStatementHierarchy R_HierRuntimeRprstnNode HierarchyID Hierarchy ID
KEY HierarchyVersion R_HierRuntimeRprstnNode HierarchyVersion Version
KEY HierarchyNode R_HierRuntimeRprstnNode HierarchyNode Node
KEY ParentNode R_HierRuntimeRprstnNode ParentNode Parent Node
KEY ValidityEndDate R_HierRuntimeRprstnNode ValidityEndDate ValidTo
ValidityStartDate R_HierRuntimeRprstnNode ValidityStartDate Validity Start Date
ChartOfAccounts R_HierRuntimeRprstnNode HierarchyNodeClass Node Class
NodeType R_HierRuntimeRprstnNode NodeType Object Type
FinStatementHierarchyNodeValue R_HierRuntimeRprstnNode HierarchyNodeVal Value
DebitCreditCode R_HierRuntimeRprstnNode DebitCreditCode Single-Character Flag
SequenceNumber SequenceNumber Sort sequence
HierarchyLevel HierarchyNodeLevel Hierarchy Node Level
SignIsInverted R_HierRuntimeRprstnNodeAttrib HierNodeAttributeRangeFromVal Attribute Value
_Text _Text
_ParentText _ParentText
_FinancialStatementLeafItem _FinancialStatementLeafItem
_Hierarchy _Hierarchy

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_FinStmntExpandedHierNode.
-- 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.
-- SQL view name: IFISTMNTEXPND

CREATE VIEW I_FinStmntExpandedHierNode AS
SELECT
  node.HierarchyID AS FinancialStatementHierarchy,
  node.HierarchyVersion AS HierarchyVersion,
  node.HierarchyNode AS HierarchyNode,
  node.ParentNode AS ParentNode,
  node.ValidityEndDate AS ValidityEndDate,
  node.ValidityStartDate AS ValidityStartDate,
  node.HierarchyNodeClass AS ChartOfAccounts,
  node.NodeType AS NodeType,
  node.HierarchyNodeVal AS FinStatementHierarchyNodeValue,
  node.DebitCreditCode AS DebitCreditCode,
  SequenceNumber,
  HierarchyNodeLevel AS HierarchyLevel,
  attrib.HierNodeAttributeRangeFromVal AS SignIsInverted
FROM I_FinancialStatementHier AS hier
LEFT OUTER JOIN R_HierRuntimeRprstnAttrib AS source ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_HierRuntimeRprstnNode AS node ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_HierRuntimeRprstnNodeAttrib AS attrib ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FinancialStatementHierNodeT AS _Text ON FinancialStatementHierarchy = _Text.FinancialStatementHierarchy AND ValidityEndDate = _Text.ValidityEndDate AND HierarchyNode = _Text.HierarchyNode  -- association [0..*]
LEFT OUTER JOIN I_FinancialStatementHierNodeT AS _ParentText ON FinancialStatementHierarchy = _ParentText.FinancialStatementHierarchy AND ValidityEndDate = _ParentText.ValidityEndDate AND HierarchyNode = _ParentText.HierarchyNode  -- association [0..*]
LEFT OUTER JOIN I_FinancialStatementHier AS _Hierarchy ON FinancialStatementHierarchy = _Hierarchy.FinancialStatementHierarchy AND ValidityEndDate = _Hierarchy.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_FinancialStatementLeafItem AS _FinancialStatementLeafItem ON FinancialStatementLeafItem = _FinancialStatementLeafItem.FinancialStatementLeafItem  -- association [0..1]
LEFT OUTER JOIN P_HRRP_NODE_ATTR AS _NodeAttribute ON FinancialStatementHierarchy = _NodeAttribute.HierarchyID AND HierarchyVersion = _NodeAttribute.HierarchyVersion AND ValidityEndDate = _NodeAttribute.ValidityEndDate AND ChartOfAccounts = _NodeAttribute.NodeClass AND HierarchyNode = _NodeAttribute.HierarchyNode AND ParentNode = _NodeAttribute.ParentNode  -- association [0..*]
;

Learn More