SAP ABAP Table SMODOTATT (Documentation: Used Fields per Documentation type)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA (Application Component) Mobile Sales
     ⤷ SMO3 (Package) Consolidated Database

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMODOTATT	Table Relationship Diagram
Short Description	Documentation: Used Fields per Documentation type

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	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	SFADOTATT	☑	SMO_SFDATT	SMO_GUID	CHAR	32	0	SFA key for SMODOTATT Table
3	SFADOTDEF	☐	SMO_SFADOT	SMO_GUID	CHAR	32	0	SFA Key of Documentation Type defn. (SMODOTDEF)
4	SFAPOSORG	☐	SMO_SFAPOG	SMO_GUID	CHAR	32	0	Position/ Org.Unit (GUID)
5	FLDEF	☐	SMO_FLDEF	SMO_FLDEF	CHAR	1	0	Flag Definition
6	MTART	☐	SMO3MTART	SMO3MTART	CHAR	20	0	Material type
7	MATKL	☐	SMO3MATKL	SMO3MATKL	CHAR	20	0	Material group
8	MATNR	☐	SMO3MATNR	SMO3MATNR	CHAR	40	0	Material number
9	SFAMARA	☐	SMO_SFAMAR	SMO_GUID	CHAR	32	0	SFA Key of Material
10	PRODTXT	☐	SMO_PRODDT	SMO_TXT30	CHAR	30	0	Product/Article text
11	PHREFNR	☐	SMO_PHREFN	SMO_TXT10	CHAR	10	0	Pharmaceutical Reference Number
12	PHLINE	☐	SMO_PHLINE	SMO_TXT20	CHAR	20	0	Pharmaceutical: BU Line
13	SORT	☐	SMO_SORT	SMO_LOGICL	CHAR	1	0	Flag : Field 'Sort Key' used in Docu
14	KVARTTYP	☐	SMO_KVARTT	SMO_LOGICL	CHAR	1	0	Flag : Field 'Type of article' used in Docu
15	STATUS	☐	SMO_STATUS	SMO_LOGICL	CHAR	1	0	Flag : Field 'Status' used for Docu
16	KVMARKET	☐	SMO_KVMARK	SMO_LOGICL	CHAR	1	0	Flag : Field 'market of the material' used in Docu
17	PRDHA	☐	SMO_PRDHA	SMO_LOGICL	CHAR	1	0	Flag: 'Material Hierachy Field' used in Docu
18	CHARGE	☐	SMO_CHARGE	SMO_LOGICL	CHAR	1	0	Flag: field 'Charge Number' is used in Docu
19	PRPRIO	☐	SMO_PRPRIO	SMO_LOGICL	CHAR	1	0	Flag: Field 'Product Priority' is used in DOCU
20	STORNO	☐	SMO_STORNO	SMO_LOGICL	CHAR	1	0	Flag: Field 'Storno field' is used in Docu
21	SENDSTA	☐	SMO_SENDST	SMO_LOGICL	CHAR	1	0	Flag: Field 'Send status' is used in Docu
22	LAENG	☐	SMO_LAENG	SMO_LOGICL	CHAR	1	0	Flag: Field 'Length' is used in Docu
23	BREIT	☐	SMO_BREIT	SMO_LOGICL	CHAR	1	0	Flag: Field 'Width' is used for Docu
24	HOEHE	☐	SMO_HOEHE	SMO_LOGICL	CHAR	1	0	Flag: Field 'Height' is used for Docu
25	MEABM	☐	SMO_MEABM	SMO_LOGICL	CHAR	1	0	Flag: Field 'Unit of Measure' is use for Docu
26	VOLUM	☐	SMO_VOLUM	SMO_LOGICL	CHAR	1	0	Flag: Field 'material measurement in volumes' used for Docu
27	VOLEH	☐	SMO_VOLEH	SMO_LOGICL	CHAR	1	0	Flag: Field 'Volume unit' used for Docu
28	BRGEW	☐	SMO_BRGEW	SMO_LOGICL	CHAR	1	0	Flag: Field 'Gross weight' used for Docu
29	NTGEW	☐	SMO_NTGEW	SMO_LOGICL	CHAR	1	0	Flag: Field 'Net weight' used for Docu
30	GEWEI	☐	SMO_GEWEI	SMO_LOGICL	CHAR	1	0	Flag: Field 'Unit of weight' used for Docu
31	KV_COMPPR	☐	SMO_KVCOMP	SMO_LOGICL	CHAR	1	0	Flag: Field 'Competitor Product' used for Docu
32	KV_RESULT	☐	SMO_KVRESU	SMO_LOGICL	CHAR	1	0	Flag: Field 'Result' used for Docu
33	RESREAS	☐	SMO_RESREA	SMO_LOGICL	CHAR	1	0	Flag: Field 'Reason for Result' used for Docu
34	PROMTYP	☐	SMO_PROMTY	SMO_LOGICL	CHAR	1	0	Flag: Field 'Promotion Type' used for Docu
35	LBVAL	☐	SMO_LBVAL	SMO_LOGICL	CHAR	1	0	Flag: Field 'Sample Value' used for Activity Journals
36	SUBJECTA	☐	SMO_SUBJEA	SMO_LOGICL	CHAR	1	0	Flag: Field 'Subject A' used for Docu
37	SUBJECTB	☐	SMO_SUBJEB	SMO_LOGICL	CHAR	1	0	Flag: Field 'Subject B' used for Docu
38	DISCUSS	☐	SMO_DISCUS	SMO_LOGICL	CHAR	1	0	Flag: Field 'Discussed' used for Docu
39	DISCUSSB	☐	SMO_DISCUB	SMO_LOGICL	CHAR	1	0	Flag: Field 'Discussed B' used for Docu
40	DISCUSSC	☐	SMO_DISCUC	SMO_LOGICL	CHAR	1	0	Flag: Field 'Discussed C' used for Docu
41	PRAVB	☐	SMO_PRAVB	SMO_LOGICL	CHAR	1	0	Flag: Fields 'Product available before visit' used for Docu
42	PRAVA	☐	SMO_PRAVA	SMO_LOGICL	CHAR	1	0	Flag: field "product available after visit" used?
43	PRAVB1	☐	SMO_PRAVB1	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available before visit check 1'
44	PRAVA1	☐	SMO_PRAVA1	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available aftre visit check 1' used
45	PRAVB2	☐	SMO_PRAVB2	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available before visit check 2'
46	PRAVA2	☐	SMO_PRAVA2	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available aftre visit check 1' used
47	PRAVB3	☐	SMO_PRAVB3	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available before visit check 3'
48	PRAVA3	☐	SMO_PRAVA3	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available aftre visit check 3' used
49	PRAVB4	☐	SMO_PRAVB4	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available before visit check 4'
50	PRAVA4	☐	SMO_PRAVA4	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available aftre visit check 4' used
51	PRAVB5	☐	SMO_PRAVB5	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available before visit check 5' used
52	PRAVA5	☐	SMO_PRAVA5	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available aftre visit check 5' used
53	PRAVB6	☐	SMO_PRAVB6	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available before visit check 6' used
54	PRAVA6	☐	SMO_PRAVA6	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available aftre visit check 6' used
55	PRAVB7	☐	SMO_PRAVB7	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available before visit check 7' used
56	PRAVA7	☐	SMO_PRAVA7	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available aftre visit check 7' used
57	PRAVB8	☐	SMO_PRAVB8	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available before visit check 8' used
58	PRAVA8	☐	SMO_PRAVA8	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available aftre visit check 8' used
59	PRAVB9	☐	SMO_PRAVB9	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available before visit check 9' used
60	PRAVA9	☐	SMO_PRAVA9	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available aftre visit check 9' used
61	PRAVB0	☐	SMO_PRAVB0	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available before visit check 10' used
62	PRAVA0	☐	SMO_PRAVA0	SMO_LOGICL	CHAR	1	0	Flag: Field 'product available aftre visit check 10' used
63	NROFFAC	☐	SMO_NROPFF	SMO_LOGICL	CHAR	1	0	Flag: Field 'Number of facings' used for Docu
64	NROFSAM	☐	SMO_NROFSA	SMO_LOGICL	CHAR	1	0	Flag: Field 'Number of samples' used for Docu
65	FACLEN	☐	SMO_FACLEN	SMO_LOGICL	CHAR	1	0	Flag: Field 'Length of facings' used for Docu
66	FACWID	☐	SMO_FACWID	SMO_LOGICL	CHAR	1	0	Flag: Field 'Width of facings' used for Docu
67	FACDEP	☐	SMO_FACDEP	SMO_LOGICL	CHAR	1	0	Flag: Field 'Depth of facings' used for Docu
68	FACUNIT	☐	SMO_FACUNI	SMO_LOGICL	CHAR	1	0	Flag: Field 'Unit of facings' used for Docu
69	NRMSHF	☐	SMO_NRMSHF	SMO_LOGICL	CHAR	1	0	Flag: Field 'Number of main shelf Products' used for Docu
70	NRPSHF	☐	SMO_NRPSHF	SMO_LOGICL	CHAR	1	0	Flag: Field 'Number of pr. in promoted shelf' used for Docu
71	SPRICE	☐	SMO_SPRICE	SMO_LOGICL	CHAR	1	0	Flag: Field 'sales price' used for Docu
72	OPRICE	☐	SMO_OPRICE	SMO_LOGICL	CHAR	1	0	Flag: Field 'Order price in store' used for Docu
73	APRICE	☐	SMO_APRICE	SMO_LOGICL	CHAR	1	0	Flag: Field 'Action Sales Price' used for Docu
74	POSVER	☐	SMO_POSVER	SMO_LOGICL	CHAR	1	0	Flag: Field 'Vertical position in shelf' used for Docu
75	POSHOR	☐	SMO_POSHOR	SMO_LOGICL	CHAR	1	0	Flag: Field 'Horizontal position in shelf' used for Docu
76	POSQLI	☐	SMO_POSQLI	SMO_LOGICL	CHAR	1	0	Flag: Field 'Qualification shelf position' used for Docu
77	ECROPT	☐	SMO_ECROPT	SMO_LOGICL	CHAR	1	0	Flag: Field 'ECR Optimization'' used for Docu
78	POSLOC	☐	SMO_POSLOC	SMO_LOGICL	CHAR	1	0	Flag: Field 'location of main placement' used for Docu
79	KV_ZPANZ	☐	SMO_KVZPAN	SMO_LOGICL	CHAR	1	0	Flag: Field 'Number of Second Placements' used for Docu
80	KV_ZPAVA	☐	SMO_KVZPAV	SMO_LOGICL	CHAR	1	0	Flag: Field 'Second Placement available' used for Docu
81	SPTSK_S	☐	SMO_SPTSKS	SMO_CHOI3	CHAR	3	0	Special task centre Sht
82	SPTSK_L	☐	SMO_SPTSKL	SMO_TXT100	CHAR	100	0	Special task Centre long (100)
83	SPTSK_E	☐	SMO_SPTSKE	SMO_CHOI3	CHAR	3	0	Special task centre Result
84	SPTSK_N	☐	SMO_SPTSKN	SMO_NUM83	DEC	8	3	Special task centre Result num.
85	KV_STOCK	☐	SMO_KVSTOC	SMO_LOGICL	CHAR	1	0	Flag: Field 'Products in stock' used for Docu
86	KV_DEKO	☐	SMO_KVDEKO	SMO_LOGICL	CHAR	1	0	Flag: Field 'Deko Material' used for Docu
87	DEKOTP	☐	SMO_DEKOPT	SMO_LOGICL	CHAR	1	0	Flag: Field 'Deko Type' used for Docu
88	SPTFI_L	☐	SMO_SPTFIL	SMO_CHOI1	CHAR	1	0	Flag: Field 'Special task Field Long' used for Docu
89	SPTFI_S	☐	SMO_SPTFIS	SMO_CHOI1	CHAR	1	0	Flag: Field 'Special task field Sht' used for Docu
90	SPTFI_N	☐	SMO_SPTFIN	SMO_CHOI1	CHAR	1	0	Flag: Field 'Special task centre Res. Numeric' used for Docu
91	.INCLUDE	☐				0	0	Record Modification Fields for Mobile Sales/Service
92	ERFASS	☐	SMO_CREATE	SMO_DATE	DATS	8	0	Date of Creation.
93	GEAEND	☐	SMO_MODIFY	SMO_DATE	DATS	8	0	Date last Modified
94	BEARB	☐	SMO_BEARB	SMO_BEARB	CHAR	15	0	Record Edited by User Name
95	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
96	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
97	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
98	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
99	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
100	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
101	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
102	IMAGELEN	☐	SMO_IMAGLG	SMO_IMAGLG	INT2	5	0	Size of the Image to be stored
103	TEXTX	☐	SMO_TEXTX	SMO_LNGBIN	CHAR	34	0	Memo: Documentation
104	SAMRETURN	☐	SMO_BOOLEAN	SMO3ATXFE	CHAR	1	0	Boolean
105	SAMTOBESENT	☐	SMO_BOOLEAN	SMO3ATXFE	CHAR	1	0	Boolean
106	SFAPRDCATG	☐	SMO_BOOLEAN	SMO3ATXFE	CHAR	1	0	Boolean
107	SFAPRDHIER	☐	SMO_BOOLEAN	SMO3ATXFE	CHAR	1	0	Boolean
108	EXPLOSION	☐	SMO_BOOLEAN	SMO3ATXFE	CHAR	1	0	Boolean
109	EDLP	☐	SMO_APRICE	SMO_LOGICL	CHAR	1	0	Flag: Field 'Action Sales Price' used for Docu
110	LISTINGFEE	☐	SMO_APRICE	SMO_LOGICL	CHAR	1	0	Flag: Field 'Action Sales Price' used for Docu
111	SFAPRDCATGKEY	☐	SMOSFACATG	SMO_GUID	CHAR	32	0	SFA Key of Product Category
112	SFAPRDHIERKEY	☐	SMOSFAHIER	SMO_GUID	CHAR	32	0	SFA Key of Product Hierarchy
113	ALT_ID	☐	SMOALT_ID	SMO3MATNR	CHAR	40	0	Alternative ID

History

Last changed by/on	SAP	20050115
SAP Release Created in