SAP ABAP Table CRMS_E2C_QUERY_OPP (Business Trns. IL Structure for Opportunity: Search Criteria)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF-E2C (Application Component) CRM on Email
     ⤷ CRM_EMAILTOCRM (Package) Exchange data with CRM backend using EMAIL technology

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_E2C_QUERY_OPP	Table Relationship Diagram
Short Description	Business Trns. IL Structure for Opportunity: 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	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
2	PROSPECT	☐	CRMT_PROSPECT	BU_PARTNER	CHAR	10	0	Prospect	*
3	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
4	CURR_PHASE	☐	CRMT_CURR_PHASE	CRM_PHASE	CHAR	3	0	Sales Stage	*
5	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
6	STATUS_AREA	☐	CRMT_STATUS_AREA_OIC	CRM_STATUS_AREA_OIC	CHAR	13	0	Status Area (All, Completed, Not Completed)
7	EMPLOYEE_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
8	COMPETITOR	☐	CRMT_BP_COMPETITOR	CRM_PARTNER_NUMBER	CHAR	20	0	Competitor
9	SALES_TEAM_MEMBER	☐	CRMT_BP_SLS_TEAM_MEMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Sales Team Member
10	PRODUCT_ID	☐	CRMT_PRODUCT_ID	CRM_ORDERED_PROD	CHAR	54	0	Product ID
11	OPP_TYPE	☐	CRMT_OPPORT_TYPE	CRM_OPPORT_TYPE	CHAR	4	0	Opportunity Type	*
12	OPP_SOURCE	☐	CRMT_SOURCE	CRM_SOURCE	CHAR	3	0	Origin of Opportunity/Lead	*
13	IMPORTANCE	☐	CRMT_IMPORTANCE	CRM_IMPORTANCE	CHAR	1	0	Opportunity/Lead Priority	*
14	CHANNEL_PARTNER	☐	CRMT_UIU_SALES_PARTNER	BU_PARTNER	CHAR	10	0	Sales Partner ID	*
15	RESP_CHAN_PARTNER	☐	CRMT_RESP_AT_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Responsible at Channel Partner	*
16	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
17	CAMPAIGN_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
18	CAMPAIGN_DES	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
19	COMPETITOR_NAME	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
20	PROSPECT_NAME	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
21	SALESTEAM_FIRSTNAME	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
22	SALESTEAM_LASTNAME	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
23	RESPONS_AREA	☐	CRMT_RESPONS_AREA_OIC	CRM_RESPONS_AREA_OIC	CHAR	1	0	Belonging To (Me, My Department, My Group)
24	LEAD_ID	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
25	LEAD_DES	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
26	VALID_FROM	☐	CRMT_DATES_START_DATE	DATUM	DATS	8	0	Start Date
27	CONTACT_PERSON	☐	CRMT_UIU_CONTACT_PARTY	CRM_PARTNER_NUMBER	CHAR	20	0	Contact
28	END_DATE_RANGE	☐	CRMT_EXPECT_END	DATUM	DATS	8	0	Expected Closing Date
29	TIMEFRAME	☐	CRMT_UIU_TIMEFRAME	CHAR40	CHAR	40	0	Timeframe (End Date Range)
30	CHANNEL_PARTNER_NAME	☐	CRMT_UIU_SALES_PARTNER_NAME	CHAR40	CHAR	40	0	Sales Partner Name
31	RESP_CHAN_PARTNER_FIRSTNAME	☐	CRMT_UIU_RESP_AT_CHAN_PART_FN	CHAR40	CHAR	40	0	Employee Resp. at Channel Partner First Name
32	RESP_CHAN_PARTNER_LASTNAME	☐	CRMT_UIU_RESP_AT_CHAN_PART_LN	CHAR40	CHAR	40	0	Employee Resp. at Channel Partner Last Name
33	EMPLOYEE_RESP_LASTNAME	☐	CRMT_UIU_EMPLOYEE_RESP_LASTNA	CHAR40	CHAR	40	0	Employee Responsible Last Name
34	EMPLOYEE_RESP_FIRSTNAME	☐	CRMT_UIU_EMPLOYEE_RESP_FIRSTNA	CHAR40	CHAR	40	0	Employee Responsible First Name
35	CONTACT_FIRSTNAME	☐	CRMT_UIU_CONTACT_FIRSTNAME	CHAR40	CHAR	40	0	Contact First Name
36	CONTACT_LASTNAME	☐	CRMT_UIU_CONTACT_LASTNAME	CHAR40	CHAR	40	0	Contact Last Name
37	PRODUCT_NAME	☐	CRMT_UIU_PRODUCT_NAME	CHAR40	CHAR	40	0	Product Name
38	DESCR_OPP_UC	☐	CRMT_DESCRIPTION_OPP_UC	TEXT40	CHAR	40	0	Opportunity Description in UC
39	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
40	BU_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
41	OEM_END_CUST	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
42	OEM_PROJECT_OWNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
43	OEM_PURCHASE_CONT	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
44	ASSEMBLY_OWNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
45	DESIGN_HOUSE	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
46	OEM_DESIGN_IN_LOC	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
47	PROJECT_OWNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
48	DISTRIBUTOR	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
49	DISTR_LOC	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
50	APPROVER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
51	VALIDATOR	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
52	OWNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
53	FIELD_APPL_ENGINEER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
54	CATEGORY_ID	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
55	PARTNER_COMB	☐	CRMT_UIU_PARTNER_TO_PARTNERFCT	CHAR40	CHAR	40	0	Partner In Partner Function
56	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
57	TERR_DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
58	.INCLUDE	☐				0	0	EEW Include
59	EEW_BUS2000111_SEARCH_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
60	.INCLUDE	☐				0	0

History

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