CLUIPROFILE SAP (Profile Definition for the iPPE Workbench Express) Table details
Description: Profile Definition for the iPPE Workbench Express
Table field list including key, data, relationships and ABAP select examples
CLUIPROFILE is a standard SAP Table which is used to store Profile Definition for the iPPE Workbench Express data and is available within R/3 SAP systems depending on the version and release level.
The CLUIPROFILE table consists of various fields, each holding specific information or linking keys about Profile Definition for the iPPE Workbench Express data available in SAP. These include PROFILE_ID (Profile Name for iPPE Workbench Express), STD_PROFIL (Basic Profile for Unassigned Users), LAYO_IDENT (Additional Identification of ALV Layout), LAYO_USE_ACT (Usage of Process Structure).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: E - Control table, SAP and customer have separate key areasDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
Text table = CLUIPROFILET
SAP CLUIPROFILE table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
PROFILE_ID | Profile Name for iPPE Workbench Express | PPELUI_PROFILE_ID | CHAR | 8 | PPELUI_PROFILE_ID | ||||
STD_PROFIL | Basic Profile for Unassigned Users | PPELUI_DEF_PROFILE | CHAR | 1 | XFELD | ||||
LAYO_IDENT | Additional Identification of ALV Layout | PPELUI_LAYO_ID | CHAR | 4 | CHAR4 | ||||
LAYO_USE_ACT | Usage of Process Structure | PPELUI_LAYO_USE_ACT | CHAR | 1 | PPELUI_LAYO_USE | ||||
LAYO_USE_CMP | Usage of Product Structure | PPELUI_LAYO_USE_CMP | CHAR | 1 | PPELUI_LAYO_USE | ||||
LAYO_VIS_HDR | Display Table of Production Versions | PPELUI_LAYO_VIS_HDR | CHAR | 1 | PPELUI_LAYO_VIS | ||||
LAYO_VIS_CMPHD | Display Table for Maintaining BOM Header | PPELUI_LAYO_VIS_CMPHD | CHAR | 1 | PPELUI_LAYO_VIS | ||||
LAYO_VIS_CMPST | Display Table for Maintaining Components | PPELUI_LAYO_VIS_CMPST | CHAR | 1 | PPELUI_LAYO_VIS | ||||
LAYO_VIS_ACTHD | Display Table for Maintaining the Routing Header | PPELUI_LAYO_VIS_ACTHD | CHAR | 1 | PPELUI_LAYO_VIS | ||||
LAYO_VIS_ACTST | Display Table for Maintaining Routing | PPELUI_LAYO_VIS_ACTST | CHAR | 1 | PPELUI_LAYO_VIS | ||||
LAYO_SEQUENCE | Table Sequence in the iPPE Workbench Express | PPELUI_LAYO_SEQ | CHAR | 1 | PPELUI_LAYO_SEQ | ||||
LAYO_HDR_DEF | Standard Column Set for Displaying Production Version | PPELUI_LAYO_DEF_HDR | CHAR | 12 | SLIS_VARI | ||||
LAYO_HDR_MAX | Maximum Column Set for Displaying Production Version | PPELUI_LAYO_MAX_HDR | CHAR | 12 | SLIS_VARI | ||||
LAYO_CMPHD_DEF | Standard Column Set for Displaying BOM Header | PPELUI_LAYO_DEF_CMPHD | CHAR | 12 | SLIS_VARI | ||||
LAYO_CMPHD_MAX | Maximum Column Set for Displaying BOM Header | PPELUI_LAYO_MAX_CMPHD | CHAR | 12 | SLIS_VARI | ||||
LAYO_CMPST_DEF | Standard Column Set for Displaying Components | PPELUI_LAYO_DEF_CMPST | CHAR | 12 | SLIS_VARI | ||||
LAYO_CMPST_MAX | Maximum Column Set for Displaying Components | PPELUI_LAYO_MAX_CMPST | CHAR | 12 | SLIS_VARI | ||||
LAYO_ACTHD_DEF | Standard Column Set for Displaying Routing Header | PPELUI_LAYO_DEF_ACTHD | CHAR | 12 | SLIS_VARI | ||||
LAYO_ACTHD_MAX | Maximum Column Set for Displaying Routing Header | PPELUI_LAYO_MAX_ACTHD | CHAR | 12 | SLIS_VARI | ||||
LAYO_ACTST_DEF | Standard Column Set for Displaying Routing | PPELUI_LAYO_DEF_ACTST | CHAR | 12 | SLIS_VARI | ||||
LAYO_ACTST_MAX | Maximum Column Set for Displaying Routing | PPELUI_LAYO_MAX_ACTST | CHAR | 12 | SLIS_VARI | ||||
LAYO_SAVE_OPTION | Save ALV Layout in the iPPE Workbench Express | PPELUI_LAYO_SAVE | CHAR | 1 | PPELUI_LAYO_SAVE | ||||
LAYO_HDR_SIZE | Standard Size in Percent for Production Version Display | PPELUI_LAYO_SIZE_HDR | INT1 | 3 | PPELUI_LAYO_SIZE | ||||
LAYO_CMPHD_SIZE | Standard Size in Percent for BOM Header Display | PPELUI_LAYO_SIZE_CMPHD | INT1 | 3 | PPELUI_LAYO_SIZE | ||||
LAYO_CMPST_SIZE | Standard Size in Percent for Components Display | PPELUI_LAYO_SIZE_CMPST | INT1 | 3 | PPELUI_LAYO_SIZE | ||||
LAYO_ACTHD_SIZE | Standard Size in Percent for Routing Header Display | PPELUI_LAYO_SIZE_ACTHD | INT1 | 3 | PPELUI_LAYO_SIZE | ||||
LAYO_ACTST_SIZE | Standard Size in Percent for Routing Display | PPELUI_LAYO_SIZE_ACTST | INT1 | 3 | PPELUI_LAYO_SIZE | ||||
DIA_C_CREATION | Behavior When Creating Product Structure | PPELUI_DIA_CREA | CHAR | 1 | PPELUI_DIA_CREA | ||||
USE_WORKLIST | Worklist Allowed | PPELUI_USE_WORKLIST | CHAR | 1 | XFELD | ||||
USE_FILTER | Filter by Date Validity Possible | PPELUI_USE_FILTER | CHAR | 1 | XFELD | ||||
USE_ECM | Engineering Change Management Usable | PPELUI_USE_ECM | CHAR | 1 | XFELD | ||||
USE_EDE_CMP | Object Dependency Usable for Product Structure | PPELUI_USE_EDE_CMP | CHAR | 1 | XFELD | ||||
USE_EDE_ACT | Object Dependency Usable for Process Structure | PPELUI_USE_EDE_ACT | CHAR | 1 | XFELD | ||||
USE_CLS_CMP | Classification Usable for Product Structure | PPELUI_USE_CLS_CMP | CHAR | 1 | XFELD | ||||
USE_CLS_ACT | Classification Usable for Process Structure | PPELUI_USE_CLS_ACT | CHAR | 1 | XFELD | ||||
VAL_LOCEXT | Character field of length 40 | CHAR40 | CHAR | 40 | CHAR40 | ||||
VAL_LOCEXT_ACT | Use of Value for Location | PPELUI_VAL_ACTVT_LOCEXT | CHAR | 1 | PPELUI_ACTIVITY | ||||
VAL_H_USAGE | Usage in iPPE | PPE_USE | CHAR | 3 | Assigned to domain | PPE_USE | PPE_USE | ||
VAL_H_USAGE_ACT | Use of Value for iPPE Usage | PPELUI_VAL_ACTVT_USAGE | CHAR | 1 | PPELUI_ACTIVITY | ||||
VAL_COPY | Copy Production Versions | PPELUI_VAL_COPY | CHAR | 1 | PPELUI_VAL_COPY | ||||
VAL_COPY_ACT | Use of Value for Copy Option | PPELUI_VAL_ACTVT_COPY | CHAR | 1 | PPELUI_ACTIVITY | ||||
VAL_CLASS | Class | PPE_KLASSE | CHAR | 18 | KLASSE | KLA_AT | PVS_CLASS02 | ||
VAL_CLASSTYPE | Class Type | PPE_KLASSENART | CHAR | 3 | Assigned to domain | KLASSENART | PPE_KAR | PVS_KLART01 | |
VAL_CLASS_ACT | Use of Value for Class and Class Type | PPELUI_VAL_ACTVT_CLASS | CHAR | 1 | PPELUI_ACTIVITY | ||||
VAL_A_TYPE | Type of iPPE Process Structure | PPE_PLANTYPE | CHAR | 1 | PPE_PLANTYPE | ||||
VAL_A_TYPE_ACT | Use of Value for Routing Type | PPELUI_VAL_ACTVT_PLANTYPE | CHAR | 1 | PPELUI_ACTIVITY | ||||
VAL_A_CTM | Use: CTM Planning | PPE_CTM_USE | CHAR | 1 | PPE_XFIELD | ||||
VAL_A_CTM_ACT | Value Handling for CTM Planning | PPELUI_VAL_ACTVT_CTM_USE | CHAR | 1 | PPELUI_ACTIVITY | ||||
VAL_A_TUOM | Time Unit | PPE_TIMEUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | PPE_TIMEUNIT | |
VAL_A_TUOM_ACT | Use of Value for Time Unit (Mode) | PPELUI_VAL_ACTVT_TIMEUNIT | CHAR | 1 | PPELUI_ACTIVITY | ||||
VAL_H_LOTS_MAX | Maximum Lot Size | PPE_LOSSBS | QUAN | 13(3) | MENG13 | ||||
VAL_H_LOTS_MIN | Minimum Lot Size | PPE_LOSSVN | QUAN | 13(3) | MENG13 | ||||
VAL_H_LOTS_UOM | Unit of Measure of Lot Size | PPELUI_VAL_LOTS_SIZE_UNIT | UNIT | 3 | Assigned to domain | CUNIT | PVS_QUNIT | ||
VAL_H_LOTS_ACT | Use of Values for Lot Sizes | PPELUI_VAL_ACTVT_LOTS_SIZE | CHAR | 1 | PPELUI_ACTIVITY | ||||
VAL_A_NOBRK | No Breaks | PPELUI_VAL_NO_BREAK | CHAR | 1 | XFELD | ||||
VAL_A_NOBRK_ACT | Use of Value for No Breaks | PPELUI_VAL_ACTVT_NO_BREAK | CHAR | 1 | PPELUI_ACTIVITY | ||||
VAL_A_BREAK | Duration of a Short Break During an Activity | PPE_MAX_BREAK | QUAN | 13(3) | MENG13 | ||||
VAL_A_BREAK_UOM | Unit for Short Break | PPE_MAX_BREAK_TUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | PPE_TIMEUNIT | |
VAL_A_BREAK_ACT | Use of Values for Maximum Break | PPELUI_VAL_ACTVT_MAX_BREAK | CHAR | 1 | PPELUI_ACTIVITY | ||||
VAL_A_PSHFT | Production Within a Shift | PPE_PROD_IN_SHIFT | CHAR | 1 | XFELD | ||||
VAL_A_PSHFT_ACT | Use of Value for Shift Production | PPELUI_VAL_ACTVT_PROD_IN_SHIFT | CHAR | 1 | PPELUI_ACTIVITY | ||||
VAL_H_PPRIO | Procurement Priority | PPE_PROCPRIO | DEC | 15(2) | DEC13_2 | ||||
VAL_H_PPRIO_ACT | Use of Value for Procurement Priority | PPELUI_VAL_ACTVT_PROCURE_PRIO | CHAR | 1 | PPELUI_ACTIVITY |
Key field | Non-key field |
How do I retrieve data from SAP table CLUIPROFILE using ABAP code
The following ABAP code Example will allow you to do a basic selection on CLUIPROFILE to SELECT all data from the tableDATA: WA_CLUIPROFILE TYPE CLUIPROFILE.
SELECT SINGLE *
FROM CLUIPROFILE
INTO CORRESPONDING FIELDS OF WA_CLUIPROFILE
WHERE...
How to access SAP table CLUIPROFILE
Within an ECC or HANA version of SAP you can also view further information about CLUIPROFILE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects