2LIS_11_V_ITM

Sales-Shipping Allocation Item Data | #TRAN | Extraction method: CO | Delta: ABR | Component: Sales and Distribution
Tables used: VBAP, LIPS, LIKP, VBAK, VBKD ... +2 more
Column Name Description
VBELN Sales and Distribution Document Number
POSNR Item number of the SD document
Column Name Description
💲 SD Document Currency (WAERK):
OAUWE Net Value of Open Orders
MCBW_LFWRT BW: Delivered Sales Order Value
MCBW_NETPR_AVKM BW: Net Price Referring to Sales Quantity for Order Item
Column Name Description
📏 Sales unit (VRKME):
OAUME Open orders quantity in base unit of measure
LFIMG_AVME Actual quantity delivered (in sales units)
Column Name Description
ERDAT Date on which the record was created
STADAT Statistics date
KURSK_DAT Translation 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
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
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
ANZOAUPO Number of Open Sales Order Items MCZAEHLER
PERIV Fiscal Year Variant PERIV
MCEX_APCAMPAIGN Campaign of referred sales order item for BW-Extraction SYSUUID_C
Master Data Relations Join Conditions
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • 2LIS_11_V_ITM.MANDT == TVAG.MANDT
  • 2LIS_11_V_ITM.ABGRU == TVAG.ABGRU
Sales District
  • Client
  • Sales District
  • 2LIS_11_V_ITM.MANDT == T171.MANDT
  • 2LIS_11_V_ITM.BZIRK == T171.BZIRK
Batch Number
  • Client
  • ?
  • Batch Number
  • Material Number
  • Plant
  • 2LIS_11_V_ITM.MANDT == MCHA.MANDT
  • 2LIS_11_V_ITM.[column in domain "WERKS_D"] == MCHA.WERKS
  • 2LIS_11_V_ITM.CHARG == MCHA.CHARG
  • 2LIS_11_V_ITM.MATNR == MCHA.MATNR
  • 2LIS_11_V_ITM.WERKS == MCHA.WERKS
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • 2LIS_11_V_ITM.MANDT == TVFS.MANDT
  • 2LIS_11_V_ITM.FAKSK == TVFS.FAKSP
Billing Block for Item
  • Client
  • Billing Block for Item
  • 2LIS_11_V_ITM.MANDT == TVFS.MANDT
  • 2LIS_11_V_ITM.FAKSP == TVFS.FAKSP
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • 2LIS_11_V_ITM.MANDT == TINC.MANDT
  • 2LIS_11_V_ITM.INCO1 == TINC.INCO1
Customer Group
  • Client
  • Customer Group
  • 2LIS_11_V_ITM.MANDT == T151.MANDT
  • 2LIS_11_V_ITM.KDGRP == T151.KDGRP
Sold-to Party
  • Client
  • Sold-to Party
  • 2LIS_11_V_ITM.MANDT == KNA1.MANDT
  • 2LIS_11_V_ITM.KUNNR == KNA1.KUNNR
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • 2LIS_11_V_ITM.MANDT == TCURV.MANDT
  • 2LIS_11_V_ITM.KURST == TCURV.KURST
Customer Group 1
  • Client
  • Customer Group 1
  • 2LIS_11_V_ITM.MANDT == TVV1.MANDT
  • 2LIS_11_V_ITM.KVGR1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • 2LIS_11_V_ITM.MANDT == TVV2.MANDT
  • 2LIS_11_V_ITM.KVGR2 == TVV2.KVGR2
Customer Group 5
  • Client
  • Customer Group 5
  • 2LIS_11_V_ITM.MANDT == TVV5.MANDT
  • 2LIS_11_V_ITM.KVGR5 == TVV5.KVGR5
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • 2LIS_11_V_ITM.MANDT == TVLS.MANDT
  • 2LIS_11_V_ITM.LIFSK == TVLS.LIFSP
Material Group
  • Client
  • Material Group
  • 2LIS_11_V_ITM.MANDT == T023.MANDT
  • 2LIS_11_V_ITM.MATKL == T023.MATKL
Material: order item
  • Client
  • Material Number
  • 2LIS_11_V_ITM.MANDT == MARA.MANDT
  • 2LIS_11_V_ITM.MATNR == MARA.MATNR
Material Entered
  • Client
  • Material Entered
  • 2LIS_11_V_ITM.MANDT == MARA.MANDT
  • 2LIS_11_V_ITM.MATWA == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • 2LIS_11_V_ITM.MANDT == T006.MANDT
  • 2LIS_11_V_ITM.MEINS == T006.MSEHI
Material Group 1
  • Client
  • Material Group 1
  • 2LIS_11_V_ITM.MANDT == TVM1.MANDT
  • 2LIS_11_V_ITM.MVGR1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • 2LIS_11_V_ITM.MANDT == TVM2.MANDT
  • 2LIS_11_V_ITM.MVGR2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • 2LIS_11_V_ITM.MANDT == TVM3.MANDT
  • 2LIS_11_V_ITM.MVGR3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • 2LIS_11_V_ITM.MANDT == TVM4.MANDT
  • 2LIS_11_V_ITM.MVGR4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • 2LIS_11_V_ITM.MANDT == TVM5.MANDT
  • 2LIS_11_V_ITM.MVGR5 == TVM5.MVGR5
Product hierarchy
  • Client
  • Product hierarchy
  • 2LIS_11_V_ITM.MANDT == T179.MANDT
  • 2LIS_11_V_ITM.PRODH == T179.PRODH
Route
  • Client
  • Route
  • 2LIS_11_V_ITM.MANDT == TVRO.MANDT
  • 2LIS_11_V_ITM.ROUTE == TVRO.ROUTE
Division
  • Client
  • Division
  • 2LIS_11_V_ITM.MANDT == TSPA.MANDT
  • 2LIS_11_V_ITM.SPART == TSPA.SPART
Statistics Currency
  • Client
  • Statistics Currency
  • 2LIS_11_V_ITM.MANDT == TCURC.MANDT
  • 2LIS_11_V_ITM.STWAE == TCURC.WAERS
Sales group
  • Client
  • Sales office
  • Sales group
  • 2LIS_11_V_ITM.MANDT == TVBVK.MANDT
  • 2LIS_11_V_ITM.VKBUR == TVBVK.VKBUR
  • 2LIS_11_V_ITM.VKGRP == TVBVK.VKGRP
Volume unit
  • Client
  • Volume unit
  • 2LIS_11_V_ITM.MANDT == T006.MANDT
  • 2LIS_11_V_ITM.VOLEH == T006.MSEHI
Sales unit
  • Client
  • Sales unit
  • 2LIS_11_V_ITM.MANDT == T006.MANDT
  • 2LIS_11_V_ITM.VRKME == T006.MSEHI
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • 2LIS_11_V_ITM.MANDT == TVST.MANDT
  • 2LIS_11_V_ITM.VSTEL == TVST.VSTEL
Distribution Channel
  • Client
  • Distribution Channel
  • 2LIS_11_V_ITM.MANDT == TVTW.MANDT
  • 2LIS_11_V_ITM.VTWEG == TVTW.VTWEG
SD Document Currency
  • Client
  • SD Document Currency
  • 2LIS_11_V_ITM.MANDT == TCURC.MANDT
  • 2LIS_11_V_ITM.WAERK == TCURC.WAERS
Promotion
  • Client
  • Promotion
  • 2LIS_11_V_ITM.MANDT == WAKH.MANDT
  • 2LIS_11_V_ITM.WAKTION == WAKH.AKTNR
Plant
  • Client
  • Plant
  • 2LIS_11_V_ITM.MANDT == T001W.MANDT
  • 2LIS_11_V_ITM.WERKS == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Division
  • Sales office
  • Sales Organization
  • Distribution Channel
  • 2LIS_11_V_ITM.MANDT == TVKBZ.MANDT
  • 2LIS_11_V_ITM.SPART == TVKBZ.SPART
  • 2LIS_11_V_ITM.VKBUR == TVKBZ.VKBUR
  • 2LIS_11_V_ITM.VKORG == TVKBZ.VKORG
  • 2LIS_11_V_ITM.VTWEG == TVKBZ.VTWEG