SAP ABAP Table SMOOPHTRNS (Extract Structure Opportunities)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ANA-EXT (Application Component) Extraction Technology
     ⤷ SMOX_MAP (Package) Mapping objects from BW adapter

Basic Data

Table Category	INTTAB	Structure
Structure	SMOOPHTRNS	Table Relationship Diagram
Short Description	Extract Structure Opportunities

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	OBJNUM	☐	SMO_OBJNUM	SMO_TEXT32	CHAR	32	0	Project Number
2	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
3	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
4	SPART	☐	SPART	SPART	CHAR	2	0	Division
5	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
6	PROSPECT	☐	SMO_SFAKN1	SMO_GUID	CHAR	32	0	SFA Key of Business Partner
7	CPTYPE	☐	SMOCPTYPE	CHAR3	CHAR	3	0	Customer or Prospect?
8	BPARTNER	☐	SMOBWPRTNR	SMOBWPRTNR	CHAR	10	0	Business Partner Number
9	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
10	CALMONTH	☐	SMOCALMON	SMOCALMON	NUMC	6	0	Calendar Month
11	CALYEAR	☐	SMOCALYEAR	SMOCALYEAR	NUMC	4	0	Calendar Year
12	WRTTP	☐	SMOWRTTP	SMOWRTTP	NUMC	3	0	Value Type
13	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
14	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
15	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	*
16	KVMARKT	☐	SMO_MARKET	SMO_TXT4	CHAR	4	0	Market of Partner
17	ACCNTGRP	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	*
18	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	*
19	SFAPCPROMO	☐	SMO_SFAPMO	SMO_GUID	CHAR	32	0	SFA Key of the Promotion
20	POTENT	☐	SMO_POTENT	SMO_CURRCY	CURR	28	9	Potential
21	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
22	TOCHA	☐	SMO_TOCHA	SMO_NUM3	DEC	3	0	Probability of opportunity
23	OPP_AGE	☐	SMOOPP_AGE	SMOOPP_AGE	INT4	10	0	Age of the Opportunity
24	REFER	☐	SMO_REFER	SMO_LOGICL	CHAR	1	0	HT: This is a reference Opportunity (T/F)
25	OBJTYP	☐	SMO_OBJTYP	SMO_TXT4	CHAR	4	0	Object/Opportunity Sub-Type
26	CLASSI	☐	SMO_CLASSI	SMO_TEXT1	CHAR	1	0	Opportunity Class
27	OBJART	☐	SMO_OBJART	SMO_TXT4	CHAR	4	0	Object/Opportunity Type
28	BEGIN_	☐	SMO_BEGIN_	SMO_DATE	DATS	8	0	Start date of opportunity
29	END_	☐	SMO_END_	SMO_DATE	DATS	8	0	End date of Opportunity
30	PHASE	☐	SMO_PHASE	SMO_TXT3	CHAR	3	0	Funnel Phase
31	NOOPP	☐	SMONOOPP	SMOCOUNTER	DEC	9	0	Number of Opportunities
32	ERGEBN	☐	SMO_ERGEBN	SMO_TXT3	CHAR	3	0	Result
33	ERGEBG	☐	SMO_ERGEBG	SMO_TXT3	CHAR	3	0	Reason for result

History

Last changed by/on	SAP	20130604
SAP Release Created in