2LIS_11_V_SCL

Sales-Shipping Allocation Schedule Line | #TRAN | Extraction method: CO | Delta: ABR | Component: Sales and Distribution
Tables used: VBAP, LIPS, LIKP, VBAK, VBEP ... +3 more
Column Name Description
VBELN Sales and Distribution Document Number
POSNR Item number of the SD document
ETENR Schedule Line Number
Column Name Description
💲 SD Document Currency (WAERK):
MCBW_WWERT BW: Value of Requested Quantity
MCBW_BWERT BW: Value of Confirmed Quantity
MCBW_VSWRT BW: Delivered Value for Schedule Line
MCBW_OLFWRT BW: Open Sales Order Value for Schedule Line
MCBW_NETPR_AVKM BW: Net Price Referring to Sales Quantity for Order Item
Column Name Description
📏 Sales unit (VRKME):
BMENG Confirmed Quantity
OLFMNG Open quantity to be delivered (in sales unit)
WMENG Order Quantity in Sales Units
VSMNG Delivered quantity in sales units
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
ERDAT Date on which the record was created
STADAT Statistics date
Column Name Description
ROCANCEL Indicator: Cancel Data Record Show values
ABSTA Rejection Status (Item) Show values
VBTYP SD Document Category Show values
SHKZG Returns Item Show values
APOPLANNED Planning in APO Show values
Column Name Description Domain name
BUKRS Company Code BUKRS
KVGR3 Customer Group 3 KVGR3
KVGR4 Customer Group 4 KVGR4
VKORG Sales Organization VKORG
EAN11 International Article Number (EAN/UPC) EAN11
PKUNRE Bill-to Party KUNNR
PKUNRG Payer KUNNR
PKUNWE Ship-to Party KUNNR
PSPDNR Forwarding Agent LIFNR
PVRTNR Sales employee PERNR
STCUR Exchange rate for statistics (Exch.rate at time of creation) KURRF
UMVKN Denominator (divisor) for conversion of sales Qty into SKU UMBSN
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMBSZ
WERKS Plant (Own or External) WERKS
INCO2 Incoterms (Part 2) INCO2
KURSK Exchange Rate for Price Determination KURRF
SPARA Division for order header SPART
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID
B_DELAY BW Extraction SD/LE: Confirmation Delivery MCZAEHLER
PERIV Fiscal Year Variant PERIV
MCEX_APCAMPAIGN Campaign of referred sales order item for BW-Extraction SYSUUID_C
Master Data Relations Join Conditions
Sales District
  • Client
  • Sales District
  • 2LIS_11_V_SCL.MANDT == T171.MANDT
  • 2LIS_11_V_SCL.BZIRK == T171.BZIRK
Batch Number
  • Client
  • ?
  • Batch Number
  • Material Number
  • Plant (Own or External)
  • 2LIS_11_V_SCL.MANDT == MCHA.MANDT
  • 2LIS_11_V_SCL.[column in domain "WERKS_D"] == MCHA.WERKS
  • 2LIS_11_V_SCL.CHARG == MCHA.CHARG
  • 2LIS_11_V_SCL.MATNR == MCHA.MATNR
  • 2LIS_11_V_SCL.WERKS == MCHA.WERKS
Schedule line category
  • Client
  • Schedule line category
  • 2LIS_11_V_SCL.MANDT == TVEP.MANDT
  • 2LIS_11_V_SCL.ETTYP == TVEP.ETTYP
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • 2LIS_11_V_SCL.MANDT == TVFS.MANDT
  • 2LIS_11_V_SCL.FAKSK == TVFS.FAKSP
Billing Block for Item
  • Client
  • Billing Block for Item
  • 2LIS_11_V_SCL.MANDT == TVFS.MANDT
  • 2LIS_11_V_SCL.FAKSP == TVFS.FAKSP
Weight Unit
  • Client
  • Weight Unit
  • 2LIS_11_V_SCL.MANDT == T006.MANDT
  • 2LIS_11_V_SCL.GEWEI == T006.MSEHI
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • 2LIS_11_V_SCL.MANDT == TINC.MANDT
  • 2LIS_11_V_SCL.INCO1 == TINC.INCO1
Customer Group
  • Client
  • Customer Group
  • 2LIS_11_V_SCL.MANDT == T151.MANDT
  • 2LIS_11_V_SCL.KDGRP == T151.KDGRP
Sold-to Party
  • Client
  • Sold-to Party
  • 2LIS_11_V_SCL.MANDT == KNA1.MANDT
  • 2LIS_11_V_SCL.KUNNR == KNA1.KUNNR
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • 2LIS_11_V_SCL.MANDT == TCURV.MANDT
  • 2LIS_11_V_SCL.KURST == TCURV.KURST
Customer Group 1
  • Client
  • Customer Group 1
  • 2LIS_11_V_SCL.MANDT == TVV1.MANDT
  • 2LIS_11_V_SCL.KVGR1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • 2LIS_11_V_SCL.MANDT == TVV2.MANDT
  • 2LIS_11_V_SCL.KVGR2 == TVV2.KVGR2
Customer Group 5
  • Client
  • Customer Group 5
  • 2LIS_11_V_SCL.MANDT == TVV5.MANDT
  • 2LIS_11_V_SCL.KVGR5 == TVV5.KVGR5
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • 2LIS_11_V_SCL.MANDT == TVLS.MANDT
  • 2LIS_11_V_SCL.LIFSK == TVLS.LIFSP
Schedule Line Blocked for Delivery
  • Client
  • Schedule Line Blocked for Delivery
  • 2LIS_11_V_SCL.MANDT == TVLS.MANDT
  • 2LIS_11_V_SCL.LIFSP == TVLS.LIFSP
Material Group
  • Client
  • Material Group
  • 2LIS_11_V_SCL.MANDT == T023.MANDT
  • 2LIS_11_V_SCL.MATKL == T023.MATKL
Material: order item
  • Client
  • Material Number
  • 2LIS_11_V_SCL.MANDT == MARA.MANDT
  • 2LIS_11_V_SCL.MATNR == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • 2LIS_11_V_SCL.MANDT == T006.MANDT
  • 2LIS_11_V_SCL.MEINS == T006.MSEHI
Material Group 1
  • Client
  • Material Group 1
  • 2LIS_11_V_SCL.MANDT == TVM1.MANDT
  • 2LIS_11_V_SCL.MVGR1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • 2LIS_11_V_SCL.MANDT == TVM2.MANDT
  • 2LIS_11_V_SCL.MVGR2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • 2LIS_11_V_SCL.MANDT == TVM3.MANDT
  • 2LIS_11_V_SCL.MVGR3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • 2LIS_11_V_SCL.MANDT == TVM4.MANDT
  • 2LIS_11_V_SCL.MVGR4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • 2LIS_11_V_SCL.MANDT == TVM5.MANDT
  • 2LIS_11_V_SCL.MVGR5 == TVM5.MVGR5
Product hierarchy
  • Client
  • Product hierarchy
  • 2LIS_11_V_SCL.MANDT == T179.MANDT
  • 2LIS_11_V_SCL.PRODH == T179.PRODH
Route
  • Client
  • Route
  • 2LIS_11_V_SCL.MANDT == TVRO.MANDT
  • 2LIS_11_V_SCL.ROUTE == TVRO.ROUTE
Division
  • Client
  • Division
  • 2LIS_11_V_SCL.MANDT == TSPA.MANDT
  • 2LIS_11_V_SCL.SPART == TSPA.SPART
Statistics Currency
  • Client
  • Statistics Currency
  • 2LIS_11_V_SCL.MANDT == TCURC.MANDT
  • 2LIS_11_V_SCL.STWAE == TCURC.WAERS
Sales group
  • Client
  • Sales office
  • Sales group
  • 2LIS_11_V_SCL.MANDT == TVBVK.MANDT
  • 2LIS_11_V_SCL.VKBUR == TVBVK.VKBUR
  • 2LIS_11_V_SCL.VKGRP == TVBVK.VKGRP
Volume unit
  • Client
  • Volume unit
  • 2LIS_11_V_SCL.MANDT == T006.MANDT
  • 2LIS_11_V_SCL.VOLEH == T006.MSEHI
Sales unit
  • Client
  • Sales unit
  • 2LIS_11_V_SCL.MANDT == T006.MANDT
  • 2LIS_11_V_SCL.VRKME == T006.MSEHI
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • 2LIS_11_V_SCL.MANDT == TVST.MANDT
  • 2LIS_11_V_SCL.VSTEL == TVST.VSTEL
Distribution Channel
  • Client
  • Distribution Channel
  • 2LIS_11_V_SCL.MANDT == TVTW.MANDT
  • 2LIS_11_V_SCL.VTWEG == TVTW.VTWEG
SD Document Currency
  • Client
  • SD Document Currency
  • 2LIS_11_V_SCL.MANDT == TCURC.MANDT
  • 2LIS_11_V_SCL.WAERK == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Division
  • Sales office
  • Sales Organization
  • Distribution Channel
  • 2LIS_11_V_SCL.MANDT == TVKBZ.MANDT
  • 2LIS_11_V_SCL.SPART == TVKBZ.SPART
  • 2LIS_11_V_SCL.VKBUR == TVKBZ.VKBUR
  • 2LIS_11_V_SCL.VKORG == TVKBZ.VKORG
  • 2LIS_11_V_SCL.VTWEG == TVKBZ.VTWEG