SAP ABAP Table E3CLIPS (SIS - delivery item, first part)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PCT (Application Component) Product Catalog
     ⤷ IDOCLOGISTICS (Package) IDoc Interface (logistics segment definitions)

Basic Data

Table Category	INTTAB	Structure
Structure	E3CLIPS	Table Relationship Diagram
Short Description	SIS - delivery item, first part

Delivery and Maintenance

Pool/cluster
Delivery Class
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	SUPKZ	☐	SUPKZ	SUPKZ	CHAR	1	0	Statistics update indicator (post in/post out)
2	VBELN	☑	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
3	POSNR	☑	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
4	PSTYV	☐	PSTYV_VL	PSTYV	CHAR	4	0	Delivery item category	*
5	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
6	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
7	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
8	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
9	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered	*
10	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
11	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
12	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
13	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
14	KDMAT	☐	KDMAT	IDNEX	CHAR	35	0	Material belonging to the customer
15	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
16	LFIMG	☐	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
17	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
18	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
19	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
20	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
21	NTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
22	BRGEW	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
23	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
24	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
25	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
26	KZTLF	☐	KZTLF	KZTLF	CHAR	1	0	Partial delivery at item level
27	UEBTK	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
28	UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
29	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
30	CHSPL	☐	CHSPL	XFELD	CHAR	1	0	Batch split allowed
31	FAKSP	☐	FAKSP	FAKSP	CHAR	2	0	Lock	*
32	MBDAT	☐	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
33	LGMNG	☐	LGMNG	MENG13	QUAN	13	3	Actual quantity delivered in stockkeeping units
34	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
35	LGPBE	☐	LGPBE	CHAR10	CHAR	10	0	Storage Bin
36	VBELV	☐	VBELV	VBELN	CHAR	10	0	Originating document	*
37	POSNV	☐	POSNV	POSNR	NUMC	6	0	Originating item	*
38	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
39	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	*
40	UPFLU	☐	UPFLU	XFELD	CHAR	1	0	Update indicator for flow table
41	UEPOS	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures	*
42	FKREL	☐	FKREL	FKREL	CHAR	1	0	Relevant for Billing
43	LADGR	☐	LADGR	LADGR	CHAR	4	0	Loading Group	*
44	TRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	*
45	KOMKZ	☐	KOMKZ	KOMKZ	CHAR	1	0	Indicator for picking control
46	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	*
47	LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	*
48	LGPLA	☐	LGPLA	LGPLA	CHAR	10	0	Storage Bin	*
49	BWTEX	☐	BWTEX	XFELD	CHAR	1	0	Indicator: Separate valuation
50	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
51	BWLVS	☐	BWLVS	BWLVS	NUMC	3	0	Movement Type for Warehouse Management	*
52	KZDLG	☐	LVS_KZDLG	XFELD	CHAR	1	0	Indicator: dynamic storage bin in warehouse management
53	BDART	☐	BDART	BDART	CHAR	2	0	Requirement type
54	PLART	☐	PLART	PLART	CHAR	1	0	Planning type	*
55	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
56	XCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
57	XCHAR	☐	XCHAR	XFELD	CHAR	1	0	Batch management indicator (internal)
58	VGREF	☐	VGREF	XFELD	CHAR	1	0	Preceding document has resulted from reference
59	POSAR	☐	POSAR	POSAR	CHAR	1	0	Item type
60	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
61	SUMBD	☐	SUMBD	SUMBD	CHAR	1	0	Summing up of requirements
62	MTVFP	☐	MTVFP	MTVFP	CHAR	2	0	Checking Group for Availability Check	*
63	EANNR	☐	EANNR	CHAR13	CHAR	13	0	European Article Number (EAN) - obsolete!!!!!
64	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
65	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
66	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
67	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
68	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
69	GRKOR	☐	GRKOR	GRKOR	NUMC	3	0	Delivery group (items are delivered together)
70	FMENG	☐	FMENG	XFELD	CHAR	1	0	Quantity is fixed
71	ANTLF	☐	ANTLF	ANTLF	DEC	1	0	Maximum number of partial deliveries allowed per item
72	VBEAF	☐	VBEAF	DEC3_2	DEC	5	2	Fixed shipping processing time in days (= setup time)
73	VBEAV	☐	VBEAV	DEC3_2	DEC	5	2	Variable shipping processing time in days
74	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
75	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
76	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
77	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
78	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
79	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
80	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
81	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
82	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
83	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
84	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
85	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	*
86	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	*
87	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	*
88	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	*
89	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	*
90	MVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	*
91	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	*
92	MVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3	*
93	MVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4	*
94	MVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5	*
95	VPZUO	☐	VPZUO	ZUVKZ	CHAR	1	0	Allocation Indicator
96	VGTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
97	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
98	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
99	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
100	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
101	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
102	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
103	VPMAT	☐	VPMAT	MATNR	CHAR	18	0	Planning material	*
104	VPWRK	☐	VPWRK	WERKS	CHAR	4	0	Planning plant	*
105	PRBME	☐	PRBME	MEINS	UNIT	3	0	Base unit of measure for product group	*
106	UMREF	☐	UMREFF	FLTP	FLTP	16	16	Conversion factor: quantities
107	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
108	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
109	PCKPF	☐	PCKPF	PCKPF	CHAR	1	0	Packing control
110	BEDAR_LF	☐	BEDAR	BEDAR	CHAR	3	0	Requirements class	*
111	CMPNT	☐	CMPNT	XFELD	CHAR	1	0	ID: Item with active credit function / relevant for credit
112	KCMENG	☐	KCMENG	MENG15	QUAN	15	3	Cumulative batch quantity of all split items (in StckUnit)
113	KCBRGEW	☐	KCBRGEW	MENG15	QUAN	15	3	Cumulative gross weight of all batch split items
114	KCNTGEW	☐	KCNTGEW	MENG15	QUAN	15	3	Cumulative net weight of all batch split items
115	KCVOLUM	☐	KCVOLUM	MENG15	QUAN	15	3	Cumulative volume of all batch split items
116	UECHA	☐	UECHA	POSNR	NUMC	6	0	Higher-Level Item of Batch Split Item	*
117	CUOBJ	☐	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
118	CUOBJ_CH	☐	CUOBJ_CH	CUOBJ	NUMC	18	0	Internal object number of the batch classification
119	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
120	SERAIL	☐	SERAIL	SERAIL	CHAR	4	0	Serial Number Profile	*
121	KCGEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
122	KCVOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
123	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
124	ABRLI	☐	ABRLI	ABRLI	NUMC	4	0	Internal delivery schedule number	*
125	ABART	☐	ABART	ABART	CHAR	1	0	Release type
126	ABRVW	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator	*
127	QPLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	*
128	QTLOS	☐	QTLOS	QTLOS	NUMC	6	0	Partial lot number	*
129	NACHL	☐	NACHL	XFELD	CHAR	1	0	Customer has not posted goods receipt
130	MAGRV	☐	MAGRV	MAGRV	CHAR	4	0	Material Group: Packaging Materials	*
131	OBJKO	☐	OBJKO	J_OBJNR	CHAR	22	0	Object number at header level	*
132	OBJPO	☐	OBJPO	J_OBJNR	CHAR	22	0	Object number at item level	*

History

Last changed by/on	SAP	20140121
SAP Release Created in