SAP ABAP Table CRMS_CLM_DYNAMIC_SQ (Call List Dynamic Search query)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IC-CAL (Application Component) Call List Execution and Maintenance
     ⤷ CRM_CLMIL (Package) Call List Managment Interaction Layer

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_CLM_DYNAMIC_SQ	Table Relationship Diagram
Short Description	Call List Dynamic Search query

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	ASSIGN_ID	☐	UUID	UUID	RAW	16	0	Global Unique ID for table
2	ASSIGN_CALL_LIST_ID	☐	CRMT_CLM_CALL_LIST_ID	CRM_CLM_CALL_LIST_ID	RAW	16	0	Call list id
3	ASSIGN_OBJECT_ID	☐	PD_OBJID_R	NUM08	NUMC	8	0	Object ID
4	ASSIGN_OBJECT_ID_EX	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
5	ASSIGN_OBJECT_TYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
6	ASSIGN_DESCRIPTION	☐			STRG	0	0
7	BP_PARTNER_NUMBER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
8	BP_ROLE	☐	BU_ROLE	BU_RLTYP	CHAR	6	0	BP role	*
9	BP_SEARCH_TERM1	☐	BU_MCNAME1	CHAR35	CHAR	35	0	Search Help Field 1 (Name 1/Last Name)
10	BP_SEARCH_TERM2	☐	BU_MCNAME2	CHAR35	CHAR	35	0	Search Help Field 2 (Name 2/First Name)
11	BP_TELEPHONE	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
12	BP_EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
13	BP_URL	☐	AD_URI2	CHAR50	CHAR	50	0	URI address search field
14	BP_HOUSE_NUMBER	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
15	BP_STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
16	BP_CITY	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
17	BP_REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
18	BP_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
19	BP_POSTAL_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
20	BP_CONTACT	☐	BU_CONTACT	BU_CONTACT	CHAR	1	0	Business Partner: Contact Permission
21	CALL_ID	☐	CRMT_CLM_CALL_ID	CRM_CLM_CALL_ID	RAW	16	0	Call id
22	CALL_CALL_LIST_ID	☐	CRMT_CLM_CALL_LIST_ID	CRM_CLM_CALL_LIST_ID	RAW	16	0	Call list id
23	CALL_STATE	☐	CRMT_CLM_CALL_STATE	CRM_CLM_CALL_STATE	CHAR	1	0	Call State
24	CALL_ATTEMPTS_ACTUAL	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
25	CALL_LOCK_OWNER	☐	CRMT_CLM_CALL_OWNER	SYCHAR12	CHAR	12	0	Call Owner
26	CALL_PRIORITY	☐	NUMC2	NUMC2	NUMC	2	0	Two digit number
27	CALL_RESCHEDULED	☐	CRMT_CLM_BOOLEAN	CRM_CLM_BOOLEAN	CHAR	1	0	Logical Variable
28	CALL_CALL_RESULT	☐	CRMT_CLM_CALL_RESULT	CRM_CLM_CALL_RESULT	CHAR	1	0	Call result	*
29	CALL_DURATION_ACTUAL	☐	CRMT_CLM_CALL_DURATION_ACTUAL		TIMS	6	0	Call actual duration
30	CALL_CALL_TIME_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
31	CALL_START_ON_DATE	☐	CRMT_CLM_CALL_START_ON_DATE		DATS	8	0	Call start on date
32	CALL_STOP_ON_DATE	☐	CRMT_CLM_CALL_STOP_ON_DATE		DATS	8	0	Call stop on date
33	CALL_COMPLETE_BY_DATE	☐	CRMT_CLM_CALL_COMPLETE_BY_DATE		DATS	8	0	Call complete by date
34	CAMPAIGN_ID	☐	CRM_MKTPL_CAMPAIGNID	CGPL_EXTID	CHAR	24	0	Campaign
35	CAMPAIGN_DESCRIPTION	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
36	CAMPAIGN_TYPE	☐	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type	*
37	CAMPAIGN_PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority
38	CAMPAIGN_PLAN_START_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
39	CAMPAIGN_PLAN_FINISH_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
40	CL_ID	☐	CHAR32	CHAR32	CHAR	32	0	Character field, length 32
41	CL_NAME	☐	CRMT_CLM_CALL_LIST_NAME	CRM_CHAR64_LOW	CHAR	64	0	Call List Name
42	CL_TYPE_NAME	☐	CRMT_CLM_CALL_LIST_TYPE	CRM_CLM_CALL_LIST_TYPE	CHAR	32	0	Call List Type	*
43	CL_RESPONSIBLE_USER	☐	CRMT_CLM_RESPONSIBLE_USER	XUBNAME	CHAR	12	0	Responsible User	*
44	CL_EXECUTION_MODE	☐	CRMT_CLM_CL_EXECUTION_MODE	CRM_CL_EXECUTION_MODE	CHAR	1	0	Call List Execution Mode
45	CL_PRIORITY	☐	CRMT_TM_CL_PRIORITY	CRM_CL_PRIORITY	NUMC	2	0	Call List Priority
46	CL_START_ON_DATE	☐	CRMT_CLM_CL_START_ON_DATE		DATS	8	0	Call list start on date
47	CL_STOP_ON_DATE	☐	CRMT_CLM_CL_STOP_ON_DATE		DATS	8	0	Call list stop on date
48	CL_COMPLETE_BY_DATE	☐	CRMT_CLM_CL_COMPLETE_BY_DATE		DATS	8	0	Call list complete by date
49	CL_ACTIVE	☐	CRMT_CLM_ACTIVATION_STATE	CRM_CLM_ACTIVATION_STATE	CHAR	1	0	Activation state
50	CL_INTERACTION_CENTER_ID	☐	CRMT_CLM_INTERACTION_CENTER_ID	HROBJID	NUMC	8	0	Interaction center id (Organizational unit id)	*
51	CL_LOCAL_SIZE	☐	CRMT_CLM_CL_LOCAL_SIZE		INT4	10	0	Call list local size
52	CL_TOTAL_SIZE	☐	CRMT_CLM_CL_TOTAL_SIZE		INT4	10	0	Call list total size

History

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