SAP ABAP Table SMOOPMTRN2 (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	SMOOPMTRN2	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	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
3	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
4	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
5	SPART	☐	SPART	SPART	CHAR	2	0	Division
6	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
7	BPARTNER	☐	SMOBWPRTNR	SMOBWPRTNR	CHAR	10	0	Business Partner Number
8	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
9	CALMONTH	☐	SMOCALMON	SMOCALMON	NUMC	6	0	Calendar Month
10	CALYEAR	☐	SMOCALYEAR	SMOCALYEAR	NUMC	4	0	Calendar Year
11	WRTTP	☐	SMOWRTTP	SMOWRTTP	NUMC	3	0	Value Type
12	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
13	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
14	AMOUNT	☐	SMOOPPMQ		QUAN	15	3	Number of Opportunities (Material Level)
15	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
16	VALUE	☐	SMO_VLUE	SMO_CURRCY	CURR	28	9	Monetary Volume in Currency
17	PROB	☐	SMO_PROB	SMO_NUM3	DEC	3	0	Probability
18	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
19	SFAPCPROMO	☐	SMO_SFAPMO	SMO_GUID	CHAR	32	0	SFA Key of the Promotion
20	SFAPCCAMPN	☐	SMO_SFACPN	SMO_GUID	CHAR	32	0	SFA KEY of the Campaign
21	CANCELFLG	☐	SMOBWSTRNO		CHAR	1	0	BWA: Reversal Record Indicator
22	EMPLOYEE	☐	SMOXPERSNR		NUMC	8	0	Employee

History

Last changed by/on	SAP	20130604
SAP Release Created in