In this post, I will try and describe everything you need to know about the SAP crmd_tm_iact 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_TM_IACT 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_TM_IACT....Right lets get started!
Object Name: CRMD_TM_IACT
Dictionary Type: Transparent table
Description: Calls
| 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) | T000 | Client | MANDT | TEST | CRM | ||||
| PID | CRMT_CLM_CALL_ID | RAW | 16(0) | Call id | CRM_CLM_CALL_ID | CRM | ||||||
| CL_PID | CRMT_CLM_CALL_LIST_ID | RAW | 16(0) | Call list id | CRM_CLM_CALL_LIST_ID | CRM_CLM_CALL_LIST | PID | CRM | ||||
| LOCK_STATE | CRMT_CLM_CALL_STATE | CHAR | 1(0) | Call State | CRM_CLM_CALL_STATE | CRM | ||||||
| PRIORITY | CRMT_CLM_CALL_PRIORITY | INT4 | 10(0) | Call priority | CRM | |||||||
| STATE | CRMT_CLM_STATE | CHAR | 1(0) | Object state | CRM | |||||||
| LOCK_OWNER | CRMT_TM_USERID | CHAR | 12(0) | CLM: User ID | CHAR12 | CRM | ||||||
| REFS | UUID | RAW | 16(0) | Global Unique ID for table | UUID | CRM | ||||||
| ATTEMPTS | NUMC2 | NUMC | 2(0) | Two digit number | NUMC2 | CRM | ||||||
| HARDWARE_OUTCOME | CRMT_CLM_CALL_RESULT | CHAR | 1(0) | * | Call result | CRM_CLM_CALL_RESULT | CRM_CLM_CALL_RESULT | ID | CRM | |||
| NEXT_PID | CRMT_CLM_CALL_ID | RAW | 16(0) | Call id | CRM_CLM_CALL_ID | CRM | ||||||
| PREVIOUS_PID | CRMT_CLM_CALL_ID | RAW | 16(0) | Call id | CRM_CLM_CALL_ID | CRM | ||||||
| FLAGS | CRMT_CLM_FLAGS | RAW | 4(0) | Indicators | CRM | |||||||
| CALL_TIME | CRMT_CLM_CALL_TIME | DEC | 15(0) | Call Time | CRM_CLM_TIMESTAMP | CRM | ||||||
| DURATION | CRMT_CLM_CALL_DURATION_ACTUAL | TIMS | 6(0) | Call actual duration | CRM | |||||||
| ATTEMPTS_MAX | CRMT_CLM_ATTEMPTS_MAX | INT2 | 5(0) | Maximum number of attempts | CRM | |||||||
| PROC_TIME_EXP | CRMT_CLM_PROC_TIME_EXPECTED | TIMS | 6(0) | Expected processing time | CRM | |||||||
| PROC_TIME_MAX | CRMT_CLM_PROC_TIME_MAX | TIMS | 6(0) | Maximum processing time | CRM | |||||||
| START_ON | CRMT_CLM_CALL_START_ON | DEC | 15(0) | Execution start date and time for calls | CRM_CLM_TIMESTAMP | CRM_CLM_TIMESTAMP | VALUE | CRM | ||||
| STOP_ON | CRMT_CLM_CALL_STOP_ON | DEC | 15(0) | Execution stop date and time for calls | CRM_CLM_TIMESTAMP | CRM_CLM_TIMESTAMP | VALUE | CRM | ||||
| COMPLETE_BY | CRMT_CLM_CALL_COMPLETE_BY | DEC | 15(0) | Execution complete by date and time for calls | CRM_CLM_TIMESTAMP | CRM_CLM_TIMESTAMP | VALUE | CRM | ||||
| RESCHEDULED | CRMT_CLM_CALL_RESCHEDULED | CHAR | 1(0) | Call rescheduling flag | CRM_BOOLEAN | CRM | ||||||
| COMPLETED_ON | CRMT_CLM_CALL_COMPLETED_ON | DEC | 15(0) | Call completion date and time | CRM_CLM_TIMESTAMP | CRM_CLM_TIMESTAMP | VALUE | CRM | ||||
| DURATION_SECONDS | CRMT_CLM_TIME_SECONDS | DEC | 10(0) | Time in seconds | CRM_CLM_TIME_SECONDS | CRM | ||||||
| PROCESSED_ON | CRMT_CLM_CALL_PROCESSED_ON | DEC | 15(0) | Date and time a call was processed last time | CRM_CLM_TIMESTAMP | CRM | ||||||
| DURATION_AVERAGE | CRMT_CLM_CALL_DURATION_AVG | TIMS | 6(0) | Average call duration | CRM | |||||||
| DURATION_MAX | CRMT_CLM_CALL_DURATION_MAX | TIMS | 6(0) | Maximum call duration | CRM | |||||||
| DURATION_MIN | CRMT_CLM_CALL_DURATION_MIN | TIMS | 6(0) | Minimum call duration | CRM | |||||||
| DURATION_AVG_SEC | CRMT_CLM_TIME_SECONDS | DEC | 10(0) | Time in seconds | CRM_CLM_TIME_SECONDS | CRM | ||||||
| ORDER_NUMBER | CRMT_CLM_CALL_ORDER_NUMBER | INT4 | 10(0) | Call order number in a call list | CRM_CLM_CALL_ORDER_NUMBER | CRM | ||||||
| ADDRNUMBER | AD_ADDRNUM | CHAR | 10(0) | * | Address number | AD_ADDRNUM | ADR | CRM | ||||
| PERSNUMBER | AD_PERSNUM | CHAR | 10(0) | * | Person number | AD_PERSNUM | CDT | ADDRESS | PERSNUMBER | CRM |