SAP ABAP Table CRMT_BSP_CLM_SEARCH_ALL (Search call lists)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IC-CAL (Application Component) Call List Execution and Maintenance
     ⤷ CRM_BSP_MODEL_IL_CLM (Package) Model Implementation: Call List Management

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_CLM_SEARCH_ALL	Table Relationship Diagram
Short Description	Search call lists

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BSP_CLM_SEARCH_ALL	COUNTRY	T005	LAND1
2	CRMT_BSP_CLM_SEARCH_ALL	REGION	T005S	BLAND

History

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