SAP ABAP Table SMOOBJEKT (Opportunity)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA (Application Component) Mobile Sales
     ⤷ SMO3 (Package) Consolidated Database

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMOOBJEKT	Table Relationship Diagram
Short Description	Opportunity

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	SFAPCCAMPN	☐	SMO_SFACPN	SMO_GUID	CHAR	32	0	SFA KEY of the Campaign
4	SFAAOBJEKT	☐	SMO_SFAAOJ	SMO_GUID	CHAR	32	0	SFA key for related Object/Opportunity
5	SOURCE	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
6	VKORG	☐	SMO3VKORG	SMO3VKORG	CHAR	14	0	Sales organization
7	VTWEG	☐	SMO3VTWEG	SMO3VTWEG	CHAR	2	0	Distribution channel
8	SPART	☐	SMO3SPART	SMO3SPART	CHAR	2	0	Division
9	PHLINE	☐	SMO_PHLINE	SMO_TXT20	CHAR	20	0	Pharmaceutical: BU Line
10	BZIRK	☐	SMO3BZIRK	SMO3BZIRK	CHAR	6	0	Sales district
11	VKBUR	☐	SMO3VKBUR	SMO3VKBUR	CHAR	14	0	Sales office
12	VKGRP	☐	SMO3VKGRP	SMO3VKGRP	CHAR	14	0	Sales group
13	OBJNUM	☐	SMO_OBJNUM	SMO_TEXT32	CHAR	32	0	Project Number
14	KUNAME	☐	SMO_KUNAME	SMO_TEXT10	CHAR	10	0	Short Name for Opportunity
15	REFER	☐	SMO_REFER	SMO_LOGICL	CHAR	1	0	HT: This is a reference Opportunity (T/F)
16	OBJART	☐	SMO_OBJART	SMO_TXT4	CHAR	4	0	Object/Opportunity Type
17	OBJTYP	☐	SMO_OBJTYP	SMO_TXT4	CHAR	4	0	Object/Opportunity Sub-Type
18	NAME1	☐	SMO_NAME1	SMO_TXT40	CHAR	40	0	Name 1 of Opportunity
19	NAME2	☐	SMO_NAME2	SMO_TXT40	CHAR	40	0	Name 2 of Opportunity
20	STRAS	☐	AD_STREET	TEXT60	CHAR	60	0	Street
21	PSTLZ	☐	SMO3PSTLZ	PSTLZ	CHAR	10	0	Zip code
22	ORT01	☐	AD_CITY1	TEXT40	CHAR	40	0	City
23	ORT02	☐	SMO_ORT02	SMO_TXT40	CHAR	40	0	HT district
24	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
25	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
26	VERGAB	☐	SMO_VERGAB	SMO_DATE	DATS	8	0	Submission date
27	KVORIGIN	☐	SMO_ORIGIN	SMO_TXT3	CHAR	3	0	Source of opportunity
28	BAUVOL	☐	SMO_BAUVOL	SMO_CURRCY	CURR	28	9	Total volume in Currency
29	POTENT	☐	SMO_POTENT	SMO_CURRCY	CURR	28	9	Potential
30	TOTPOT	☐	SMO_TOTPO	SMO_CURRCY	CURR	28	9	Overall Potential
31	WAER1	☐	SMO3WAERS	WAERS	CUKY	5	0	Currency key	*
32	BAUVOL2	☐	SMO_BAUVO2	SMO_CURRCY	CURR	28	9	Total volume in currency 2
33	POTENT2	☐	SMO_POTEN2	SMO_CURRCY	CURR	28	9	Own Opp. Potential
34	TOTPOT2	☐	SMO_TOTP2	SMO_CURRCY	CURR	28	9	Overall Potential in alternative currency
35	WAER2	☐	SMO3WAERS	WAERS	CUKY	5	0	Currency key	*
36	AMOUNT	☐	SMO_AMOUNT	SMO_NUM12	DEC	12	2	AMOUNT
37	MEINS	☐	SMO3MEINS	MEINS	UNIT	3	0	Base unit of measure	*
38	BEGIN_	☐	SMO_BEGIN_	SMO_DATE	DATS	8	0	Start date of opportunity
39	END_	☐	SMO_END_	SMO_DATE	DATS	8	0	End date of Opportunity
40	AUSSCH	☐	SMO_AUSSCH	SMO_DATE	DATS	8	0	HT date of announcement
41	LIEFER	☐	SMO_LIEFER	SMO_DATE	DATS	8	0	Date of delivery
42	ERGEBN	☐	SMO_ERGEBN	SMO_TXT3	CHAR	3	0	Result
43	ERGEBG	☐	SMO_ERGEBG	SMO_TXT3	CHAR	3	0	Reason for result
44	CHANCE	☐	SMO_CHANCE	SMO_NUM3	DEC	3	0	Own probability
45	TOCHA	☐	SMO_TOCHA	SMO_NUM3	DEC	3	0	Probability of opportunity
46	CLASSI	☐	SMO_CLASSI	SMO_TEXT1	CHAR	1	0	Opportunity Class
47	PHASE	☐	SMO_PHASE	SMO_TXT3	CHAR	3	0	Funnel Phase
48	SFAPOSORG	☐	SMO_SFAPOG	SMO_GUID	CHAR	32	0	Position/ Org.Unit (GUID)
49	INACTIVE	☐	SMO_INACTI	SMO_LOGICL	CHAR	1	0	Inactive (T/F)
50	OWNER	☐	SMO_OWNERC	SMO_GUID	CHAR	32	0	User who created the object
51	FLAG1	☐	SMO_FLAG1	SMO_TEXT1	CHAR	1	0	Flag
52	NON_GUID	☐	SMO_NGUID	SMO_NGUID	DEC	1	0	Not Guided Record
53	.INCLUDE	☐				0	0	Record Modification Fields for Mobile Sales/Service
54	ERFASS	☐	SMO_CREATE	SMO_DATE	DATS	8	0	Date of Creation.
55	GEAEND	☐	SMO_MODIFY	SMO_DATE	DATS	8	0	Date last Modified
56	BEARB	☐	SMO_BEARB	SMO_BEARB	CHAR	15	0	Record Edited by User Name
57	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
58	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
59	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
60	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
61	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
62	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
63	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
64	ERRORFLAG	☐	SMO_ERRORF	SMO_TEXT1	CHAR	1	0	CRM Error flag
65	SALESCYLE	☐	SMO_SALESC	SMO_CHAR5	CHAR	5	0	Sales Cycle
66	LOG_SYSTEM	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
67	ARCHIVING	☐	SMO_ARCHIV	SMO_TEXT1	CHAR	1	0	Indicator whether this object can be archived
68	PHASE_SIN	☐	SMO_PHA_S	SMO_DATE	DATS	8	0	Opportunity Phase since
69	STATUS_SIN	☐	SMO_STAT_S	SMO_DATE	DATS	8	0	Status since
70	ADDR_NO	☐	SMO_ADR_NO	SMO_TEXT10	CHAR	10	0	Address Number
71	ADDR_NAME	☐	SMO_ADR_NA	SMO_TXT40	CHAR	40	0	Name of Address
72	CREATED_BY	☐	SMO_CRE_BY	SMO_TXT12	CHAR	12	0	Created by
73	STSMA	☐	SMO_STSMA	SMO_TXT8	CHAR	8	0	Status profile
74	STAT	☐	SMO_CRMSTA	SMO_TXT5	CHAR	5	0	Object status
75	KATALOGART	☐	SMO_KATAL	SMO_TEXT2	CHAR	2	0	Status reason: catalog
76	CODEGRUPPE	☐	SMO_CODEG	SMO_TXT8	CHAR	8	0	Status reason: code group
77	CODE	☐	SMO_CODE	SMO_TXT4	CHAR	4	0	Status reason: code
78	RESPVKORG	☐	SMO_RESVK	SMO3VKORG	CHAR	14	0	Responsible Organization unit
79	SOURCEC	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
80	MAXSTNO	☐	SMO_MAXSTNO	NUMC2	NUMC	2	0	Status Number of the Highest Status Reached
81	MAXSTATUS	☐	SMO_CRMSTA	SMO_TXT5	CHAR	5	0	Object status
82	PONUMBER	☐	CRMT_PO_NUMBER_SOLD	TEXT35	CHAR	35	0	Sold-To Party's External Reference Number
83	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
84	SERVICE_ORG_RESP	☐	CRMT_SERVICE_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Service)
85	SERVICE_GRP	☐	SMO3SERGRP	SMO3SERGRP	CHAR	14	0	Service Organization Group

History

Last changed by/on	SAP	20130604
SAP Release Created in