SAP ABAP Table CRMS_ICM_CMG_WLI_SEARCH_RESULT (ICM CMG BOL advanced search structure (WorkList))

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_WLI_SEARCH_RESULT	Table Relationship Diagram
Short Description	ICM CMG BOL advanced search structure (WorkList)

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	ICM CMG BOL advanced search structure
2	.INCLUDE	☐				0	0	Case Attributes
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	CASE_GUID	☐	SCMG_CASE_GUID	SYSUUID_C	CHAR	32	0	Technical Case Key (Case GUID)	SCMG_T_CASE
5	.INCLUDE	☐				0	0	Case Attributes
6	CASE_TYPE	☐	SCMGCASE_TYPE	SCMGCASE_TYPE	CHAR	4	0	Case Type	SCMGCASETYPE
7	EXT_KEY	☐	SCMG_EXT_KEY	SCMG_EXT_KEY	CHAR	12	0	Case ID
8	EXT_REF	☐	SCMG_EXT_REF	CHAR30	CHAR	30	0	External reference
9	CREATED_BY	☐	SCMG_CREATE_USER	XUBNAME	CHAR	12	0	Created By	USR02
10	CREATE_TIME	☐	SCMG_CREATE_TIME	SCMG_TIMESTAMP	DEC	15	0	Created On
11	CHANGED_BY	☐	SCMG_CHANGE_USER	XUBNAME	CHAR	12	0	Last Changed by	USR02
12	CHANGE_TIME	☐	SCMG_CHANGE_TIME	SCMG_TIMESTAMP	DEC	15	0	Last Changed On
13	CLOSED_BY	☐	SCMG_CLOSED_BY	XUBNAME	CHAR	12	0	Closed by User	USR02
14	CLOSING_TIME	☐	SCMG_CLOSING_TIME	SCMG_TIMESTAMP	DEC	15	0	Closed at Time
15	PLAN_END_DATE	☐	SCMG_PLAN_END_DATE	DATUM	DATS	8	0	Planned Close Date
16	PROCESSOR	☐	SCMG_PROCESSOR	XUBNAME	CHAR	12	0	Processor	USR02
17	RESPONSIBLE	☐	SCMG_RESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
18	CASE_TITLE	☐	SCMG_CASE_TITLE	TEXT80	CHAR	80	0	Case Title
19	ESCAL_REASON	☐	SCMG_ESCAL_REASON	CHAR2	CHAR	2	0	Reason for Escalation	SCMGATTR_SESCAL
20	CATEGORY	☐	SCMG_CATEGORY	CHAR4	CHAR	4	0	Category	SCMGATTR_CATEGO
21	PRIORITY	☐	SCMG_PRIORITY	NUM01	NUMC	1	0	Priority	SCMGATTR_PRIO
22	SECURE_LEVEL	☐	SCMG_SECURE_LEVEL	CHAR1	CHAR	1	0	Authorization level	SCMGAUT_SECLEVL
23	PROFILE_ID	☐	SCMGSTATUSPROFID	SCMGPROFID	CHAR	8	0	Case: Status Profile	SCMGSTATPROF
24	STAT_ORDERNO	☐	SCMGSTATUSONR	SCMGSTATUSONR	NUMC	2	0	Case: Status	SCMGSTATPROFS
25	STAT_PARA	☐	SCMGSTATPARA	CHAR03	CHAR	3	0	Case: System Status	SCMGSTAT
26	STAT_OBJNR	☐	SCMGSTATOBJNR	SYSUUID_C	CHAR	32	0	Case: Status Object Number (GUID), (Central Status Managmnt)
27	STAT_LINE	☐	SCMGSTATLINE	SCMGSTATLINE	CHAR	40	0	Case: System Status Description (Central Status Management)
28	STAT_USER_LINE	☐	SCMGSTATUSERLINE	SCMGSTATLINE	CHAR	40	0	Case: User Status Description (Central Status Management)
29	REASON_CODE	☐	SCMG_REASON_CODE	CHAR4	CHAR	4	0	Reason for Case	SCMGATTR_REASON
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	New ICM attribute structure for include
50	START_DATE	☐	CRM_ICM_CMG_START_TIMESTAMP	CMG_TIMESTAMP	DEC	15	0	ICM Case & Lead Start Timestamp
51	END_DATE	☐	CRM_ICM_CMG_END_TIMESTAMP	CMG_TIMESTAMP	DEC	15	0	ICM Case & Lead End Timestamp
52	START_CRIME	☐	CRM_ICM_CMG_START_CRIME_STAMP	CMG_TIMESTAMP	DEC	15	0	ICM Case & Lead Start Timestamp of Crime
53	END_CRIME	☐	CRM_ICM_CMG_END_CRIME_STAMP	CMG_TIMESTAMP	DEC	15	0	ICM Case & Lead End Timestamp of Crime
54	SUMMARY	☐	CRM_ICM_CMG_SUMMARY		STRG	0	0	ICM Case & Lead Summary
55	EXPUNGE_DATE	☐	CRM_ICM_CMG_EXPUNGE_DATE	DATUM	DATS	8	0	Expunge Date
56	SECURITY_LEVEL	☐	CRM_ICM_AUT_SEC_LVL	CRM_ICM_AUT_SEC_LVL	NUMC	6	0	Investigative Case Management Security Level
57	HIDDEN_FLAG	☐	CRM_ICM_CMG_HIDDEN_FLAG	CRM_BOOLEAN	CHAR	1	0	ICM Case Hidden Checkbox
58	.INCLUDE	☐				0	0	Include for Customer Includes used by Standard Case
59	ICM_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
60	DESCR_CASETYPE	☐	SCMGTYPEDESCR	TEXT40	CHAR	40	0	Short Text for Case Type
61	DESCRP_RESP_EMP	☐	BU_TEXT60	TEXT60	CHAR	60	0	Name
62	DESCRP_RESP_GRP	☐	BU_TEXT60	TEXT60	CHAR	60	0	Name
63	DESCRP_RESP_ORG	☐	BU_TEXT60	TEXT60	CHAR	60	0	Name
64	DESCRP_STATPARA	☐	SCMGSTATPARA_DESCR	TEXT40	CHAR	40	0	Case: System Status Description
65	DESCRP_STAT_ORDNO	☐	SCMGSTAT_DESCR	SCMGSTAT_DESCR	CHAR	40	0	Case: Status Description
66	DESCRP_PRIO	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
67	DESCRP_ESCAL	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
68	RESP_EMP_NO	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
69	RESP_GRP_NO	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
70	RESP_ORG_NO	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
71	.INCLUDE	☐				0	0	ICM CMG worklist specific case attributes
72	MAIN_LEGAL_REFERENCE	☐	CRM_ICM_LAW_ID	CRM_ICM_LAW_ID	CHAR	32	0	Legal Reference ID
73	ONLY_RESPONSIBLE	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
74	XRF_NUM	☐	CRM_ICM_CMG_XRF_NUM	TEXT30	CHAR	30	0	External Reference Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_ICM_CMG_WLI_SEARCH_RESULT	CASE_GUID	SCMG_T_CASE	CASE_GUID	KEY	1	1
2	CRMS_ICM_CMG_WLI_SEARCH_RESULT	CASE_TYPE	SCMGCASETYPE	CASE_TYPE
3	CRMS_ICM_CMG_WLI_SEARCH_RESULT	CATEGORY	SCMGATTR_CATEGO	CATEGORY
4	CRMS_ICM_CMG_WLI_SEARCH_RESULT	CHANGED_BY	USR02	BNAME
5	CRMS_ICM_CMG_WLI_SEARCH_RESULT	CLOSED_BY	USR02	BNAME
6	CRMS_ICM_CMG_WLI_SEARCH_RESULT	CREATED_BY	USR02	BNAME
7	CRMS_ICM_CMG_WLI_SEARCH_RESULT	ESCAL_REASON	SCMGATTR_SESCAL	ESCAL_REASON	KEY
8	CRMS_ICM_CMG_WLI_SEARCH_RESULT	PRIORITY	SCMGATTR_PRIO	PRIORITY
9	CRMS_ICM_CMG_WLI_SEARCH_RESULT	PROCESSOR	USR02	BNAME
10	CRMS_ICM_CMG_WLI_SEARCH_RESULT	PROFILE_ID	SCMGSTATPROF	PROFILE_ID
11	CRMS_ICM_CMG_WLI_SEARCH_RESULT	REASON_CODE	SCMGATTR_REASON	REASON_CODE
12	CRMS_ICM_CMG_WLI_SEARCH_RESULT	RESPONSIBLE	USR02	BNAME
13	CRMS_ICM_CMG_WLI_SEARCH_RESULT	SECURE_LEVEL	SCMGAUT_SECLEVL	SECURE_LEVEL
14	CRMS_ICM_CMG_WLI_SEARCH_RESULT	STAT_ORDERNO	SCMGSTATPROFS	STAT_ORDERNO
15	CRMS_ICM_CMG_WLI_SEARCH_RESULT	STAT_PARA	SCMGSTAT	STAT_PARA

History

Last changed by/on	SAP	20141013
SAP Release Created in	701