1. Home
  2. Resources
  3. SAP Tables
  4. MC11VA0SCL - Extraction SD Sales BW: Document Schedule Line

SAP Table MC11VA0SCL

Extraction SD Sales BW: Document Schedule Line

MC11VA0SCL (Extraction SD Sales BW: Document Schedule Line) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MC11VA0SCL to other SAP tables.

MC11VA0SCL table fields

Field Data element Checktable Datatype Length Decimals
ROCANCEL Indicator: Cancel Data Record ROCANCEL CHAR 1 0
X TRUE
NULL FALSE
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
OIC_NXTINV Next billing date for invoice if status is provisional OIC_NXINV DATS 8 0
OIG_SSTSF TD Shipment Status (Functional) OIG_SSTSF CHAR 1 0
1 Partially Scheduled
2 Scheduled
3 Partially Loaded (Plants Missing)
4 Completely Loaded
5 Partially Confirmed (Deliveries Missing)
6 Completely Confirmed
OI_SHIP Ship-to party KUNWE CHAR 10 0
ABSTA Rejection status for SD item ABSTA_VB CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
POSNR Item number of the SD document POSNR NUMC 6 0
UVALL General Incompletion Status of Item UVALL_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVFAK Item Incompletion Status with Respect to Billing UVFAK_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVPRS Pricing for item is incomplete UVPRS_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVVLK Incompletion status of the item with regard to delivery UVVLK_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
OIFINAL Final Delivery Indicator OID_FINAL CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
OIINVCST1 Status of invoice cycle 1 OIA_INVCS1 CHAR 1 0
NULL not invoiced
P provisionally invoiced
C completely invoiced
OIINVCST2 Status of invoice cycle 2 OIA_INVCS2 CHAR 1 0
NULL not invoiced
P provisionally invoiced
C completely invoiced
OIINVCST3 Status of invoice cycle 3 OIA_INVCS3 CHAR 1 0
NULL not invoiced
P provisionally invoiced
C completely invoiced
OIINVCST4 Status of invoice cycle 4 OIA_INVCS4 CHAR 1 0
NULL not invoiced
P provisionally invoiced
C completely invoiced
OIINVCST5 Status of invoice cycle 5 OIA_INVCS5 CHAR 1 0
NULL not invoiced
P provisionally invoiced
C completely invoiced
OIINVCST6 Status of invoice cycle 6 OIA_INVCS6 CHAR 1 0
NULL not invoiced
P provisionally invoiced
C completely invoiced
OIINVCST7 Status of invoice cycle 7 OIA_INVCS7 CHAR 1 0
NULL not invoiced
P provisionally invoiced
C completely invoiced
OIINVCST8 Status of invoice cycle 8 OIA_INVCS8 CHAR 1 0
NULL not invoiced
P provisionally invoiced
C completely invoiced
OIINVCST9 Status of invoice cycle 9 OIA_INVCS9 CHAR 1 0
NULL not invoiced
P provisionally invoiced
C completely invoiced
BMENG Confirmed Quantity BMENG QUAN 13 3
CMENG Corrected quantity in sales unit CMENG QUAN 13 3
EDATU Schedule line date EDATU DATS 8 0
ETENR Delivery Schedule Line Number ETENR NUMC 4 0
ETTYP Schedule line category ETTYP CHAR 2 0
LDDAT Loading Date LDDAT DATS 8 0
LIFSP Schedule line blocked for delivery LIFSP_EP CHAR 2 0
LMENG Required quantity for mat.management in stockkeeping units LMENG QUAN 13 3
MBDAT Material Staging/Availability Date MBDAT DATS 8 0
MEINS Base Unit of Measure MEINS UNIT 3 0
TDDAT Transportation Planning Date TDDAT_D DATS 8 0
VRKME Sales unit VRKME UNIT 3 0
WADAT Goods Issue Date WADAT DATS 8 0
WLDATBE Desired del. date in confirmed schedule lines WLDATBE DATS 8 0
WMENG Order quantity in sales units WMENG QUAN 13 3
ANGDT Quotation/Inquiry is valid from ANGDT_V DATS 8 0
AUART Sales Document Type AUART CHAR 4 0
AUGRU Order reason (reason for the business transaction) AUGRU CHAR 3 0
BNDDT Date until which bid/quotation is binding (valid-to date) BNDDT DATS 8 0
BUKRS Company Code BUKRS CHAR 4 0
FAKSK Billing block in SD document FAKSK CHAR 2 0
HWAER Local Currency HWAER CUKY 5 0
KUNNR Sold-to party KUNAG CHAR 10 0
KURST Exchange Rate Type KURST CHAR 4 0
KVGR1 Customer group 1 KVGR1 CHAR 3 0
KVGR2 Customer group 2 KVGR2 CHAR 3 0
KVGR3 Customer group 3 KVGR3 CHAR 3 0
KVGR4 Customer group 4 KVGR4 CHAR 3 0
KVGR5 Customer group 5 KVGR5 CHAR 3 0
LIFSK Delivery block (document header) LIFSK CHAR 2 0
STWAE Statistics currency STWAE CUKY 5 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
VKBUR Sales Office VKBUR CHAR 4 0
VKGRP Sales Group VKGRP CHAR 3 0
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
ABGRU Reason for rejection of quotations and sales orders ABGRU_VA CHAR 2 0
AEDAT Changed On AEDAT DATS 8 0
AWAHR Order probability of the item AWAHR NUMC 3 0
000 Sales order probability
CHARG Batch Number CHARG_D CHAR 10 0
CMKUA Credit data exchange rate for requested delivery date CMKUA DEC 9 5
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERZET Entry time ERZET TIMS 6 0
FAKSP Billing block for item FAKSP_AP CHAR 2 0
GEWEI Weight Unit GEWEI UNIT 3 0
KMEIN Condition unit KMEIN UNIT 3 0
KPEIN Condition pricing unit KPEIN DEC 5 0
LGORT Storage Location LGORT_D CHAR 4 0
MATKL Material Group MATKL CHAR 9 0
MATNR Material Number MATNR CHAR 18 0
MATWA Material entered MATWA CHAR 18 0
MVGR1 Material group 1 MVGR1 CHAR 3 0
MVGR2 Material group 2 MVGR2 CHAR 3 0
MVGR3 Material group 3 MVGR3 CHAR 3 0
MVGR4 Material group 4 MVGR4 CHAR 3 0
MVGR5 Material group 5 MVGR5 CHAR 3 0
NETPR Net price NETPR CURR 11 2
PABLA Unloading point of the ship-to party PABLA CHAR 25 0
PKUNRE Bill-to party KUNRE CHAR 10 0
PKUNRG Payer KUNRG CHAR 10 0
PKUNWE Ship-to party KUNWE CHAR 10 0
PRODH Product hierarchy PRODH_D CHAR 18 0
PSPDNR Forwarding agent SPDNR CHAR 10 0
PSTYV Sales document item category PSTYV CHAR 4 0
PVRTNR Sales employee VRTNR NUMC 8 0
PZPERS Person responsible DZPERS NUMC 8 0
ROUTE Route ROUTE CHAR 6 0
SPART Division SPART CHAR 2 0
STADAT Statistics date STADAT DATS 8 0
STCUR Exchange rate for statistics (Exch.rate at time of creation) STCUR_AP DEC 9 5
SUGRD Reason for material substitution SUGRD CHAR 4 0
UMVKN Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 0
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 0
UMZIN Factor for converting sales units to base units (target qty) UMZIN DEC 5 0
UMZIZ Factor for converting sales units to base units (target qty) UMZIZ DEC 5 0
VDATU Date of update for statistics updating MC_VDATUM DATS 8 0
VGTYP Document category of preceding SD document VBTYP_V CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
VOLEH Volume unit VOLEH UNIT 3 0
VSTEL Shipping Point/Receiving Point VSTEL CHAR 4 0
WAERK SD Document Currency WAERK CUKY 5 0
WERKS Plant (Own or External) WERKS_EXT CHAR 4 0
ZIEME Target quantity UoM DZIEME UNIT 3 0
OIA_BASELO Base location OIA_BASELO CHAR 15 0
OIBASPROD Base product number OIA_SBMAT CHAR 18 0
BZIRK Sales district BZIRK CHAR 6 0
FBUDA Date on which services rendered FBUDA DATS 8 0
FKDAT Billing date for billing index and printout FKDAT DATS 8 0
INCO1 Incoterms (Part 1) INCO1 CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
KDGRP Customer group KDGRP CHAR 2 0
KTGRD Account assignment group for this customer KTGRD CHAR 2 0
KURSK Exchange Rate for Price Determination KURSK DEC 9 5
KURSK_DAT Translation Date WWERT_D DATS 8 0
PRSDT Date for pricing and exchange rate PRSDT DATS 8 0
OIPFLIC IS-OIL partner function for tax exemption license OIH_PFLIC CHAR 2 0
OIPTRM1 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM2 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM3 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM4 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM5 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM6 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM7 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM8 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM9 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OITITLE Location of title transfer for Incoterms purposes OIC_TITLE CHAR 1 0
NULL Title passes at plant
1 Title passes at Ship-to
WAERK_VBAK SD Document Currency WAERK CUKY 5 0
SPARA Division for order header SPART_AK CHAR 2 0
VGTYP_AK Sales Document Category of Reference Doc. in Order Header MC_VBTYPAK CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
PERIV Fiscal Year Variant PERIV CHAR 2 0
MCEX_APCAMPAIGN Campaign of referred sales order item for BW-Extraction MCEX_APCAMPAIGN CHAR 32 0
APOPLANNED Planning in APO APOPLANNED CHAR 1 0
0 Sales Scheduling Agreement Item not Planned in APO
1 Sales Scheduling Agreement Item Planned in APO
NULL Sales Scheduling Agreement Item not Planned in APO
FACELOC Customer-Facing Location FACELOC CHAR 20 0
FLOCTYPE Type of Customer-Facing Location FLOCTYPE CHAR 4 0
1001 Production Plant
1002 Distribution center
1003 Shipping Point
1005 Transportation Zone
1006 Stock transfer point
1007 Storage Location MRP Area
1010 Customer
1011 Vendor
1050 Subcontractor
1020 Transportation Service Agent
1030 Terminal
1031 Geographical Area
1040 Store
EXECLOC Executing Location EXECLOC CHAR 20 0
ELOCTYPE Type of Executing Location ELOCTYPE CHAR 4 0
1001 Production Plant
1002 Distribution center
1003 Shipping Point
1005 Transportation Zone
1006 Stock transfer point
1007 Storage Location MRP Area
1010 Customer
1011 Vendor
1050 Subcontractor
1020 Transportation Service Agent
1030 Terminal
1031 Geographical Area
1040 Store
LOGSYS Logical system LOGSYS CHAR 10 0
VWPOS Item usage VWPOS CHAR 4 0
STOCKLOC First Inventory-Managing Location STOCKLOC CHAR 20 0
SLOCTYPE Type of First Inventory-Managing Location SLOCTYPE CHAR 4 0
1001 Production Plant
1002 Distribution center
1003 Shipping Point
1005 Transportation Zone
1006 Stock transfer point
1007 Storage Location MRP Area
1010 Customer
1011 Vendor
1050 Subcontractor
1020 Transportation Service Agent
1030 Terminal
1031 Geographical Area
1040 Store