SAP ABAP Table CRMST_QUERY_ICM_ACT_BTIL (BTIL structure for Activities - Search criteria)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX (Application Component) Business Transactions
     ⤷ CRM_BTIL_OBJ (Package) Objects of the Transaction Interaction Layer

Basic Data

Table Category	INTTAB	Structure
Structure	CRMST_QUERY_ICM_ACT_BTIL	Table Relationship Diagram
Short Description	BTIL structure for Activities - Search criteria

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	CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
2	EMPLOYEE_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
3	STATUS_COMMON	☐	CRMT_STATUS_COMMON		CHAR	13	0	General Status (User, System, Area)
4	VALID_FROM	☐	CRMT_BSP_VALID_FROM	DATUM	DATS	8	0	"Valid From" Date
5	VALID_TO	☐	CRMT_REPORT_TO	SYDATS	DATS	8	0	Valid To
6	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority	*
7	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
8	ACTIVITY_PARTNER	☐	CRMT_ACTIVITY_PARTNER	BU_PARTNER	CHAR	10	0	Activity Partner	*
9	TEMPLATE_TYPE	☐	CRMT_TEMPLATE_TYPE_DB	CRM_TEMPLATE_TYPE	CHAR	1	0	Template Type of CRM Transaction
10	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE_DB	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
11	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
12	START_DATE_RANGE	☐	CRMT_REPORT_STARTDATE	DATUM	DATS	8	0	Start Date
13	END_DATE_RANGE	☐	CRMT_REPORT_ENDDATE	DATUM	DATS	8	0	End Date
14	RESPONS_AREA	☐	CRMT_RESPONS_AREA_OIC	CRM_RESPONS_AREA_OIC	CHAR	1	0	Belonging To (Me, My Department, My Group)
15	RESP_CHAN_PARTNER	☐	CRMT_RESP_AT_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Responsible at Channel Partner	*
16	CAMPAIGN_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
17	CAMPAIGN_NAME	☐	CRMT_CAMPAIGN_DESCRIPTION	CHAR40	CHAR	40	0	Campaign Description
18	OPPORTUNITY_ID	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
19	OPPORTUNITY_NAME	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
20	OWNER_FIRSTNAME	☐	CRMT_UIU_EMPLOYEE_RESP_FIRSTNA	CHAR40	CHAR	40	0	Employee Responsible First Name
21	OWNER_LASTNAME	☐	CRMT_UIU_EMPLOYEE_RESP_LASTNA	CHAR40	CHAR	40	0	Employee Responsible Last Name
22	LEAD_ID	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
23	LEAD_NAME	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
24	CONTACT_FIRSTNAME	☐	CRMT_UIU_CONTACT_FIRSTNAME	CHAR40	CHAR	40	0	Contact First Name
25	CONTACT_LASTNAME	☐	CRMT_UIU_CONTACT_LASTNAME	CHAR40	CHAR	40	0	Contact Last Name
26	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
27	TIMEFRAME	☐	CRMT_UIU_TIMEFRAME	CHAR40	CHAR	40	0	Timeframe (End Date Range)
28	QUOTATION_ID	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
29	QUOTATION_NAME	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
30	BU_PARTNER	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
31	ACTIVITY_PARTNER_NAME	☐	CRMT_UIU_ACCOUNT_NAME	CHAR40	CHAR	40	0	Account Name
32	CHANNEL_PARTNER_NAME	☐	CRMT_UIU_SALES_PARTNER_NAME	CHAR40	CHAR	40	0	Sales Partner Name
33	RESP_CHAN_PARTNER_FIRSTNAME	☐	CRMT_UIU_RESP_AT_CHAN_PART_FN	CHAR40	CHAR	40	0	Employee Resp. at Channel Partner First Name
34	RESP_CHAN_PARTNER_LASTNAME	☐	CRMT_UIU_RESP_AT_CHAN_PART_LN	CHAR40	CHAR	40	0	Employee Resp. at Channel Partner Last Name
35	CHANNEL_PARTNER	☐	CRMT_UIU_SALES_PARTNER	BU_PARTNER	CHAR	10	0	Sales Partner ID	*
36	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
37	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
38	.INCLUDE	☐				0	0	Extensibility for ICM Activity
39	EEW_ACT_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
40	.INCLUDE	☐				0	0
41	TRADE_PROMO_ID	☐	CRM_MKTPL_TRADEID	CGPL_EXTID	CHAR	24	0	Trade Promotion
42	TRADE_PROMO_DESC	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
43	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
44	FINANCIAL_CONTRACT_ID	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
45	IOBJECT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
46	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
47	TERR_DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
48	CLASS	☐	CRMT_ACTIVITY_CLASS	CRM_ACTIVITY_CLASS	CHAR	1	0	Activity Class
49	.INCLUDE	☐				0	0	ICM Combined Search Attributes
50	LOCATION_COMB	☐	CRM_ICM_IL_REL_LOC_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Locations
51	CASE_COMB	☐	CRM_ICM_IL_REL_CMG_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Cases
52	LEAD_COMB	☐	CRM_ICM_IL_REL_LEAD_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Leads
53	INCIDENT_COMB	☐	CRM_ICM_IL_REL_INC_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Incidents
54	BP_COMB	☐	CRM_ICM_IL_REL_BP_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Business Partners
55	OBJECT_COMB	☐	CRM_ICM_IL_REL_OBJ_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Objects
56	OPERATION_COMB	☐	CRM_ICM_IL_REL_ACT_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Activities
57	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
58	REL_TYPE_ID	☐	CRM_ICM_REL_TYPE_ID		CHAR	4	0	CRM ICM Relationship Type ID
59	REL_VALID_FROM	☐	CRM_ICM_REL_DATE	SYDATS	DATS	8	0	ICM Relationship: Dates
60	REL_VALID_TO	☐	CRM_ICM_REL_DATE	SYDATS	DATS	8	0	ICM Relationship: Dates
61	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
62	LAW_ID	☐	CRM_ICM_LAW_ID	CRM_ICM_LAW_ID	CHAR	32	0	Legal Reference ID
63	MAIN_REF	☐	CRM_LAWREF_MAIN	CRM_BOOLEAN	CHAR	1	0	Legal Reference Main Reference Flag
64	MY_WORKLIST	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable

History

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