SAP ABAP View SMOFACV (View Facts)

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	SMOFACV
Short Description	View Facts
Root table	SMOCONDOCU	Documentation

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SMOCONDOCU	MANDT	JL	EQ				0	0
2	SMOVBKA	MANDT	JR	EQ			AND	0	0
3	SMOCONDOCU	MANDT	JL	EQ				0	0
4	SMOKNA1	MANDT	JR	EQ			AND	0	0
5	SMOCONDOCU	SFAKNA1	JL	EQ				0	0
6	SMOKNA1	SFAKNA1	JR	EQ			AND	0	0
7	SMOCONDOCU	MANDT	JL	EQ				0	0
8	SMOVBKA	MANDT	JR	EQ			AND	0	0
9	SMOCONDOCU	SFAVBKA	JL	EQ				0	0
10	SMOVBKA	SFAVBKA	JR	EQ			AND	0	0
11	SMOCONDOCU	MANDT	JL	EQ				0	0
12	SMOADRC	MANDT	JR	EQ			AND	0	0
13	SMOCONDOCU	SFAKNA1	JL	EQ				0	0
14	SMOADRC	SFAKNA1	JR	EQ			AND	0	0
15	SMOVBKA	KV_ACTFLAG		EQ	'X'		AND	0	0
16	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	SMOCONDOCU	SFAVBKA		☐	SMO_SFAACT	☐	SFA key of Activity Master (VBKA)
3	PROSPECT	SMOVBKA	SFAKNA1		☐	SMO_SFAKN1	☐	SFA Key of Business Partner
4	MATNR	SMOCONDOCU	MATNR		☐	SMO3MATNR	☐	Material number
5	NOFACNG	SMOCONDOCU	NROFFAC		☐	SMO_NROFFA	☐	Number of facing
6	NOSAMPLE	SMOCONDOCU	NROFSAM		☐	SMO_NROFS4	☐	Number of samples
7	SPRICE	SMOCONDOCU	SPRICE		☐	SMO_SPRIC7	☐	sales price in store
8	APRICE	SMOCONDOCU	APRICE		☐	SMO_APRIC7	☐	action sales price in store
9	WAERS	SMOCONDOCU	KVCURR1		☐	SMO3WAERS	☐	Currency key
10	KTABG	SMOVBKA	KTABG		☐	SMO3KTABG	☐	Start of sales activity (date)
11	CUSTOMER	SMOKNA1	KUNNR		☐	SMO3KUNNR	☐	Customer number
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	VKORG	SMOVBKA	VKORG		☐	SMO3VKORG	☐	Sales organization
23	VTWEG	SMOVBKA	VTWEG		☐	SMO3VTWEG	☐	Distribution channel
24	SPART	SMOVBKA	SPART		☐	SMO3SPART	☐	Division
25	VKBUR	SMOVBKA	VKBUR		☐	SMO3VKBUR	☐	Sales office

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