SAP ABAP Table SMOVBKA (Sales Activities)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMOVBKA	Table Relationship Diagram
Short Description	Sales Activities

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	SFAVBKA	☑	SMO_SFAACT	SMO_GUID	CHAR	32	0	SFA key of Activity Master (VBKA)
3	SOURCE	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
4	VBELN	☐	SMO3CAS_V	SMO3VBELN	CHAR	10	0	SD document no. of a sales activity in sales support
5	VKORG	☐	SMO3VKORG	SMO3VKORG	CHAR	14	0	Sales organization
6	VTWEG	☐	SMO3VTWEG	SMO3VTWEG	CHAR	2	0	Distribution channel
7	SPART	☐	SMO3SPART	SMO3SPART	CHAR	2	0	Division
8	VKBUR	☐	SMO3VKBUR	SMO3VKBUR	CHAR	14	0	Sales office
9	VKGRP	☐	SMO3VKGRP	SMO3VKGRP	CHAR	14	0	Sales group
10	KTAAR	☐	SMO3KTAAR	SMO3KTAAR	CHAR	4	0	Sales Activity Type for Sales Support
11	PRIVATE_	☐	SMO_PRIVAT	SMO_LOGICL	CHAR	1	0	Private (true/false)
12	KTABG	☐	SMO3KTABG	SMO3KTABG	DATS	8	0	Start of sales activity (date)
13	KTABT	☐	SMO3KTABT	SMO3KTABT	TIMS	6	0	Start of sales activity
14	KTAEN	☐	SMO3KTAEN	SMO3KTAEN	DATS	8	0	End of sales activity (date)
15	KTAET	☐	SMO3KTAET	SMO3KTAET	TIMS	6	0	End of sales activity (time)
16	KV_ACTDAT	☐	SMO_ACTDAT	SMO_DATE	DATS	8	0	Activity Date (Calender Assignment)
17	KTAGR	☐	SMO3KTAGR	SMO3KTAGR	CHAR	3	0	Reason for sales activity
18	KTAST	☐	SMO3KTAST	SMO3KTAST	CHAR	1	0	Status of sales activity
19	KTAER	☐	SMO3KTAER	SMO3KTAER	CHAR	3	0	Outcome of sales activities
20	KTAEB	☐	SMO3KTAEB	SMO3KTAEB	CHAR	3	0	Analysis of sales activity outcome
21	KTEXT	☐	SMO3KTEXT	TEXT40	CHAR	40	0	Short text for a sales activity
22	KV_PRIO	☐	SMO_PRIOAC	SMO_TEXT1	CHAR	1	0	Activity priority
23	KV_WDAY	☐	SMO_KVWDAY	SMO_LOGICL	CHAR	1	0	Flag: Activity lasts the whole day
24	KV_ACTFLAG	☐	SMO_ACTFLG	SMO_LOGICL	CHAR	1	0	Flag: Activity (T) or task (F)
25	RESREAS	☐	SMO_RESRAS	SMO_TXT3	CHAR	3	0	Reason for result
26	KV_OBJECT	☐	SMO_OBJTVE	SMO_OBJTVE	CHAR	4	0	Objective of activity
27	KUNNR	☐	SMO3KUNDE	SMO3KUNDE	CHAR	10	0	Partner number (KUNNR, LIFNR, or PERNR)
28	SFAKNA1	☐	SMO_SFAKN1	SMO_GUID	CHAR	32	0	SFA Key of Business Partner
29	SOURCE_C	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
30	KV_PREV	☐	SMO_SFAPRE	SMO_GUID	CHAR	32	0	SFA key of previous activity
31	SFARECRIT	☐	SMO_SFRECR	SMO_GUID	CHAR	32	0	SFA key of Recurrency
32	SFADOTDEF	☐	SMO_SFADOT	SMO_GUID	CHAR	32	0	SFA Key of Documentation Type defn. (SMODOTDEF)
33	SFAPOSORG	☐	SMO_SFAPOG	SMO_GUID	CHAR	32	0	Position/ Org.Unit (GUID)
34	OWNER	☐	SMO_SFAOWN	SMO_GUID	CHAR	32	0	Key of the Employee who owns the business object
35	SFAOBJEKT	☐	SMO_SFAOB1	SMO_GUID	CHAR	32	0	SFA key of opportunity the activity is related to
36	SFAPCCAMPN	☐	SMO_SFCAMA	SMO_GUID	CHAR	32	0	SFA key of Campaign the activity is related to
37	SFAVBAK	☐	SMO_SFVKAC	SMO_GUID	CHAR	32	0	SFA key of sales document related to the activity
38	SFAAVBKA	☐	SMO_SFAAVK	SMO_GUID	CHAR	32	0	SFA key of another Activity related to this activity
39	MGERROR	☐	SMO_MGERR	SMO_LOGICL	CHAR	1	0	Flag: Errors occurred during mass generation (T/F)
40	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	*
41	NON_GUID	☐	SMO_NGUID	SMO_NGUID	DEC	1	0	Not Guided Record
42	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
43	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
44	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
45	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
46	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
47	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
48	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
49	ERRORFLAG	☐	SMO_FLAG1	SMO_TEXT1	CHAR	1	0	Flag
50	DATECOMPL	☐	DATECOMPL	SMO3KTABG	DATS	8	0	Date of Completion (for Tasks)
51	PERCECOMPL	☐	PERCECOMPL	NUMC3	NUMC	3	0	Percentage Completed (for Tasks)
52	CATEGORY	☐	SMO_CATEGO	CHAR3	CHAR	3	0	Category
53	ASSIGNGUID	☐	SMO_ASGUID	SMO_GUID	CHAR	32	0	ASSIGNMENT_GUID
54	STSMA	☐	SMO_STSMA	SMO_TXT8	CHAR	8	0	Status profile
55	STAT	☐	SMO_CRMSTA	SMO_TXT5	CHAR	5	0	Object status
56	KATALOGART	☐	SMO_KATAL	SMO_TEXT2	CHAR	2	0	Status reason: catalog
57	CODEGRUPPE	☐	SMO_CODEG	SMO_TXT8	CHAR	8	0	Status reason: code group
58	CODE	☐	SMO_CODE	SMO_TXT4	CHAR	4	0	Status reason: code
59	PROC_TYPE	☐	SMO_PROCT	SMO_TXT4	CHAR	4	0	process type
60	KATALOGAR1	☐	SMO_KATAL	SMO_TEXT2	CHAR	2	0	Status reason: catalog
61	CODEGRUPP1	☐	SMO_CODEG	SMO_TXT8	CHAR	8	0	Status reason: code group
62	CODE1	☐	SMO_CODE	SMO_TXT4	CHAR	4	0	Status reason: code
63	EXTNUM	☐	SMOEXTNUM	SMO_CHAR20	CHAR	20	0	external number
64	PROPPERSTA	☐	SMO_DATE	SMO_DATE	DATS	8	0	Promotion Start Date
65	PROPPEREND	☐	SMO_DATE	SMO_DATE	DATS	8	0	Promotion Start Date
66	SALESORESP	☐	SMO3RESP	SMO3RESP	CHAR	14	0	Responsible Sales Organization
67	PRIORITY	☐	SC_PRIOIND	SC_PRIO	NUMC	1	0	Appointment priority	*
68	OBJECTTYPE	☐	CRMT_OBJCT	SMO_TXT10	CHAR	10	0	Type of CRM Subobject
69	TEMPLATE	☐	SMO_FLAG1	SMO_TEXT1	CHAR	1	0	Flag
70	DIRECTION	☐	SMODIRECT	DEFAULT	CHAR	1	0	Direction
71	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
72	SERVICE_ORG_RESP	☐	CRMT_SERVICE_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Service)
73	TOURGUID	☐	SMO_SFATOUR	SMO_GUID	CHAR	32	0	SFA Key of Tour Header (SMOTOUR)
74	CREATION_DATE	☐	SMO_CREATEDON	SMO_DATE	DATS	8	0	Created on date
75	CLASS	☐	CRMT_ACTIVITY_CLASS	CRM_ACTIVITY_CLASS	CHAR	1	0	Activity Class
76	ALT_ID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
77	FIXED	☐	CRMT_FIXED_APPOINTMENT	CRMT_FIXED_APPOINTMENT	CHAR	1	0	Appointment is Fixed

History

Last changed by/on	SAP	20110908
SAP Release Created in