SAP ABAP Table BTOP_OPPT_CRMBY_ELE_QUERYFOROP (Proxy Structure (generated))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-OPP (Application Component) Opportunities
     ⤷ CRM_BT_OPPT_XI_PROXY (Package) Opportunity Bundle

Basic Data

Table Category	INTTAB	Structure
Structure	BTOP_OPPT_CRMBY_ELE_QUERYFOROP	Table Relationship Diagram
Short Description	Proxy Structure (generated)

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	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
2	BUDGET_PROSPECT	☐	CRMSEF_PARTY_ID		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	SCHEME_ID	☐			CHAR	60	0
5	SCHEME_AGENCY_ID	☐			CHAR	60	0
6	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
7	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
8	CONTENT	☐	CRMSEF_PARTY_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
9	CHANGEDON	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
10	COMPETITOR_ID	☐	CRMSEF_PARTY_ID		STRU	0	0
11	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
12	SCHEME_ID	☐			CHAR	60	0
13	SCHEME_AGENCY_ID	☐			CHAR	60	0
14	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
15	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
16	CONTENT	☐	CRMSEF_PARTY_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
17	MAIN_COMPETITOR	☐	CRMSEF_LANGUAGEINDEPENDENT_LON		CHAR	80	0	Proxy Data Element (Generated)
18	USER_STATUS	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
19	CONTACT_PERSON_ID	☐	CRMSEF_PARTY_ID		STRU	0	0
20	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
21	SCHEME_ID	☐			CHAR	60	0
22	SCHEME_AGENCY_ID	☐			CHAR	60	0
23	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
24	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
25	CONTENT	☐	CRMSEF_PARTY_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
26	MAIN_CONTACT	☐	CRMSEF_LANGUAGEINDEPENDENT_LON		CHAR	80	0	Proxy Data Element (Generated)
27	CREATED_ON	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
28	CURRENCY	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
29	SALES_STAGE	☐	CRMSEF_SALES_CYCLE_PHASE_STEP1		STRU	0	0
30	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
31	LIST_ID	☐			CHAR	60	0
32	LIST_VERSION_ID	☐			CHAR	15	0
33	LIST_AGENCY_ID	☐			CHAR	60	0
34	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
35	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
36	CONTENT	☐	CRMSEF_SALES_CYCLE_PHASE_STEP		CHAR	3	0	GDT for Sales Cycle Phase Step Code
37	DESCRIPTION	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
38	OPPORTUNITY_DESCRIPTION	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
39	CLOSING_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
40	EXP_REVENUE	☐	CRMSEF_AMOUNT		STRU	0	0
41	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
42	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
43	CONTENT	☐	CRMSEF_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (Generated)
44	FORECAST_REL	☐	CRMSEF_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has ex
45	OBJECT_GUID	☐	CRMSEF_UUID		STRU	0	0
46	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
47	SCHEME_ID	☐			CHAR	60	0
48	SCHEME_AGENCY_ID	☐			CHAR	60	0
49	CONTENT	☐	CRMSEF_UUID_CONTENT		CHAR	36	0	Universally Unique Identifier
50	REASON	☐	CRMSEF_CUSTOMER_TRANSACTION_D2		STRU	0	0
51	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
52	LIST_ID	☐			CHAR	60	0
53	LIST_VERSION_ID	☐			CHAR	15	0
54	LIST_AGENCY_ID	☐			CHAR	60	0
55	AGENCY_SCHEME_ID	☐			CHAR	60	0
56	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
57	CONTENT	☐	CRMSEF_CUSTOMER_TRANSACTION_D3		CHAR	3	0	Proxy Data Element (generated)
58	PRIORITY	☐	CRMSEF_LANGUAGEINDEPENDENT_LON		CHAR	80	0	Proxy Data Element (Generated)
59	NET_VALUE_MAN	☐	CRMSEF_AMOUNT		STRU	0	0
60	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
61	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
62	CONTENT	☐	CRMSEF_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (Generated)
63	ID	☐	CRMSEF_BUSINESS_TRANSACTION_D1		STRU	0	0
64	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
65	SCHEME_ID	☐			CHAR	60	0
66	SCHEME_AGENCY_ID	☐			CHAR	60	0
67	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
68	CONTENT	☐	CRMSEF_BUSINESS_TRANSACTION_DO		CHAR	35	0	Proxy Data Element (Generated)
69	OBJECT_KEY	☐	CRMSEF_LANGUAGEINDEPENDENT_TEX		STRG	0	0	Proxy Data Element (generated)
70	EMPLOYEE_RESPONSIBLE	☐	CRMSEF_PARTY_ID		STRU	0	0
71	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
72	SCHEME_ID	☐			CHAR	60	0
73	SCHEME_AGENCY_ID	☐			CHAR	60	0
74	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
75	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
76	CONTENT	☐	CRMSEF_PARTY_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
77	PERSON_RESPONSIBLE	☐	CRMSEF_LANGUAGEINDEPENDENT_MED		CHAR	40	0	Description
78	STAGE_SINCE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
79	CHANCEOF_SUCCESS	☐	CRMSEF_NUMBER_VALUE		INT4	10	0	Proxy Data Element (Generated)
80	TYPE	☐	CRMSEF_BUSINESS_TRANSACTION_D3		CHAR	4	0	Processing Type Code
81	PROCESS_TYPE_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_LON		CHAR	80	0	Proxy Data Element (Generated)
82	PROSPECT	☐	CRMSEF_PARTY_ID		STRU	0	0
83	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
84	SCHEME_ID	☐			CHAR	60	0
85	SCHEME_AGENCY_ID	☐			CHAR	60	0
86	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
87	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
88	CONTENT	☐	CRMSEF_PARTY_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
89	SALES_PROSPECT	☐	CRMSEF_LANGUAGEINDEPENDENT_LON		CHAR	80	0	Proxy Data Element (Generated)
90	RESPONSIBLE_AT_PARTNER	☐	CRMSEF_PARTY_ID		STRU	0	0
91	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
92	SCHEME_ID	☐			CHAR	60	0
93	SCHEME_AGENCY_ID	☐			CHAR	60	0
94	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
95	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
96	CONTENT	☐	CRMSEF_PARTY_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
97	EMPLOYEE_RESP_AT_CHANNEL_PAR	☐	CRMSEF_LANGUAGEINDEPENDENT_LON		CHAR	80	0	Proxy Data Element (Generated)
98	SALES_CYCLE	☐	CRMSEF_SALES_CYCLE_PHASE_STEP1		STRU	0	0
99	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
100	LIST_ID	☐			CHAR	60	0
101	LIST_VERSION_ID	☐			CHAR	15	0
102	LIST_AGENCY_ID	☐			CHAR	60	0
103	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
104	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
105	CONTENT	☐	CRMSEF_SALES_CYCLE_PHASE_STEP		CHAR	3	0	GDT for Sales Cycle Phase Step Code
106	SALESPARTNER_ID	☐	CRMSEF_PARTY_ID		STRU	0	0
107	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
108	SCHEME_ID	☐			CHAR	60	0
109	SCHEME_AGENCY_ID	☐			CHAR	60	0
110	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
111	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
112	CONTENT	☐	CRMSEF_PARTY_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
113	CHANNEL_PARTNER	☐	CRMSEF_PARTY_ID		STRU	0	0
114	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
115	SCHEME_ID	☐			CHAR	60	0
116	SCHEME_AGENCY_ID	☐			CHAR	60	0
117	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
118	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
119	CONTENT	☐	CRMSEF_PARTY_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
120	ORIGIN	☐	CRMSEF_CUSTOMER_TRANSACTION_D1		STRU	0	0
121	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
122	LIST_ID	☐			CHAR	60	0
123	LIST_VERSION_ID	☐			CHAR	15	0
124	LIST_AGENCY_ID	☐			CHAR	60	0
125	AGENCY_SCHEME_ID	☐			CHAR	60	0
126	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
127	CONTENT	☐	CRMSEF_CUSTOMER_TRANSACTION_DO		CHAR	3	0	Proxy Data Element (generated)
128	ORIGIN_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_LON		CHAR	80	0	Proxy Data Element (Generated)
129	START_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
130	STATUS	☐	CRMSEF_OPPORTUNITY_LIFE_CYCLE		CHAR	2	0	Proxy Data Element (generated)
131	STATUS_SINCE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
132	CALCULATED_CHANCE	☐	CRMSEF_NUMBER_VALUE		INT4	10	0	Proxy Data Element (Generated)
133	OPPORTUNITY_GROUP	☐	CRMSEF_OPPORTUNITY_GROUP_CODE1		STRU	0	0
134	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
135	LIST_ID	☐			CHAR	60	0
136	LIST_VERSION_ID	☐			CHAR	15	0
137	LIST_AGENCY_ID	☐			CHAR	60	0
138	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
139	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
140	CONTENT	☐	CRMSEF_OPPORTUNITY_GROUP_CODE		CHAR	4	0	GDT for Opportunity Groups
141	OPPORTUNITY_GROUP_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_LON		CHAR	80	0	Proxy Data Element (Generated)
142	VALID_FROM	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
143	END_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)

History

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