The CLUIPROFILE table in SAP ERP or S/4HANA stores Profile Definition for the iPPE Workbench Express data. There are total 64 fields in CLUIPROFILE table. The Profile Definition for the iPPE Workbench Express 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 CLUIPROFILE table. It is in iPPE: Customizing for iPPE Workbench Express (CPPELUI0C) ABAP package and is part of the Integrated Product and Process Engineering (AP-PPE) module.
SAP CLUIPROFILE Table Fields
Following is the list of fields that are available in SAP CLUIPROFILE table. The primary key fields of the table are MANDT (Client), PROFILE_ID (Profile Name for iPPE Workbench Express).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| PROFILE_ID | Profile Name for iPPE Workbench Express | PPELUI_PROFILE_ID | CHAR (8) | |
| STD_PROFIL | Basic Profile for Unassigned Users | PPELUI_DEF_PROFILE | CHAR (1) | |
| LAYO_IDENT | Additional Identification of ALV Layout | PPELUI_LAYO_ID | CHAR (4) | |
| LAYO_USE_ACT | Usage of Process Structure | PPELUI_LAYO_USE_ACT | CHAR (1) | |
| LAYO_USE_CMP | Usage of Product Structure | PPELUI_LAYO_USE_CMP | CHAR (1) | |
| LAYO_VIS_HDR | Display Table of Production Versions | PPELUI_LAYO_VIS_HDR | CHAR (1) | |
| LAYO_VIS_CMPHD | Display Table for Maintaining BOM Header | PPELUI_LAYO_VIS_CMPHD | CHAR (1) | |
| LAYO_VIS_CMPST | Display Table for Maintaining Components | PPELUI_LAYO_VIS_CMPST | CHAR (1) | |
| LAYO_VIS_ACTHD | Display Table for Maintaining the Routing Header | PPELUI_LAYO_VIS_ACTHD | CHAR (1) | |
| LAYO_VIS_ACTST | Display Table for Maintaining Routing | PPELUI_LAYO_VIS_ACTST | CHAR (1) | |
| LAYO_SEQUENCE | Table Sequence in the iPPE Workbench Express | PPELUI_LAYO_SEQ | CHAR (1) | |
| LAYO_HDR_DEF | Standard Column Set for Displaying Production Version | PPELUI_LAYO_DEF_HDR | CHAR (12) | |
| LAYO_HDR_MAX | Maximum Column Set for Displaying Production Version | PPELUI_LAYO_MAX_HDR | CHAR (12) | |
| LAYO_CMPHD_DEF | Standard Column Set for Displaying BOM Header | PPELUI_LAYO_DEF_CMPHD | CHAR (12) | |
| LAYO_CMPHD_MAX | Maximum Column Set for Displaying BOM Header | PPELUI_LAYO_MAX_CMPHD | CHAR (12) | |
| LAYO_CMPST_DEF | Standard Column Set for Displaying Components | PPELUI_LAYO_DEF_CMPST | CHAR (12) | |
| LAYO_CMPST_MAX | Maximum Column Set for Displaying Components | PPELUI_LAYO_MAX_CMPST | CHAR (12) | |
| LAYO_ACTHD_DEF | Standard Column Set for Displaying Routing Header | PPELUI_LAYO_DEF_ACTHD | CHAR (12) | |
| LAYO_ACTHD_MAX | Maximum Column Set for Displaying Routing Header | PPELUI_LAYO_MAX_ACTHD | CHAR (12) | |
| LAYO_ACTST_DEF | Standard Column Set for Displaying Routing | PPELUI_LAYO_DEF_ACTST | CHAR (12) | |
| LAYO_ACTST_MAX | Maximum Column Set for Displaying Routing | PPELUI_LAYO_MAX_ACTST | CHAR (12) | |
| LAYO_SAVE_OPTION | Save ALV Layout in the iPPE Workbench Express | PPELUI_LAYO_SAVE | CHAR (1) | |
| LAYO_HDR_SIZE | Standard Size in Percent for Production Version Display | PPELUI_LAYO_SIZE_HDR | INT1 (3) | |
| LAYO_CMPHD_SIZE | Standard Size in Percent for BOM Header Display | PPELUI_LAYO_SIZE_CMPHD | INT1 (3) | |
| LAYO_CMPST_SIZE | Standard Size in Percent for Components Display | PPELUI_LAYO_SIZE_CMPST | INT1 (3) | |
| LAYO_ACTHD_SIZE | Standard Size in Percent for Routing Header Display | PPELUI_LAYO_SIZE_ACTHD | INT1 (3) | |
| LAYO_ACTST_SIZE | Standard Size in Percent for Routing Display | PPELUI_LAYO_SIZE_ACTST | INT1 (3) | |
| DIA_C_CREATION | Behavior When Creating Product Structure | PPELUI_DIA_CREA | CHAR (1) | |
| USE_WORKLIST | Worklist Allowed | PPELUI_USE_WORKLIST | CHAR (1) | |
| USE_FILTER | Filter by Date Validity Possible | PPELUI_USE_FILTER | CHAR (1) | |
| USE_ECM | Engineering Change Management Usable | PPELUI_USE_ECM | CHAR (1) | |
| USE_EDE_CMP | Object Dependency Usable for Product Structure | PPELUI_USE_EDE_CMP | CHAR (1) | |
| USE_EDE_ACT | Object Dependency Usable for Process Structure | PPELUI_USE_EDE_ACT | CHAR (1) | |
| USE_CLS_CMP | Classification Usable for Product Structure | PPELUI_USE_CLS_CMP | CHAR (1) | |
| USE_CLS_ACT | Classification Usable for Process Structure | PPELUI_USE_CLS_ACT | CHAR (1) | |
| VAL_LOCEXT | Character field of length 40 | CHAR40 | CHAR (40) | |
| VAL_LOCEXT_ACT | Use of Value for Location | PPELUI_VAL_ACTVT_LOCEXT | CHAR (1) | |
| VAL_H_USAGE | Usage in iPPE | PPE_USE | * | CHAR (3) |
| VAL_H_USAGE_ACT | Use of Value for iPPE Usage | PPELUI_VAL_ACTVT_USAGE | CHAR (1) | |
| VAL_COPY | Copy Production Versions | PPELUI_VAL_COPY | CHAR (1) | |
| VAL_COPY_ACT | Use of Value for Copy Option | PPELUI_VAL_ACTVT_COPY | CHAR (1) | |
| VAL_CLASS | Class | PPE_KLASSE | CHAR (18) | |
| VAL_CLASSTYPE | Class Type | PPE_KLASSENART | * | CHAR (3) |
| VAL_CLASS_ACT | Use of Value for Class and Class Type | PPELUI_VAL_ACTVT_CLASS | CHAR (1) | |
| VAL_A_TYPE | Type of iPPE Process Structure | PPE_PLANTYPE | CHAR (1) | |
| VAL_A_TYPE_ACT | Use of Value for Routing Type | PPELUI_VAL_ACTVT_PLANTYPE | CHAR (1) | |
| VAL_A_CTM | Use: CTM Planning | PPE_CTM_USE | CHAR (1) | |
| VAL_A_CTM_ACT | Value Handling for CTM Planning | PPELUI_VAL_ACTVT_CTM_USE | CHAR (1) | |
| VAL_A_TUOM | Time Unit | PPE_TIMEUNIT | * | UNIT (3) |
| VAL_A_TUOM_ACT | Use of Value for Time Unit (Mode) | PPELUI_VAL_ACTVT_TIMEUNIT | CHAR (1) | |
| VAL_H_LOTS_MAX | Maximum Lot Size | PPE_LOSSBS | QUAN (13) | |
| VAL_H_LOTS_MIN | Minimum Lot Size | PPE_LOSSVN | QUAN (13) | |
| VAL_H_LOTS_UOM | Unit of Measure of Lot Size | PPELUI_VAL_LOTS_SIZE_UNIT | * | UNIT (3) |
| VAL_H_LOTS_ACT | Use of Values for Lot Sizes | PPELUI_VAL_ACTVT_LOTS_SIZE | CHAR (1) | |
| VAL_A_NOBRK | No Breaks | PPELUI_VAL_NO_BREAK | CHAR (1) | |
| VAL_A_NOBRK_ACT | Use of Value for No Breaks | PPELUI_VAL_ACTVT_NO_BREAK | CHAR (1) | |
| VAL_A_BREAK | Duration of a Short Break During an Activity | PPE_MAX_BREAK | QUAN (13) | |
| VAL_A_BREAK_UOM | Unit for Short Break | PPE_MAX_BREAK_TUNIT | * | UNIT (3) |
| VAL_A_BREAK_ACT | Use of Values for Maximum Break | PPELUI_VAL_ACTVT_MAX_BREAK | CHAR (1) | |
| VAL_A_PSHFT | Production Within a Shift | PPE_PROD_IN_SHIFT | CHAR (1) | |
| VAL_A_PSHFT_ACT | Use of Value for Shift Production | PPELUI_VAL_ACTVT_PROD_IN_SHIFT | CHAR (1) | |
| VAL_H_PPRIO | Procurement Priority | PPE_PROCPRIO | DEC (15) | |
| VAL_H_PPRIO_ACT | Use of Value for Procurement Priority | PPELUI_VAL_ACTVT_PROCURE_PRIO | CHAR (1) |
