SAP ABAP Table SMOCONDOCU (Documentation)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

CRM-MSA (Application Component) Mobile Sales
⤷

SMO3 (Package) Consolidated Database

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMOCONDOCU	Table Relationship Diagram
Short Description	Documentation

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	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client	*
2	SFACONDOCU	SMO_SFACON	SMO_GUID	CHAR	32	0	SFA Key of an Activity Documentation
3	SFAVBKA	SMO_SFAACT	SMO_GUID	CHAR	32	0	SFA key of Activity Master (VBKA)
4	SFAKNA1	SMO_SFAKN1	SMO_GUID	CHAR	32	0	SFA Key of Business Partner
5	SFAKVBEZ6	SMO_SFAZ06	SMO_GUID	CHAR	32	0	SFA Key of IL. Business Partner - Business Partner
6	SFAKNA2	SMO_SFAKN2	SMO_GUID	CHAR	32	0	SFA Key for Busines Partner 2 / Contact person
7	SFADOTDEF	SMO_SFADOT	SMO_GUID	CHAR	32	0	SFA Key of Documentation Type defn. (SMODOTDEF)
8	SFAMARA	SMO_SFAMAR	SMO_GUID	CHAR	32	0	SFA Key of Material
9	SFAMITABT	SMO_SFAMIT	SMO_GUID	CHAR	32	0	Employee Key
10	SFAPOSORG	SMO_SFAPOG	SMO_GUID	CHAR	32	0	Position/ Org.Unit (GUID)
11	SOURCE	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
12	SORT	SMO_SORTF	SMO_TXT5	CHAR	5	0	Sorting
13	STATUS	SMO_STATU4	SMO_TXT4	CHAR	4	0	Status of documented product
14	MATNR	SMO3MATNR	SMO3MATNR	CHAR	40	0	Material number
15	MTART	SMO3MTART	SMO3MTART	CHAR	20	0	Material type
16	MATKL	SMO3MATKL	SMO3MATKL	CHAR	20	0	Material group
17	PHREFNR	SMO_PHREFN	SMO_TXT10	CHAR	10	0	Pharmaceutical Reference Number
18	PHLINE	SMO_PHLINE	SMO_TXT20	CHAR	20	0	Pharmaceutical: BU Line
19	KVARTTYP	SMO_KVARTP	SMO_TXT5	CHAR	5	0	Article Type in SFA/FSA
20	KVMARKET	SMO_MARKET	SMO_TXT4	CHAR	4	0	Market of Partner
21	PRDHA	SMO3PRODH	SMO3PRODH	CHAR	20	0	Product hierarchy
22	CHARGE	SMO3CHARG	SMO3CHARG	CHAR	10	0	Batch number
23	PRPRIO	SMO_PRPRI4	SMO_TXT4	CHAR	4	0	Product Priority
24	STORNO	STORNO	CHAR1_X	CHAR	1	0	Indicator: Data to Be Canceled
25	SENDSTA	SMO_SENDSF	SMO_TEXT1	CHAR	1	0	Send Status
26	LAENG	SMO3LAENG	MENG13	QUAN	13	3	Length
27	BREIT	SMO3BREIT	MENG13	QUAN	13	3	Width
28	HOEHE	SMO3HOEHE	MENG13	QUAN	13	3	Height
29	MEABM	SMO3MEABM	MEINS	UNIT	3	0	Unit of dimension for length/width/height	*
30	VOLUM	SMO3VOLUM	MENG13	QUAN	13	3	Volume
31	VOLEH	SMO3VOLEH	MEINS	UNIT	3	0	Volume unit	*
32	BRGEW	SMO3BRGEW	MENG13	QUAN	13	3	Gross weight
33	NTGEW	SMO3NTGEW	MENG13	QUAN	13	3	Net weight
34	GEWEI	SMO3GEWEI	MEINS	UNIT	3	0	Weight Unit	*
35	KV_COMPPR	SMO_KVCMPP	SMO_TXT50	CHAR	50	0	Competitor Products
36	KV_RESULT	SMO_KVRESF	SMO_TEXT1	CHAR	1	0	Result
37	RESREAS	SMO_RESRAS	SMO_TXT3	CHAR	3	0	Reason for result
38	PROMTYP	SMO_PROTYP	SMO_TXT4	CHAR	4	0	Promotion type
39	LBVAL	SMO_LBVALF	SMO_NUM152	DEC	15	2	Value of left Behind
40	SUBJECTA	SMO_SUBJE1	SMO_TXT10	CHAR	10	0	Free Text: Subject
41	SUBJECTB	SMO_SUBJE1	SMO_TXT10	CHAR	10	0	Free Text: Subject
42	DISCUSS	SMO_DISCUF	SMO_LOGICL	CHAR	1	0	Discussed (1,2,3)
43	DISCUSSB	SMO_DISCUF	SMO_LOGICL	CHAR	1	0	Discussed (1,2,3)
44	DISCUSSC	SMO_DISCUF	SMO_LOGICL	CHAR	1	0	Discussed (1,2,3)
45	PRAVA	SMO_PRAVAF	SMO_TXT3	CHAR	3	0	Product available after visit at checkout X (1-10)
46	PRAVA1	SMO_PRAVAF	SMO_TXT3	CHAR	3	0	Product available after visit at checkout X (1-10)
47	PRAVA2	SMO_PRAVAF	SMO_TXT3	CHAR	3	0	Product available after visit at checkout X (1-10)
48	PRAVA3	SMO_PRAVAF	SMO_TXT3	CHAR	3	0	Product available after visit at checkout X (1-10)
49	PRAVA4	SMO_PRAVAF	SMO_TXT3	CHAR	3	0	Product available after visit at checkout X (1-10)
50	PRAVA5	SMO_PRAVAF	SMO_TXT3	CHAR	3	0	Product available after visit at checkout X (1-10)
51	PRAVA6	SMO_PRAVAF	SMO_TXT3	CHAR	3	0	Product available after visit at checkout X (1-10)
52	PRAVA7	SMO_PRAVAF	SMO_TXT3	CHAR	3	0	Product available after visit at checkout X (1-10)
53	PRAVA8	SMO_PRAVAF	SMO_TXT3	CHAR	3	0	Product available after visit at checkout X (1-10)
54	PRAVA9	SMO_PRAVAF	SMO_TXT3	CHAR	3	0	Product available after visit at checkout X (1-10)
55	PRAVA0	SMO_PRAVAF	SMO_TXT3	CHAR	3	0	Product available after visit at checkout X (1-10)
56	PRAVB	SMO_PRAV3	SMO_TXT3	CHAR	3	0	Product available before Visit at check out X (1-10)
57	PRAVB1	SMO_PRAV3	SMO_TXT3	CHAR	3	0	Product available before Visit at check out X (1-10)
58	PRAVB2	SMO_PRAV3	SMO_TXT3	CHAR	3	0	Product available before Visit at check out X (1-10)
59	PRAVB3	SMO_PRAV3	SMO_TXT3	CHAR	3	0	Product available before Visit at check out X (1-10)
60	PRAVB4	SMO_PRAV3	SMO_TXT3	CHAR	3	0	Product available before Visit at check out X (1-10)
61	PRAVB5	SMO_PRAV3	SMO_TXT3	CHAR	3	0	Product available before Visit at check out X (1-10)
62	PRAVB6	SMO_PRAV3	SMO_TXT3	CHAR	3	0	Product available before Visit at check out X (1-10)
63	PRAVB7	SMO_PRAV3	SMO_TXT3	CHAR	3	0	Product available before Visit at check out X (1-10)
64	PRAVB8	SMO_PRAV3	SMO_TXT3	CHAR	3	0	Product available before Visit at check out X (1-10)
65	PRAVB9	SMO_PRAV3	SMO_TXT3	CHAR	3	0	Product available before Visit at check out X (1-10)
66	PRAVB0	SMO_PRAV3	SMO_TXT3	CHAR	3	0	Product available before Visit at check out X (1-10)
67	NROFFAC	SMO_NROFFA	SMO_NUM4	DEC	4	0	Number of facing
68	NROFSAM	SMO_NROFS4	SMO_NUM4	DEC	4	0	Number of samples
69	FACLEN	SMO_FACLE6	SMO_NUM6_2	DEC	6	2	length of facing
70	FACWID	SMO_FACWI6	SMO_NUM6_2	DEC	6	2	width of facing
71	FACDEP	SMO_FACDE6	SMO_NUM6_2	DEC	6	2	depth of facing
72	FACUNIT	SMO3MEINS	MEINS	UNIT	3	0	Base unit of measure	*
73	NRMSHF	SMO_NRMSH6	SMO_NUM6	DEC	6	0	Number of produts in main shelf
74	NRPSHF	SMO_NRPSG6	SMO_NUM6	DEC	6	0	Number of products in promation shelf
75	SPRICE	SMO_SPRIC7	SMO_CURRCY	CURR	28	9	sales price in store
76	OPRICE	SMO_OPRIC7	SMO_CURRCY	CURR	28	9	order price in store
77	APRICE	SMO_APRIC7	SMO_CURRCY	CURR	28	9	action sales price in store
78	KVCURR1	SMO3WAERS	WAERS	CUKY	5	0	Currency key	*
79	POSVER	SMO_POSVE3	SMO_TXT3	CHAR	3	0	vertical position in shelf
80	POSHOR	SMO_POSHO3	SMO_TXT3	CHAR	3	0	horizontal position in shelf
81	POSQLI	SMO_POSQL3	SMO_TXT3	CHAR	3	0	Qualification of the shelf position
82	ECROPT	SMO_ECROP3	SMO_TXT3	CHAR	3	0	Optimization of the shelf performed within an ECR agreement
83	POSLOC	SMO_POSLO3	SMO_TXT3	CHAR	3	0	main location of placement, eg. pallet, chip etc.
84	KV_ZPANZ	SMO_KVZPN3	SMO_NUM3	DEC	3	0	Numer of Second placements
85	KV_ZPAVA	SMO_KVZPAF	SMO_LOGICL	CHAR	1	0	Second Placement Available
86	SPTSK_S	SMO_SPTSKS	SMO_CHOI3	CHAR	3	0	Special task centre Sht
87	SPTSK_L	SMO_SPTSKL	SMO_TXT100	CHAR	100	0	Special task Centre long (100)
88	SPTSK_E	SMO_SPTSKE	SMO_CHOI3	CHAR	3	0	Special task centre Result
89	SPTSK_N	SMO_SPTSKN	SMO_NUM83	DEC	8	3	Special task centre Result num.
90	KV_DEKO	SMO_KVDEK3	SMO_TXT3	CHAR	3	0	Deko-Material
91	KV_STOCK	SMO_KVSTO6	SMO_NUM6	DEC	6	0	Number of articles on stock
92	DEKOTP	SMO_DEKOT3	SMO_TXT3	CHAR	3	0	Deko type
93	SPTFI_L	SMO_SPTFL1	SMO_TXT100	CHAR	100	0	Special task Field Long
94	SPTFI_S	SMO_SPTFS3	SMO_TXT3	CHAR	3	0	Special task field
95	SPTFI_N	SMO_SPTFN8	SMO_NUM83	DEC	8	3	Special task Field result
96	.INCLUDE				0	0	Record Modification Fields for Mobile Sales/Service
97	ERFASS	SMO_CREATE	SMO_DATE	DATS	8	0	Date of Creation.
98	GEAEND	SMO_MODIFY	SMO_DATE	DATS	8	0	Date last Modified
99	BEARB	SMO_BEARB	SMO_BEARB	CHAR	15	0	Record Edited by User Name
100	.INCLUDE				0	0	Communication Fields for Mobile Sales/Service
101	TR_USER	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
102	TR_ID	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
103	TR_STATUS	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
104	TIMESTAMP	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
105	DELETED	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
106	TR_ROOTID	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
107	IMAGELEN	SMO_IMAGLG	SMO_IMAGLG	INT2	5	0	Size of the Image to be stored
108	TEXTX	SMO_TEXTX	SMO_LNGBIN	CHAR	34	0	Memo: Documentation
109	SFACCALIKO	SMO_SFLIKO	SMO_GUID	CHAR	32	0	SFA Key of Listing Header
110	CONFIG_ID	SMO_CONFID	SMO_CONFID	CHAR	8	0	Identity code for configuration
111	INST_ID	SMO_INSCID	SMO_TXT8	CHAR	8	0	SCE Instance ID
112	ROOT_ID	SMO_ROOTID	SMO_CONFID	CHAR	8	0	Configuration Root ID
113	LIHEADSEQ	SMO_CHOI2	SMO_TXT2	CHAR	4	0	Free Choice Field on Customer's Demand
114	LIITEMSEQ	SMO_LTYPE	SMO_TXT2	CHAR	4	0	Listing Type
115	REPSTAT	SMO_REPSTAT	SMO_TEXT1	CHAR	1	0	Activity Journal Status
116	SAMRETURN	SMO_BOOLEAN	SMO3ATXFE	CHAR	1	0	Boolean
117	SAMTOBESENT	SMO_BOOLEAN	SMO3ATXFE	CHAR	1	0	Boolean
118	LINEITEMSTAT	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
119	SFAPPRHDR	SMOSFAPPRH	SMO_GUID	CHAR	32	0	Key of CDB Table SMOPPRHDR
120	SALESUNIT	SMO_SALESUNIT	MEINS	UNIT	3	0	Sales Unit	*
121	SFAPRDCATG	SMOSFACATG	SMO_GUID	CHAR	32	0	SFA Key of Product Category
122	SFAPRDHIER	SMOSFAHIER	SMO_GUID	CHAR	32	0	SFA Key of Product Hierarchy
123	EDLP	SMO_SPRIC7	SMO_CURRCY	CURR	28	9	sales price in store
124	LISTINGFEE	SMO_SPRIC7	SMO_CURRCY	CURR	28	9	sales price in store
125	PPR_RANK	CRMT_PRP_RANK	CRM_PRP_RANK	NUMC	10	0	Rank Indicator of a PPR	*
126	ALT_ID	SMOALT_ID	SMO3MATNR	CHAR	40	0	Alternative ID
127	POSX	POSX	SMO_NUM6_2	DEC	6	2	X co-ordinate of Product in Shelf
128	POSY	POSY	SMO_NUM6_2	DEC	6	2	Y co-ordinate of Product in Shelf
129	POSZ	SMO_POSZ	SMO_NUM6_2	DEC	6	2	Z co-ordinate of Product in Shelf
130	DESCRIPTION	SMO3MAKTX	TEXT40	CHAR	40	0	Material description