In this post, I will try and describe everything you need to know about the SAP crmd_erms_header 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_ERMS_HEADER 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_ERMS_HEADER....Right lets get started!
Object Name: CRMD_ERMS_HEADER
Dictionary Type: Transparent table
Description: Statistical data header
Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
MANDT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
CON_ID | CRMT_ERMS_CONNECTION_ID | CHAR | 34(0) | E-Mail ID for E-Mail Response Management System (ERMS) | CRM_ERMS_CONNECTION_ID | CRM | ||||||
CON_DIRECT | CRMT_ERMS_CONNECTION_DIR | CHAR | 1(0) | Connection Direction | CRM_ERMS_CONNECTION_DIR | CRM | ||||||
EXT_ADDR | CRMT_ERMS_ADDRESS | CHAR | 241(0) | Address | CRM_ERMS_ADDRESS | CRM | ||||||
INT_ADDR | CRMT_ERMS_ADDRESS | CHAR | 241(0) | Address | CRM_ERMS_ADDRESS | CRM | ||||||
START_TMSP | CRMT_ERMS_TIMESTAMP | DEC | 15(0) | UTC Timestamp (YYYYMMDDhhmmss) | CRM_ERMS_TIMESTAMP | CRM | ||||||
CREATE_ON | CRMT_ERMS_CREATED_ON | DATS | 8(0) | Created On Date | DATS | CRM | ||||||
CHANGE_ON | CRMT_ERMS_CHANGED_ON | DATS | 8(0) | Last Changed On | DATS | CRM | ||||||
STATUS | CRMT_ERMS_STATUS | CHAR | 3(0) | * | E-Mail Status | CRM_ERMS_STATUS | CRM | |||||
ORG_UNIT | CRMT_ERMS_ORG | CHAR | 10(0) | * | Organizational Unit | BU_PARTNER | CRM | |||||
HANDLING_TIME | CRMT_ERMS_DURATION | DEC | 13(0) | Duration | CRM_ERMS_DURATION | CRM | ||||||
RESPONSE_TIME | CRMT_ERMS_DURATION | DEC | 13(0) | Duration | CRM_ERMS_DURATION | CRM | ||||||
IN_SL | CRMT_ERMS_IN_SL | INT4 | 10(0) | In Service Level | CRM_ERMS_IN_SL | CRM | ||||||
WEBFORM_ID | CRMT_ERMS_WEBFORM_ID | CHAR | 30(0) | Web Form ID | CRM_ERMS_WEBFORM_ID | CRM | ||||||
EMAIL_TYPE | CRMT_ERMS_COMMUNICATION_TYPE | CHAR | 1(0) | Communication Type | CRM_ERMS_COMMUNICATION_TYPE | CRM | ||||||
FINAL | CRMT_ERMS_FINAL | CHAR | 1(0) | Final Flag | CRM_ERMS_FLAG | CRM | ||||||
BW_EXTRACT | CRMT_ERMS_EXTRACT | CHAR | 1(0) | BW Extraction Flag | CRM_ERMS_FLAG | CRM | ||||||
WORKITEM_ID | SWW_WIID | NUMC | 12(0) | * | Work item ID | SWW_WIID | WID | CRM | ||||
ESCALATION_TYPE | CRMT_ERMS_ESCAL_TYPE | CHAR | 1(0) | Escalation Type | CRMT_ERMS_ESCAL_TYPE | CRM | ||||||
ESCALATION_TIME | CRMT_ERMS_ESCAL_TIME | DEC | 15(0) | Escalation Time | CRM_ERMS_TIMESTAMP | CRM | ||||||
ESC_TIME_IN_HRS | CRMT_ERMS_ESC_TIME_HRS_2000 | DEC | 13(2) | Escalation Time stamp (hours since Jan, 01 00:00) | CRMT_ERMS_ESC_TIME_HRS_2000 | CRM | ||||||
RESP_AGENT | CRMT_ERMS_AGENT | CHAR | 10(0) | Responsible Agent | CRMT_ERMS_AGENT | CRM |