SAP ABAP Table E3CVBAP (SIS - sales order 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	E3CVBAP	Table Relationship Diagram
Short Description	SIS - sales order item, first part

Delivery and Maintenance

Pool/cluster
Delivery Class
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	SUPKZ	SUPKZ	SUPKZ	CHAR	1	0	Statistics update indicator (post in/post out)
2	VBELN	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
3	POSNR	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
4	MATNR	MATNR	MATNR	CHAR	18	0	Material Number	*
5	MATWA	MATWA	MATNR	CHAR	18	0	Material entered	*
6	PMATN	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	*
7	CHARG	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
8	MATKL	MATKL	MATKL	CHAR	9	0	Material Group	*
9	ARKTX	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
10	PSTYV	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
11	POSAR	POSAR	POSAR	CHAR	1	0	Item type
12	LFREL	LFREL_AP	XFELD	CHAR	1	0	Item is relevant for delivery
13	FKREL	FKREL	FKREL	CHAR	1	0	Relevant for Billing
14	UEPOS	VEPOS	VEPOS	NUMC	6	0	Handling Unit Item	*
15	GRPOS	GRPOS	GRPOS	NUMC	6	0	Item for which this item is an alternative
16	ABGRU	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	*
17	PRODH	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
18	ZWERT	DZWERT	WERT7	CURR	13	2	Target value for outline agreement in document currency
19	ZMENG	DZMENG	MENG13	QUAN	13	3	Target quantity in sales units
20	ZIEME	DZIEME	MEINS	UNIT	3	0	Target quantity UoM	*
21	UMZIZ	UMZIZ	UMBSZ	DEC	5	0	Factor for converting sales units to base units (target qty)
22	UMZIN	UMZIN	UMBSN	DEC	5	0	Factor for converting sales units to base units (target qty)
23	MEINS	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
24	SMENG	SMENG	MENG13	QUAN	13	3	Scale quantity in base unit of measure
25	ABLFZ	ABLFZ	ABLFZ	QUAN	13	3	Rounding quantity for delivery
26	ABDAT	ABDAT	DATUM	DATS	8	0	Reconciliation date for agreed cumulative quantity
27	ABSFZ	ABSFZ	MENG13	QUAN	13	3	Allowed deviation in quantity (absolute)
28	POSEX	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
29	KDMAT	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
30	KBVER	KBVER	PACK2	DEC	3	0	Allowed deviation in quantity (in percent)
31	KEVER	KEVER	PACK2	DEC	3	0	Days by which the quantity can be shifted
32	VKGRU	VKGRU	RMA_VORGA	CHAR	3	0	Repair processing: Classify items	*
33	VKAUS	VKAUS	VKAUS	CHAR	3	0	Unused - Reserve Length 3
34	GRKOR	GRKOR	GRKOR	NUMC	3	0	Delivery group (items are delivered together)
35	FMENG	FMENG	XFELD	CHAR	1	0	Quantity is fixed
36	UEBTK	UEBTK_V	XFELD	CHAR	1	0	Unlimited overdelivery allowed
37	UEBTO	CHAR5	CHAR5	CHAR	5	0	R/2 table
38	UNTTO	CHAR5	CHAR5	CHAR	5	0	R/2 table
39	FAKSP	FAKSP_AP	FAKSP	CHAR	2	0	Billing block for item	*
40	ATPKZ	ATPKZ	ATPKZ	CHAR	1	0	Replacement part
41	RKFKF	RKFKF	RKFKF	CHAR	1	0	Form of Billing for CO/PPC Orders
42	SPART	SPART	SPART	CHAR	2	0	Division	*
43	GSBER	GSBER	GSBER	CHAR	4	0	Business Area	*
44	NETWR	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
45	WAERK	WAERK	WAERS	CUKY	5	0	SD document currency	*
46	ANTLF	ANTLF	ANTLF	DEC	1	0	Maximum number of partial deliveries allowed per item
47	KZTLF	KZTLF	KZTLF	CHAR	1	0	Partial delivery at item level
48	CHSPL	CHSPL	XFELD	CHAR	1	0	Batch split allowed
49	KWMENG	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
50	LSMENG	LSMENG	MENG15	QUAN	15	3	Cumulative Target Delivery Qty (all dlv-relev.sched.lines)
51	KBMENG	KBMENG	MENG15	QUAN	15	3	Cumulative confirmed quantity in sales unit
52	KLMENG	KLMENG	MENG15	QUAN	15	3	Cumulative Confirmed Quantity in Base Unit of Measure
53	VRKME	VRKME	MEINS	UNIT	3	0	Sales unit	*
54	UMVKZ	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
55	UMVKN	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
56	BRGEW	BRGEW_AP	MENG15	QUAN	15	3	Gross weight of item
57	NTGEW	NTGEW_AP	MENG15	QUAN	15	3	Net weight of item
58	GEWEI	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
59	VOLUM	VOLUM_AP	MENG15	QUAN	15	3	Volume of the item
60	VOLEH	VOLEH	MEINS	UNIT	3	0	Volume unit	*
61	VBELV	VBELV	VBELN	CHAR	10	0	Originating document	*
62	POSNV	POSNV	POSNR	NUMC	6	0	Originating item	*
63	VGBEL	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
64	VGPOS	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	*
65	VOREF	VOREF	XFELD	CHAR	1	0	Complete reference indicator
66	UPFLU	UPFLU	XFELD	CHAR	1	0	Update indicator for flow table
67	ERLRE	ERLRE	ERLRE	CHAR	1	0	Completion rule for quotation / contract
68	LPRIO	LPRIO	LPRIO	NUMC	2	0	Delivery priority	*
69	WERKS	WERKS_D	WERKS	CHAR	4	0	Plant	*
70	LGORT	LGORT_D	LGORT	CHAR	4	0	Storage location	*
71	VSTEL	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
72	ROUTE	ROUTE	ROUTE	CHAR	6	0	Route	*
73	STKEY	STKEY	STKEY	CHAR	1	0	Origin of the bill of material
74	STDAT	STDAT	DATUM	DATS	8	0	Date of Bill of Material
75	STLNR	STNUM	STNUM	CHAR	8	0	Bill of Material
76	STPOS	STPOS_D	STPOS	DEC	4	0	Bill of material item number
77	AWAHR	AWAHR	AWAHR	NUMC	3	0	Order probability of the item
78	ERDAT	ERDAT	DATUM	DATS	8	0	Date on which the record was created
79	ERNAM	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
80	ERZET	ERZET	UZEIT	TIMS	6	0	Entry time
81	TAXM1	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
82	TAXM2	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
83	TAXM3	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
84	TAXM4	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
85	TAXM5	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
86	TAXM6	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
87	TAXM7	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
88	TAXM8	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
89	TAXM9	TAXMT	TAXKD	CHAR	1	0	Tax classification material	*
90	VBEAF	VBEAF	DEC3_2	DEC	5	2	Fixed shipping processing time in days (= setup time)
91	VBEAV	VBEAV	DEC3_2	DEC	5	2	Variable shipping processing time in days
92	VGREF	VGREF	XFELD	CHAR	1	0	Preceding document has resulted from reference
93	NETPR	NETPR	WERTV6	CURR	11	2	Net price
94	KPEIN	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
95	KMEIN	KMEIN	MEINS	UNIT	3	0	Condition Unit	*
96	SHKZG	SHKZG_VA	XFELD	CHAR	1	0	Returns Item
97	SKTOF	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
98	MTVFP	MTVFP	MTVFP	CHAR	2	0	Checking Group for Availability Check	*
99	SUMBD	SUMBD	SUMBD	CHAR	1	0	Summing up of requirements
100	KONDM	KONDM	KONDM	CHAR	2	0	Material Pricing Group	*
101	KTGRM	KTGRM	KTGRM	CHAR	2	0	Account assignment group for this material	*
102	BONUS	BONUS	BONUS	CHAR	2	0	Volume rebate group	*
103	PROVG	PROVG	PROVG	CHAR	2	0	Commission group	*
104	EANNR	EANNR	CHAR13	CHAR	13	0	European Article Number (EAN) - obsolete!!!!!
105	PRSOK	PRSOK	XFELD	CHAR	1	0	Pricing is OK
106	BWTAR	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
107	BWTEX	BWTEX	XFELD	CHAR	1	0	Indicator: Separate valuation
108	XCHPF	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
109	XCHAR	XCHAR	XFELD	CHAR	1	0	Batch management indicator (internal)
110	LFMNG	MINLF	MENG13	QUAN	13	3	Minimum delivery quantity in delivery note processing
111	STAFO	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
112	WAVWR	WAVWR	WERTV7	CURR	13	2	Cost in document currency
113	KZWI1	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
114	KZWI2	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
115	KZWI3	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
116	KZWI4	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
117	KZWI5	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
118	KZWI6	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
119	STCUR	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
120	AEDAT	AEDAT	DATUM	DATS	8	0	Last Changed On
121	EAN11	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
122	FIXMG	FIXMG	XFELD	CHAR	1	0	Delivery date and quantity fixed
123	PRCTR	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
124	MVGR1	MVGR1	MVGR1	CHAR	3	0	Material group 1	*
125	MVGR2	MVGR2	MVGR2	CHAR	3	0	Material group 2	*
126	MVGR3	MVGR3	MVGR3	CHAR	3	0	Material group 3	*
127	MVGR4	MVGR4	MVGR4	CHAR	3	0	Material group 4	*
128	MVGR5	MVGR5	MVGR5	CHAR	3	0	Material group 5	*
129	KMPMG	KMPMG	MENGV13	QUAN	13	3	Component Quantity
130	SUGRD	SUGRD	SUGRD	CHAR	4	0	Reason for material substitution	*
131	SOBKZ	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
132	VPZUO	VPZUO	ZUVKZ	CHAR	1	0	Allocation Indicator