SAP ABAP Table MC13VD0ITM (Extraction SD Billing Document 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	MC13VD0ITM	Table Relationship Diagram
Short Description	Extraction SD Billing Document BW: Document Item

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 Billing Document BW: Document Item MCVBUK
3	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
4	.INCLUDE	☐				0	0	Extraction SD Billing Document BW: Document Item MCVBUP
5	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
6	.INCLUDE	☐				0	0	Extraction SD Billing Document BW: Document Item MCVBRK
7	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
8	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
9	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	*
10	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	*
11	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
12	FKTYP	☐	FKTYP	FKTYP	CHAR	1	0	Billing Category
13	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
14	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	*
15	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
16	KUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	*
17	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
18	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
19	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	*
20	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
21	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
22	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
23	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
24	.INCLUDE	☐				0	0	Extraction SD Billing Document BW: Document Item MCVBRP
25	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
26	AUBEL	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
27	AUPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
28	BONBA	☐	BONBA	WERTV7	CURR	13	2	Rebate basis 1
29	BONUS	☐	BONUS	BONUS	CHAR	2	0	Volume rebate group	*
30	BRGEW	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
31	BRTWR	☐	BRTWR_FP	WERTV8	CURR	15	2	Gross value of the billing item in document currency
32	BWAPPLNM	☐	RSAPPLNM	RSAPPLNM	CHAR	30	0	Application Component
33	BWVORG	☐	MCW_BWVORG	NUM3	NUMC	3	0	SAP BW transaction key
34	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
35	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
36	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
37	FAREG	☐	FAREG	FAREG	CHAR	1	0	Rule in billing plan/invoice plan
38	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
39	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
40	FKLMG	☐	FKLMG	MENG13	QUAN	13	3	Billing quantity in stockkeeping unit
41	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
42	KNUMA_AG	☐	KNUMA_AG	KNUMA	CHAR	10	0	Sales deal	*
43	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
44	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
45	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
46	KURSK_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
47	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	*
48	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	*
49	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	*
50	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	*
51	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	*
52	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
53	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
54	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
55	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
56	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
57	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
58	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
59	LMENG	☐	LMENG	MENG13	QUAN	13	3	Required quantity for mat.management in stockkeeping units
60	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
61	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
62	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered	*
63	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
64	MVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	*
65	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	*
66	MVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3	*
67	MVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4	*
68	MVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5	*
69	MWSBP	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
70	NETWR	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
71	NTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
72	PKUNRE	☐	KUNRE	KUNNR	CHAR	10	0	Bill-to party	*
73	PKUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
74	POSAR	☐	POSAR	POSAR	CHAR	1	0	Item type
75	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
76	PROVG	☐	PROVG	PROVG	CHAR	2	0	Commission group	*
77	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
78	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
79	PVRTNR	☐	VRTNR	PERNR	NUMC	8	0	Sales employee
80	SKFBP	☐	SKFBP	WERTV7	CURR	13	2	Amount eligible for cash discount in document currency
81	SMENG	☐	SMENG	MENG13	QUAN	13	3	Scale quantity in base unit of measure
82	SPARA	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	*
83	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
84	STADAT	☐	STADAT	DATUM	DATS	8	0	Statistics date
85	STCUR	☐	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
86	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
87	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
88	VDATU	☐	MC_VDATUM	DATUM	DATS	8	0	Date of update for statistics updating
89	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
90	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	*
91	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
92	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
93	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
94	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
95	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
96	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
97	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
98	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
99	PS_POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
100	ANZFKPOS	☐	MC_ANZFKPO	MCZAEHLER	DEC	9	0	Number of billing items
101	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
102	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