SAP ABAP Table SMOOPPGV (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SMOOPPGV	Table Relationship Diagram
Short Description	Generated Table for View

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

History

Last changed by/on	SAP	20140117
SAP Release Created in