CGPL_HIERARCHY

Transparent Table Application Table
8 Fields 15 CDS Views

Project Planning: Activities and Projects Hierarchy Table

CGPL_HIERARCHY is an SAP database table in S/4HANA. Project Planning: Activities and Projects Hierarchy Table. It contains 8 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
I_FMEANodeHierarchy view from BASIC Hierarchy of FMEA Nodes
I_FMEATaskHierarchy view_entity from BASIC Hierarchy of FMEA Action
I_FMEATaskHierarchy view_entity inner BASIC Hierarchy of FMEA Action
I_GrantorProgramHierarchy view_entity from BASIC Grantor Program Hierarchy
I_PPM_BPForObjectDirect view inner BASIC Directly Assigned Project Managers
I_PPM_BPForObjectIndirect view inner BASIC Project Managers Assgined By Role
I_PPM_ChecklistItem view inner BASIC Determines Checklist Items
I_PPM_ChecklistItem view left_outer BASIC Determines Checklist Items
I_PPM_IsMyProject view left_outer COMPOSITE All projects a user is respsonible for
I_PPM_ProjectRole view left_outer BASIC Project Role
I_PPM_SeverityValue view inner BASIC Severity Value
I_PPM_TeamMemberRoleStaffing view inner COMPOSITE Team Member Role Staffing
I_ProjPrtfloInitvRoleStaffing view_entity inner BASIC Proj Portfolio Initiative Role Staffing
P_AuditComponent view from BASIC Audit Component
v_dpr_bp_entity_view view inner Generic entities for business partner guid

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY guid CGPL_GUID16 CGPL_GUID
project_guid CGPL_GUID16 CGPL_GUID
task_level CGPL_LEVEL Level
up CGPL_GUID16 CGPL_GUID
down CGPL_GUID16 CGPL_GUID
left_node CGPL_GUID16 CGPL_GUID
right_node CGPL_GUID16 CGPL_GUID

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.

-- Project Planning: Activities and Projects Hierarchy Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CGPL_HIERARCHY (
    CLIENT,        -- Client [MANDT]
    GUID,          -- CGPL_GUID [CGPL_GUID16]
    PROJECT_GUID,  -- CGPL_GUID [CGPL_GUID16]
    TASK_LEVEL,    -- Level [CGPL_LEVEL]
    UP,            -- CGPL_GUID [CGPL_GUID16]
    DOWN,          -- CGPL_GUID [CGPL_GUID16]
    LEFT_NODE,     -- CGPL_GUID [CGPL_GUID16]
    RIGHT_NODE,    -- CGPL_GUID [CGPL_GUID16]
    PRIMARY KEY (CLIENT, GUID)
);

Learn More