CRMD_ERMS_HEADER - Statistical data header
Statistical data header information is stored in SAP table CRMD_ERMS_HEADER.
It is part of development package CRM_ERMS_REPORTING in software component CRM-IC-EMS-MON. This development package consists of objects that can be grouped under "CRM_ERMS_REPORTING".
It is part of development package CRM_ERMS_REPORTING in software component CRM-IC-EMS-MON. This development package consists of objects that can be grouped under "CRM_ERMS_REPORTING".
Fields for table CRMD_ERMS_HEADER
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| CON_ID | E-Mail ID for E-Mail Response Management System (ERMS) | X | CRMT_ERMS_CONNECTION_ID | CHAR | 68 | |
| CON_DIRECT | Connection Direction | CRMT_ERMS_CONNECTION_DIR | CHAR | 2 | ||
| EXT_ADDR | Address | CRMT_ERMS_ADDRESS | CHAR | 482 | ||
| INT_ADDR | Address | CRMT_ERMS_ADDRESS | CHAR | 482 | ||
| START_TMSP | UTC Timestamp (YYYYMMDDhhmmss) | CRMT_ERMS_TIMESTAMP | DEC | 8 | ||
| CREATE_ON | Created On Date | CRMT_ERMS_CREATED_ON | DATS | 16 | ||
| CHANGE_ON | Last Changed On | CRMT_ERMS_CHANGED_ON | DATS | 16 | ||
| STATUS | E-Mail Status | CRMT_ERMS_STATUS | CHAR | 6 | ||
| ORG_UNIT | Organizational Unit | CRMT_ERMS_ORG | CHAR | 20 | ||
| HANDLING_TIME | Duration | CRMT_ERMS_DURATION | DEC | 7 | ||
| RESPONSE_TIME | Duration | CRMT_ERMS_DURATION | DEC | 7 | ||
| IN_SL | In Service Level | CRMT_ERMS_IN_SL | INT4 | 4 | ||
| WEBFORM_ID | Web Form ID | CRMT_ERMS_WEBFORM_ID | CHAR | 60 | ||
| EMAIL_TYPE | Communication Type | CRMT_ERMS_COMMUNICATION_TYPE | CHAR | 2 | ||
| FINAL | Final | CRMT_ERMS_FINAL | CHAR | 2 | ||
| BW_EXTRACT | BW Extraction Flag | CRMT_ERMS_EXTRACT | CHAR | 2 | ||
| WORKITEM_ID | Work item ID | SWW_WIID | NUMC | 24 | ||
| ESCALATION_TYPE | Escalation Type | CRMT_ERMS_ESCAL_TYPE | CHAR | 2 | ||
| ESCALATION_TIME | Escalation Time | CRMT_ERMS_ESCAL_TIME | DEC | 8 | ||
| ESC_TIME_IN_HRS | Escalation Time stamp (hours since Jan, 01 00:00) | CRMT_ERMS_ESC_TIME_HRS_2000 | DEC | 7 | ||
| RESP_AGENT | Responsible Agent | CRMT_ERMS_AGENT | CHAR | 20 | ||
| CMS_ID | Interaction Center ID | CRMT_IC_MDB_CCID | CHAR | 64 | ||
| TOBE_DELETED | To Be Deleted | CRMT_ERMS_DELETE | CHAR | 2 |