I_FINANCIALSTATEMENTHIER

CDS View

Financial Statement Hierarchy

I_FINANCIALSTATEMENTHIER is a CDS View in S/4HANA. Financial Statement Hierarchy. It contains 7 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_CO_AcctBalLdgrFinStmntStruc view_entity inner CONSUMPTION Colombia Acct Bal Ledger Fin Statement structure
C_CO_UGPPFinStmntStructure view_entity inner CONSUMPTION Colombia UGPP Fin Statement structure
I_FinancialStatementStructure view from COMPOSITE Financial Statement Version Structure
I_FinStmntExpandedHierNode view from COMPOSITE Financial Statement Expanded Hier Node
P_CN_FinancialStatementVersion view from CONSUMPTION Financial Statement Version for China
P_FINSTMNTHIERINCOAVH view_entity from BASIC Value help for fin stmnt hier in COA
P_GLAccountInCOAHierarchy view from COMPOSITE
P_GLACCTWITHCOCODE view inner COMPOSITE
SHIDCN_FinStmntVersionct view from Financial Statement Version Help

Fields (7)

KeyField CDS FieldsUsed in Views
KEY FinancialStatementHierarchy FinancialStatementHierarchy 2
KEY ValidityEndDate ValidityEndDate 2
_Text _HierText 2
FunctionalAreaIsUsed FunctionalAreaIsUsed 1
GroupChartOfAccountIsUsed GroupChartOfAccountIsUsed 1
HierarchyType HierarchyType 1
ValidityStartDate ValidityStartDate 2

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FINANCIALSTATEMENTHIER (
    FINANCIALSTATEMENTHIERARCHY,
    VALIDITYENDDATE,
    _TEXT,
    FUNCTIONALAREAISUSED,
    GROUPCHARTOFACCOUNTISUSED,
    HIERARCHYTYPE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (FINANCIALSTATEMENTHIERARCHY, VALIDITYENDDATE)
);