SAP ABAP View SMOOPPMV (View Opportunities (M))
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-ANA-EXT (Application Component) Extraction Technology
     SMOX_MAP (Package) Mapping objects from BW adapter
Basic Data
View Type D Database View 
Database View SMOOPPMV  
Short Description View Opportunities (M)    
Root table SMOOBJEKT   Opportunity 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 SMOOBJEKT SMOOBJEKT
2 SMOKVBEZ9  
3 SMOKVBEZ12  
4 SMOKNA1  
5 SMOPCCAMPN  
6 SMOKVBEZTP  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 SMOOBJEKT MANDT JL EQ 0 0
2 SMOKVBEZ9 MANDT JR EQ AND 0 0
3 SMOOBJEKT MANDT JL EQ 0 0
4 SMOKVBEZ12 MANDT JR EQ AND 0 0
5 SMOKVBEZ9 MANDT JL EQ 0 0
6 SMOKNA1 MANDT JR EQ AND 0 0
7 SMOOBJEKT SFAOBJEKT JL EQ 0 0
8 SMOKVBEZ9 SFAOBJEKT JR EQ AND 0 0
9 SMOOBJEKT SFAOBJEKT JL EQ 0 0
10 SMOKVBEZ12 SFAOBJEKT JR EQ AND 0 0
11 SMOKVBEZ9 SFAKNA1 JL EQ 0 0
12 SMOKNA1 SFAKNA1 JR EQ AND 0 0
13 SMOOBJEKT MANDT JL EQ 0 0
14 SMOPCCAMPN MANDT JR EQ AND 0 0
15 SMOOBJEKT SFAPCCAMPN JL EQ 0 0
16 SMOPCCAMPN SFAPCCAMPN JR EQ AND 0 0
17 SMOKVBEZ9 MANDT JL EQ 0 0
18 SMOKVBEZTP MANDT JR EQ AND 0 0
19 SMOKVBEZ9 SFAKVBEZTP JL EQ 0 0
20 SMOKVBEZTP SFAKVBEZTP JR EQ AND 0 0
21 SMOKVBEZTP RELTYP EQ '000024' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT SMOOBJEKT MANDT   MANDT Client
2 VKORG SMOOBJEKT VKORG   SMO3VKORG Sales organization
3 VTWEG SMOOBJEKT VTWEG   SMO3VTWEG Distribution channel
4 SPART SMOOBJEKT SPART   SMO3SPART Division
5 VKBUR SMOOBJEKT VKBUR   SMO3VKBUR Sales office
6 OBJNUM SMOOBJEKT OBJNUM   SMO_OBJNUM Project Number
7 LAND1 SMOOBJEKT LAND1   LAND1 Country Key
8 REGIO SMOOBJEKT REGIO   REGIO Region (State, Province, County)
9 SFAKNA1 SMOKVBEZ9 SFAKNA1   SMO_SFAKN1 SFA Key of Business Partner
10 KUNNR SMOKVBEZ9 KUNNR   SMO3KUNNR Customer number
11 MATNR SMOKVBEZ12 MATNR   SMO3PON CRM Product Order Number (PON)
12 AMOUNT SMOKVBEZ12 AMOUNT   SMO_SLEAMT Amount
13 MEINS SMOKVBEZ12 MEINS   SMO3MEINS Base unit of measure
14 VALUE SMOKVBEZ12 VALUE   SMO_VLUE Monetary Volume in Currency
15 CURR SMOKVBEZ12 CURR   SMO3WAERS Currency key
16 BRSCH SMOKNA1 BRSCH   SMO3BRSCH Industry key
17 KUKLA SMOKNA1 KUKLA   SMO3KUKLA Customer classification
18 KVMARKT SMOKNA1 KVMARKT   SMO_MARKET Market of Partner
19 SFAPCPROMO SMOPCCAMPN SFAPCPROMO   SMO_SFAPMO SFA Key of the Promotion
20 BEGIN_ SMOOBJEKT BEGIN_   SMO_BEGIN_ Start date of opportunity
21 END_ SMOOBJEKT END_   SMO_END_ End date of Opportunity
22 NON_GUID SMOKNA1 NON_GUID   SMO_NGUID Not Guided Record
23 PROB SMOKVBEZ12 PROB   SMO_PROB Probability
24 KTOKD SMOKNA1 KTOKD   SMO3KTOKD Customer account group
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20140117 
SAP Release Created in