SAP ABAP Table CRMS_ICM_CMG_SEARCH_COMB (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_COMB	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	CASE_TYPE	☐	SCMGCASE_TYPE	SCMGCASE_TYPE	CHAR	4	0	Case Type	*
2	STAT_ORDERNO	☐	SCMGSTATUSONR	SCMGSTATUSONR	NUMC	2	0	Case: Status
3	STAT_PARA	☐	SCMGSTATPARA	CHAR03	CHAR	3	0	Case: System Status
4	START_DATE	☐	CRM_ICM_CMG_START_TIMESTAMP	CMG_TIMESTAMP	DEC	15	0	ICM Case & Lead Start Timestamp
5	END_DATE	☐	CRM_ICM_CMG_END_TIMESTAMP	CMG_TIMESTAMP	DEC	15	0	ICM Case & Lead End Timestamp
6	START_CRIME	☐	CRM_ICM_CMG_START_CRIME_STAMP	CMG_TIMESTAMP	DEC	15	0	ICM Case & Lead Start Timestamp of Crime
7	END_CRIME	☐	CRM_ICM_CMG_END_CRIME_STAMP	CMG_TIMESTAMP	DEC	15	0	ICM Case & Lead End Timestamp of Crime
8	.INCLUDE	☐				0	0	Include for CRM-Specific Case Attributes(SAP, IBU and Cust.)
9	CRM_CASE_TITLE	☐	CRMT_CMG_CASE_TITLE_UPPER	CHAR80	CHAR	80	0	Text Without Upper/Lower Case
10	CRM_SCH_REF_TIME	☐	CRMT_CMG_SCH_REF_TSTMP	CMG_TIMESTAMP	DEC	15	0	Schema Reference Timestamp - Categories
11	CRM_BUS_REF_TIME	☐	CRMT_CMG_REF_TSTMP	CMG_TIMESTAMP	DEC	15	0	Business Reference Timestamp - Categories
12	CRM_SCHEMA_ID	☐	CRMT_CMG_SCH_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	CRM Case Management - Schema ID
13	CRM_CATEGORY_ID	☐	CRMT_CMG_CAT_ID	CRM_ERMS_CAT_CA_ID_DO	CHAR	40	0	CRM Case Management - Reference Category ID
14	.INCLUDE	☐				0	0
15	.INCLUDE	☐				0	0
16	.INCLUDE	☐				0	0
17	.INCLUDE	☐				0	0
18	.INCLUDE	☐				0	0
19	.INCLUDE	☐				0	0
20	.INCLUDE	☐				0	0	FS-Specific Case Attributes
21	PROD_CAT_ID	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
22	CATEGORY_TEXT	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
23	.INCLUDE	☐				0	0	Include for Customer Includes used by Standard Case
24	CMG_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
25	.INCLUDE	☐				0	0
26	.INCLUDE	☐				0	0
27	.INCLUDE	☐				0	0	ICM Combined Search Attributes
28	LOCATION_COMB	☐	CRM_ICM_IL_REL_LOC_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Locations
29	CASE_COMB	☐	CRM_ICM_IL_REL_CMG_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Cases
30	LEAD_COMB	☐	CRM_ICM_IL_REL_LEAD_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Leads
31	INCIDENT_COMB	☐	CRM_ICM_IL_REL_INC_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Incidents
32	BP_COMB	☐	CRM_ICM_IL_REL_BP_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Business Partners
33	OBJECT_COMB	☐	CRM_ICM_IL_REL_OBJ_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Objects
34	OPERATION_COMB	☐	CRM_ICM_IL_REL_ACT_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Activities
35	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
36	REL_TYPE_ID	☐	CRM_ICM_REL_TYPE_ID		CHAR	4	0	CRM ICM Relationship Type ID
37	REL_VALID_FROM	☐	CRM_ICM_REL_DATE	SYDATS	DATS	8	0	ICM Relationship: Dates
38	REL_VALID_TO	☐	CRM_ICM_REL_DATE	SYDATS	DATS	8	0	ICM Relationship: Dates

History

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