The CGPL_HIERARCHY table in SAP ERP or S/4HANA stores Project Planning: Activities and Projects Hierarchy Table data. There are total 8 fields in CGPL_HIERARCHY table. The Project Planning: Activities and Projects Hierarchy Table table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CGPL_HIERARCHY table. It is in Project Planning – Application Objects (CGPL_APPLICATION_OBJECTS) ABAP package and is part of the Generic Project Planning (CA-GTF-GPL) module.
SAP CGPL_HIERARCHY Table Fields
Following is the list of fields that are available in SAP CGPL_HIERARCHY table. The primary key fields of the table are CLIENT (Client), GUID (Project Planning: 16-Character GUID for Projects and Activts).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| GUID | Project Planning: 16-Character GUID for Projects and Activts | CGPL_GUID16 | RAW (16) | |
| PROJECT_GUID | Project Planning: 16-Character GUID for Projects and Activts | CGPL_GUID16 | CGPL_PROJECT | RAW (16) |
| TASK_LEVEL | CGPL Planning Level of Activity | CGPL_LEVEL | INT1 (3) | |
| UP | Project Planning: 16-Character GUID for Projects and Activts | CGPL_GUID16 | RAW (16) | |
| DOWN | Project Planning: 16-Character GUID for Projects and Activts | CGPL_GUID16 | RAW (16) | |
| LEFT_NODE | Project Planning: 16-Character GUID for Projects and Activts | CGPL_GUID16 | RAW (16) | |
| RIGHT_NODE | Project Planning: 16-Character GUID for Projects and Activts | CGPL_GUID16 | RAW (16) |
