I_FINSTMNTEXPANDEDHIERNODE

CDS View

Financial Statement Expanded Hier Node

I_FINSTMNTEXPANDEDHIERNODE is a CDS View in S/4HANA. Financial Statement Expanded Hier Node. It contains 10 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
P_FinStmntHierarchyWithCoCode view from COMPOSITE Financial Statement Hierarchy with Company Code
P_FinStmntHierarchyWithCoCode view union_all COMPOSITE Financial Statement Hierarchy with Company Code
P_KZ_DATASELFINSTMNT view from COMPOSITE data selection for financial statment
P_KZ_DATASELFINSTMNT view union_all COMPOSITE data selection for financial statment
P_RU_DataSelFinSTMNT view from COMPOSITE data selection for financial statment
P_RU_DataSelFinSTMNT view union_all COMPOSITE data selection for financial statment
P_RU_DataSelFinSTMNTV508 view from COMPOSITE Data selection view for fin stmnt new
P_RU_DataSelFinSTMNTV508 view union_all COMPOSITE Data selection view for fin stmnt new
P_RU_DSFinStmntExpandHierNode view from COMPOSITE Data selection view for fin stmnt new
P_RU_DSFinStmntExpandHierNode view union_all COMPOSITE Data selection view for fin stmnt new

Fields (10)

KeyField CDS FieldsUsed in Views
KEY FinancialStatementHierarchy FinancialStatementHierarchy 4
KEY HierarchyNode HierarchyNode 1
KEY HierarchyVersion HierarchyVersion 1
KEY ParentNode ParentNode 1
KEY ValidityEndDate ValidityEndDate 1
ChartOfAccounts ChartOfAccounts 2
DebitCreditCode DebitCreditCode 1
FinancialStatementLeafItem FinancialStatementLeafItem 3
FinStatementHierarchyNodeValue FinStatementHierarchyNodeValue 1
GLAccountInfo GLAccountInfo 3

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 Expanded Hier Node
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FINSTMNTEXPANDEDHIERNODE (
    FINANCIALSTATEMENTHIERARCHY,
    HIERARCHYNODE,
    HIERARCHYVERSION,
    PARENTNODE,
    VALIDITYENDDATE,
    CHARTOFACCOUNTS,
    DEBITCREDITCODE,
    FINANCIALSTATEMENTLEAFITEM,
    FINSTATEMENTHIERARCHYNODEVALUE,
    GLACCOUNTINFO,
    PRIMARY KEY (FINANCIALSTATEMENTHIERARCHY, HIERARCHYNODE, HIERARCHYVERSION, PARENTNODE, VALIDITYENDDATE)
);