SAP ABAP Table CRMT_EMWB_IL_EMAIL_SEARCH (Email WorkBench - Search Parameters)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IC-EMS (Application Component) E-Mail Response Management System
     ⤷ CRM_ERMS_EMAIL_IL (Package) ERMS email interaction layer

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_EMWB_IL_EMAIL_SEARCH	Table Relationship Diagram
Short Description	Email WorkBench - Search Parameters

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Workbench Search Criteria
2	.INCLUDE	☐				0	0	Workbench Search Criteria
3	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
4	EXT_ADDR	☐	CRMT_ERMS_EMAIL_FROM	CRM_ERMS_ADDRESS	CHAR	241	0	From
5	INT_ADDR	☐	CRMT_ERMS_EMAIL_TO	CRM_ERMS_ADDRESS	CHAR	241	0	To
6	CREATE_FROM	☐	CRMT_ERMS_DATE_FROM	DATS	DATS	8	0	From Date
7	CREATE_TO	☐	CRMT_ERMS_DATE_TO	DATS	DATS	8	0	To Date
8	CHANGE_ON	☐	CRMT_ERMS_CHANGED_ON	DATS	DATS	8	0	Last Changed On
9	STATUS	☐	CRMT_ERMS_STATUS	CRM_ERMS_STATUS	CHAR	3	0	E-Mail Status	CRMD_ERMS_STATUS
10	ORG_UNIT	☐	CRMT_ERMS_ORG	BU_PARTNER	CHAR	10	0	Organizational Unit	*
11	WEBFORM_ID	☐	CRMT_ERMS_WEBFORM_ID	CRM_ERMS_WEBFORM_ID	CHAR	30	0	Web Form ID
12	DOC_COUNT	☐	CRMT_ERMS_MATCH_COUNT	CRMT_ERMS_MATCH_COUNT	INT4	10	0	Number of Matching Documents
13	EVENT	☐	CRMT_ERMS_EVENT	CRM_ERMS_EVENT	CHAR	3	0	E-Mail Event
14	RESP_AGENT	☐	CRMT_ERMS_AGENT	CRMT_ERMS_AGENT	CHAR	10	0	Responsible Agent
15	EVENT_TMSP	☐	CRMT_ERMS_TIMESTAMP	CRM_ERMS_TIMESTAMP	DEC	15	0	UTC Timestamp (YYYYMMDDhhmmss)
16	CASE_NUMBER	☐	CRMT_ERMS_CASE_ID	SCMG_EXT_KEY	CHAR	12	0	Case ID
17	ORDER_NUMBER	☐	CRMT_ERMS_SERVICE_ID	CRM_OBJECT_ID	CHAR	10	0	Service ID
18	CATEGORY_ID	☐	CRM_ERMS_CAT_GUID	SYSUUID	RAW	16	0	Multilevel Cat. - GUID Data Element
19	RULE_ID	☐	CRM_ERMS_RULEID	SYSUUID	RAW	16	0	Rule ID
20	ORGUNIT_TYPE_O	☐	CRMT_ERMS_ORGUNIT_TYPE		CHAR	2	0	Organizational Unit Type
21	ORGUNIT_TYPE_US	☐	CRMT_ERMS_ORGUNIT_TYPE		CHAR	2	0	Organizational Unit Type
22	QUERY_STRING	☐	CRMT_ERMS_STRING		STRG	0	0	String
23	ORG_UNIT_TYPE	☐	CRMT_CLM_OM_OBJECT_TYPE	OTYPE	CHAR	2	0	Organizational management object type	*
24	ORG_UNIT_ID	☐	PD_OBJID_R	NUM08	NUMC	8	0	Object ID
25	ORG_UNIT_DESCR	☐	CRMT_CLM_OM_OBJECT_NAME	STRING	STRG	0	0	Organizational management object name
26	PROCESSOR_TYPE	☐	CRMT_CLM_OM_OBJECT_TYPE	OTYPE	CHAR	2	0	Organizational management object type	*
27	PROCESSOR_ID	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
28	PROCESSOR_DESCR	☐	CRMT_CLM_OM_OBJECT_NAME	STRING	STRG	0	0	Organizational management object name
29	FINAL	☐	CRMT_ERMS_FINAL	CRM_ERMS_FLAG	CHAR	1	0	Final
30	ESCALATION_TYPE	☐	CRMT_ERMS_ESCAL_TYPE	CRMT_ERMS_ESCAL_TYPE	CHAR	1	0	Escalation Type
31	ESCALATION_TIME	☐	CRMT_ERMS_ESCAL_TIME	CRM_ERMS_TIMESTAMP	DEC	15	0	Escalation Time
32	ESC_TIME_IN_HRS	☐	CRMT_ERMS_ESC_TIME_HRS_2000	CRMT_ERMS_ESC_TIME_HRS_2000	DEC	13	2	Escalation Time stamp (hours since Jan, 01 00:00)
33	RESP_AGENT_USER	☐	CRMT_ERMS_UNAME	UNAME	CHAR	12	0	Responsible Agent User ID
34	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_EMWB_IL_EMAIL_SEARCH	STATUS	CRMD_ERMS_STATUS	STATUS_ID

History

Last changed by/on	SAP	20110908
SAP Release Created in	510