2LIS_11_VASCL

Sales Document Schedule Line | #TRAN | Extraction method: CO | Delta: ABR | Component: Sales and Distribution
Tables used: VBAP, VBAK, VBEP, VBKD, VBUP ... +1 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):
NETPR Net Price
Column Name Description
📏 Sales unit (VRKME):
BMENG Confirmed Quantity
CMENG Corrected quantity in sales unit
WMENG Order Quantity in Sales Units
📏 Base Unit of Measure (MEINS):
LMENG Required quantity for mat.management in stockkeeping 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
ANGDT Quotation/Inquiry is Valid From
BNDDT Date Until Which Bid/Quotation is Binding (Valid-To 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
FBUDA Date on which services are rendered
FKDAT Billing Date
KURSK_DAT Translation date
PRSDT Date for Pricing and Exchange Rate
Column Name Description
ROCANCEL Indicator: Cancel Data Record Show values
ABSTA Rejection Status (Item) Show values
UVALL Incompletion Status (Item) Show values
UVFAK Billing Incompletion Status (Item) Show values
UVPRS Pricing Incompletion Status (Item) Show values
UVVLK Delivery Incompletion Status (Item) Show values
VBTYP SD Document Category Show values
AWAHR Order Probability of the Item Show values
VGTYP Document Category of Preceding SD Document Show values
VGTYP_AK Sales Document Category of Reference Doc. in Order Header Show values
APOPLANNED Planning in APO Show values
FLOCTYPE Type of Customer-Facing Location Show values
ELOCTYPE Type of Executing Location Show values
SLOCTYPE Type of First Inventory-Managing Location Show values
Column Name Description Domain name
AUART Sales Document Type AUART
BUKRS Company Code BUKRS
KUNNR Sold-to Party KUNNR
KVGR2 Customer Group 2 KVGR2
KVGR3 Customer Group 3 KVGR3
KVGR4 Customer Group 4 KVGR4
KVGR5 Customer Group 5 KVGR5
VKORG Sales Organization VKORG
VTWEG Distribution Channel VTWEG
CMKUA Credit data exchange rate for requested delivery date KURRF
EAN11 International Article Number (EAN/UPC) EAN11
ERNAM Name of Person Responsible for Creating the Object USNAM
KPEIN Condition Pricing Unit KPEIN
PABLA Unloading point of the ship-to party TEXT25
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
UMZIN Factor for Converting Sales Units to Base Units (Target Qty) UMBSN
UMZIZ Factor for Converting Sales Units to Base Units (Target Qty) 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
PERIV Fiscal Year Variant PERIV
MCEX_APCAMPAIGN Campaign of referred sales order item for BW-Extraction SYSUUID_C
FACELOC Customer-Facing Location LOCNR
EXECLOC Executing Location LOCNR
LOGSYS Logical system LOGSYS
VWPOS Item Usage VWPOS
STOCKLOC First Inventory-Managing Location LOCNR
Master Data Relations Join Conditions
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • 2LIS_11_VASCL.MANDT == TVAG.MANDT
  • 2LIS_11_VASCL.ABGRU == TVAG.ABGRU
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • 2LIS_11_VASCL.MANDT == TVAU.MANDT
  • 2LIS_11_VASCL.AUGRU == TVAU.AUGRU
Sales District
  • Client
  • Sales District
  • 2LIS_11_VASCL.MANDT == T171.MANDT
  • 2LIS_11_VASCL.BZIRK == T171.BZIRK
Batch Number
  • Client
  • Batch Number
  • Material Number
  • Plant (Own or External)
  • 2LIS_11_VASCL.MANDT == MCHA.MANDT
  • 2LIS_11_VASCL.CHARG == MCHA.CHARG
  • 2LIS_11_VASCL.MATNR == MCHA.MATNR
  • 2LIS_11_VASCL.WERKS == MCHA.WERKS
Schedule line category
  • Client
  • Schedule line category
  • 2LIS_11_VASCL.MANDT == TVEP.MANDT
  • 2LIS_11_VASCL.ETTYP == TVEP.ETTYP
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • 2LIS_11_VASCL.MANDT == TVFS.MANDT
  • 2LIS_11_VASCL.FAKSK == TVFS.FAKSP
Billing Block for Item
  • Client
  • Billing Block for Item
  • 2LIS_11_VASCL.MANDT == TVFS.MANDT
  • 2LIS_11_VASCL.FAKSP == TVFS.FAKSP
Weight Unit
  • Client
  • Weight Unit
  • 2LIS_11_VASCL.MANDT == T006.MANDT
  • 2LIS_11_VASCL.GEWEI == T006.MSEHI
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • 2LIS_11_VASCL.MANDT == TINC.MANDT
  • 2LIS_11_VASCL.INCO1 == TINC.INCO1
Customer Group
  • Client
  • Customer Group
  • 2LIS_11_VASCL.MANDT == T151.MANDT
  • 2LIS_11_VASCL.KDGRP == T151.KDGRP
Condition Unit
  • Client
  • Condition Unit
  • 2LIS_11_VASCL.MANDT == T006.MANDT
  • 2LIS_11_VASCL.KMEIN == T006.MSEHI
Account Assignment Group for this Customer
  • Client
  • Account Assignment Group for this Customer
  • 2LIS_11_VASCL.MANDT == TVKT.MANDT
  • 2LIS_11_VASCL.KTGRD == TVKT.KTGRD
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • 2LIS_11_VASCL.MANDT == TCURV.MANDT
  • 2LIS_11_VASCL.KURST == TCURV.KURST
Customer Group 1
  • Client
  • Customer Group 1
  • 2LIS_11_VASCL.MANDT == TVV1.MANDT
  • 2LIS_11_VASCL.KVGR1 == TVV1.KVGR1
Storage location
  • Client
  • Storage location
  • Plant (Own or External)
  • 2LIS_11_VASCL.MANDT == T001L.MANDT
  • 2LIS_11_VASCL.LGORT == T001L.LGORT
  • 2LIS_11_VASCL.WERKS == T001L.WERKS
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • 2LIS_11_VASCL.MANDT == TVLS.MANDT
  • 2LIS_11_VASCL.LIFSK == TVLS.LIFSP
Schedule Line Blocked for Delivery
  • Client
  • Schedule Line Blocked for Delivery
  • 2LIS_11_VASCL.MANDT == TVLS.MANDT
  • 2LIS_11_VASCL.LIFSP == TVLS.LIFSP
Material Group
  • Client
  • Material Group
  • 2LIS_11_VASCL.MANDT == T023.MANDT
  • 2LIS_11_VASCL.MATKL == T023.MATKL
Material: order item
  • Client
  • Material Number
  • 2LIS_11_VASCL.MANDT == MARA.MANDT
  • 2LIS_11_VASCL.MATNR == MARA.MATNR
Material Entered
  • Client
  • Material Entered
  • 2LIS_11_VASCL.MANDT == MARA.MANDT
  • 2LIS_11_VASCL.MATWA == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • 2LIS_11_VASCL.MANDT == T006.MANDT
  • 2LIS_11_VASCL.MEINS == T006.MSEHI
Material Group 1
  • Client
  • Material Group 1
  • 2LIS_11_VASCL.MANDT == TVM1.MANDT
  • 2LIS_11_VASCL.MVGR1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • 2LIS_11_VASCL.MANDT == TVM2.MANDT
  • 2LIS_11_VASCL.MVGR2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • 2LIS_11_VASCL.MANDT == TVM3.MANDT
  • 2LIS_11_VASCL.MVGR3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • 2LIS_11_VASCL.MANDT == TVM4.MANDT
  • 2LIS_11_VASCL.MVGR4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • 2LIS_11_VASCL.MANDT == TVM5.MANDT
  • 2LIS_11_VASCL.MVGR5 == TVM5.MVGR5
Product hierarchy: order item
  • Client
  • Product hierarchy
  • 2LIS_11_VASCL.MANDT == T179.MANDT
  • 2LIS_11_VASCL.PRODH == T179.PRODH
Sales document item category
  • Client
  • Sales document item category
  • 2LIS_11_VASCL.MANDT == TVPT.MANDT
  • 2LIS_11_VASCL.PSTYV == TVPT.PSTYV
Route
  • Client
  • Route
  • 2LIS_11_VASCL.MANDT == TVRO.MANDT
  • 2LIS_11_VASCL.ROUTE == TVRO.ROUTE
Division in order header
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • 2LIS_11_VASCL.MANDT == TVTA.MANDT
  • 2LIS_11_VASCL.SPART == TVTA.SPART
  • 2LIS_11_VASCL.VKORG == TVTA.VKORG
  • 2LIS_11_VASCL.VTWEG == TVTA.VTWEG
Statistics Currency
  • Client
  • Statistics Currency
  • 2LIS_11_VASCL.MANDT == TCURC.MANDT
  • 2LIS_11_VASCL.STWAE == TCURC.WAERS
Reason for material substitution
  • Client
  • Reason for material substitution
  • 2LIS_11_VASCL.MANDT == TVSU.MANDT
  • 2LIS_11_VASCL.SUGRD == TVSU.SUGRD
Sales group
  • Client
  • Sales office
  • Sales group
  • 2LIS_11_VASCL.MANDT == TVBVK.MANDT
  • 2LIS_11_VASCL.VKBUR == TVBVK.VKBUR
  • 2LIS_11_VASCL.VKGRP == TVBVK.VKGRP
Volume unit
  • Client
  • Volume unit
  • 2LIS_11_VASCL.MANDT == T006.MANDT
  • 2LIS_11_VASCL.VOLEH == T006.MSEHI
Sales unit
  • Client
  • Sales unit
  • 2LIS_11_VASCL.MANDT == T006.MANDT
  • 2LIS_11_VASCL.VRKME == T006.MSEHI
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • 2LIS_11_VASCL.MANDT == TVST.MANDT
  • 2LIS_11_VASCL.VSTEL == TVST.VSTEL
SD Document Currency
  • Client
  • SD Document Currency
  • SD Document Currency
  • 2LIS_11_VASCL.MANDT == TCURC.MANDT
  • 2LIS_11_VASCL.WAERK == TCURC.WAERS
  • 2LIS_11_VASCL.WAERK_VBAK == TCURC.WAERS
SD Document Currency
  • Client
  • SD Document Currency
  • SD Document Currency
  • 2LIS_11_VASCL.MANDT == TCURC.MANDT
  • 2LIS_11_VASCL.WAERK == TCURC.WAERS
  • 2LIS_11_VASCL.WAERK_VBAK == TCURC.WAERS
Target Quantity UoM
  • Client
  • Target Quantity UoM
  • 2LIS_11_VASCL.MANDT == T006.MANDT
  • 2LIS_11_VASCL.ZIEME == T006.MSEHI
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Division
  • Sales office
  • Sales Organization
  • Distribution Channel
  • 2LIS_11_VASCL.MANDT == TVKBZ.MANDT
  • 2LIS_11_VASCL.SPART == TVKBZ.SPART
  • 2LIS_11_VASCL.VKBUR == TVKBZ.VKBUR
  • 2LIS_11_VASCL.VKORG == TVKBZ.VKORG
  • 2LIS_11_VASCL.VTWEG == TVKBZ.VTWEG