I_FINSTMNTEXPANDEDHIERNODE

CDS View
10 Fields 12 CDS Views

Financial Statement Expanded Hier Node

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

CDS Views using this table (12)

ViewTypeJoinVDMDescription
P_FinStmntHierarchyWithCoCode view from COMPOSITE
P_FinStmntHierarchyWithCoCode view union_all COMPOSITE
P_KZ_DATASELFINSTMNT view from COMPOSITE
P_KZ_DATASELFINSTMNT view union_all COMPOSITE
P_RU_DataSelFinSTMNT view from COMPOSITE
P_RU_DataSelFinSTMNT view union_all COMPOSITE
P_RU_DataSelFinSTMNTV508 view from COMPOSITE
P_RU_DataSelFinSTMNTV508 view union_all COMPOSITE
P_RU_DSFinStmntExpandHierNode view from COMPOSITE
P_RU_DSFinStmntExpandHierNode view union_all COMPOSITE
P_UA_DATASELFINSTMNT view from COMPOSITE
P_UA_DATASELFINSTMNT view union_all COMPOSITE

Fields (10)

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

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)
);

Learn More