I_FINANCIALSTATEMENTHIERNODE

CDS View
14 Fields 4 CDS Views

Financial Statement Hierarchy Node

I_FINANCIALSTATEMENTHIERNODE is a CDS View in S/4HANA. Financial Statement Hierarchy Node. It contains 14 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_AT_AstAcqnDownPaymentC view_entity inner CONSUMPTION AT Asst Acqn and Down Payment - Cube
I_BalShtIncStatementHierNode view_entity from BASIC Balance Sheet Hierarchy Node
I_FinancialStatementStructure view inner COMPOSITE Financial Statement Version Structure
P_GLAccountInCOAHierarchy view_entity inner COMPOSITE GL Account in Chart of Accounts Hierarchy

Fields (14)

KeyField CDS FieldsUsed in Views
KEY HierarchyNode FinancialStatementItem,HierarchyNode 3
KEY ParentNode ParentNode,ParentNodeUniqueID 3
DebitCreditCode DebitCreditCode 1
FinancialStatementHierarchy FinancialStatementHierarchy 1
FinancialStatementLeafItem FinancialStatementLeafItem 1
FinancialStatementNodeType FinancialStatementNodeType,NodeType 3
FinStmntNodeFormattedID FinStmntNodeFormattedID 1
HierarchyLevel HierarchyLevel 3
HierarchyNodeSequence HierarchyNodeSequence,SiblingNode 3
HierarchyNodeVal HierarchyNodeVal 1
HierarchyVersion HierarchyVersion 1
SignIsInverted SignIsInverted 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Financial Statement Hierarchy Node
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FINANCIALSTATEMENTHIERNODE (
    HIERARCHYNODE,
    PARENTNODE,
    DEBITCREDITCODE,
    FINANCIALSTATEMENTHIERARCHY,
    FINANCIALSTATEMENTLEAFITEM,
    FINANCIALSTATEMENTNODETYPE,
    FINSTMNTNODEFORMATTEDID,
    HIERARCHYLEVEL,
    HIERARCHYNODESEQUENCE,
    HIERARCHYNODEVAL,
    HIERARCHYVERSION,
    SIGNISINVERTED,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (HIERARCHYNODE, PARENTNODE)
);

Learn More