2LIS_11_VAITM

Sales Document Item Data | #TRAN | Extraction method: CO | Delta: ABR | Component: Sales and Distribution
Tables used: VBAP, LIPS, VBAK, LIKP, 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):
KZWI1 Subtotal 1 from Pricing Procedure for Price Element
KZWI2 Subtotal 2 from Pricing Procedure for Price Element
KZWI3 Subtotal 3 from Pricing Procedure for Price Element
KZWI4 Subtotal 4 from Pricing Procedure for Price Element
KZWI5 Subtotal 5 from Pricing Procedure for Price Element
KZWI6 Subtotal 6 from Pricing Procedure for Price Element
MWSBP Tax Amount in Document Currency
NETPR Net Price
NETWR Net Value of the Order Item in Document Currency
WAVWR Cost in Document Currency
ZWERT Target Value for Outline Agreement in Document Currency
MCBW_NETPR_AVKM BW: Net Price Referring to Sales Quantity for Order Item
Column Name Description
📏 Weight Unit (GEWEI):
BRGEW Gross Weight of the Item
NTGEW Net Weight of the Item
📏 Sales unit (VRKME):
KBMENG Cumulative Confirmed Quantity in Sales Unit
KWMENG Cumulative order quantity in sales units
LSMENG Cumulative Required Delivery Qty (All Dlv-Relev.Sched.Lines)
📏 Base Unit of Measure (MEINS):
KLMENG Cumulative Confirmed Quantity in Base Unit
LFMNG Minimum Delivery Quantity in Delivery Note Processing
📏 Volume unit (VOLEH):
VOLUM Volume of the item
📏 Target Quantity UoM (ZIEME):
ZMENG Target Quantity in Sales Units
Column Name Description
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
UEBTK Unlimited Overdelivery Allowed 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
Column Name Description Domain name
AUART Sales Document Type AUART
BUKRS Company Code BUKRS
KVGR3 Customer Group 3 KVGR3
KVGR4 Customer Group 4 KVGR4
VKORG Sales Organization VKORG
BWAPPLNM Application Component RSAPPLNM
BWVORG SAP BW transaction key NUM3
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
UEBTO Overdelivery Tolerance PRZ21
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
UNTTO Underdelivery Tolerance PRZ21
VGBEL Document number of the reference document VBELN
VGPOS Item number of the reference item POSNR
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
ANZAUPO Number of 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_VAITM.MANDT == TVAG.MANDT
  • 2LIS_11_VAITM.ABGRU == TVAG.ABGRU
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • 2LIS_11_VAITM.MANDT == TVAU.MANDT
  • 2LIS_11_VAITM.AUGRU == TVAU.AUGRU
Sales District
  • Client
  • Sales District
  • 2LIS_11_VAITM.MANDT == T171.MANDT
  • 2LIS_11_VAITM.BZIRK == T171.BZIRK
Batch Number
  • Client
  • ?
  • Batch Number
  • Material Number
  • Plant (Own or External)
  • 2LIS_11_VAITM.MANDT == MCHA.MANDT
  • 2LIS_11_VAITM.[column in domain "WERKS_D"] == MCHA.WERKS
  • 2LIS_11_VAITM.CHARG == MCHA.CHARG
  • 2LIS_11_VAITM.MATNR == MCHA.MATNR
  • 2LIS_11_VAITM.WERKS == MCHA.WERKS
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • 2LIS_11_VAITM.MANDT == TVFS.MANDT
  • 2LIS_11_VAITM.FAKSK == TVFS.FAKSP
Billing Block for Item
  • Client
  • Billing Block for Item
  • 2LIS_11_VAITM.MANDT == TVFS.MANDT
  • 2LIS_11_VAITM.FAKSP == TVFS.FAKSP
Weight Unit
  • Client
  • Weight Unit
  • 2LIS_11_VAITM.MANDT == T006.MANDT
  • 2LIS_11_VAITM.GEWEI == T006.MSEHI
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • 2LIS_11_VAITM.MANDT == TINC.MANDT
  • 2LIS_11_VAITM.INCO1 == TINC.INCO1
Customer Group
  • Client
  • Customer Group
  • 2LIS_11_VAITM.MANDT == T151.MANDT
  • 2LIS_11_VAITM.KDGRP == T151.KDGRP
Condition Unit
  • Client
  • Condition Unit
  • 2LIS_11_VAITM.MANDT == T006.MANDT
  • 2LIS_11_VAITM.KMEIN == T006.MSEHI
Sales Deal
  • Client
  • Sales Deal
  • 2LIS_11_VAITM.MANDT == KONA.MANDT
  • 2LIS_11_VAITM.KNUMA_AG == KONA.KNUMA
Account Assignment Group for this Customer
  • Client
  • Account Assignment Group for this Customer
  • 2LIS_11_VAITM.MANDT == TVKT.MANDT
  • 2LIS_11_VAITM.KTGRD == TVKT.KTGRD
Sold-to Party
  • Client
  • Sold-to Party
  • 2LIS_11_VAITM.MANDT == KNA1.MANDT
  • 2LIS_11_VAITM.KUNNR == KNA1.KUNNR
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • 2LIS_11_VAITM.MANDT == TCURV.MANDT
  • 2LIS_11_VAITM.KURST == TCURV.KURST
Customer Group 1
  • Client
  • Customer Group 1
  • 2LIS_11_VAITM.MANDT == TVV1.MANDT
  • 2LIS_11_VAITM.KVGR1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • 2LIS_11_VAITM.MANDT == TVV2.MANDT
  • 2LIS_11_VAITM.KVGR2 == TVV2.KVGR2
Customer Group 5
  • Client
  • Customer Group 5
  • 2LIS_11_VAITM.MANDT == TVV5.MANDT
  • 2LIS_11_VAITM.KVGR5 == TVV5.KVGR5
Storage location
  • Client
  • ?
  • Storage location
  • Plant (Own or External)
  • 2LIS_11_VAITM.MANDT == T001L.MANDT
  • 2LIS_11_VAITM.[column in domain "WERKS_D"] == T001L.WERKS
  • 2LIS_11_VAITM.LGORT == T001L.LGORT
  • 2LIS_11_VAITM.WERKS == T001L.WERKS
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • 2LIS_11_VAITM.MANDT == TVLS.MANDT
  • 2LIS_11_VAITM.LIFSK == TVLS.LIFSP
Material Group
  • Client
  • Material Group
  • 2LIS_11_VAITM.MANDT == T023.MANDT
  • 2LIS_11_VAITM.MATKL == T023.MATKL
Material: order item
  • Client
  • Material Number
  • 2LIS_11_VAITM.MANDT == MARA.MANDT
  • 2LIS_11_VAITM.MATNR == MARA.MATNR
Material Entered
  • Client
  • Material Entered
  • 2LIS_11_VAITM.MANDT == MARA.MANDT
  • 2LIS_11_VAITM.MATWA == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • 2LIS_11_VAITM.MANDT == T006.MANDT
  • 2LIS_11_VAITM.MEINS == T006.MSEHI
Material Group 1
  • Client
  • Material Group 1
  • 2LIS_11_VAITM.MANDT == TVM1.MANDT
  • 2LIS_11_VAITM.MVGR1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • 2LIS_11_VAITM.MANDT == TVM2.MANDT
  • 2LIS_11_VAITM.MVGR2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • 2LIS_11_VAITM.MANDT == TVM3.MANDT
  • 2LIS_11_VAITM.MVGR3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • 2LIS_11_VAITM.MANDT == TVM4.MANDT
  • 2LIS_11_VAITM.MVGR4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • 2LIS_11_VAITM.MANDT == TVM5.MANDT
  • 2LIS_11_VAITM.MVGR5 == TVM5.MVGR5
Product hierarchy
  • Client
  • Product hierarchy
  • 2LIS_11_VAITM.MANDT == T179.MANDT
  • 2LIS_11_VAITM.PRODH == T179.PRODH
Sales document item category
  • Client
  • Sales document item category
  • 2LIS_11_VAITM.MANDT == TVPT.MANDT
  • 2LIS_11_VAITM.PSTYV == TVPT.PSTYV
Route
  • Client
  • Route
  • 2LIS_11_VAITM.MANDT == TVRO.MANDT
  • 2LIS_11_VAITM.ROUTE == TVRO.ROUTE
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • 2LIS_11_VAITM.MANDT == T148.MANDT
  • 2LIS_11_VAITM.SOBKZ == T148.SOBKZ
Division
  • Client
  • Division
  • 2LIS_11_VAITM.MANDT == TSPA.MANDT
  • 2LIS_11_VAITM.SPART == TSPA.SPART
Statistics Currency
  • Client
  • Statistics Currency
  • 2LIS_11_VAITM.MANDT == TCURC.MANDT
  • 2LIS_11_VAITM.STWAE == TCURC.WAERS
Reason for material substitution
  • Client
  • Reason for material substitution
  • 2LIS_11_VAITM.MANDT == TVSU.MANDT
  • 2LIS_11_VAITM.SUGRD == TVSU.SUGRD
Sales group
  • Client
  • Sales office
  • Sales group
  • 2LIS_11_VAITM.MANDT == TVBVK.MANDT
  • 2LIS_11_VAITM.VKBUR == TVBVK.VKBUR
  • 2LIS_11_VAITM.VKGRP == TVBVK.VKGRP
Volume unit
  • Client
  • Volume unit
  • 2LIS_11_VAITM.MANDT == T006.MANDT
  • 2LIS_11_VAITM.VOLEH == T006.MSEHI
Sales unit
  • Client
  • Sales unit
  • 2LIS_11_VAITM.MANDT == T006.MANDT
  • 2LIS_11_VAITM.VRKME == T006.MSEHI
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • 2LIS_11_VAITM.MANDT == TVST.MANDT
  • 2LIS_11_VAITM.VSTEL == TVST.VSTEL
Distribution Channel
  • Client
  • Distribution Channel
  • 2LIS_11_VAITM.MANDT == TVTW.MANDT
  • 2LIS_11_VAITM.VTWEG == TVTW.VTWEG
SD Document Currency
  • Client
  • SD Document Currency
  • SD Document Currency
  • 2LIS_11_VAITM.MANDT == TCURC.MANDT
  • 2LIS_11_VAITM.WAERK == TCURC.WAERS
  • 2LIS_11_VAITM.WAERK_VBAK == TCURC.WAERS
SD Document Currency
  • Client
  • SD Document Currency
  • SD Document Currency
  • 2LIS_11_VAITM.MANDT == TCURC.MANDT
  • 2LIS_11_VAITM.WAERK == TCURC.WAERS
  • 2LIS_11_VAITM.WAERK_VBAK == TCURC.WAERS
Promotion
  • Client
  • Promotion
  • 2LIS_11_VAITM.MANDT == WAKH.MANDT
  • 2LIS_11_VAITM.WAKTION == WAKH.AKTNR
Product Catalog
  • Client
  • Product catalog number
  • 2LIS_11_VAITM.MANDT == WWMI.MANDT
  • 2LIS_11_VAITM.WMINR == WWMI.WMINR
Target Quantity UoM
  • Client
  • Target Quantity UoM
  • 2LIS_11_VAITM.MANDT == T006.MANDT
  • 2LIS_11_VAITM.ZIEME == T006.MSEHI
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Division
  • Sales office
  • Sales Organization
  • Distribution Channel
  • 2LIS_11_VAITM.MANDT == TVKBZ.MANDT
  • 2LIS_11_VAITM.SPART == TVKBZ.SPART
  • 2LIS_11_VAITM.VKBUR == TVKBZ.VKBUR
  • 2LIS_11_VAITM.VKORG == TVKBZ.VKORG
  • 2LIS_11_VAITM.VTWEG == TVKBZ.VTWEG