SAP ABAP Table CRMS_CLM_SQ_CONDITIONS (Search query conditions)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CIC-CAM (Application Component) Campaign Execution
     ⤷ CRM_CIC_CLM_BO (Package) Call list management business objects

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_CLM_SQ_CONDITIONS	Table Relationship Diagram
Short Description	Search query conditions

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	CALL_LIST	☐	CRMS_CLM_SQ_CALL_LIST		STRU	0	0
2	ID	☐	CHAR32	CHAR32	CHAR	32	0	Character field, length 32
3	ID_O	☐	CRMT_TM_RELATIONAL_OPERATOR_EQ	CRM_CLM_RELATIONAL_OPERATOR_EQ	CHAR	2	0	Equality relationship operator
4	NAME	☐	CRMT_CLM_CALL_LIST_NAME	CRM_CHAR64_LOW	CHAR	64	0	Call List Name
5	NAME_O	☐	CRMT_CLM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
6	TYPE_NAME	☐	CRMT_CLM_CALL_LIST_TYPE	CRM_CLM_CALL_LIST_TYPE	CHAR	32	0	Call List Type
7	TYPE_NAME_O	☐	CRMT_TM_RELATIONAL_OPERATOR_EQ	CRM_CLM_RELATIONAL_OPERATOR_EQ	CHAR	2	0	Equality relationship operator
8	RESPONSIBLE	☐	CRMT_CLM_RESPONSIBLE_USER	XUBNAME	CHAR	12	0	Responsible User
9	RESPONSIBLE_O	☐	CRMT_TM_RELATIONAL_OPERATOR_EQ	CRM_CLM_RELATIONAL_OPERATOR_EQ	CHAR	2	0	Equality relationship operator
10	EXECUTION_MODE	☐	CRMT_CLM_CL_EXECUTION_MODE	CRM_CL_EXECUTION_MODE	CHAR	1	0	Call List Execution Mode
11	EXECUTION_MODE_O	☐	CRMT_TM_RELATIONAL_OPERATOR_EQ	CRM_CLM_RELATIONAL_OPERATOR_EQ	CHAR	2	0	Equality relationship operator
12	PRIORITY	☐	CRMT_TM_CL_PRIORITY	CRM_CL_PRIORITY	NUMC	2	0	Call List Priority
13	PRIORITY_O	☐	CRMT_CLM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
14	START_ON_DATE	☐	CRMT_CLM_CL_START_ON_DATE		DATS	8	0	Call list start on date
15	START_ON_TIME	☐	CRMT_CLM_CL_START_ON_TIME		TIMS	6	0	Call list start on time
16	START_ON_O	☐	CRMT_CLM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
17	STOP_ON_DATE	☐	CRMT_CLM_CL_STOP_ON_DATE		DATS	8	0	Call list stop on date
18	STOP_ON_TIME	☐	CRMT_CLM_CL_STOP_ON_TIME		TIMS	6	0	Call list stop on time
19	STOP_ON_O	☐	CRMT_CLM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
20	COMPLETE_BY_DATE	☐	CRMT_CLM_CL_COMPLETE_BY_DATE		DATS	8	0	Call list complete by date
21	COMPLETE_BY_TIME	☐	CRMT_CLM_CL_COMPLETE_BY_TIME		TIMS	6	0	Call list complete by time
22	COMPLETE_BY_O	☐	CRMT_CLM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
23	ACTIVE	☐	CRMT_CLM_ACTIVATION_STATE	CRM_CLM_ACTIVATION_STATE	CHAR	1	0	Activation state
24	ACTIVE_O	☐	CRMT_TM_RELATIONAL_OPERATOR_EQ	CRM_CLM_RELATIONAL_OPERATOR_EQ	CHAR	2	0	Equality relationship operator
25	INTERACTION_CENTER_ID	☐	CRMT_CLM_INTERACTION_CENTER_ID	HROBJID	NUMC	8	0	Interaction center id (Organizational unit id)
26	INTERACTION_CENTER_ID_O	☐	CRMT_TM_RELATIONAL_OPERATOR_EQ	CRM_CLM_RELATIONAL_OPERATOR_EQ	CHAR	2	0	Equality relationship operator
27	COMPLETION_STATUS_O	☐	CRMT_TM_RELATIONAL_OPERATOR_EQ	CRM_CLM_RELATIONAL_OPERATOR_EQ	CHAR	2	0	Equality relationship operator
28	COMPLETION_STATUS	☐	CRMT_CLM_COMPLETION_STATUS	CRM_CLM_COMPLETION_STATUS	CHAR	1	0	Completion Status
29	START_ON	☐	CRMT_CLM_CL_START_ON	CRM_CLM_TIMESTAMP	DEC	15	0	Call list execution start date and time
30	STOP_ON	☐	CRMT_CLM_CL_STOP_ON	CRM_CLM_TIMESTAMP	DEC	15	0	Call list stop on date and time
31	COMPLETE_BY	☐	CRMT_CLM_CL_COMPLETE_BY	CRM_CLM_TIMESTAMP	DEC	15	0	Call list complete by date and time
32	LOCAL_SIZE	☐	CRMT_CLM_CL_LOCAL_SIZE		INT4	10	0	Call list local size
33	LOCAL_SIZE_O	☐	CRMT_CLM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
34	TOTAL_SIZE	☐	CRMT_CLM_CL_TOTAL_SIZE		INT4	10	0	Call list total size
35	TOTAL_SIZE_O	☐	CRMT_CLM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
36	INTERACTION	☐	CRMS_CLM_SQ_CALL		STRU	0	0
37	ID	☐	CRMT_CLM_CALL_ID	CRM_CLM_CALL_ID	RAW	16	0	Call id
38	ID_O	☐	CRMT_TM_RELATIONAL_OPERATOR_EQ	CRM_CLM_RELATIONAL_OPERATOR_EQ	CHAR	2	0	Equality relationship operator
39	CALL_LIST_ID	☐	CRMT_CLM_CALL_LIST_ID	CRM_CLM_CALL_LIST_ID	RAW	16	0	Call list id
40	CALL_LIST_ID_O	☐	CRMT_TM_RELATIONAL_OPERATOR_EQ	CRM_CLM_RELATIONAL_OPERATOR_EQ	CHAR	2	0	Equality relationship operator
41	STATE	☐	CRMT_CLM_CALL_STATE	CRM_CLM_CALL_STATE	CHAR	1	0	Call State
42	STATE_O	☐	CRMT_TM_RELATIONAL_OPERATOR_EQ	CRM_CLM_RELATIONAL_OPERATOR_EQ	CHAR	2	0	Equality relationship operator
43	ATTEMPTS_ACTUAL	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
44	ATTEMPTS_ACTUAL_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
45	LOCK_OWNER	☐	CRMT_CLM_CALL_OWNER	SYCHAR12	CHAR	12	0	Call Owner
46	LOCK_OWNER_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
47	PRIORITY	☐	NUMC2	NUMC2	NUMC	2	0	Two digit number
48	PRIORITY_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
49	RESCHEDULED	☐	CRMT_CLM_BOOLEAN	CRM_CLM_BOOLEAN	CHAR	1	0	Logical Variable
50	RESCHEDULED_O	☐	CRMT_TM_RELATIONAL_OPERATOR_EQ	CRM_CLM_RELATIONAL_OPERATOR_EQ	CHAR	2	0	Equality relationship operator
51	CALL_RESULT	☐	CRMT_CLM_CALL_RESULT	CRM_CLM_CALL_RESULT	CHAR	1	0	Call result
52	CALL_RESULT_O	☐	CRMT_TM_RELATIONAL_OPERATOR_EQ	CRM_CLM_RELATIONAL_OPERATOR_EQ	CHAR	2	0	Equality relationship operator
53	DURATION_ACTUAL	☐	CRMT_CLM_CALL_DURATION_ACTUAL		TIMS	6	0	Call actual duration
54	DURATION_ACTUAL_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
55	CALL_TIME	☐	CRMT_CLM_CALL_TIME	CRM_CLM_TIMESTAMP	DEC	15	0	Call Time
56	CALL_TIME_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
57	CALL_TIME_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
58	CALL_TIME_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
59	START_ON_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
60	START_ON_DATE	☐	CRMT_CLM_CALL_START_ON_DATE		DATS	8	0	Call start on date
61	START_ON_TIME	☐	CRMT_CLM_CALL_START_ON_TIME		TIMS	6	0	Call start on time
62	STOP_ON_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
63	STOP_ON_DATE	☐	CRMT_CLM_CALL_STOP_ON_DATE		DATS	8	0	Call stop on date
64	STOP_ON_TIME	☐	CRMT_CLM_CALL_STOP_ON_TIME		TIMS	6	0	Call stop on time
65	COMPLETE_BY_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
66	COMPLETE_BY_DATE	☐	CRMT_CLM_CALL_COMPLETE_BY_DATE		DATS	8	0	Call complete by date
67	COMPLETE_BY_TIME	☐	CRMT_CLM_CALL_COMPLETE_BY_TIME		TIMS	6	0	Call complete by time
68	ASSIGNMENT	☐	CRMS_CLM_SQ_ASSIGNMENT		STRU	0	0
69	ID	☐	UUID	UUID	RAW	16	0	Global Unique ID for table
70	ID_O	☐	CRMT_TM_RELATIONAL_OPERATOR_EQ	CRM_CLM_RELATIONAL_OPERATOR_EQ	CHAR	2	0	Equality relationship operator
71	CALL_LIST_ID	☐	CRMT_CLM_CALL_LIST_ID	CRM_CLM_CALL_LIST_ID	RAW	16	0	Call list id
72	CALL_LIST_ID_O	☐	CRMT_TM_RELATIONAL_OPERATOR_EQ	CRM_CLM_RELATIONAL_OPERATOR_EQ	CHAR	2	0	Equality relationship operator
73	OM_ID	☐	PD_OBJID_R	NUM08	NUMC	8	0	Object ID
74	OM_ID_O	☐	CRMT_TM_RELATIONAL_OPERATOR_EQ	CRM_CLM_RELATIONAL_OPERATOR_EQ	CHAR	2	0	Equality relationship operator
75	OM_EXTENDED_ID	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
76	OM_EXTENDED_ID_O	☐	CRMT_TM_RELATIONAL_OPERATOR_EQ	CRM_CLM_RELATIONAL_OPERATOR_EQ	CHAR	2	0	Equality relationship operator
77	OM_TYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type
78	OM_TYPE_O	☐	CRMT_TM_RELATIONAL_OPERATOR_EQ	CRM_CLM_RELATIONAL_OPERATOR_EQ	CHAR	2	0	Equality relationship operator
79	DESCRIPTION	☐			STRG	0	0
80	BUSINESS_PARTNER	☐	CRMS_CLM_SQ_BUSINESS_PARTNER		STRU	0	0
81	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
82	ROLE	☐	BU_ROLE	BU_RLTYP	CHAR	6	0	BP role
83	SEARCH_TERM1	☐	BU_MCNAME1	CHAR35	CHAR	35	0	Search Help Field 1 (Name 1/Last Name)
84	SEARCH_TERM2	☐	BU_MCNAME2	CHAR35	CHAR	35	0	Search Help Field 2 (Name 2/First Name)
85	TELEPHONE	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
86	EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
87	URL	☐	AD_URI2	CHAR50	CHAR	50	0	URI address search field
88	HOUSE_NUMBER	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
89	STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
90	CITY	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
91	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
92	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
93	POSTAL_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
94	CONTACT	☐	BU_CONTACT	BU_CONTACT	CHAR	1	0	Business Partner: Contact Permission
95	CAMPAIGN	☐	CRMS_CLM_SQ_CAMPAIGN		STRU	0	0
96	ID	☐	CRM_MKTPL_CAMPAIGNID	CGPL_EXTID	CHAR	24	0	Campaign
97	ID_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
98	DESCRIPTION	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
99	DESCRIPTION_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
100	TYPE	☐	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type
101	TYPE_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
102	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority
103	PRIORITY_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
104	PLAN_START_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
105	PLAN_START_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
106	PLAN_START_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
107	PLAN_FINISH_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
108	PLAN_FINISH_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
109	PLAN_FINISH_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
110	ICWIN_SCRIPT	☐	CRMS_CLM_SQ_ICWIN_SCRIPT		STRU	0	0
111	DESCRIPTION	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
112	DESCRIPTION_O	☐	CRMT_TM_RELATIONAL_OPERATOR_EQ	CRM_CLM_RELATIONAL_OPERATOR_EQ	CHAR	2	0	Equality relationship operator
113	LANGUAGE	☐	SYLANGU	SYLANGU	LANG	1	0	Language Key
114	LANGUAGE_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
115	TREE_ID	☐	CRMT_TREEID	CRM_TREEID	NUMC	8	0	Name of Interaction Center (IC) WinClient Script
116	TREE_ID_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
117	VALID_FROM	☐	CRMT_VALIDFROM	DATS	DATS	8	0	CRMT_VALIDFROM
118	VALID_FROM_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
119	VALID_TO	☐	CRMT_VALIDTO	DATS	DATS	8	0	CRMT_VALIDTO
120	VALID_TO_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
121	ICWEB_SCRIPT	☐	CRMS_CLM_SQ_ICWEB_SCRIPT		STRU	0	0
122	ID	☐	CRM_IC_SCRNAME	CRM_IC_XMLNAME	CHAR	32	0	Name of Interaction Center (IC) WebClient Script
123	ID_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
124	DATE_FROM	☐	DATS	DATS	DATS	8	0	Field of type DATS
125	DATE_FROM_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator
126	DATE_TO	☐	DATS	DATS	DATS	8	0	Field of type DATS
127	DATE_TO_O	☐	CRMT_TM_RELATIONAL_OPERATOR	CRM_CLM_RELATIONAL_OPERATOR	CHAR	2	0	Relational operator

History

Last changed by/on	SAP	20130604
SAP Release Created in	400