SAP ABAP Table CRMT_BSP_ERMS_WORKBENCH_SEARCH (Workbench Search Criteria)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IC-EMS (Application Component) E-Mail Response Management System
     ⤷ CRM_ERMS_WORKBENCH (Package) ERMS Workbench

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_ERMS_WORKBENCH_SEARCH	Table Relationship Diagram
Short Description	Workbench Search Criteria

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

Foreign Keys

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

History

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