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 |