I_GRANTHIERARCHYNODE

CDS View

Grant Hierarchy Node

I_GRANTHIERARCHYNODE is a CDS View in S/4HANA. Grant Hierarchy Node. It contains 10 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_GrantCoreHierNode view from COMPOSITE Grant Hierarchy Node
A_GrantHierNode view from COMPOSITE Grant Hierarchy Node
I_GrantHierarchyNodeStdVH view_entity from BASIC Grant Hierarchy Node

Fields (10)

KeyField CDS FieldsUsed in Views
KEY GrantHierarchy GrantHierarchy 1
KEY HierarchyNode HierarchyNode 1
KEY ValidityEndDate ValidityEndDate 1
GrantID GrantID 1
HierarchyNodeLevel HierarchyNodeLevel 1
HierarchyNodeSequence HierarchyNodeSequence 1
HierarchyVersion HierarchyVersion 1
NodeType NodeType 1
ParentNode ParentNode 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.

-- Grant Hierarchy Node
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GRANTHIERARCHYNODE (
    GRANTHIERARCHY,
    HIERARCHYNODE,
    VALIDITYENDDATE,
    GRANTID,
    HIERARCHYNODELEVEL,
    HIERARCHYNODESEQUENCE,
    HIERARCHYVERSION,
    NODETYPE,
    PARENTNODE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (GRANTHIERARCHY, HIERARCHYNODE, VALIDITYENDDATE)
);