SAP ABAP Table SMOFACTRNS (Extract Structure Facts)

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	SMOFACTRNS	Table Relationship Diagram
Short Description	Extract Structure Facts

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	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
2	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
3	PROSPECT	☐	SMO_SFAKN1	SMO_GUID	CHAR	32	0	SFA Key of Business Partner
4	BPARTNER	☐	SMOBWPRTNR	SMOBWPRTNR	CHAR	10	0	Business Partner Number
5	CPTYPE	☐	SMOCPTYPE	CHAR3	CHAR	3	0	Customer or Prospect?
6	SFAVBKA	☐	SMO_SFAACT	SMO_GUID	CHAR	32	0	SFA key of Activity Master (VBKA)
7	CALDAY	☐	SMOCALDAY	DATUM	DATS	8	0	Calendar Day
8	CALWEEK	☐	SMOCALWEEK	SMOCALWEK	NUMC	6	0	Calendar Week
9	CALMONTH	☐	SMOCALMON	SMOCALMON	NUMC	6	0	Calendar Month
10	CALYEAR	☐	SMOCALYEAR	SMOCALYEAR	NUMC	4	0	Calendar Year
11	WRTTP	☐	SMOWRTTP	SMOWRTTP	NUMC	3	0	Value Type
12	NOFACNG	☐	SMONOFAC	SMOCOUNTER	DEC	9	0	Number
13	NOSAMPLE	☐	SMONOSAM	SMOCOUNTER	DEC	9	0	Number
14	SPRICE	☐	SMO_SPRIC7	SMO_CURRCY	CURR	28	9	sales price in store
15	APRICE	☐	SMO_APRIC7	SMO_CURRCY	CURR	28	9	action sales price in store
16	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
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	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	*
23	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	*
24	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	*
25	KEYACC	☐	SMO_KEYACC	SMO_LOGICL	CHAR	1	0	Business Partner is Key Account (T/F)
26	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
27	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
28	SPART	☐	SPART	SPART	CHAR	2	0	Division
29	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*

History

Last changed by/on	SAP	20130604
SAP Release Created in