MPE_USER_CERT - Certificates assigned to User
Certificates assigned to User information is stored in SAP table MPE_USER_CERT.
It is part of development package MPE_USER_GROUP in software component PP-PEO-CER. This development package consists of objects that can be grouped under "Manufacturing Plan & Exec - Manufacturing User Group".
It is part of development package MPE_USER_GROUP in software component PP-PEO-CER. This development package consists of objects that can be grouped under "Manufacturing Plan & Exec - Manufacturing User Group".
Fields for table MPE_USER_CERT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | Client | X | MANDT | CLNT | 6 | |
| PARTNER | Business Partner | X | MPE_USER_ID | CHAR | 20 | MPE_USER_PROFILE |
| CERTIFICATEID | Certification | X | MPE_CER_CERID | CHAR | 100 | MPE_CER |
| ASSIGNMENTDATE | Certificate Assignment Date | MPE_CER_DATE | DATS | 16 | ||
| EXPIRATIONDATE | Certificate Expiration Date | MPE_CER_EXP_DATE | DATS | 16 | ||
| SKILLLEVEL | Certification Skill Level | MPE_CER_SL | INT1 | 1 | ||
| TRAININGREQUIRED | Training Only Authorization | MPE_CER_TRAINING | CHAR | 2 | ||
| ASSIGNMENTSTATUS | Certification Assignment Status | MPE_CER_STATUS | CHAR | 2 | ||
| .INCLUDE | MPE_ADMIN_DATA | 0 | ||||
| .INCLUDE | ADMIN_DATA_CREATED | MPE_ADMIN_DATA_CREATE | 0 | |||
| CREATED_BY | Created By | MPE_CREATE_USER | CHAR | 24 | ||
| CREATED_AT | Date and Time of Creation | MPE_CREATE_TIMESTAMP | DEC | 8 | ||
| .INCLUDE | ADMIN_DATA_CHANGED | MPE_ADMIN_DATA_LCHANGE | 0 | |||
| CHANGED_BY | Changed By | MPE_LCHANGE_USER | CHAR | 24 | ||
| CHANGED_AT | MPE Last Change Timestamp | MPE_LCHANGE_TIMESTAMP | DEC | 8 |