SAP ABAP Table MC11VA0SCL (Extraction SD Sales BW: Document Schedule Line)

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	MC11VA0SCL	Table Relationship Diagram
Short Description	Extraction SD Sales BW: Document Schedule Line

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 Schedule Line MCVBUK
3	VBELN	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
4	.INCLUDE				0	0	Extraction SD Sales BW: Document Schedule Line 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 Schedule Line MCVBEP
12	BMENG	BMENG	MENG13	QUAN	13	3	Confirmed quantity
13	CMENG	CMENG	MENG13	QUAN	13	3	Corrected quantity in sales unit
14	EDATU	EDATU	DATUM	DATS	8	0	Schedule line date
15	ETENR	ETENR	ETENR	NUMC	4	0	Schedule line	*
16	ETTYP	ETTYP	ETTYP	CHAR	2	0	Item Cat. in Schedule Line	*
17	LDDAT	LDDAT	DATUM	DATS	8	0	Loading Date
18	LIFSP	LIFSP_EP	LIFSP	CHAR	2	0	Schedule line blocked for delivery	*
19	LMENG	LMENG	MENG13	QUAN	13	3	Required quantity for mat.management in stockkeeping units
20	MBDAT	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
21	MEINS	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
22	TDDAT	TDDAT_D	DATUM	DATS	8	0	Transportation Planning Date
23	VRKME	VRKME	MEINS	UNIT	3	0	Sales unit	*
24	WADAT	WADAT	DATUM	DATS	8	0	Goods Issue Date
25	WLDATBE	WLDATBE	DATUM	DATS	8	0	Desired del. date in confirmed schedule lines
26	WMENG	WMENG	MENG13	QUAN	13	3	Order quantity in sales units
27	.INCLUDE				0	0	Extraction SD Sales BW: Document Schedule Line MCVBAK
28	ANGDT	ANGDT_V	DATUM	DATS	8	0	Quotation/Inquiry is valid from
29	AUART	AUART	AUART	CHAR	4	0	Sales Document Type	*
30	AUGRU	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
31	BNDDT	BNDDT	DATUM	DATS	8	0	Date until which bid/quotation is binding (valid-to date)
32	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	*
33	FAKSK	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	*
34	HWAER	HWAER	WAERS	CUKY	5	0	Local Currency	*
35	KUNNR	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
36	KURST	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
37	KVGR1	KVGR1	KVGR1	CHAR	3	0	Customer group 1	*
38	KVGR2	KVGR2	KVGR2	CHAR	3	0	Customer group 2	*
39	KVGR3	KVGR3	KVGR3	CHAR	3	0	Customer group 3	*
40	KVGR4	KVGR4	KVGR4	CHAR	3	0	Customer group 4	*
41	KVGR5	KVGR5	KVGR5	CHAR	3	0	Customer group 5	*
42	LIFSK	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	*
43	STWAE	STWAE	WAERS	CUKY	5	0	Statistics currency	*
44	VBTYP	VBTYP	VBTYP	CHAR	1	0	SD document category
45	VKBUR	VKBUR	VKBUR	CHAR	4	0	Sales office	*
46	VKGRP	VKGRP	VKGRP	CHAR	3	0	Sales group	*
47	VKORG	VKORG	VKORG	CHAR	4	0	Sales Organization	*
48	VTWEG	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
49	.INCLUDE				0	0	Extraction SD Sales BW: Document Schedule Line MCVBAP
50	ABGRU	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	*
51	AEDAT	AEDAT	DATUM	DATS	8	0	Last Changed On
52	AWAHR	AWAHR	AWAHR	NUMC	3	0	Order probability of the item
53	CHARG	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
54	CMKUA	CMKUA	KURRF	DEC	9	5	Credit data exchange rate for requested delivery date
55	EAN11	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
56	ERDAT	ERDAT	DATUM	DATS	8	0	Date on which the record was created
57	ERNAM	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
58	ERZET	ERZET	UZEIT	TIMS	6	0	Entry time
59	FAKSP	FAKSP_AP	FAKSP	CHAR	2	0	Billing block for item	*
60	GEWEI	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
61	KMEIN	KMEIN	MEINS	UNIT	3	0	Condition Unit	*
62	KPEIN	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
63	LGORT	LGORT_D	LGORT	CHAR	4	0	Storage location	*
64	MATKL	MATKL	MATKL	CHAR	9	0	Material Group	*
65	MATNR	MATNR	MATNR	CHAR	18	0	Material Number	*
66	MATWA	MATWA	MATNR	CHAR	18	0	Material entered	*
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	NETPR	NETPR	WERTV6	CURR	11	2	Net price
73	PABLA	PABLA	TEXT25	CHAR	25	0	Unloading point of the ship-to party
74	PKUNRE	KUNRE	KUNNR	CHAR	10	0	Bill-to party	*
75	PKUNRG	KUNRG	KUNNR	CHAR	10	0	Payer	*
76	PKUNWE	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
77	PRODH	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
78	PSPDNR	SPDNR	LIFNR	CHAR	10	0	Carrier	*
79	PSTYV	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
80	PVRTNR	VRTNR	PERNR	NUMC	8	0	Sales employee
81	ROUTE	ROUTE	ROUTE	CHAR	6	0	Route	*
82	SPART	SPART	SPART	CHAR	2	0	Division	*
83	STADAT	STADAT	DATUM	DATS	8	0	Statistics date
84	STCUR	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
85	SUGRD	SUGRD	SUGRD	CHAR	4	0	Reason for material substitution	*
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	UMZIN	UMZIN	UMBSN	DEC	5	0	Factor for converting sales units to base units (target qty)
89	UMZIZ	UMZIZ	UMBSZ	DEC	5	0	Factor for converting sales units to base units (target qty)
90	VDATU	MC_VDATUM	DATUM	DATS	8	0	Date of update for statistics updating
91	VGTYP	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
92	VOLEH	VOLEH	MEINS	UNIT	3	0	Volume unit	*
93	VSTEL	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
94	WAERK	WAERK	WAERS	CUKY	5	0	SD document currency	*
95	WERKS	WERKS_EXT	WERKS	CHAR	4	0	Plant (Own or External)	*
96	ZIEME	DZIEME	MEINS	UNIT	3	0	Target quantity UoM	*
97	.INCLUDE				0	0	Extraction SD Sales BW: Document Schedule Line MCVBKD
98	BZIRK	BZIRK	BZIRK	CHAR	6	0	Sales district	*
99	FBUDA	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
100	FKDAT	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
101	INCO1	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
102	INCO2	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
103	KDGRP	KDGRP	KDGRP	CHAR	2	0	Customer group	*
104	KTGRD	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	*
105	KURSK	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
106	KURSK_DAT	WWERT_D	DATUM	DATS	8	0	Translation date
107	PRSDT	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
108	WAERK_VBAK	WAERK	WAERS	CUKY	5	0	SD document currency	*
109	SPARA	SPART_AK	SPART	CHAR	2	0	Division for order header	*
110	VGTYP_AK	MC_VBTYPAK	VBTYP	CHAR	1	0	Sales Document Category of Reference Doc. in Order Header
111	PS_POSID	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
112	PERIV	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
113	MCEX_APCAMPAIGN	MCEX_APCAMPAIGN	SYSUUID_C	CHAR	32	0	Campaign of referred sales order item for BW-Extraction
114	APOPLANNED	APOPLANNED	APOPLANNED	CHAR	1	0	Planning in APO
115	FACELOC	FACELOC	LOCNR	CHAR	20	0	Customer-Facing Location
116	FLOCTYPE	FLOCTYPE	LOCTYP	CHAR	4	0	Type of Customer-Facing Location
117	EXECLOC	EXECLOC	LOCNR	CHAR	20	0	Executing Location
118	ELOCTYPE	ELOCTYPE	LOCTYP	CHAR	4	0	Type of Executing Location
119	LOGSYS	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
120	VWPOS	VWPOS	VWPOS	CHAR	4	0	Item usage	*
121	STOCKLOC	STOCKLOC	LOCNR	CHAR	20	0	First Inventory-Managing Location
122	SLOCTYPE	SLOCTYPE	LOCTYP	CHAR	4	0	Type of First Inventory-Managing Location