SAP ABAP Table CRMST_QUERY_LEA_BTIL (Business Trans. IL Structure for Complaint - 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_LEA_BTIL	Table Relationship Diagram
Short Description	Business Trans. IL Structure for Complaint - 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	PRODUCT_KIND_SEL	☐	CRMT_PRODUCT_LOC_2	CRM_PRODUCT_LOC_2	CHAR	2	0	Product/Product Selection for Locator/OIC (Product/IObject)
2	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
3	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
4	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
5	TEMPLATE_TYPE	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
6	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
7	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
8	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
9	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
10	BU_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
11	PARTNER_NAME	☐	BU_MCNAME1	CHAR35	CHAR	35	0	Search Help Field 1 (Name 1/Last Name)
12	PRODUCT_ID	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
13	PRODUCT_NAME	☐	CRMT_UIU_PRODUCT_NAME	CHAR40	CHAR	40	0	Product Name
14	PROD_HIERARCHY	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
15	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
16	TERR_DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
17	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
18	STATUS_AREA	☐	CRMT_STATUS_AREA_OIC	CRM_STATUS_AREA_OIC	CHAR	13	0	Status Area (All, Completed, Not Completed)
19	STATUS_COMMON	☐	CRMT_STATUS_COMMON		CHAR	13	0	General Status (User, System, Area)
20	OWNER_FIRSTNAME	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
21	OWNER_LASTNAME	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
22	CONTACT_LASTNAME	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
23	CONTACT_FIRSTNAME	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
24	VALID_FROM	☐	CRMT_DATES_START_DATE	DATUM	DATS	8	0	Start Date
25	VALID_TO	☐	CRMT_DATES_END_DATE	DATS	DATS	8	0	End Date
26	TIMEFRAME	☐	CRMT_UIU_TIMEFRAME	CHAR40	CHAR	40	0	Timeframe (End Date Range)
27	LE_IMPORTANCE	☐	CRMT_IMPORTANCE	CRM_IMPORTANCE	CHAR	1	0	Opportunity/Lead Priority	*
28	LEAD_TYPE	☐	CRMT_LEAD_TYPE	CRM_LEAD_TYPE	CHAR	4	0	Lead Group	*
29	LE_SOURCE	☐	CRMT_SOURCE	CRM_SOURCE	CHAR	3	0	Origin of Opportunity/Lead	*
30	QUAL_LEVEL_MAN	☐	CRMT_LEAD_QUAL_LEVEL_MAN	CRM_LEAD_QUAL_LEVEL	CHAR	2	0	Lead Qualification Level	*
31	EMPLOYEE_RESP	☐	CRMT_UIU_EMPLOYEE_RESP	CRM_PARTNER_NUMBER	CHAR	20	0	Employee Responsible
32	PROSPECT	☐	CRMT_BSP_PARTNER_NUMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Usage Within BSP
33	CONTACT_PERSON	☐	CRMT_UIU_CONTACT_PARTY	CRM_PARTNER_NUMBER	CHAR	20	0	Contact
34	RESPONS_AREA	☐	CRMT_RESPONS_AREA_OIC	CRM_RESPONS_AREA_OIC	CHAR	1	0	Belonging To (Me, My Department, My Group)
35	CHANNEL_PARTNER	☐	CRMT_UIU_SALES_PARTNER	BU_PARTNER	CHAR	10	0	Sales Partner ID	*
36	RESP_CHAN_PARTNER	☐	CRMT_RESP_AT_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Responsible at Channel Partner	*
37	PROSPECT_NAME	☐	CRMT_UIU_PROSPECT_NAME	CHAR40	CHAR	40	0	Prospect Name
38	CHANNEL_PARTNER_NAME	☐	CRMT_UIU_SALES_PARTNER_NAME	CHAR40	CHAR	40	0	Sales Partner Name
39	RESP_CHAN_PARTNER_FIRSTNAME	☐	CRMT_UIU_RESP_AT_CHAN_PART_FN	CHAR40	CHAR	40	0	Employee Resp. at Channel Partner First Name
40	RESP_CHAN_PARTNER_LASTNAME	☐	CRMT_UIU_RESP_AT_CHAN_PART_LN	CHAR40	CHAR	40	0	Employee Resp. at Channel Partner Last Name
41	CAMPAIGN_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
42	CAMPAIGN_DES	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
43	PARTNER_COMB	☐	CRMT_UIU_PARTNER_TO_PARTNERFCT	CHAR40	CHAR	40	0	Partner In Partner Function
44	.INCLUDE	☐				0	0	EEW Include
45	EEW_BUS2000108_SEARCH_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
46	.INCLUDE	☐				0	0
47	INCL_SUB_TERR	☐	CRMT_SUB_TERR_IND	CRM_SUB_TERR_IND	CHAR	1	0	Indicator: Include Subterritories in Territory Search

History

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