SAP ABAP View SMOOPPGV2 (View Opportunities (G))

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	SMOOPPGV2
Short Description	View Opportunities (G)
Root table	SMOOBJEKT	Opportunity

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SMOOBJEKT	SMOOBJEKT
2	SMOKVBEZ9
3	SMOKNA1
4	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	SMOKVBEZ9	MANDT	JL	EQ				0	0
4	SMOKNA1	MANDT	JR	EQ			AND	0	0
5	SMOOBJEKT	SFAOBJEKT	JL	EQ				0	0
6	SMOKVBEZ9	SFAOBJEKT	JR	EQ			AND	0	0
7	SMOKVBEZ9	SFAKNA1	JL	EQ				0	0
8	SMOKNA1	SFAKNA1	JR	EQ			AND	0	0
9	SMOKVBEZ9	MANDT	JL	EQ				0	0
10	SMOKVBEZTP	MANDT	JR	EQ			AND	0	0
11	SMOKVBEZ9	SFAKVBEZTP	JL	EQ				0	0
12	SMOKVBEZTP	SFAKVBEZTP	JR	EQ			AND	0	0
13	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	SFAOBJEKT	SMOOBJEKT	SFAOBJEKT		☐	SMO_SFAOBJ	☐	SFA Key of Opportunity
3	KEYSFAKNA1	SMOKNA1	SFAKNA1		☐	SMO_SFAKN1	☐	SFA Key of Business Partner
4	REC_PROP	SMOKVBEZTP	REC_PROP		☐	SMO_RECPRP	☐	Record Property
5	SFAKVBEZTP	SMOKVBEZTP	SFAKVBEZTP		☐	SMO_SFAZTP	☐	SFA Key of Relation Type
6	SFAKVBEZ9	SMOKVBEZ9	SFAKVBEZ9		☐	SMO_SFAZ09	☐	SFA Key of Interlinkage Customer-Opportunity (SMOKVBEZ9)
7	VKORG	SMOOBJEKT	VKORG		☐	SMO3VKORG	☐	Sales organization
8	VTWEG	SMOOBJEKT	VTWEG		☐	SMO3VTWEG	☐	Distribution channel
9	SPART	SMOOBJEKT	SPART		☐	SMO3SPART	☐	Division
10	VKBUR	SMOOBJEKT	VKBUR		☐	SMO3VKBUR	☐	Sales office
11	OBJNUM	SMOOBJEKT	OBJNUM		☐	SMO_OBJNUM	☐	Project Number
12	LAND1	SMOOBJEKT	LAND1		☐	LAND1	☐	Country Key
13	REGIO	SMOOBJEKT	REGIO		☐	REGIO	☐	Region (State, Province, County)
14	SFAKNA1	SMOKVBEZ9	SFAKNA1		☐	SMO_SFAKN1	☐	SFA Key of Business Partner
15	KUNNR	SMOKVBEZ9	KUNNR		☐	SMO3KUNNR	☐	Customer number
16	BRSCH	SMOKNA1	BRSCH		☐	SMO3BRSCH	☐	Industry key
17	KUKLA	SMOKNA1	KUKLA		☐	SMO3KUKLA	☐	Customer classification
18	KVMARKT	SMOKNA1	KVMARKT		☐	SMO_MARKET	☐	Market of Partner
19	BEGIN_	SMOOBJEKT	BEGIN_		☐	SMO_BEGIN_	☐	Start date of opportunity
20	END_	SMOOBJEKT	END_		☐	SMO_END_	☐	End date of Opportunity
21	POTENT	SMOOBJEKT	POTENT		☐	SMO_POTENT	☐	Potential
22	TOTPOT	SMOOBJEKT	TOTPOT		☐	SMO_TOTPO	☐	Overall Potential
23	POTENT2	SMOOBJEKT	POTENT2		☐	SMO_POTEN2	☐	Own Opp. Potential
24	AMOUNT	SMOOBJEKT	AMOUNT		☐	SMO_AMOUNT	☐	AMOUNT
25	MEINS	SMOOBJEKT	MEINS		☐	SMO3MEINS	☐	Base unit of measure
26	SFAPCCAMPN	SMOOBJEKT	SFAPCCAMPN		☐	SMO_SFACPN	☐	SFA KEY of the Campaign
27	SOURCE	SMOOBJEKT	SOURCE		☐	SMO_SOURCE	☐	Source of an object
28	BZIRK	SMOOBJEKT	BZIRK		☐	SMO3BZIRK	☐	Sales district
29	VKGRP	SMOOBJEKT	VKGRP		☐	SMO3VKGRP	☐	Sales group
30	KUNAME	SMOOBJEKT	KUNAME		☐	SMO_KUNAME	☐	Short Name for Opportunity
31	REFER	SMOOBJEKT	REFER		☐	SMO_REFER	☐	HT: This is a reference Opportunity (T/F)
32	OBJART	SMOOBJEKT	OBJART		☐	SMO_OBJART	☐	Object/Opportunity Type
33	OBJTYP	SMOOBJEKT	OBJTYP		☐	SMO_OBJTYP	☐	Object/Opportunity Sub-Type
34	NAME1	SMOOBJEKT	NAME1		☐	SMO_NAME1	☐	Name 1 of Opportunity
35	NAME2	SMOOBJEKT	NAME2		☐	SMO_NAME2	☐	Name 2 of Opportunity
36	STARS	SMOOBJEKT	STRAS		☐	AD_STREET	☐	Street
37	PSTLZ	SMOOBJEKT	PSTLZ		☐	SMO3PSTLZ	☐	Zip code
38	ORT01	SMOOBJEKT	ORT01		☐	AD_CITY1	☐	City
39	ORT02	SMOOBJEKT	ORT02		☐	SMO_ORT02	☐	HT district
40	VERGAB	SMOOBJEKT	VERGAB		☐	SMO_VERGAB	☐	Submission date
41	KVORIGIN	SMOOBJEKT	KVORIGIN		☐	SMO_ORIGIN	☐	Source of opportunity
42	BAUVOL	SMOOBJEKT	BAUVOL		☐	SMO_BAUVOL	☐	Total volume in Currency
43	WAER1	SMOOBJEKT	WAER1		☐	SMO3WAERS	☐	Currency key
44	BAUVOL2	SMOOBJEKT	BAUVOL2		☐	SMO_BAUVO2	☐	Total volume in currency 2
45	WAER2	SMOOBJEKT	WAER2		☐	SMO3WAERS	☐	Currency key
46	AUSSCH	SMOOBJEKT	AUSSCH		☐	SMO_AUSSCH	☐	HT date of announcement
47	LIEFER	SMOOBJEKT	LIEFER		☐	SMO_LIEFER	☐	Date of delivery
48	ERGEBN	SMOOBJEKT	ERGEBN		☐	SMO_ERGEBN	☐	Result
49	ERGEBG	SMOOBJEKT	ERGEBG		☐	SMO_ERGEBG	☐	Reason for result
50	CHANCE	SMOOBJEKT	CHANCE		☐	SMO_CHANCE	☐	Own probability
51	TOCHA	SMOOBJEKT	TOCHA		☐	SMO_TOCHA	☐	Probability of opportunity
52	CLASSI	SMOOBJEKT	CLASSI		☐	SMO_CLASSI	☐	Opportunity Class
53	PHASE	SMOOBJEKT	PHASE		☐	SMO_PHASE	☐	Funnel Phase
54	INACTIVE	SMOOBJEKT	INACTIVE		☐	SMO_INACTI	☐	Inactive (T/F)
55	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