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

SAP Table MC11V_0SCL

Extraction SD Sales BW: Allocation Schedule Line

MC11V_0SCL (Extraction SD Sales BW: Allocation 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 MC11V_0SCL to other SAP tables.

MC11V_0SCL 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
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
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
MBDAT Material Staging/Availability Date MBDAT DATS 8 0
OLFMNG Open quantity to be delivered (in sales unit) OLFMNG QUAN 13 3
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
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
OIAEVGTYPE Evergreen type OIA_EVTYPE CHAR 1 0
NULL None
R Regular
U Unlimited
OICFKARTDI Differential invoice billing type proposal OICFKARTDI CHAR 4 0
OICHEADOFF Head office account number (in branch accounts) KNRZE CHAR 10 0
OICNTNTE Contact note OID_CNTNTE CHAR 35 0
OICNTPER Contact person OID_CNTPER CHAR 35 0
OIDRESTR Contract restrictions flag OIDRESTR CHAR 1 0
NULL Not Selected
X Selected
OIDSTS_SHP Status of contract restriction for ship-to party OIDSTS_SHP CHAR 1 0
NULL Not Selected
X Selected
OID_SORT2 Descending sort key for sales orders (converted time) OID_SORT2 NUMC 10 0
OID_SORTL Descending sort key for sales orders (converted date) OID_SORTL NUMC 10 0
OIISOIL Sales order created by IS-Oil: X=Yes BLANK=No OID_ISOIL CHAR 1 0
X Yes
NULL No
OILASTOR Last order number OID_LASTOR CHAR 10 0
OIPARTNR Customer name (sold-to party or ship-to party) OID_PARTNR CHAR 10 0
OIPBL Business location identifier (IS-Oil MRN) OIF_PBLNR CHAR 10 0
OIPTRFNC Partner function OID_PTRFNC CHAR 2 0
CHARG Batch Number CHARG_D CHAR 10 0
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
FAKSP Billing block for item FAKSP_AP CHAR 2 0
GEWEI Weight Unit GEWEI UNIT 3 0
MATKL Material Group MATKL CHAR 9 0
MATNR Material Number MATNR CHAR 18 0
MEINS Base Unit of Measure MEINS UNIT 3 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
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
PVRTNR Sales employee VRTNR NUMC 8 0
PZPERS Person responsible DZPERS NUMC 8 0
ROUTE Route ROUTE CHAR 6 0
SHKZG Returns Item SHKZG_VA CHAR 1 0
X Yes
NULL No
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
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
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
OIA_BASELO Base location OIA_BASELO CHAR 15 0
OIBASPROD Base product number OIA_SBMAT CHAR 18 0
OIBYPASS IS-Oil plant determination indicator: x=yes blank=no OID_BYPASS CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
OICERTF1 Excise tax external license number OIH_CERTF1 CHAR 15 0
OICONTNR Outline agreement: contract OIC_CONTNR CHAR 10 0
OIC_ADESTN Alternate destination OIC_ADESTN CHAR 15 0
OIC_AORGIN Alternate origin OIC_AORGIN CHAR 15 0
OIC_DCITYC Destination city code OIC_DCITYC CHAR 4 0
OIC_DCOUNC Destination county code OIC_DCOUNC CHAR 3 0
OIC_DLAND1 Destination country OIC_DLAND1 CHAR 3 0
OIC_DRCREG DRC region OIC_DRCREG CHAR 3 0
OIC_DRCTRY DRC country OIC_DRCTRY CHAR 3 0
OIC_DREGIO Destination region OIC_DREGIO CHAR 3 0
OIC_KMPOS Reference contract line item number OIC_KMPOS NUMC 6 0
OIC_LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
OIC_MOT IS-OIL MAP external details mode of transport OIC_MOT CHAR 2 0
OIC_OCITYC Origin city code OIC_OCITYC CHAR 4 0
OIC_OCOUNC Origin county code OIC_OCOUNC CHAR 3 0
OIC_OLAND1 Origin country OIC_OLAND1 CHAR 3 0
OIC_OREGIO Origin region OIC_OREGIO CHAR 3 0
OIC_PBATCH Pipeline operator�s external batch number OIC_PBATCH CHAR 16 0
OIC_PDESTN Tax destination OIC_PDESTN CHAR 15 0
OIC_PORGIN Tax origin OIC_PORGIN CHAR 15 0
OIC_PTRIP Pipeline trip number (external) OIC_PTRIP CHAR 16 0
OIC_TRUCKN Truck number OIC_TRUCKN CHAR 10 0
OIDMSG_DAT Message type for contract restrictions validity period OIDMSG_DAT CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_PRD Message type for product with contract restrictions OIDMSG_PRD CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_QTY Message type for contract restrictions quantity OIDMSG_QTY CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_SHP Message type for contract restrictions ship-to party OIDMSG_SHP CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_TRM Message type for contract restrictions payment terms OIDMSG_TRM CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_UOM Message type for contract restrictions unit of measure OIDMSG_UOM CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDRC Differential Reference Code (DRC) OIC_DRC CHAR 5 0
OID_EXTBOL External bill of lading OID_EXTBOL CHAR 16 0
OID_MISCDL Miscellaneous delivery number OID_MISCDL CHAR 16 0
OID_SHIP Ship-to party KUNWE CHAR 10 0
OIEDBAL Excise duty balancing is required (indicator) OIH_EDBAL CHAR 1 0
X Yes
NULL No
OIEDBALM Excise duty balancing method indicator OIH_EDBALM CHAR 1 0
0 Transport & Distribution (TD) is not Active
1 Loading with Vehicle's Status
2 Loading with Customer's Status
OIEDOK Excise duty validation indicator OIH_EDOK CHAR 1 0
X Yes
NULL No
OIEXGNUM Exchange agreement number OIA_EXGNUM CHAR 10 0
OIEXGTYP Exchange type OIA_EXGTYP CHAR 4 0
OIFEECH Fee edit control OIA_FEECH CHAR 1 0
1 Add, delete, change, reprice abilities active
2 Change, reprice only
3 Display only active
OIFEEDT Fee pricing condition date OIA_FEEDT DATS 8 0
OIFEETOT Fee total OIA_FEETOT CURR 13 2
OIGNRULE Gross/net pricing rule OIC_GNRULE NUMC 3 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP CHAR 2 0
OIH_FOLQTY Excise Tax Follow-On License Quantity OIH_FOLQTY QUAN 13 3
OIH_LCFOL Follow-on license for quantity license OIH_LCFOL CHAR 10 0
OIH_LICIN Excise tax internal license number OIH_LICIN CHAR 10 0
OIH_LICTP License type OIH_LICTP CHAR 4 0
OIINEX Code for internal or external excise duty rate determination OIH_INEX CHAR 2 0
OIINTQTY Quantity scheduled to be exchanged OIA_INTQTY QUAN 13 3
OIMEINS Quantity schedule-related UoM OIA_MEINS UNIT 3 0
OIMETIND Metropolitan indicator OIC_METIND CHAR 4 0
OINETCYC Netting cycle (FI blocking indicator) OIA_NETCYC CHAR 1 0
OIOILCON Oil content in a material as a percentage OIH_OILCON DEC 5 2
0 Range of permissible values for Mineral Oil Content %
OIPBLP Business location identifier (IS-Oil MRN) OIF_PBLNRP CHAR 10 0
OIPIPEVAL Validation indicator for pipeline fields (X=ON, blank=OFF) OID_PIPEV CHAR 1 0
X Yes
NULL No
OIPLANTD Plant determination active or not active OID_PLANTD CHAR 1 0
X Yes
NULL No
OIPRICIE ED pricing: external (indicator) OIH_PRICIE CHAR 1 0
X Yes
NULL No
OIPSDRC Pricing DRC (grouping customers by DRC for pricing) OIC_PSDRC CHAR 5 0
OIRECQTY Quantity intended against an exchange OIA_RECQTY QUAN 13 3
OISBREL Sub product/ base product relevence indicator OIA_SBREL NUMC 3 0
OISLF State license fee zone OIC_SLF CHAR 3 0
OISMENGE Called-off/delivered/goods receipt quantity OIA_SMENGE QUAN 13 3
OITAXFROM Excise duty tax key for 'from' location OIH_TAXFRO CHAR 2 0
OITAXGRP Excise Duty Group OIH_TAXGRP CHAR 2 0
OITAXTO Excise duty tax key for 'to' location OIH_TAXTO CHAR 2 0
OIWAP Wide-area pricing zone OIC_WAP CHAR 3 0
BZIRK Sales district BZIRK CHAR 6 0
INCO1 Incoterms (Part 1) INCO1 CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
KDGRP Customer group KDGRP CHAR 2 0
KURSK Exchange Rate for Price Determination KURSK DEC 9 5
OIC_TIME Time for time-pricing OIC_TIME TIMS 6 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
SPARA Division for order header SPART_AK CHAR 2 0
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
B_DELAY BW Extraction SD/LE: Confirmation Delivery MCBW_B_DELAY DEC 9 0
VSMNG Delivered quantity in sales units VSMNG QUAN 13 3
MCBW_WWERT BW: Value of Requested Quantity MCBW_WWERT CURR 19 2
MCBW_BWERT BW: Value of Confirmed Quantity MCBW_BWERT CURR 19 2
MCBW_VSWRT BW: Delivered Value for Schedule Line MCBW_VSWRT CURR 19 2
MCBW_OLFWRT BW: Open Sales Order Value for Schedule Line MCBW_OLFWRT CURR 19 2
MCBW_NETPR_AVKM BW: Net Price Referring to Sales Quantity for Order Item MCBW_NETPR_AVKM CURR 11 2
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