SAP ABAP View SMOGACV (View GN_ACTIV)

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	SMOGACV
Short Description	View GN_ACTIV
Root table	SMOVBKA	Sales Activities

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SMOVBKA	SMOVBKA
2	SMOKNA1
3	SMOADRC

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SMOVBKA	MANDT	JL	EQ				0	0
2	SMOKNA1	MANDT	JR	EQ			AND	0	0
3	SMOVBKA	SFAKNA1	JL	EQ				0	0
4	SMOKNA1	SFAKNA1	JR	EQ			AND	0	0
5	SMOVBKA	MANDT	JL	EQ				0	0
6	SMOADRC	MANDT	JR	EQ			AND	0	0
7	SMOVBKA	SFAKNA1	JL	EQ				0	0
8	SMOADRC	SFAKNA1	JR	EQ			AND	0	0
9	SMOVBKA	KV_ACTFLAG		EQ	'X'		AND	0	0
10	SMOADRC	ADRCDFLT		EQ	'S'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	SMOVBKA	MANDT		☐	MANDT	☐	Client
2	SFAVBKA	SMOVBKA	SFAVBKA		☐	SMO_SFAACT	☐	SFA key of Activity Master (VBKA)
3	PROSPECT	SMOVBKA	SFAKNA1		☐	SMO_SFAKN1	☐	SFA Key of Business Partner
4	VKORG	SMOVBKA	VKORG		☐	SMO3VKORG	☐	Sales organization
5	VTWEG	SMOVBKA	VTWEG		☐	SMO3VTWEG	☐	Distribution channel
6	SPART	SMOVBKA	SPART		☐	SMO3SPART	☐	Division
7	VKBUR	SMOVBKA	VKBUR		☐	SMO3VKBUR	☐	Sales office
8	KTAAR	SMOVBKA	KTAAR		☐	SMO3KTAAR	☐	Sales Activity Type for Sales Support
9	KTABG	SMOVBKA	KTABG		☐	SMO3KTABG	☐	Start of sales activity (date)
10	CUSTOMER	SMOKNA1	KUNNR		☐	SMO3KUNNR	☐	Customer number
11	SFAPCCAMPN	SMOVBKA	SFAPCCAMPN		☐	SMO_SFCAMA	☐	SFA key of Campaign the activity is related to
12	KTOKD	SMOKNA1	KTOKD		☐	SMO3KTOKD	☐	Customer account group
13	SOURCE	SMOKNA1	SOURCE		☐	SMO_SOURCE	☐	Source of an object
14	BRSCH	SMOKNA1	BRSCH		☐	SMO3BRSCH	☐	Industry key
15	NIELS	SMOKNA1	NIELS		☐	SMO3NIELS	☐	Nielsen indicator
16	KUKLA	SMOKNA1	KUKLA		☐	SMO3KUKLA	☐	Customer classification
17	KEYACC	SMOKNA1	KEYACC		☐	SMO_KEYACC	☐	Business Partner is Key Account (T/F)
18	KVOUTYP	SMOKNA1	KVOUTYP		☐	SMO_OUTYP	☐	Outlet Type
19	KVMARKT	SMOKNA1	KVMARKT		☐	SMO_MARKET	☐	Market of Partner
20	COUNTRY	SMOADRC	COUNTRY		☐	LAND1	☐	Country Key
21	REGION	SMOADRC	REGION		☐	REGIO	☐	Region (State, Province, County)
22	SFAOBJEKT	SMOVBKA	SFAOBJEKT		☐	SMO_SFAOB1	☐	SFA key of opportunity the activity is related to

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