2LIS_12_VCSCL

Sales-Shipping Schedule Line Delivery | #TRAN | Extraction method: CO | Delta: ABR | Component: Sales and Distribution
Tables used: LIPS, LIKP, VBUP, VBUK → show details
Column Name Description
VBELN Sales and Distribution Document Number
POSNR Item number of the SD document
Column Name Description
Column Name Description
📏 Sales unit (VRKME):
VSMNG_L Delivered quantity per schedule line and delivery item
Column Name Description
EDATU Schedule line date
LDDAT Loading Date
MBDAT Material Staging/Availability Date
TDDAT Transportation Planning Date
WADAT Goods Issue Date
WLDATBE Desired del. date in confirmed schedule lines
LFDAT Delivery Date
WADAT_IST Actual Goods Movement Date
AEDAT Last Changed On
ERDAT Date on which the record was created
ERZET Entry time
STADAT Statistics date
VDATU Date of update for statistics updating
WADAT_LIKP Goods Issue Date
Column Name Description
ROCANCEL Indicator: Cancel Data Record Show values
KOQUA Confirmation Status of Picking/Putaway Show values
KOSTA Picking Status/Putaway Status (Item) Show values
WBSTA Goods Movement Status (Item) Show values
VBTYP SD Document Category Show values
KOMKZ Indicator for picking control Show values
KZVBR Consumption posting Show values
POSAR Item Type Show values
VGTYP SD Document Category Show values
Column Name Description Domain name
ETENR Schedule Line Number ETENR
LIFSP Schedule Line Blocked for Delivery LIFSP
ABLAD Unloading Point TEXT25
BUKRS Company Code BUKRS
INCO2 Incoterms (Part 2) INCO2
LFART Delivery Type LFART
LIFNR Vendor's account number LIFNR
EAN11 International Article Number (EAN/UPC) EAN11
ERNAM Name of Person Responsible for Creating the Object USNAM
PKUNRE Bill-to Party KUNNR
PKUNRG Payer KUNNR
PSPDNR Forwarding Agent LIFNR
PVRTNR Sales employee PERNR
UMVKN Denominator (divisor) for conversion of sales Qty into SKU UMBSN
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMBSZ
VBELN_VA Sales Document VBELN
POSNR_VA Sales Document Item POSNR
SPARA Division for order header SPART
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID
WA_DELAY BW Extraction SD/LE: GI Delay - GI Date for Schedule Line MCZAEHLER
PERIV Fiscal Year Variant PERIV
WA_DELAY_LF BW Extraction LE: Actual GI Delay - GI Date for Delivery MCZAEHLER
MCEX_APCAMPAIGN Campaign of referred sales order item for BW-Extraction SYSUUID_C
Master Data Relations Join Conditions
Sales District
  • Client
  • Sales District
  • 2LIS_12_VCSCL.MANDT == T171.MANDT
  • 2LIS_12_VCSCL.BZIRK == T171.BZIRK
Batch Number
  • Client
  • Batch Number
  • Material Number
  • Plant
  • 2LIS_12_VCSCL.MANDT == MCHA.MANDT
  • 2LIS_12_VCSCL.CHARG == MCHA.CHARG
  • 2LIS_12_VCSCL.MATNR == MCHA.MATNR
  • 2LIS_12_VCSCL.WERKS == MCHA.WERKS
Schedule line category
  • Client
  • Schedule line category
  • 2LIS_12_VCSCL.MANDT == TVEP.MANDT
  • 2LIS_12_VCSCL.ETTYP == TVEP.ETTYP
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • 2LIS_12_VCSCL.MANDT == TVFS.MANDT
  • 2LIS_12_VCSCL.FAKSK == TVFS.FAKSP
Billing Block
  • Client
  • Billing Block
  • 2LIS_12_VCSCL.MANDT == TVFS.MANDT
  • 2LIS_12_VCSCL.FAKSP == TVFS.FAKSP
Business Area
  • Client
  • Business Area
  • 2LIS_12_VCSCL.MANDT == TGSB.MANDT
  • 2LIS_12_VCSCL.GSBER == TGSB.GSBER
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • 2LIS_12_VCSCL.MANDT == TINC.MANDT
  • 2LIS_12_VCSCL.INCO1 == TINC.INCO1
Customer Group
  • Client
  • Customer Group
  • 2LIS_12_VCSCL.MANDT == T151.MANDT
  • 2LIS_12_VCSCL.KDGRP == T151.KDGRP
Sold-to Party
  • Client
  • Sold-to Party
  • 2LIS_12_VCSCL.MANDT == KNA1.MANDT
  • 2LIS_12_VCSCL.KUNAG == KNA1.KUNNR
Ship-to Party
  • Client
  • Ship-to Party
  • 2LIS_12_VCSCL.MANDT == KNA1.MANDT
  • 2LIS_12_VCSCL.KUNNR == KNA1.KUNNR
Customer Group 1
  • Client
  • Customer Group 1
  • 2LIS_12_VCSCL.MANDT == TVV1.MANDT
  • 2LIS_12_VCSCL.KVGR1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • 2LIS_12_VCSCL.MANDT == TVV2.MANDT
  • 2LIS_12_VCSCL.KVGR2 == TVV2.KVGR2
Customer Group 3
  • Client
  • Customer Group 3
  • 2LIS_12_VCSCL.MANDT == TVV3.MANDT
  • 2LIS_12_VCSCL.KVGR3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • 2LIS_12_VCSCL.MANDT == TVV4.MANDT
  • 2LIS_12_VCSCL.KVGR4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • 2LIS_12_VCSCL.MANDT == TVV5.MANDT
  • 2LIS_12_VCSCL.KVGR5 == TVV5.KVGR5
Warehouse Number / Warehouse Complex
  • Client
  • Warehouse Number / Warehouse Complex
  • 2LIS_12_VCSCL.MANDT == T300.MANDT
  • 2LIS_12_VCSCL.LGNUM == T300.LGNUM
Storage location
  • Client
  • Storage location
  • Plant
  • 2LIS_12_VCSCL.MANDT == T001L.MANDT
  • 2LIS_12_VCSCL.LGORT == T001L.LGORT
  • 2LIS_12_VCSCL.WERKS == T001L.WERKS
Storage Bin
  • Client
  • Warehouse Number / Warehouse Complex
  • Storage Bin
  • Storage Type
  • 2LIS_12_VCSCL.MANDT == LAGP.MANDT
  • 2LIS_12_VCSCL.LGNUM == LAGP.LGNUM
  • 2LIS_12_VCSCL.LGPLA == LAGP.LGPLA
  • 2LIS_12_VCSCL.LGTYP == LAGP.LGTYP
Storage Type
  • Client
  • Warehouse Number / Warehouse Complex
  • Storage Type
  • 2LIS_12_VCSCL.MANDT == T301.MANDT
  • 2LIS_12_VCSCL.LGNUM == T301.LGNUM
  • 2LIS_12_VCSCL.LGTYP == T301.LGTYP
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • 2LIS_12_VCSCL.MANDT == TVLS.MANDT
  • 2LIS_12_VCSCL.LIFSK == TVLS.LIFSP
Loading Point
  • Client
  • Loading Point
  • Shipping Point / Receiving Point
  • 2LIS_12_VCSCL.MANDT == TVLA.MANDT
  • 2LIS_12_VCSCL.LSTEL == TVLA.LSTEL
  • 2LIS_12_VCSCL.VSTEL == TVLA.VSTEL
Material Group
  • Client
  • Material Group
  • 2LIS_12_VCSCL.MANDT == T023.MANDT
  • 2LIS_12_VCSCL.MATKL == T023.MATKL
Material Number
  • Client
  • Material Number
  • 2LIS_12_VCSCL.MANDT == MARA.MANDT
  • 2LIS_12_VCSCL.MATNR == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • 2LIS_12_VCSCL.MANDT == T006.MANDT
  • 2LIS_12_VCSCL.MEINS == T006.MSEHI
Material Group 1
  • Client
  • Material Group 1
  • 2LIS_12_VCSCL.MANDT == TVM1.MANDT
  • 2LIS_12_VCSCL.MVGR1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • 2LIS_12_VCSCL.MANDT == TVM2.MANDT
  • 2LIS_12_VCSCL.MVGR2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • 2LIS_12_VCSCL.MANDT == TVM3.MANDT
  • 2LIS_12_VCSCL.MVGR3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • 2LIS_12_VCSCL.MANDT == TVM4.MANDT
  • 2LIS_12_VCSCL.MVGR4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • 2LIS_12_VCSCL.MANDT == TVM5.MANDT
  • 2LIS_12_VCSCL.MVGR5 == TVM5.MVGR5
Product hierarchy
  • Client
  • Product hierarchy
  • 2LIS_12_VCSCL.MANDT == T179.MANDT
  • 2LIS_12_VCSCL.PRODH == T179.PRODH
Delivery item category
  • Client
  • Delivery item category
  • 2LIS_12_VCSCL.MANDT == TVPT.MANDT
  • 2LIS_12_VCSCL.PSTYV == TVPT.PSTYV
Route
  • Client
  • Route
  • 2LIS_12_VCSCL.MANDT == TVRO.MANDT
  • 2LIS_12_VCSCL.ROUTE == TVRO.ROUTE
Sales office
  • Client
  • Sales office
  • 2LIS_12_VCSCL.MANDT == TVBUR.MANDT
  • 2LIS_12_VCSCL.VKBUR == TVBUR.VKBUR
Sales group
  • Client
  • Sales group
  • 2LIS_12_VCSCL.MANDT == TVKGR.MANDT
  • 2LIS_12_VCSCL.VKGRP == TVKGR.VKGRP
Sales Organization
  • Client
  • Sales Organization
  • 2LIS_12_VCSCL.MANDT == TVKO.MANDT
  • 2LIS_12_VCSCL.VKORG == TVKO.VKORG
Sales unit
  • Client
  • Sales unit
  • 2LIS_12_VCSCL.MANDT == T006.MANDT
  • 2LIS_12_VCSCL.VRKME == T006.MSEHI
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • 2LIS_12_VCSCL.MANDT == TVST.MANDT
  • 2LIS_12_VCSCL.VSTEL == TVST.VSTEL
Distribution Channel
  • Client
  • Distribution Channel
  • 2LIS_12_VCSCL.MANDT == TVTW.MANDT
  • 2LIS_12_VCSCL.VTWEG == TVTW.VTWEG
Plant
  • Client
  • Plant
  • 2LIS_12_VCSCL.MANDT == T001W.MANDT
  • 2LIS_12_VCSCL.WERKS == T001W.WERKS