SAP ABAP Table SMOOPMTRNS (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	SMOOPMTRNS	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	PROSPECT	☐	SMO_SFAKN1	SMO_GUID	CHAR	32	0	SFA Key of Business Partner
8	BPARTNER	☐	SMOBWPRTNR	SMOBWPRTNR	CHAR	10	0	Business Partner Number
9	CPTYPE	☐	SMOCPTYPE	CHAR3	CHAR	3	0	Customer or Prospect?
10	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
11	CALMONTH	☐	SMOCALMON	SMOCALMON	NUMC	6	0	Calendar Month
12	CALYEAR	☐	SMOCALYEAR	SMOCALYEAR	NUMC	4	0	Calendar Year
13	WRTTP	☐	SMOWRTTP	SMOWRTTP	NUMC	3	0	Value Type
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	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
20	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
21	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	*
22	KVMARKT	☐	SMO_MARKET	SMO_TXT4	CHAR	4	0	Market of Partner
23	ACCNTGRP	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	*
24	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	*
25	SFAPCPROMO	☐	SMO_SFAPMO	SMO_GUID	CHAR	32	0	SFA Key of the Promotion
26	SFAPCCAMPN	☐	SMO_SFACPN	SMO_GUID	CHAR	32	0	SFA KEY of the Campaign

History

Last changed by/on	SAP	20130604
SAP Release Created in