The CGPL_ARCH_IDX table in SAP ERP or S/4HANA stores Project Planning: Index of Archived Projects data. There are total 7 fields in CGPL_ARCH_IDX table. The Project Planning: Index of Archived Projects 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_ARCH_IDX table. It is in Project Planning – General Functions (CGPL_GENERIC_FUNCTIONS) ABAP package and is part of the Generic Project Planning (CA-GTF-GPL) module.
SAP CGPL_ARCH_IDX Table Fields
Following is the list of fields that are available in SAP CGPL_ARCH_IDX table. The primary key fields of the table are CLIENT (Client), GUID (UUID in X form (binary)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| GUID | UUID in X form (binary) | SYSUUID_X | RAW (16) | |
| EXTERNAL_ID | Project Planning: External Indentifier of an Element | CGPL_EXTID | CHAR (24) | |
| OBJECT_TYPE | Object Type in Project Planning | CGPL_OBJECT_TYPE | CHAR (3) | |
| ARCHIVE_NAME | Key for Archive File | ARKEY | CHAR (20) | |
| UP | Project Planning: 16-Character GUID for Projects and Activts | CGPL_GUID16 | RAW (16) | |
| APPLICATION | Application in Project Planning | CGPL_APPLICATION_TYPE | * | CHAR (3) |
