1. Home
  2. Resources
  3. SAP Tables
  4. MC12VC0SCL - Extraction LE Shipping BW: Schedule Line Delivery

SAP Table MC12VC0SCL

Extraction LE Shipping BW: Schedule Line Delivery

MC12VC0SCL (Extraction LE Shipping BW: Schedule Line Delivery) 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 MC12VC0SCL to other SAP tables.

MC12VC0SCL table fields

Field Data element Checktable Datatype Length Decimals
ROCANCEL Indicator: Cancel Data Record ROCANCEL CHAR 1 0
X TRUE
NULL FALSE
KOSTK Overall picking / putaway status KOSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
WBSTK Total goods movement status WBSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
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
KOQUA Confirmation status of picking/putaway KOQUA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
KOSTA Picking status/Putaway status KOSTA 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
WBSTA Goods movement status WBSTA 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
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
TDDAT Transportation Planning Date TDDAT_D DATS 8 0
VSMNG_L Delivered quantity per schedule line and delivery item MC_VSMNG_L QUAN 15 3
WADAT Goods Issue Date WADAT DATS 8 0
WLDATBE Desired del. date in confirmed schedule lines WLDATBE DATS 8 0
ABLAD Unloading Point ABLAD CHAR 25 0
BUKRS Company Code BUKRS CHAR 4 0
BZIRK Sales district BZIRK CHAR 6 0
FAKSK Billing block in SD document FAKSK CHAR 2 0
INCO1 Incoterms (Part 1) INCO1 CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
KDGRP Customer group KDGRP CHAR 2 0
KUNAG Sold-to party KUNAG CHAR 10 0
KUNNR Ship-to party KUNWE CHAR 10 0
LFART Delivery Type LFART CHAR 4 0
LFDAT Delivery Date LFDAT_V DATS 8 0
LIFNR Vendor Account Number ELIFN CHAR 10 0
LIFSK Delivery block (document header) LIFSK CHAR 2 0
LSTEL Loading Point LSTEL CHAR 2 0
ROUTE Route ROUTE CHAR 6 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
VKORG Sales Organization VKORG CHAR 4 0
VSTEL Shipping Point/Receiving Point VSTEL CHAR 4 0
WADAT_IST Actual Goods Movement Date WADAT_IST DATS 8 0
OICFKARTDI Differential invoice billing type proposal OICFKARTDI CHAR 4 0
OICSDP_DVERNO Version number sequence OIC_SDP_DVERNO CHAR 2 0
OILDTIM Loading time OIC_LDTIM TIMS 6 0
OIWATIM Actual goods issue time (for time pricing) OIC_WATIM TIMS 6 0
WAERK SD Document Currency WAERK CUKY 5 0
OIO_HOLD Indicator: Hold Delivery Onshore OIO_HOLD CHAR 1 0
X Yes
NULL No
OIO_HOLD_ORIG Flag: Delivery was Originally Held at Base Location OIO_HOLD_ORIG CHAR 1 0
X Yes
NULL No
AEDAT Changed On AEDAT DATS 8 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
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERZET Entry time ERZET TIMS 6 0
FAKSP Block FAKSP CHAR 2 0
GSBER Business Area GSBER CHAR 4 0
KOMKZ Indicator for picking control KOMKZ CHAR 1 0
NULL Picking is not carried out
A Picking is not carried out with WMS
B WMS fixed bin picking
C Picking carried out via WMS transfer orders
D LEAN WM in use
1 Single-step procedure for multiple picking
2 Two-step procedure for multiple picking
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
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
LGNUM Warehouse Number / Warehouse Complex LGNUM CHAR 3 0
LGORT Storage Location LGORT_D CHAR 4 0
LGPLA Storage Bin LGPLA CHAR 10 0
LGTYP Storage Type LGTYP CHAR 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
POSAR Item type POSAR CHAR 1 0
NULL Standard Item
A Value Item
B Text item
C Packing item (will be generated)
D Material not relevant
E Packaging Item (External)
PRODH Product hierarchy PRODH_D CHAR 18 0
PSPDNR Forwarding agent SPDNR CHAR 10 0
PSTYV Delivery item category PSTYV_VL CHAR 4 0
PVRTNR Sales employee VRTNR NUMC 8 0
PZPERS Person responsible DZPERS NUMC 8 0
STADAT Statistics date STADAT DATS 8 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
VDATU Date of update for statistics updating MC_VDATUM DATS 8 0
VGTYP 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
VRKME Sales unit VRKME UNIT 3 0
VTWEG Distribution Channel VTWEG CHAR 2 0
WERKS Plant WERKS_D CHAR 4 0
OIA_BASELO Base location OIA_BASELO CHAR 15 0
OIA_FFTYP Fulfillment indicator for exchange assignments OIA_FFTYP CHAR 1 0
E Exchange entitlement only
N No assignment possible
NULL Not specified
OIA_IPMVAT VAT on internally-posted material OIA_IPMVAT CHAR 1 0
NULL No VAT calculation
X VAT calculation with subtotal V of pricing procedure
OIBASPROD Base product number OIA_SBMAT CHAR 18 0
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_DATE Date for time pricing OIC_LFDAT DATS 8 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_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_TIME Time for time pricing OIC_LFTIM TIMS 6 0
OIC_TRUCKN Truck number OIC_TRUCKN CHAR 10 0
OIC_WADAT Goods issue date (for time pricing) OIC_WADAT DATS 8 0
OIC_WATIM Actual goods issue time (for time pricing) OIC_WATIM TIMS 6 0
OIDATFM1 Excise Duty License Valid from Date OIH_DATFM1 DATS 8 0
OIDATTO1 Valid to date for excise duty tax certificate OIH_DATTO1 DATS 8 0
OID_EXTBOL External bill of lading OID_EXTBOL CHAR 16 0
OID_MISCDL Miscellaneous delivery number OID_MISCDL CHAR 16 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
OIEXGNUM Exchange agreement number OIA_EXGNUM CHAR 10 0
OIEXGTYP Exchange type OIA_EXGTYP CHAR 4 0
OIEXTNR External tracking number OIH_EXTNR CHAR 18 0
OIFEEDT Fee pricing condition date OIA_FEEDT DATS 8 0
OIFEETOT Fee total OIA_FEETOT CURR 13 2
OIFTIND Final transfer indicator OIH_FTIND CHAR 1 0
X Final transfer indicator
OIGHNDL Gain handling OIH_GHNDL CHAR 1 0
NULL Post transit gain only on final transfer
1 Post transit gain when GR > in-transit quantity
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
OIITMNR Tracking number item line OIH_ITMNR NUMC 5 0
OII_CONLG OIL-BDRP: Consignment stock receiving s/loc in delivery OII_CONLG CHAR 4 0
OII_CONWK OIL-BDRP: Consignment stock receiving plant in delivery OII_CONWK CHAR 4 0
OIMATREF Material group reference for exchange balance reporting OIA_MATREF CHAR 20 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 %
OIO_SPROC Supply Process OIO_SPROC CHAR 4 0
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
OIPRICIE ED pricing: external (indicator) OIH_PRICIE CHAR 1 0
X Yes
NULL No
OIPRIOP Price options for gain calculation OIH_PRIOP CHAR 1 0
1 G/L calculation based on the sending plant (from GI)
2 G/L calculation based on the receiving plant (current)
3 G/L calculation based on the sending plant (at time of GR)
4 G/L calculation based on condition record
OISBREL Sub product/ base product relevence indicator OIA_SBREL NUMC 3 0
OITAXFROM Excise duty tax key for 'from' location OIH_TAXFRO CHAR 2 0
OITAXGRP Excise Duty Group OIH_TAXGRP CHAR 2 0
OITAXINV Excise duty tax value for an invoice OIH_TAXINV CURR 13 2
OITAXISS Excise duty value for goods issue OIH_TAXISS CURR 13 2
OITAXLOD Excise duty tax value for goods loading OIH_TAXLOD CURR 13 2
OITAXTO Excise duty tax key for 'to' location OIH_TAXTO CHAR 2 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
OITRIND Transfer sign for plant-to-plant transfers OIH_TRIND CHAR 1 0
NULL SAP standard procedure
1 SAP standard procedure with tracking records for statistics
2 IS-OIL plant to plant transfers with tracking records
OITRKJR Tracking number year OIH_TRKJR NUMC 4 0
OITRKNR Tracking number OIH_TRKNR CHAR 10 0
VBELN_VA Sales Document VBELN_VA CHAR 10 0
POSNR_VA Sales Document Item POSNR_VA NUMC 6 0
WADAT_LIKP Goods Issue Date WADAT DATS 8 0
SPARA Division for order header SPART_AK CHAR 2 0
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
WA_DELAY BW Extraction SD/LE: GI Delay - GI Date for Schedule Line MCBW_WA_DELAY DEC 9 0
PERIV Fiscal Year Variant PERIV CHAR 2 0
WA_DELAY_LF BW Extraction LE: Actual GI Delay - GI Date for Delivery MCBW_WA_DELAY_LF DEC 9 0
MCEX_APCAMPAIGN Campaign of referred sales order item for BW-Extraction MCEX_APCAMPAIGN CHAR 32 0