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
⤷ 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 |