In this post, I will try and describe everything you need to know about the SAP crmd_ei_log_cmp table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_EI_LOG_CMP what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_EI_LOG_CMP....Right lets get started!
Object Name: CRMD_EI_LOG_CMP
Dictionary Type: Transparent table
Description: EI: Log for knowledge base compilation
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | |||||
| KB_NAME | CRMT_EI_KB_NAME | CHAR | 30(0) | * | Name of Knowledge Base | CRMT_EI_KB_NAME | ||||||
| LANG | SPRAS | LANG | 1(0) | * | Language Key | SPRAS | SPR | SAP | H_T002 | SPRAS | ||
| GUID | CRMT_EI_GUID | RAW | 16(0) | SAF - GUID | SYSUUID | |||||||
| INDEX_NAME | CRMT_EI_INDEX_NAME | CHAR | 32(0) | SAF: Search index name | CRM_EI_INDEX_NAME | |||||||
| FCMP_START_TIME | TIMESTAMP | DEC | 15(0) | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |||||||
| FCMP_END_TIME | TIMESTAMP | DEC | 15(0) | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |||||||
| FCMP_DOC_CNT | CRMT_EI_NUMBER | INT4 | 10(0) | SAF - Numbers | CRM_EI_NUMBER | |||||||
| FCMP_LAST_KB_ID | CRMT_EI_KB_ID | CHAR | 50(0) | Knowledge Base Entity ID | CRM_EI_KB_ID | |||||||
| FCMP_RESP_USR | CRMT_EI_USER | CHAR | 12(0) | SAF - User | USNAM | |||||||
| FCMP_COMPLETED | CRMT_EI_STATUS | CHAR | 1(0) | SAF - Status String | CRM_EI_STATUS | |||||||
| CLU_START_TIME | TIMESTAMP | DEC | 15(0) | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |||||||
| CLU_END_TIME | TIMESTAMP | DEC | 15(0) | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |||||||
| CLU_RESP_USR | CRMT_EI_USER | CHAR | 12(0) | SAF - User | USNAM | |||||||
| CLU_COMPLETED | CRMT_EI_STATUS | CHAR | 1(0) | SAF - Status String | CRM_EI_STATUS | |||||||
| CLU_NO | CRMT_EI_NUMBER | INT4 | 10(0) | SAF - Numbers | CRM_EI_NUMBER | |||||||
| CLU_DOC_CNT | CRMT_EI_NUMBER | INT4 | 10(0) | SAF - Numbers | CRM_EI_NUMBER | |||||||
| ACMP_START_TIME | TIMESTAMP | DEC | 15(0) | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |||||||
| ACMP_END_TIME | TIMESTAMP | DEC | 15(0) | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |||||||
| ACMP_COMPLETED | CRMT_EI_STATUS | CHAR | 1(0) | SAF - Status String | CRM_EI_STATUS | |||||||
| ACMP_DOC_NEW | CRMT_EI_NUMBER | INT4 | 10(0) | SAF - Numbers | CRM_EI_NUMBER | |||||||
| ACMP_DOC_UPDATE | CRMT_EI_NUMBER | INT4 | 10(0) | SAF - Numbers | CRM_EI_NUMBER | |||||||
| ACMP_DOC_DELETE | CRMT_EI_NUMBER | INT4 | 10(0) | SAF - Numbers | CRM_EI_NUMBER | |||||||
| ACMP_RESP_USR | CRMT_EI_USER | CHAR | 12(0) | SAF - User | USNAM | |||||||
| FCMP_QUEUE_SYNC | TIMESTAMP | DEC | 15(0) | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |||||||
| ACMP_QUEUE_SYNC | TIMESTAMP | DEC | 15(0) | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |||||||
| FCMP_ERROR | CRMT_EI_CMP_ERROR | INT4 | 10(0) | SAF - Compilation Error | CRM_EI_CMP_ERROR | |||||||
| ACMP_ERROR | CRMT_EI_CMP_ERROR | INT4 | 10(0) | SAF - Compilation Error | CRM_EI_CMP_ERROR | |||||||
| CLU_ERROR | CRMT_EI_CMP_ERROR | INT4 | 10(0) | SAF - Compilation Error | CRM_EI_CMP_ERROR | |||||||
| DELTA_CNT | CRMT_EI_NUMBER | INT4 | 10(0) | SAF - Numbers | CRM_EI_NUMBER | |||||||
| DEL_RESP_USR | CRMT_EI_USER | CHAR | 12(0) | SAF - User | USNAM | |||||||
| DELETED | BOOLEAN | CHAR | 1(0) | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | KA | ||||||
| ACMP_B_STARTED | BOOLEAN | CHAR | 1(0) | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | KA | ||||||
| CLU_B_STARTED | BOOLEAN | CHAR | 1(0) | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | KA | ||||||
| FCMP_B_STARTED | BOOLEAN | CHAR | 1(0) | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | KA | ||||||
| CREATE_ERROR | CRMT_EI_CMP_ERROR | INT4 | 10(0) | SAF - Compilation Error | CRM_EI_CMP_ERROR | |||||||
| DELETE_ERROR | CRMT_EI_CMP_ERROR | INT4 | 10(0) | SAF - Compilation Error | CRM_EI_CMP_ERROR | |||||||
| FCMP_ERROR_TXT | CRMT_EI_ERROR_TEXT | CHAR | 100(0) | Error Text | CRM_EI_ERROR_TEXT | |||||||
| ACMP_ERROR_TXT | CRMT_EI_ERROR_TEXT | CHAR | 100(0) | Error Text | CRM_EI_ERROR_TEXT | |||||||
| CLU_ERROR_TXT | CRMT_EI_ERROR_TEXT | CHAR | 100(0) | Error Text | CRM_EI_ERROR_TEXT | |||||||
| CREATE_ERROR_TXT | CRMT_EI_ERROR_TEXT | CHAR | 100(0) | Error Text | CRM_EI_ERROR_TEXT | |||||||
| DELETE_ERROR_TXT | CRMT_EI_ERROR_TEXT | CHAR | 100(0) | Error Text | CRM_EI_ERROR_TEXT |