SAP ABAP Table SMOOPHTRN2 (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	SMOOPHTRN2	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	BPARTNER	☐	SMOBWPRTNR	SMOBWPRTNR	CHAR	10	0	Business Partner Number
7	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
8	CALMONTH	☐	SMOCALMON	SMOCALMON	NUMC	6	0	Calendar Month
9	CALYEAR	☐	SMOCALYEAR	SMOCALYEAR	NUMC	4	0	Calendar Year
10	WRTTP	☐	SMOWRTTP	SMOWRTTP	NUMC	3	0	Value Type
11	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
12	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
13	SFAPCPROMO	☐	SMO_SFAPMO	SMO_GUID	CHAR	32	0	SFA Key of the Promotion
14	SFAPCCAMPN	☐	SMO_SFACPN	SMO_GUID	CHAR	32	0	SFA KEY of the Campaign
15	POTENT	☐	SMO_POTENT	SMO_CURRCY	CURR	28	9	Potential
16	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
17	TOCHA	☐	SMO_TOCHA	SMO_NUM3	DEC	3	0	Probability of opportunity
18	OPP_AGE	☐	SMOOPP_AGE	SMOOPP_AGE	INT4	10	0	Age of the Opportunity
19	REFER	☐	SMO_REFER	SMO_LOGICL	CHAR	1	0	HT: This is a reference Opportunity (T/F)
20	OBJTYP	☐	SMO_OBJTYP	SMO_TXT4	CHAR	4	0	Object/Opportunity Sub-Type
21	CLASSI	☐	SMO_CLASSI	SMO_TEXT1	CHAR	1	0	Opportunity Class
22	OBJART	☐	SMO_OBJART	SMO_TXT4	CHAR	4	0	Object/Opportunity Type
23	BEGIN_	☐	SMO_BEGIN_	SMO_DATE	DATS	8	0	Start date of opportunity
24	END_	☐	SMO_END_	SMO_DATE	DATS	8	0	End date of Opportunity
25	PHASE	☐	SMO_PHASE	SMO_TXT3	CHAR	3	0	Funnel Phase
26	NOOPP	☐	SMONOOPP	SMOCOUNTER	DEC	9	0	Number of Opportunities
27	ERGEBN	☐	SMO_ERGEBN	SMO_TXT3	CHAR	3	0	Result
28	ERGEBG	☐	SMO_ERGEBG	SMO_TXT3	CHAR	3	0	Reason for result
29	CANCELFLG	☐	SMOBWSTRNO		CHAR	1	0	BWA: Reversal Record Indicator
30	EMPLOYEE	☐	SMOXPERSNR		NUMC	8	0	Employee

History

Last changed by/on	SAP	20130604
SAP Release Created in