The CGIPROFIL table in SAP ERP or S/4HANA stores iPPE Workbench: Profile Definitions data. There are total 24 fields in CGIPROFIL table. The iPPE Workbench: Profile Definitions 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 CGIPROFIL table. It is in Customizing General Parts of the iPPE Interface (CPPEGUI0C) ABAP package and is part of the Integrated Product and Process Engineering (AP-PPE) module.
SAP CGIPROFIL Table Fields
Following is the list of fields that are available in SAP CGIPROFIL table. The primary key fields of the table are MANDT (Client), PROFIL_ID (Number of iPPE User Profile).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| PROFIL_ID | Number of iPPE User Profile | PVS_PROFIL_ID | CHAR (8) | |
| TREE_ID | Identification of the ALV Tree on the iPPE User Interface | PVS_TREE_ID | CHAR (2) | |
| URL | Internet/Intranet Address | PVS_URL | CHAR (255) | |
| NAVTREE_EXT | Width of the Navigation Area | PVS_NAVTREE_EXT | INT2 (5) | |
| HEADER_WIDTH | Width of Hierarchy Column | PVS_HEADER_WIDTH | INT4 (10) | |
| VAR_ASSEMBLY | Use of Variant Assembly | PVS_VAR_ASSEMBLY | CHAR (1) | |
| TAPART | iPPE Partner for Time Analysis | PPE_GI_TAPART | CHAR (20) | |
| PROFIL_AT1 | Profile ID of the Assignment Tree | PPE_PROFIL_ASSIGTREE | CGIPROFIL | CHAR (8) |
| PROFIL_AT2 | Profile ID of the Assignment Tree | PPE_PROFIL_ASSIGTREE | CGIPROFIL | CHAR (8) |
| PROFIL_AT3 | Profile ID of the Assignment Tree | PPE_PROFIL_ASSIGTREE | CGIPROFIL | CHAR (8) |
| CAX | CAD and DMU Authorization | PVS_CAX | CHAR (1) | |
| DOKAR | Document Type | DOKAR | * | CHAR (3) |
| DOKVR | Document Version | DOKVR | CHAR (2) | |
| DOKST | Document Status | PPE_DOCST | * | CHAR (2) |
| DAPPL | Workstation Application | PPE_DAPPL | * | CHAR (3) |
| DISVARIANT | Display Variant for Navigation / Assignment Tree | PPE_DISVARIANT | CHAR (12) | |
| THUMBNAIL | Thumbnail Active | PPE_THUMBNAIL | CHAR (1) | |
| TBN_DOKAR | Document Type for Thumbnail | PPE_TBN_DOKAR | * | CHAR (3) |
| TBN_DAPPL | Workstation Application for Thumbnail | PPE_TBN_DAPPL | * | CHAR (3) |
| REP_TREE | Report Tree Active | PPE_REP_TREE | CHAR (1) | |
| APPLICATION | Application in the iPPE Workbench | PPE_WB_APPLICATION | CGUI_APPL_DEF | CHAR (4) |
| GUI_ID | Identification for GUI Status and Title of an Application | PPE_WB_GUI_ID | CGUI_APPL_DYN | NUMC (2) |
| STD_PROFIL | Standard Profile for Unassigned Users | PPE_STD_PROFIL | CHAR (1) |
