SAP Table CRMD_ERMS_HEADER stores Statistical data headerdata

  

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!


SAP CRMD_ERMS_HEADER dictionary attributes

Object Name: CRMD_ERMS_HEADER
Dictionary Type: Transparent table
Description: Statistical data header


CRMD_ERMS_HEADER field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) *ClientMANDTTESTCRM
CON_IDCRMT_ERMS_CONNECTION_IDCHAR34(0) E-Mail ID for E-Mail Response Management System (ERMS)CRM_ERMS_CONNECTION_IDCRM
CON_DIRECTCRMT_ERMS_CONNECTION_DIRCHAR1(0) Connection DirectionCRM_ERMS_CONNECTION_DIRCRM
EXT_ADDRCRMT_ERMS_ADDRESSCHAR241(0) AddressCRM_ERMS_ADDRESSCRM
INT_ADDRCRMT_ERMS_ADDRESSCHAR241(0) AddressCRM_ERMS_ADDRESSCRM
START_TMSPCRMT_ERMS_TIMESTAMPDEC15(0) UTC Timestamp (YYYYMMDDhhmmss)CRM_ERMS_TIMESTAMPCRM
CREATE_ONCRMT_ERMS_CREATED_ONDATS8(0) Created On DateDATSCRM
CHANGE_ONCRMT_ERMS_CHANGED_ONDATS8(0) Last Changed OnDATSCRM
STATUSCRMT_ERMS_STATUSCHAR3(0) *E-Mail StatusCRM_ERMS_STATUSCRM
ORG_UNITCRMT_ERMS_ORGCHAR10(0) *Organizational UnitBU_PARTNERCRM
HANDLING_TIMECRMT_ERMS_DURATIONDEC13(0) DurationCRM_ERMS_DURATIONCRM
RESPONSE_TIMECRMT_ERMS_DURATIONDEC13(0) DurationCRM_ERMS_DURATIONCRM
IN_SLCRMT_ERMS_IN_SLINT410(0) In Service LevelCRM_ERMS_IN_SLCRM
WEBFORM_IDCRMT_ERMS_WEBFORM_IDCHAR30(0) Web Form IDCRM_ERMS_WEBFORM_IDCRM
EMAIL_TYPECRMT_ERMS_COMMUNICATION_TYPECHAR1(0) Communication TypeCRM_ERMS_COMMUNICATION_TYPECRM
FINALCRMT_ERMS_FINALCHAR1(0) Final FlagCRM_ERMS_FLAGCRM
BW_EXTRACTCRMT_ERMS_EXTRACTCHAR1(0) BW Extraction FlagCRM_ERMS_FLAGCRM
WORKITEM_IDSWW_WIIDNUMC12(0) *Work item IDSWW_WIIDWIDCRM
ESCALATION_TYPECRMT_ERMS_ESCAL_TYPECHAR1(0) Escalation TypeCRMT_ERMS_ESCAL_TYPECRM
ESCALATION_TIMECRMT_ERMS_ESCAL_TIMEDEC15(0) Escalation TimeCRM_ERMS_TIMESTAMPCRM
ESC_TIME_IN_HRSCRMT_ERMS_ESC_TIME_HRS_2000DEC13(2) Escalation Time stamp (hours since Jan, 01 00:00)CRMT_ERMS_ESC_TIME_HRS_2000CRM
RESP_AGENTCRMT_ERMS_AGENTCHAR10(0) Responsible AgentCRMT_ERMS_AGENTCRM


View list of all tables