SAP ABAP Table SMOACTTRNS (Extract Structure Activities)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ANA-EXT (Application Component) Extraction Technology
     ⤷ SMOX_MAP (Package) Mapping objects from BW adapter

Basic Data

Table Category	INTTAB	Structure
Structure	SMOACTTRNS	Table Relationship Diagram
Short Description	Extract Structure Activities

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	SFAVBKA	☐	SMO_SFAACT	SMO_GUID	CHAR	32	0	SFA key of Activity Master (VBKA)
2	PROSPECT	☐	SMO_SFAKN1	SMO_GUID	CHAR	32	0	SFA Key of Business Partner
3	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
4	CPTYPE	☐	SMOCPTYPE	CHAR3	CHAR	3	0	Customer or Prospect?
5	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
6	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
7	SPART	☐	SPART	SPART	CHAR	2	0	Division
8	SFAPCPROMO	☐	SMO_SFAPMO	SMO_GUID	CHAR	32	0	SFA Key of the Promotion
9	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
10	KTAAR	☐	SMOBWKTAAR		CHAR	4	0	Activity Type
11	CALDAY	☐	SMOCALDAY	DATUM	DATS	8	0	Calendar Day
12	CALWEEK	☐	SMOCALWEEK	SMOCALWEK	NUMC	6	0	Calendar Week
13	CALMONTH	☐	SMOCALMON	SMOCALMON	NUMC	6	0	Calendar Month
14	CALYEAR	☐	SMOCALYEAR	SMOCALYEAR	NUMC	4	0	Calendar Year
15	WRTTP	☐	SMOWRTTP	SMOWRTTP	NUMC	3	0	Value Type
16	NOACT	☐	SMONOACT	SMOCOUNTER	DEC	9	0	Number of Activities
17	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
18	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
19	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	*
20	KVMARKT	☐	SMO_MARKET	SMO_TXT4	CHAR	4	0	Market of Partner
21	KVOUTYP	☐	SMO_OUTYP	SMO_TXT4	CHAR	4	0	Outlet Type
22	SOURCE	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
23	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	*
24	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	*
25	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	*
26	KEYACC	☐	SMO_KEYACC	SMO_LOGICL	CHAR	1	0	Business Partner is Key Account (T/F)
27	SFAPCCAMPN	☐	SMO_SFCAMA	SMO_GUID	CHAR	32	0	SFA key of Campaign the activity is related to
28	OBJNUM	☐	SMO_OBJNUM	SMO_TEXT32	CHAR	32	0	Project Number

History

Last changed by/on	SAP	20130604
SAP Release Created in