SAP ABAP Table SMODOCDEFL (Activity Journal Template Defaults)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

CRM-MSA (Application Component) Mobile Sales
⤷

SMO3 (Package) Consolidated Database

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMODOCDEFL	Table Relationship Diagram
Short Description	Activity Journal Template Defaults

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