I_GLACCOUNTHIERARCHYNODE

CDS View

G/L Account Hierarchy Node

I_GLACCOUNTHIERARCHYNODE is a CDS View in S/4HANA. G/L Account Hierarchy Node. It contains 14 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_CostCtrCmtmtGLAccountGroupVH view from CONSUMPTION GLAccount Group Value Help
C_GLAccountHierarchyGroupVH view from CONSUMPTION GLAccount Hierarchy/Group Value Help
C_GLAccountHierarchyNode view from CONSUMPTION API GL Acccount Hierarchy Node
I_AvailyCtrlProfileGLAcctGrpVH view inner BASIC G/L Account Group Value Help
I_CO_GLAccountHierarchyNode view_entity from COMPOSITE Colombia G/L Account Hierarchy Node
I_CurGLAcctHierarchyNode view_entity from COMPOSITE Current GL Account - Hierarchy Node
I_StatementOfChangesCube view_entity inner COMPOSITE Statement of Changes line items - Cube
P_CostCenterBudget view inner COMPOSITE Cost Center Budget Report
P_MX_FinancialStmntStructure view from COMPOSITE MX Financial Statement Structure
P_MX_FinancialStmntStructure view union_all COMPOSITE MX Financial Statement Structure
P_ProjectGLAccountHierarchy view from COMPOSITE GL Account for Global Account Hierarchy

Fields (14)

KeyField CDS FieldsUsed in Views
KEY ChartOfAccounts ChartOfAccounts,OperationalChartOfAccounts 4
KEY GLAccountHierarchy FinancialStatementHierarchy,GLAccountHierarchy 4
KEY HierarchyNode HierarchyNode 5
KEY HierarchyVersion HierarchyVersion 2
KEY ValidityEndDate ValidityEndDate 5
_Hierarchy _Hierarchy 1
_Text _Text 1
GLAccount GLAccount,OperationalGLAccount 3
HierarchyNodeLevel HierarchyNodeLevel 1
HierarchyNodeSequence HierarchyNodeSequence 2
HierarchyNodeVal HierarchyNodeVal 1
NodeType FinancialStatementNodeType,NodeType 4
ParentNode ParentNode,ProjectCostComponent 4
ValidityStartDate ValidityStartDate 5

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.

-- G/L Account Hierarchy Node
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GLACCOUNTHIERARCHYNODE (
    CHARTOFACCOUNTS,
    GLACCOUNTHIERARCHY,
    HIERARCHYNODE,
    HIERARCHYVERSION,
    VALIDITYENDDATE,
    _HIERARCHY,
    _TEXT,
    GLACCOUNT,
    HIERARCHYNODELEVEL,
    HIERARCHYNODESEQUENCE,
    HIERARCHYNODEVAL,
    NODETYPE,
    PARENTNODE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (CHARTOFACCOUNTS, GLACCOUNTHIERARCHY, HIERARCHYNODE, HIERARCHYVERSION, VALIDITYENDDATE)
);