SAP ABAP Table SMOLIPS (SD document: Delivery: 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	SMOLIPS	Table Relationship Diagram
Short Description	SD document: Delivery: Item data

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	SFALIPS	☑	SMO_SFLIPS	SMO_GUID	CHAR	32	0	SFA key of Delivery Item
3	SFALIKP	☐	SMO_SFLIKP	SMO_GUID	CHAR	32	0	SFA key of Delivery
4	VBELN	☐	SMO3VBELN3	SMO3VBELN	CHAR	10	0	Delivery
5	POSNR	☐	SMO3POSNR3	SMO3POSNR	NUMC	10	0	Delivery item
6	PSTYV	☐	SMO3PSTYV1	SMO3PSTYV	CHAR	4	0	Delivery item category
7	MATNR	☐	SMO3MATNR	SMO3MATNR	CHAR	40	0	Material number
8	MATWA	☐	SMO3MATWA	SMO3MATNR	CHAR	40	0	Material entered
9	MATKL	☐	SMO3MATKL	SMO3MATKL	CHAR	20	0	Material group
10	WERKS	☐	SMO3WERKS	SMO3WERKS	CHAR	4	0	Plant
11	LGORT	☐	SMO3LGORT	SMO3LGORT	CHAR	4	0	Storage location
12	CHARG	☐	SMO3CHARG	SMO3CHARG	CHAR	10	0	Batch number
13	KDMAT	☐	SMO3KDMAT	SMO3IDNEX	CHAR	40	0	Material belonging to the customer
14	PRODH	☐	SMO3PRODH	SMO3PRODH	CHAR	20	0	Product hierarchy
15	LFIMG	☐	SMO3LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
16	MEINS	☐	SMO3MEINS	MEINS	UNIT	3	0	Base unit of measure	*
17	VRKME	☐	SMO3VRKME	MEINS	UNIT	3	0	Sales unit	*
18	UMVKZ	☐	SMO3UMVKZ	SMO3UMBSZ	DEC	10	0	Numerator (factor) for conversion of sales quantity into SKU
19	UMVKN	☐	SMO3UMVKN	SMO3UMBSN	DEC	10	0	Denominator (divisor) for conversion of sales qty. into SKU
20	NTGEW	☐	SMO3NTGEW1	SMO3MENG11	QUAN	15	3	Net weight
21	BRGEW	☐	SMO3BRGEW1	SMO3MENG11	QUAN	15	3	Gross weight
22	GEWEI	☐	SMO3GEWEI	MEINS	UNIT	3	0	Weight Unit	*
23	VOLUM	☐	SMO3VOLUM1	SMO3MENG11	QUAN	15	3	Volume
24	VOLEH	☐	SMO3VOLEH	MEINS	UNIT	3	0	Volume unit	*
25	KZTLF	☐	SMO3KZTLF	SMO3KZTLF	CHAR	1	0	Partial delivery at item level
26	UEBTK	☐	SMO3UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited overdelivery allowed
27	UEBTO	☐	SMO3UEBTO	SMO3PRZ21	DEC	3	1	Overdelivery tolerance limit
28	UNTTO	☐	SMO3UNTTO	SMO3PRZ21	DEC	3	1	Underdelivery tolerance limit
29	CHSPL	☐	SMO3CHSPL	XFELD	CHAR	1	0	Batch split allowed
30	FAKSP	☐	SMO3FAKSP	SMO3FAKSP	CHAR	2	0	Block
31	MBDAT	☐	SMO3MBDAT	DATUM	DATS	8	0	Material availability date
32	LGMNG	☐	SMO3LGMNG	MENG13	QUAN	13	3	Actual quantity delivered in stockkeeping units
33	ARKTX	☐	SMO3ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
34	LGPBE	☐	SMO3LGPBE	CHAR10	CHAR	10	0	Storage bin
35	VBELV	☐	SMO3VBELV	SMO3VBELN	CHAR	10	0	Originating document
36	POSNV	☐	SMO3POSNV	SMO3POSNR	NUMC	10	0	Originating item
37	VGBEL	☐	SMO3VGBEL	SMO3VBELN	CHAR	10	0	Document number of the reference document
38	VGPOS	☐	SMO3VGPOS	SMO3POSNR	NUMC	10	0	Item number of the reference item
39	UEPOS	☐	SMO3UEPOS	SMO3POSNR	NUMC	10	0	Higher-level item in bill of material structures
40	FKREL	☐	SMO3FKREL	SMO3FKREL	CHAR	1	0	Relevant for billing
41	LADGR	☐	SMO3LADGR	SMO3LADGR	CHAR	4	0	Loading group
42	TRAGR	☐	SMO3TRAGR	SMO3TRAGR	CHAR	4	0	Transportation group
43	LGNUM	☐	SMO3LGNUM	SMO3LGNUM	CHAR	3	0	Warehouse number / warehouse complex
44	LGTYP	☐	SMO3LGTYP	SMO3LGTYP	CHAR	3	0	Storage type
45	LGPLA	☐	SMO3LGPLA	SMO3LGPLA	CHAR	10	0	Storage bin
46	MTART	☐	SMO3MTART	SMO3MTART	CHAR	20	0	Material type
47	POSAR	☐	SMO3POSAR	SMO3POSAR	CHAR	1	0	Item type
48	MTVFP	☐	SMO3MTVFP	SMO3MTVFP	CHAR	2	0	Checking group for availability check
49	EANNR	☐	SMO3EANNR	CHAR13	CHAR	13	0	European Article Number (EAN) - obsolete!!!!!
50	GSBER	☐	SMO3GSBER	SMO3GSBER	CHAR	4	0	Business area
51	VKBUR	☐	SMO3VKBUR	SMO3VKBUR	CHAR	14	0	Sales office
52	VKGRP	☐	SMO3VKGRP	SMO3VKGRP	CHAR	14	0	Sales group
53	VTWEG	☐	SMO3VTWEG	SMO3VTWEG	CHAR	2	0	Distribution channel
54	SPART	☐	SMO3SPART	SMO3SPART	CHAR	2	0	Division
55	GRKOR	☐	SMO3GRKOR	SMO3GRKOR	NUMC	3	0	Delivery group (items are delivered together)
56	FMENG	☐	SMO3FMENG	XFELD	CHAR	1	0	Quantity is fixed
57	ANTLF	☐	SMO3ANTLF	SMO3ANTLF	DEC	1	0	Maximum number of partial deliveries allowed per item
58	VBEAF	☐	SMO3VBEAF	DEC3_2	DEC	5	2	Fixed shipping processing time in days (= setup time)
59	VBEAV	☐	SMO3VBEAV	DEC3_2	DEC	5	2	Variable shipping processing time in days
60	KZWI1	☐	SMO_DMBTR		CURR	28	9	Amount in local currency
61	KZWI2	☐	SMO_DMBTR		CURR	28	9	Amount in local currency
62	KZWI3	☐	SMO_DMBTR		CURR	28	9	Amount in local currency
63	KZWI4	☐	SMO_DMBTR		CURR	28	9	Amount in local currency
64	KZWI5	☐	SMO_DMBTR		CURR	28	9	Amount in local currency
65	KZWI6	☐	SMO_DMBTR		CURR	28	9	Amount in local currency
66	SOBKZ	☐	SMO3SOBKZ	SMO3SOBKZ	CHAR	1	0	Special stock indicator
67	EAN11	☐	SMO3EAN11	SMO3EAN11	CHAR	40	0	International Article Number (EAN/UPC)
68	KVGR1	☐	SMO3KVGR1	SMO3KVGR1	CHAR	3	0	Customer group 1
69	KVGR2	☐	SMO3KVGR2	SMO3KVGR2	CHAR	3	0	Customer group 2
70	KVGR3	☐	SMO3KVGR3	SMO3KVGR3	CHAR	3	0	Customer group 3
71	KVGR4	☐	SMO3KVGR4	SMO3KVGR4	CHAR	3	0	Customer group 4
72	KVGR5	☐	SMO3KVGR5	SMO3KVGR5	CHAR	3	0	Customer group 5
73	MVGR1	☐	SMO3MVGR1	SMO3MVGR1	CHAR	3	0	Material group 1
74	MVGR2	☐	SMO3MVGR2	SMO3MVGR2	CHAR	3	0	Material group 2
75	MVGR3	☐	SMO3MVGR3	SMO3MVGR3	CHAR	3	0	Material group 3
76	MVGR4	☐	SMO3MVGR4	SMO3MVGR4	CHAR	3	0	Material group 4
77	MVGR5	☐	SMO3MVGR5	SMO3MVGR5	CHAR	3	0	Material group 5
78	VPZUO	☐	SMO3VPZUO	SMO3ZUVKZ	CHAR	1	0	Allocation indicator
79	VGTYP	☐	SMO3VBTYP	SMO3VBTYP	CHAR	1	0	SD document category
80	AUFNR	☐	SMO3AUFNR	SMO3AUFNR	CHAR	12	0	Order number
81	KCMENG	☐	SMO3KCMEN	SMO3MENG11	QUAN	15	3	Cumulative batch quantity of all split items (in StckUnit)
82	KCBRGEW	☐	SMO3KCBRG	SMO3MENG11	QUAN	15	3	Cumulative gross weight of all batch split items
83	KCNTGEW	☐	SMO3KCNTG	SMO3MENG11	QUAN	15	3	Cumulative net weight of all batch split items
84	KCVOLUM	☐	SMO3KCVOL	SMO3MENG11	QUAN	15	3	Cumulative volume of all batch split items
85	UECHA	☐	SMO3UECHA	SMO3POSNR	NUMC	10	0	Higher-level item of batch split item
86	CUOBJ	☐	SMO3CUOBJ2	SMO3CUOBJ	NUMC	18	0	Configuration
87	CUOBJ_CH	☐	SMO3CUOBJ1	SMO3CUOBJ	NUMC	18	0	Internal object number for batch classification
88	ANZSN	☐	SMO3ANZSN	INT4	INT4	10	0	Number of serial numbers
89	SERAIL	☐	SMO3SERAI	SMO3SERAI	CHAR	4	0	Serial Number Profile
90	KCGEWEI	☐	SMO3GEWEI	MEINS	UNIT	3	0	Weight Unit	*
91	KCVOLEH	☐	SMO3VOLEH	MEINS	UNIT	3	0	Volume unit	*
92	.INCLUDE	☐				0	0	Record Modification Fields for Mobile Sales/Service
93	ERFASS	☐	SMO_CREATE	SMO_DATE	DATS	8	0	Date of Creation.
94	GEAEND	☐	SMO_MODIFY	SMO_DATE	DATS	8	0	Date last Modified
95	BEARB	☐	SMO_BEARB	SMO_BEARB	CHAR	15	0	Record Edited by User Name
96	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
97	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
98	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
99	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
100	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
101	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
102	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object

History

Last changed by/on	SAP	20030110
SAP Release Created in