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

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	MC11V_0ITM	Table Relationship Diagram
Short Description	Extraction SD Sales BW: Document Item Allocation

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	ROCANCEL	☐	ROCANCEL	BOOLE	CHAR	1	0	Indicator: Cancel Data Record
2	.INCLUDE	☐				0	0	Extraction SD Sales BW: Allocation Document Item MCVBUK
3	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
4	.INCLUDE	☐				0	0	Extraction SD Sales BW: Allocation 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	.INCLUDE	☐				0	0	Extraction SD Sales BW: Allocation-Document Item MCVBAK
8	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
9	FAKSK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	*
10	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
11	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
12	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
13	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	*
14	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	*
15	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	*
16	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	*
17	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	*
18	LIFSK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	*
19	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	*
20	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
21	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
22	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
23	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
24	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
25	.INCLUDE	☐				0	0	Extraction SD Sales BW: Allocation Document Item MCVBAP
26	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	*
27	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
28	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
29	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
30	FAKSP	☐	FAKSP_AP	FAKSP	CHAR	2	0	Billing block for item	*
31	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
32	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
33	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered	*
34	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
35	MVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	*
36	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	*
37	MVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3	*
38	MVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4	*
39	MVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5	*
40	OAUME	☐	MC_OAUME	MENGV15_3	QUAN	15	3	Open orders quantity in base unit of measure
41	OAUWE	☐	MC_OAUWE	WERTV10	CURR	19	2	Open net value of orders
42	PKUNRE	☐	KUNRE	KUNNR	CHAR	10	0	Bill-to party	*
43	PKUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	*
44	PKUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
45	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
46	PSPDNR	☐	SPDNR	LIFNR	CHAR	10	0	Carrier	*
47	PVRTNR	☐	VRTNR	PERNR	NUMC	8	0	Sales employee
48	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	*
49	SHKZG	☐	SHKZG_VA	XFELD	CHAR	1	0	Returns Item
50	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
51	STADAT	☐	STADAT	DATUM	DATS	8	0	Statistics date
52	STCUR	☐	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
53	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
54	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
55	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
56	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
57	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
58	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
59	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
60	.INCLUDE	☐				0	0	Extraction SD Sales BW: Allocation Document Item MCVBKD
61	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	*
62	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
63	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
64	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	*
65	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
66	KURSK_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
67	WAKTION	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
68	SPARA	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	*
69	PS_POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
70	ANZOAUPO	☐	MCBW_ANZOAUPO	MCZAEHLER	DEC	9	0	Number of Open Sales Order Items
71	LFIMG_AVME	☐	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
72	MCBW_LFWRT	☐	MCBW_LFWRT	WERTV10	CURR	19	2	BW: Delivered Sales Order Value
73	MCBW_NETPR_AVKM	☐	MCBW_NETPR_AVKM	WERTV6	CURR	11	2	BW: Net Price Referring to Sales Quantity for Order Item
74	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
75	MCEX_APCAMPAIGN	☐	MCEX_APCAMPAIGN	SYSUUID_C	CHAR	32	0	Campaign of referred sales order item for BW-Extraction

History

Last changed by/on	SAP	20130529
SAP Release Created in