SAP ABAP Table MC11VA0ITM (Extraction SD Sales BW: Document Item)

Hierarchy

☛

SAP_APPL (Software Component) Logistics and Accounting
⤷

LO-LIS (Application Component) Logistics Information System (LIS)
⤷

MCEX (Package) Extraction Interface LIS-BW

Basic Data

Table Category	INTTAB	Structure
Structure	MC11VA0ITM	Table Relationship Diagram
Short Description	Extraction SD Sales BW: Document Item

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	ROCANCEL	ROCANCEL	BOOLE	CHAR	1	0	Indicator: Cancel Data Record
2	.INCLUDE				0	0	Extraction SD Sales BW: Document Item MCVBUK
3	VBELN	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
4	.INCLUDE				0	0	Extraction SD Sales BW: Document Item MCVBUP
5	ABSTA	ABSTA_VB	STATV	CHAR	1	0	Rejection status for SD item
6	POSNR	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
7	UVALL	UVALL_UP	STATV	CHAR	1	0	General Incompletion Status of the Item
8	UVFAK	UVFAK_UP	STATV	CHAR	1	0	Item incompletion status with respect to billing
9	UVPRS	UVPRS_UP	STATV	CHAR	1	0	Item is incomplete with respect to pricing
10	UVVLK	UVVLK_UP	STATV	CHAR	1	0	Incompletion Status of the Item with Regard to Delivery
11	.INCLUDE				0	0	Extraction SD Sales BW: Document Item MCVBAK
12	ANGDT	ANGDT_V	DATUM	DATS	8	0	Quotation/Inquiry is valid from
13	AUART	AUART	AUART	CHAR	4	0	Sales Document Type	*
14	AUGRU	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
15	BNDDT	BNDDT	DATUM	DATS	8	0	Date until which bid/quotation is binding (valid-to date)
16	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	*
17	FAKSK	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	*
18	HWAER	HWAER	WAERS	CUKY	5	0	Local Currency	*
19	KUNNR	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
20	KURST	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
21	KVGR1	KVGR1	KVGR1	CHAR	3	0	Customer group 1	*
22	KVGR2	KVGR2	KVGR2	CHAR	3	0	Customer group 2	*
23	KVGR3	KVGR3	KVGR3	CHAR	3	0	Customer group 3	*
24	KVGR4	KVGR4	KVGR4	CHAR	3	0	Customer group 4	*
25	KVGR5	KVGR5	KVGR5	CHAR	3	0	Customer group 5	*
26	LIFSK	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	*
27	STWAE	STWAE	WAERS	CUKY	5	0	Statistics currency	*
28	VBTYP	VBTYP	VBTYP	CHAR	1	0	SD document category
29	VKBUR	VKBUR	VKBUR	CHAR	4	0	Sales office	*
30	VKGRP	VKGRP	VKGRP	CHAR	3	0	Sales group	*
31	VKORG	VKORG	VKORG	CHAR	4	0	Sales Organization	*
32	VTWEG	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
33	.INCLUDE				0	0	Extraction SD Sales BW: Document Item MCVBAP
34	ABGRU	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	*
35	AEDAT	AEDAT	DATUM	DATS	8	0	Last Changed On
36	AWAHR	AWAHR	AWAHR	NUMC	3	0	Order probability of the item
37	BRGEW	BRGEW_AP	MENG15	QUAN	15	3	Gross weight of item
38	BWAPPLNM	RSAPPLNM	RSAPPLNM	CHAR	30	0	Application Component
39	BWVORG	MCW_BWVORG	NUM3	NUMC	3	0	SAP BW transaction key
40	CHARG	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
41	CMKUA	CMKUA	KURRF	DEC	9	5	Credit data exchange rate for requested delivery date
42	EAN11	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
43	ERDAT	ERDAT	DATUM	DATS	8	0	Date on which the record was created
44	ERNAM	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
45	ERZET	ERZET	UZEIT	TIMS	6	0	Entry time
46	FAKSP	FAKSP_AP	FAKSP	CHAR	2	0	Billing block for item	*
47	GEWEI	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
48	KBMENG	KBMENG	MENG15	QUAN	15	3	Cumulative confirmed quantity in sales unit
49	KLMENG	KLMENG	MENG15	QUAN	15	3	Cumulative Confirmed Quantity in Base Unit of Measure
50	KMEIN	KMEIN	MEINS	UNIT	3	0	Condition Unit	*
51	KNUMA_AG	KNUMA_AG	KNUMA	CHAR	10	0	Sales deal	*
52	KPEIN	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
53	KWMENG	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
54	KZWI1	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
55	KZWI2	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
56	KZWI3	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
57	KZWI4	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
58	KZWI5	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
59	KZWI6	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
60	LFMNG	MINLF	MENG13	QUAN	13	3	Minimum delivery quantity in delivery note processing
61	LGORT	LGORT_D	LGORT	CHAR	4	0	Storage location	*
62	LSMENG	LSMENG	MENG15	QUAN	15	3	Cumulative Target Delivery Qty (all dlv-relev.sched.lines)
63	MATKL	MATKL	MATKL	CHAR	9	0	Material Group	*
64	MATNR	MATNR	MATNR	CHAR	18	0	Material Number	*
65	MATWA	MATWA	MATNR	CHAR	18	0	Material entered	*
66	MEINS	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
67	MVGR1	MVGR1	MVGR1	CHAR	3	0	Material group 1	*
68	MVGR2	MVGR2	MVGR2	CHAR	3	0	Material group 2	*
69	MVGR3	MVGR3	MVGR3	CHAR	3	0	Material group 3	*
70	MVGR4	MVGR4	MVGR4	CHAR	3	0	Material group 4	*
71	MVGR5	MVGR5	MVGR5	CHAR	3	0	Material group 5	*
72	MWSBP	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
73	NETPR	NETPR	WERTV6	CURR	11	2	Net price
74	NETWR	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
75	NTGEW	NTGEW_AP	MENG15	QUAN	15	3	Net weight of item
76	PABLA	PABLA	TEXT25	CHAR	25	0	Unloading point of the ship-to party
77	PKUNRE	KUNRE	KUNNR	CHAR	10	0	Bill-to party	*
78	PKUNRG	KUNRG	KUNNR	CHAR	10	0	Payer	*
79	PKUNWE	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
80	PRODH	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
81	PSPDNR	SPDNR	LIFNR	CHAR	10	0	Carrier	*
82	PSTYV	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
83	PVRTNR	VRTNR	PERNR	NUMC	8	0	Sales employee
84	ROUTE	ROUTE	ROUTE	CHAR	6	0	Route	*
85	SOBKZ	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
86	SPART	SPART	SPART	CHAR	2	0	Division	*
87	STADAT	STADAT	DATUM	DATS	8	0	Statistics date
88	STCUR	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
89	SUGRD	SUGRD	SUGRD	CHAR	4	0	Reason for material substitution	*
90	UEBTK	UEBTK_V	XFELD	CHAR	1	0	Unlimited overdelivery allowed
91	UEBTO	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
92	UMVKN	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
93	UMVKZ	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
94	UMZIN	UMZIN	UMBSN	DEC	5	0	Factor for converting sales units to base units (target qty)
95	UMZIZ	UMZIZ	UMBSZ	DEC	5	0	Factor for converting sales units to base units (target qty)
96	UNTTO	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
97	VDATU	MC_VDATUM	DATUM	DATS	8	0	Date of update for statistics updating
98	VGBEL	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
99	VGPOS	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	*
100	VGTYP	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
101	VOLEH	VOLEH	MEINS	UNIT	3	0	Volume unit	*
102	VOLUM	VOLUM_AP	MENG15	QUAN	15	3	Volume of the item
103	VRKME	VRKME	MEINS	UNIT	3	0	Sales unit	*
104	VSTEL	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
105	WAERK	WAERK	WAERS	CUKY	5	0	SD document currency	*
106	WAVWR	WAVWR	WERTV7	CURR	13	2	Cost in document currency
107	WERKS	WERKS_EXT	WERKS	CHAR	4	0	Plant (Own or External)	*
108	ZIEME	DZIEME	MEINS	UNIT	3	0	Target quantity UoM	*
109	ZMENG	DZMENG	MENG13	QUAN	13	3	Target quantity in sales units
110	ZWERT	DZWERT	WERT7	CURR	13	2	Target value for outline agreement in document currency
111	.INCLUDE				0	0	Extraction SD Sales BW: Document Item MCVBKD
112	BZIRK	BZIRK	BZIRK	CHAR	6	0	Sales district	*
113	FBUDA	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
114	FKDAT	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
115	INCO1	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
116	INCO2	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
117	KDGRP	KDGRP	KDGRP	CHAR	2	0	Customer group	*
118	KTGRD	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	*
119	KURSK	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
120	KURSK_DAT	WWERT_D	DATUM	DATS	8	0	Translation date
121	PRSDT	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
122	WAKTION	WAKTION	WAKTION	CHAR	10	0	Promotion	*
123	WMINR	WMINR	WMINR	CHAR	10	0	Product catalog number	*
124	WAERK_VBAK	WAERK	WAERS	CUKY	5	0	SD document currency	*
125	SPARA	SPART_AK	SPART	CHAR	2	0	Division for order header	*
126	VGTYP_AK	MC_VBTYPAK	VBTYP	CHAR	1	0	Sales Document Category of Reference Doc. in Order Header
127	PS_POSID	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
128	ANZAUPO	MC_ANZAUPO	MCZAEHLER	DEC	9	0	Number of order items
129	PERIV	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
130	MCEX_APCAMPAIGN	MCEX_APCAMPAIGN	SYSUUID_C	CHAR	32	0	Campaign of referred sales order item for BW-Extraction
131	APOPLANNED	APOPLANNED	APOPLANNED	CHAR	1	0	Planning in APO
132	MCBW_NETPR_AVKM	MCBW_NETPR_AVKM	WERTV6	CURR	11	2	BW: Net Price Referring to Sales Quantity for Order Item