The CGPL_MAPPING table in SAP ERP or S/4HANA stores Mapping of SAP App. Field to MS Project data. There are total 7 fields in CGPL_MAPPING table. The Mapping of SAP App. Field to MS Project 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_MAPPING table. It is in Project Planning – Interface for MS Project (CGPL_EXTERNAL_INTERFACE) ABAP package and is part of the Generic Project Planning (CA-GTF-GPL) module.
SAP CGPL_MAPPING Table Fields
Following is the list of fields that are available in SAP CGPL_MAPPING table. The primary key fields of the table are CLIENT (Client), APPLICATION (Application in Project Planning), ALTERNATIVE (Single-Character Flag), FIELD_NAME (Field Name), FIELD_ID (4 Byte Signed Integer).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| APPLICATION | Application in Project Planning | CGPL_APPLICATION_TYPE | * | CHAR (3) |
| ALTERNATIVE | Single-Character Flag | CHAR1 | CHAR (1) | |
| FIELD_NAME | Field Name | FIELDNAME | * | CHAR (30) |
| FIELD_ID | 4 Byte Signed Integer | INT4 | INT4 (10) | |
| FIELD | Text (30 Characters) | TEXT30 | CHAR (30) | |
| DIRECTION | 1 Byte Unsigned Integer | INT1 | INT1 (3) |
