SAP ABAP Table CRMS_ICM_CMG_SEARCH (ICM CMG BOL advanced search structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IPS-ICM-CMG (Application Component) Cases and Leads
     ⤷ CRM_ICM_CMG_APP (Package) CRM ICM: Case Management - Application

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_ICM_CMG_SEARCH	Table Relationship Diagram
Short Description	ICM CMG BOL advanced search structure

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	CASE_GUID	☐	SCMG_CASE_GUID	SYSUUID_C	CHAR	32	0	Technical Case Key (Case GUID)
3	CASE_TYPE	☐	SCMGCASE_TYPE	SCMGCASE_TYPE	CHAR	4	0	Case Type	*
4	EXT_KEY	☐	SCMG_EXT_KEY	SCMG_EXT_KEY	CHAR	12	0	Case ID
5	CREATED_BY	☐	SCMG_CREATE_USER	XUBNAME	CHAR	12	0	Created By	*
6	CREATE_TIME	☐	SCMG_CREATE_TIME	SCMG_TIMESTAMP	DEC	15	0	Created On
7	CHANGED_BY	☐	SCMG_CHANGE_USER	XUBNAME	CHAR	12	0	Last Changed by	*
8	CHANGE_TIME	☐	SCMG_CHANGE_TIME	SCMG_TIMESTAMP	DEC	15	0	Last Changed On
9	CLOSED_BY	☐	SCMG_CLOSED_BY	XUBNAME	CHAR	12	0	Closed by User	*
10	CLOSING_TIME	☐	SCMG_CLOSING_TIME	SCMG_TIMESTAMP	DEC	15	0	Closed at Time
11	PLAN_END_DATE	☐	SCMG_PLAN_END_DATE	DATUM	DATS	8	0	Planned Close Date
12	ESCAL_REASON	☐	SCMG_ESCAL_REASON	CHAR2	CHAR	2	0	Reason for Escalation
13	PRIORITY	☐	SCMG_PRIORITY	NUM01	NUMC	1	0	Priority
14	STAT_ORDERNO	☐	SCMGSTATUSONR	SCMGSTATUSONR	NUMC	2	0	Case: Status
15	STAT_PARA	☐	SCMGSTATPARA	CHAR03	CHAR	3	0	Case: System Status
16	CREATE_DATE_FROM	☐	SCMG_CREATE_DATE	DATUM	DATS	8	0	Created On
17	CHANGE_DATE_FROM	☐	SCMG_CHANGE_DATE	DATUM	DATS	8	0	Date of Last Change
18	CLOSING_DATE_FROM	☐	SCMG_CLOSING_DATA	DATUM	DATS	8	0	Closed On
19	PROCESS	☐	SCMGPROCESS	SCMGPROCESS	CHAR	4	0	Permitted Process for Case Type	*
20	CREATE_DATE_TO	☐	CRMD_CMG_CREATE_DATE_TO	DATUM	DATS	8	0	CRM Case Management: Creation Date To
21	CHANGE_DATE_TO	☐	CRMD_CMG_CHANGE_DATE_TO	DATUM	DATS	8	0	CRM Case Management: Change Date To
22	CLOSING_DATE_TO	☐	SCMG_CLOSING_DATA	DATUM	DATS	8	0	Closed On
23	DATE_RANGE	☐	CRMT_DAT_RANGE	CRMT_DATE_RANGE	CHAR	5	0	Time Frame
24	START_DATE	☐	CRM_ICM_CMG_START_DATE	DATUM	DATS	8	0	ICM Case & Lead Start Date
25	END_DATE	☐	CRM_ICM_CMG_END_DATE	DATUM	DATS	8	0	ICM Case & Lead End Date
26	START_CRIME	☐	CRM_ICM_CMG_START_CRIME_DATE	DATUM	DATS	8	0	ICM Case & Lead Start Date of Crime
27	END_CRIME	☐	CRM_ICM_CMG_END_CRIME_DATE	DATUM	DATS	8	0	ICM Case & Lead End Date of Crime
28	SUMMARY	☐	CRM_ICM_CMG_SUMMARY		STRG	0	0	ICM Case & Lead Summary
29	EXPUNGE_DATE	☐	CRM_ICM_CMG_EXPUNGE_DATE	DATUM	DATS	8	0	Expunge Date
30	.INCLUDE	☐				0	0	Include for CRM-Specific Case Attributes(SAP, IBU and Cust.)
31	CRM_CASE_TITLE	☐	CRMT_CMG_CASE_TITLE_UPPER	CHAR80	CHAR	80	0	Text Without Upper/Lower Case
32	CRM_SCH_REF_TIME	☐	CRMT_CMG_SCH_REF_TSTMP	CMG_TIMESTAMP	DEC	15	0	Schema Reference Timestamp - Categories
33	CRM_BUS_REF_TIME	☐	CRMT_CMG_REF_TSTMP	CMG_TIMESTAMP	DEC	15	0	Business Reference Timestamp - Categories
34	CRM_SCHEMA_ID	☐	CRMT_CMG_SCH_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	CRM Case Management - Schema ID
35	CRM_CATEGORY_ID	☐	CRMT_CMG_CAT_ID	CRM_ERMS_CAT_CA_ID_DO	CHAR	40	0	CRM Case Management - Reference Category ID
36	.INCLUDE	☐				0	0
37	.INCLUDE	☐				0	0
38	.INCLUDE	☐				0	0
39	.INCLUDE	☐				0	0
40	.INCLUDE	☐				0	0
41	.INCLUDE	☐				0	0
42	.INCLUDE	☐				0	0	FS-Specific Case Attributes
43	PROD_CAT_ID	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
44	CATEGORY_TEXT	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
45	.INCLUDE	☐				0	0	Include for Customer Includes used by Standard Case
46	CMG_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
47	.INCLUDE	☐				0	0
48	.INCLUDE	☐				0	0
49	.INCLUDE	☐				0	0	ICM Combined Search Attributes
50	LOCATION_COMB	☐	CRM_ICM_IL_REL_LOC_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Locations
51	CASE_COMB	☐	CRM_ICM_IL_REL_CMG_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Cases
52	LEAD_COMB	☐	CRM_ICM_IL_REL_LEAD_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Leads
53	INCIDENT_COMB	☐	CRM_ICM_IL_REL_INC_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Incidents
54	BP_COMB	☐	CRM_ICM_IL_REL_BP_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Business Partners
55	OBJECT_COMB	☐	CRM_ICM_IL_REL_OBJ_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Objects
56	OPERATION_COMB	☐	CRM_ICM_IL_REL_ACT_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Activities
57	STAFF_UNITS_COMB	☐	CRM_ICM_IL_REL_SFU_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search Field for Staff and Units
58	REL_TYPE_ID	☐	CRM_ICM_REL_TYPE_ID		CHAR	4	0	CRM ICM Relationship Type ID
59	REL_VALID_FROM	☐	CRM_ICM_REL_DATE	SYDATS	DATS	8	0	ICM Relationship: Dates
60	REL_VALID_TO	☐	CRM_ICM_REL_DATE	SYDATS	DATS	8	0	ICM Relationship: Dates
61	RESP_EMP_NO	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
62	RESP_GROUP_NO	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
63	RESP_ORG_NO	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
64	PARENT_CASE_ID	☐	SCMG_EXT_KEY	SCMG_EXT_KEY	CHAR	12	0	Case ID
65	CRM_INCL_SUBCATEGORIES	☐	CRMT_CMG_INCL_SUBCATEGORIES	CRM_BOOLEAN	CHAR	1	0	Case Search Including Subcategories
66	EXT_REF	☐	SCMG_EXT_REF	CHAR30	CHAR	30	0	External reference
67	PARENT_CASE_GUID	☐	SCMG_CASE_GUID	SYSUUID_C	CHAR	32	0	Technical Case Key (Case GUID)
68	.INCLUDE	☐				0	0	Include for Customer Includes used by Standard Case
69	ICM_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
70	MY_WORKLIST	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable

History

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