SAP ABAP Table /CRMWST/OPP007ROSOPPORTUNIT001 (OPPORTUNITYBYID_I)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF-WST (Application Component) Web Services Tool
     ⤷ /CRMWST/GEN (Package) Generated Objects for CRM Web Service Tool

Basic Data

Table Category	INTTAB	Structure
Structure	/CRMWST/OPP007ROSOPPORTUNIT001	Table Relationship Diagram
Short Description	OPPORTUNITYBYID_I

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	OPPORTUNITYBYID_I	☐	/CRMWST/OPP007ROSBTORDER		STRU	0	0
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	CRM_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
5	ADMINISTRATIVEHEADEROFORDER	☐	/CRMWST/OPP007ROSBTORDERHEA005		STRU	0	0
6	OBJECT_ID	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
7	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE_DB	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type
8	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client
9	DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
10	GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
11	DATESOFHEADER	☐	/CRMWST/OPP007ROSBTHEADERDA001		STRU	0	0
12	CRM_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
13	BTDATESALLCUST_OPPORTUNITY	☐	/CRMWST/OPP007ROTBTDATESALL001		TTYP	0	0
14	BTDATE_T_ACTACTPLN	☐	/CRMWST/OPP007ROSBTDATE_T_A001		STRU	0	0
15	REF_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
16	APPT_TYPE	☐	CRMT_APPTYPE	SC_APPTTYP	CHAR	12	0	Technical Name for Date Type
17	IS_DURATION	☐			CHAR	5	0
18	TIMESTAMP_FROM	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
19	TIMESTAMP_TO	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
20	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
21	ACTUALORDERDATE	☐	/CRMWST/OPP007ROSBTDATE_T_O001		STRU	0	0
22	REF_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
23	APPT_TYPE	☐	CRMT_APPTYPE	SC_APPTTYP	CHAR	12	0	Technical Name for Date Type
24	IS_DURATION	☐			CHAR	5	0
25	DOMINANT	☐	CRMT_DATES_DOMINANT	CRM_DATES_DOMINANT	CHAR	1	0	All Day Event
26	TIMESTAMP_FROM	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
27	TIMESTAMP_TO	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
28	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
29	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
30	TRANSACTIONHISTORYOFHEADER	☐	/CRMWST/OPP007ROSBTHEADERDO001		STRU	0	0
31	CRM_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
32	BTDOCFLOWINTERACTHIST	☐	/CRMWST/OPP007ROTBTDOCFLOWI001		TTYP	0	0
33	BTDOCFLOWPLANNEDACIVITIES	☐	/CRMWST/OPP007ROTBTDOCFLOWP001		TTYP	0	0
34	BTDOCFLOWCOMPLETEDACTIVITIES	☐	/CRMWST/OPP007ROTBTDOCFLOWC001		TTYP	0	0
35	BTDOCFLOWSUBOPPT	☐	/CRMWST/OPP007ROTBTDOCFLOWS001		TTYP	0	0
36	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
37	ITEMSOFHEADER	☐	/CRMWST/OPP007ROSBTHEADERIT002		STRU	0	0
38	CRM_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
39	BTORDERITEMALLNOCOMPITEMS	☐	/CRMWST/OPP007ROTBTORDERITE002		TTYP	0	0
40	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
41	PARTIESINVOLVEDOFHEADER	☐	/CRMWST/OPP007ROSBTHEADERPA004		STRU	0	0
42	CRM_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
43	ALLSALESTEAMS	☐	/CRMWST/OPP007ROTBTPARTNERS001		TTYP	0	0
44	ALLBUYINGCENTERS	☐	/CRMWST/OPP007ROTBTPARTNERB001		TTYP	0	0
45	ALLOPPORTUNITIES	☐	/CRMWST/OPP007ROTBTPARTNERO001		TTYP	0	0
46	BTPARTNERCOMPETITORS	☐	/CRMWST/OPP007ROTBTPARTNERC001		TTYP	0	0
47	BTPARTNER_PFT_0027_MAIN	☐	/CRMWST/OPP007ROSBTPARTNER_007		STRU	0	0
48	REF_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
49	REF_PARTNER_HANDLE	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
50	REF_PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
51	REF_PARTNER_NO	☐	CRMT_PARTNER_NUMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Use Outside Partner Processing
52	REF_NO_TYPE	☐	CRMT_PARTNER_NO_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Partner Number Type (e.g. GUID, Pers. No., ...), Internal
53	REF_DISPLAY_TYPE	☐	CRMT_PARTNER_DISPLAY_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Object Type, for Which Partner Number is to be Shown
54	PARTNER_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
55	BTPARTNERCUSTRELATIONS	☐	/CRMWST/OPP007ROTBTPARTNERC002		TTYP	0	0
56	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
57	BTPARTNER_PFT_0006_MAIN	☐	/CRMWST/OPP007ROSBTPARTNER_004		STRU	0	0
58	REF_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
59	REF_PARTNER_HANDLE	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
60	REF_PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
61	REF_PARTNER_NO	☐	CRMT_PARTNER_NUMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Use Outside Partner Processing
62	REF_NO_TYPE	☐	CRMT_PARTNER_NO_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Partner Number Type (e.g. GUID, Pers. No., ...), Internal
63	REF_DISPLAY_TYPE	☐	CRMT_PARTNER_DISPLAY_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Object Type, for Which Partner Number is to be Shown
64	PARTNER_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
65	ADDRESS_SHORT	☐	AD_LINE_S	CHAR80	CHAR	80	0	One-line short form of formatted address
66	PARTNER_NO	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
67	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
68	BTPARTNER_PFT_0007_MAIN	☐	/CRMWST/OPP007ROSBTPARTNER_005		STRU	0	0
69	REF_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
70	REF_PARTNER_HANDLE	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
71	REF_PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
72	REF_PARTNER_NO	☐	CRMT_PARTNER_NUMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Use Outside Partner Processing
73	REF_NO_TYPE	☐	CRMT_PARTNER_NO_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Partner Number Type (e.g. GUID, Pers. No., ...), Internal
74	REF_DISPLAY_TYPE	☐	CRMT_PARTNER_DISPLAY_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Object Type, for Which Partner Number is to be Shown
75	PARTNER_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
76	PARTNER_NO	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
77	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
78	BTPARTNER_PFT_0008_MAIN	☐	/CRMWST/OPP007ROSBTPARTNER_006		STRU	0	0
79	REF_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
80	REF_PARTNER_HANDLE	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
81	REF_PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
82	REF_PARTNER_NO	☐	CRMT_PARTNER_NUMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Use Outside Partner Processing
83	REF_NO_TYPE	☐	CRMT_PARTNER_NO_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Partner Number Type (e.g. GUID, Pers. No., ...), Internal
84	REF_DISPLAY_TYPE	☐	CRMT_PARTNER_DISPLAY_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Object Type, for Which Partner Number is to be Shown
85	PARTNER_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
86	PARTNER_NO	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
87	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
88	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
89	STATUSOFHEADER	☐	/CRMWST/OPP007ROSBTHEADERST004		STRU	0	0
90	CRM_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
91	CURRENTSTATUSOFHEADER	☐	/CRMWST/OPP007ROSBTSTATUSHC004		STRU	0	0
92	REF_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
93	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
94	USER_STAT_PROC	☐	CRM_J_STSMA	CRM_J_STSMA	CHAR	8	0	Status Profile
95	ACT_STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
96	TXT30	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
97	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
98	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
99	REFOBJANDSUBJOFHEADER	☐	/CRMWST/OPP007ROSBTHEADERBO001		STRU	0	0
100	CRM_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
101	STATUSREASONFOROPPORTUNITY	☐	/CRMWST/OPP007ROSBTSUBJECTS001		STRU	0	0
102	SUBJECT_PROFILE	☐	CRMT_SUBJECT_PROFILE	CRM_SUBJECT_PROFILE	CHAR	9	0	Subject Profile
103	GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
104	PROFILE_TYPE	☐	CRMT_SUBJECT_PROFILE_TYPE	CRM_SUBJECT_PROFILE_TYPE	CHAR	2	0	Subject Profile Category
105	ALLSUBJECTS	☐	/CRMWST/OPP007ROTBTSUBJECTA001		TTYP	0	0
106	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
107	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
108	BTHEADERTEXTSET	☐	/CRMWST/OPP007ROSBTHEADERTE001		STRU	0	0
109	CRM_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
110	BTTEXTHFIRSTCHANGEABLE	☐	/CRMWST/OPP007ROSBTTEXTHFIR001		STRU	0	0
111	REF_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
112	TDID	☐	TDID	TDID	CHAR	4	0	Text ID
113	TDSPRAS	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
114	TDNAME	☐	TDOBNAME	TDOBNAME	CHAR	70	0	Name
115	CONC_LINES	☐	CRMDT_CONC_TEXTLINES		STRG	0	0	Concatenated Text Lines
116	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
117	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
118	ACTIVITYOFHEADER	☐	/CRMWST/OPP007ROSBTHEADERAC004		STRU	0	0
119	GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
120	CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)
121	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority
122	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
123	CUMULATEDVALUESOFHEADER	☐	/CRMWST/OPP007ROSBTHEADERCU001		STRU	0	0
124	GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
125	NET_VALUE_MAN	☐	CRMT_NET_VALUE_MAN_CUM	WERTV8	CURR	15	2	Expected Total Net Value of Products in Document Currency
126	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
127	BTHEADEROPPORTUNITYEXT	☐	/CRMWST/OPP007ROSBTHEADEROP002		STRU	0	0
128	GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
129	CURR_PHASE	☐	CRMT_CURR_PHASE	CRM_PHASE	CHAR	3	0	Sales Stage
130	EXPECT_END	☐	CRMT_EXPECT_END	DATUM	DATS	8	0	Expected Closing Date
131	EXP_REVENUE	☐	CRMT_REPORT_EXP_REVENUE	WERTV8	CURR	15	2	Expected Sales Revenue
132	EXP_WEIGHTED_REVENUE	☐	CRMT_EXP_WEIGHTED_REVENUE	WERTV8	CURR	15	2	Expected Weighted Sales Volume
133	IMPORTANCE	☐	CRMT_IMPORTANCE	CRM_IMPORTANCE	CHAR	1	0	Opportunity/Lead Priority
134	PROBABILITY	☐	CRMT_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Chance of Success
135	SOURCE	☐	CRMT_SOURCE	CRM_SOURCE	CHAR	3	0	Origin of Opportunity/Lead
136	STARTDATE	☐	CRMT_STARTDATE	DATUM	DATS	8	0	Opportunity Start Date
137	SYS_PROBABILITY	☐	CRMT_SYSTEM_PROBABILITY	CRM_SYSTEM_PROBABILITY	NUMC	3	0	Chance of Success of Opportunity - Calculated by System
138	TYPE	☐	CRMT_OPPORT_TYPE	CRM_OPPORT_TYPE	CHAR	4	0	Opportunity Type
139	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
140	ORGANIZATIONALDATAOFHEADER	☐	/CRMWST/OPP007ROSBTHEADEROR001		STRU	0	0
141	REF_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
142	SERVICE_ORG_SHORT	☐	CRMT_SERVICE_ORG_SHORT	TEXT12	CHAR	12	0	Service Organization Identifier
143	SERVICE_ORG_RESP_SHORT	☐	CRMT_SERVICE_ORG_RESP_SHORT	TEXT12	CHAR	12	0	Abbreviation: Responsible Organizational Unit (Service)
144	SERVICE_ORG_RESP	☐	CRMT_SERVICE_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Service)
145	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
146	SALES_ORG_SHORT	☐	CRMT_SALES_ORG_SHORT	TEXT12	CHAR	12	0	Sales Organization: Description of Department
147	SALES_ORG_RESP_SHORT	☐	CRMT_SALES_ORG_RESP_SHORT	TEXT12	CHAR	12	0	Abbreviation: Responsible Organizational Unit (Sales)
148	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
149	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
150	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
151	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
152	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division
153	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel
154	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
155	BTHEADERPRICINGSET	☐	/CRMWST/OPP007ROSBTHEADERPR002		STRU	0	0
156	REF_GUID	☐	CRM_WST_UUID		CHAR	36	0	UUID CHAR 36 for Web Service Tool
157	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency
158	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
159	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
160	ENHANCEMENT_CONTAINER	☐	CRMT_WST_CONTAINER		TTYP	0	0
161	LOG	☐	CRMOST_LOG		STRU	0	0
162	CONTROLLER	☐	CRMT_BOL_ATT		TTYP	0	0
163	MAXIMUM_LOG_ITEM_SEVERITY_CODE	☐	CRMOST_SEVERITY_CODE		CHAR	1	0	SEVERITY CODE
164	ITEM	☐	CRMOST_LOG_ITEM_TAB		TTYP	0	0
165	PROCESSING_RESULT_CODE	☐	CRMOST_PROCESSING_RESULT_CODE	CRMOST_PROCESSING_RESULT_CODE	CHAR	2	0	Processing Result Code

History

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