SAP ABAP Table SMOVBAP (Sales Document: Item Data)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

CRM-MSA (Application Component) Mobile Sales
⤷

SMO3 (Package) Consolidated Database

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMOVBAP	Table Relationship Diagram
Short Description	Sales Document: Item Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client	*
2	SFAVBAP	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
3	SFAVBAK	SMO_SFAVBK	SMO_GUID	CHAR	32	0	SFA Key of Sales Document
4	CONFIG_ID	SMO_CONFID	SMO_CONFID	CHAR	8	0	Identity code for configuration
5	INST_ID	SMO_INSCID	SMO_TXT8	CHAR	8	0	SCE Instance ID
6	VBELN	SMO3VBELN2	SMO3VBELN	CHAR	10	0	Sales document
7	POSNR	SMO3POSNR2	SMO3POSNR	NUMC	10	0	Sales document item
8	SOURCE	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
9	MATNR	SMO3PON	SMO3PON	CHAR	54	0	CRM Product Order Number (PON)
10	PMATN	SMO3PMATN	SMO3MATNR	CHAR	40	0	Pricing reference material
11	MATKL	SMO3MATKL	SMO3MATKL	CHAR	20	0	Material group
12	ARKTX	SMO3ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
13	PSTYV	SMO3PSTYV	SMO3PSTYV	CHAR	4	0	Sales document item category
14	SFAMARA	SMO_SFAMAR	SMO_GUID	CHAR	32	0	SFA Key of Material
15	POSAR	SMO3POSAR	SMO3POSAR	CHAR	1	0	Item type
16	UEPOS	SMO3UEPOS	SMO3POSNR	NUMC	10	0	Higher-level item in bill of material structures
17	GRPOS	SMO3GRPOS	SMO3GRPOS	NUMC	10	0	Item for which this item is an alternative
18	ABGRU	SMO3ABGRU1	SMO3ABGRU	CHAR	2	0	Reason for rejection of quotations and sales orders
19	PRODH	SMO3PRODH	SMO3PRODH	CHAR	20	0	Product hierarchy
20	ZMENG	SMO3DZMEN	MENG13	QUAN	13	3	Target quantity in sales units
21	ZIEME	SMO3DZIEM	MEINS	UNIT	3	0	Target quantity UoM	*
22	ZWERT	SMO_ZWERT	SMO_CURRCY	CURR	28	9	Target value for outline agreement in document currency
23	UMZIZ	SMO3UMZIZ	SMO3UMBSZ	DEC	10	0	Factor for converting sales units to base units (target qty)
24	UMZIN	SMO3UMZIN	SMO3UMBSN	DEC	10	0	Factor for converting sales units to base units (target qty)
25	MEINS	SMO3MEINS	MEINS	UNIT	3	0	Base unit of measure	*
26	POSEX	SMO3POSEX	SMO3POSEX	CHAR	10	0	Item number of the underlying customer purchase order
27	KDMAT	SMO3MATNR1	SMO3IDNEX	CHAR	40	0	Material number used by customer
28	UEBTK	SMO3UEBTK1	XFELD	CHAR	1	0	Unlimited overdelivery allowed
29	UEBTO	SMO3UEBTO	SMO3PRZ21	DEC	3	1	Overdelivery tolerance limit
30	UNTTO	SMO3UNTTO	SMO3PRZ21	DEC	3	1	Underdelivery tolerance limit
31	FAKSP	SMO3FAKSP1	SMO3FAKSP	CHAR	2	0	Billing block for item
32	SPART	SMO3SPART	SMO3SPART	CHAR	2	0	Division
33	NETWR	SMO_DMBTR		CURR	28	9	Amount in local currency
34	WAERK	SMO3WAERK	WAERS	CUKY	5	0	SD document currency	*
35	KZTLF	SMO3KZTLF	SMO3KZTLF	CHAR	1	0	Partial delivery at item level
36	KWMENG	SMO3KWMEN	SMO3MENG11	QUAN	15	3	Cumulative order quantity in sales units
37	LSMENG	SMO3LSMEN	SMO3MENG11	QUAN	15	3	Cumulative required delivery qty (all dlv-relev.sched.lines)
38	VRKME	SMO3VRKME	MEINS	UNIT	3	0	Sales unit	*
39	UMVKZ	SMO3UMVKZ	SMO3UMBSZ	DEC	10	0	Numerator (factor) for conversion of sales quantity into SKU
40	UMVKN	SMO3UMVKN	SMO3UMBSN	DEC	10	0	Denominator (divisor) for conversion of sales qty. into SKU
41	BRGEW	SMO3BRGEW2	SMO3MENG11	QUAN	15	3	Gross weight of item
42	NTGEW	SMO3NTGEW2	SMO3MENG11	QUAN	15	3	Net weight of item
43	GEWEI	SMO3GEWEI	MEINS	UNIT	3	0	Weight Unit	*
44	VOLUM	SMO3VOLUM2	SMO3MENG11	QUAN	15	3	Volume of the item
45	VOLEH	SMO3VOLEH	MEINS	UNIT	3	0	Volume unit	*
46	VBELV	SMO3VBELV	SMO3VBELN	CHAR	10	0	Originating document
47	POSNV	SMO3POSNV	SMO3POSNR	NUMC	10	0	Originating item
48	VGBEL	SMO3VGBEL	SMO3VBELN	CHAR	10	0	Document number of the reference document
49	VGPOS	SMO3VGPOS	SMO3POSNR	NUMC	10	0	Item number of the reference item
50	LPRIO	SMO3LPRIO	SMO3LPRIO	NUMC	2	0	Delivery priority
51	WERKS	SMO3WERKS	SMO3WERKS	CHAR	4	0	Plant
52	LGORT	SMO3LGORT	SMO3LGORT	CHAR	4	0	Storage location
53	VSTEL	SMO3VSTEL	SMO3VSTEL	CHAR	4	0	Shipping point/receiving point
54	ROUTE	SMO3ROUTE	SMO3ROUTE	CHAR	6	0	Route
55	AWAHR	SMO3AWAHR	SMO3AWAHR	NUMC	3	0	Order probability of the item
56	ERDAT	SMO3ERDAT	DATUM	DATS	8	0	Date on which the record was created
57	ERNAM	SMO3ERNAM	USNAM	CHAR	12	0	Name of person who created the object
58	ERZET	SMO3ERZET	UZEIT	TIMS	6	0	Entry time
59	TAXM1	SMO3TAXMT	SMO3TAXKD	CHAR	1	0	Tax classification material
60	TAXM2	SMO3TAXMT	SMO3TAXKD	CHAR	1	0	Tax classification material
61	TAXM3	SMO3TAXMT	SMO3TAXKD	CHAR	1	0	Tax classification material
62	TAXM4	SMO3TAXMT	SMO3TAXKD	CHAR	1	0	Tax classification material
63	TAXM5	SMO3TAXMT	SMO3TAXKD	CHAR	1	0	Tax classification material
64	TAXM6	SMO3TAXMT	SMO3TAXKD	CHAR	1	0	Tax classification material
65	TAXM7	SMO3TAXMT	SMO3TAXKD	CHAR	1	0	Tax classification material
66	TAXM8	SMO3TAXMT	SMO3TAXKD	CHAR	1	0	Tax classification material
67	TAXM9	SMO3TAXMT	SMO3TAXKD	CHAR	1	0	Tax classification material
68	NETPR	SMO_DMBTR		CURR	28	9	Amount in local currency
69	KONDM	SMO3KONDM	SMO3KONDM	CHAR	2	0	Material Pricing Group
70	PROVG	SMO3PROVG	SMO3PROVG	CHAR	2	0	Commission group
71	PRSOK	SMO3PRSOK	XFELD	CHAR	1	0	Pricing is OK
72	KZWI1	SMO_DMBTR		CURR	28	9	Amount in local currency
73	KZWI2	SMO_DMBTR		CURR	28	9	Amount in local currency
74	KZWI3	SMO_DMBTR		CURR	28	9	Amount in local currency
75	KZWI4	SMO_DMBTR		CURR	28	9	Amount in local currency
76	KZWI5	SMO_DMBTR		CURR	28	9	Amount in local currency
77	KZWI6	SMO_DMBTR		CURR	28	9	Amount in local currency
78	AEDAT	SMO3AEDAT	DATUM	DATS	8	0	Last changed on
79	EAN11	SMO3EAN11	SMO3EAN11	CHAR	40	0	International Article Number (EAN/UPC)
80	FIXMG	SMO3FIXMG	XFELD	CHAR	1	0	Delivery date and quantity fixed
81	MVGR1	SMO3MVGR1	SMO3MVGR1	CHAR	3	0	Material group 1
82	MVGR2	SMO3MVGR2	SMO3MVGR2	CHAR	3	0	Material group 2
83	MVGR3	SMO3MVGR3	SMO3MVGR3	CHAR	3	0	Material group 3
84	MVGR4	SMO3MVGR4	SMO3MVGR4	CHAR	3	0	Material group 4
85	MVGR5	SMO3MVGR5	SMO3MVGR5	CHAR	3	0	Material group 5
86	SUGRD	SMO3SUGRD	SMO3SUGRD	CHAR	4	0	Reason for material substitution
87	UMREF	SMO3UMREF	FLTP	FLTP	16	16	Conversion factor: quantities
88	BEDAE	SMO3BEDAE	SMO3BEDAE	CHAR	4	0	Requirements type
89	KOUPD	SMO3KOUPD	XFELD	CHAR	1	0	Condition update
90	MPROK	SMO3MPROK	SMO3MPROK	CHAR	1	0	Status manual price change
91	CLINT	SMO3CLINT	SMO3CLINT	NUMC	10	0	Internal class number
92	UPMAT	SMO3UPMAT	SMO3MATNR	CHAR	40	0	SFA Key of pricing reference material of main item
93	FLAG1	SMO_FLAG3	SMO_TEXT1	CHAR	1	0	Item contains structured product component
94	FLAG2	SMO_FLAG2	SMO_TEXT1	CHAR	1	0	Product related to Campaign Allocation
95	KZVBR	SMO3KZVBR	SMO3KZVBR	CHAR	1	0	Consumption posting
96	PS_PSP_PNR	SMO3PS_PS	SMO3PS_PO	NUMC	8	0	Work breakdown structure element (WBS element)
97	ROOT_ID	SMO_ROOTID	SMO_CONFID	CHAR	8	0	Configuration Root ID
98	CHARG	SMO3CHARG	SMO3CHARG	CHAR	10	0	Batch number
99	VBPCH2	SMO_VBPCH1	SMO_TEXT1	CHAR	1	0	Free choice field (1) on customers demand
100	VBPCH1	SMO_VBPCH1	SMO_TEXT1	CHAR	1	0	Free choice field (1) on customers demand
101	SKOPF	SMO3W_SOR	SMO3WSORT	CHAR	18	0	Assortment module
102	WKTNR	SMO3WKTNR	SMO3VBELN	CHAR	10	0	Value contract no.
103	WKTPS	SMO3WKTPS	SMO3POSNR	NUMC	10	0	Value contract item
104	PRINF	SMO_PRINF	SMO_TXT8	CHAR	8	0	Pricing Info
105	UEPVW	SMO3UEPVW	SMO3UEPVW	CHAR	2	0	ID for higher-level item usage
106	PROSA	SMO3PROSA	SMO3PROSA	CHAR	1	0	ID for material determination
107	SFAPCCAMPN	SMO_SFACPN	SMO_GUID	CHAR	32	0	SFA KEY of the Campaign
108	NON_GUID	SMO_NGUID	SMO_NGUID	DEC	1	0	Not Guided Record
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	ITMGUIDATP	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
117	KMPMG	SMO_KMPMG	SMO3_KMPMG	QUAN	13	3	Component quantity
118	TAXGROUPP	SMOTAX_GRP	SMO_TAXGRP	CHAR	20	0	Product Tax Group
119	TAXTARIFC	SMO3STEUC	SMO3STEUC	CHAR	16	0	Control code for consumption taxes in foreign trade
120	EXPONENT10	SMO_EXP10	EXP10	INT2	5	0	Base 10 Exponent for Conversion to the Base Unit of Measure
121	VDATU	SMO3EDATU1	DATUM	DATS	8	0	Requested delivery date
122	AEZET	SMO3AEZEI	UHRZT	TIMS	6	0	Time of change
123	AENAM	SMO3AENAM	USNAM	CHAR	12	0	Name of person who changed object
124	SFAPMATNR	SMO_SFAPMA	SMO_GUID	CHAR	32	0	SFA key of pricing reference material
125	UEPOSGUID	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
126	ALTPOSGUID	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
127	VDZET	SMO3VDZET	UHRZT	TIMS	6	0	Time of change
128	OBJECT_TYPE	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	*
129	PPR_PROD_GUID	SMOSFAPPRH	SMO_GUID	CHAR	32	0	Key of CDB Table SMOPPRHDR
130	PPR_OBJL_GUID	SMOSFAPPRH	SMO_GUID	CHAR	32	0	Key of CDB Table SMOPPRHDR
131	PRODUCT_KIND	CRMT_PRODUCT_KIND	CRM_PRODUCT_KIND	CHAR	1	0	Technnical Type of Product
132	MATWA	SMO3PON	SMO3PON	CHAR	54	0	CRM Product Order Number (PON)
133	CANCELDATE	SMOCANCELDATE	DATUM	DATS	8	0	Latest Delivery Date
134	CANCELTIME	SMOCANCELTIME	UHRZT	TIMS	6	0	Latest Delivery Time
135	ISGRIDITEM	SMOISGRIDITEM	CHKFLAG	CHAR	1	0	Flag to recognize grid items
136	ITM_TYPE_USAGE	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
137	ALT_ID	SMOALT_ID	SMO3MATNR	CHAR	40	0	Alternative ID