2LIS_12_VCITM

Delivery Item Data | #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
📏 Weight Unit (GEWEI):
BRGEW Gross weight
NTGEW Net weight
📏 Sales unit (VRKME):
LFIMG Actual quantity delivered (in sales units)
📏 Base Unit of Measure (MEINS):
LGMNG Actual quantity delivered in stockkeeping units
📏 Volume unit (VOLEH):
VOLUM Volume
Column Name Description
LFDAT Delivery Date
WADAT Planned Goods Movement 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
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
ABLAD Unloading Point TEXT25
BUKRS Company Code BUKRS
INCO2 Incoterms (Part 2) INCO2
LFART Delivery Type LFART
LIFNR Vendor's account number LIFNR
BWAPPLNM Application Component RSAPPLNM
BWVORG SAP BW transaction key NUM3
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
VBEAF Fixed shipping processing time in days (= setup time) DEC3_2
VBEAV Variable shipping processing time in days DEC3_2
VGBEL Document number of the reference document VBELN
VGPOS Item number of the reference item POSNR
ANZLIPOS Number of delivery items MCZAEHLER
SPARA Division for order header SPART
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID
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
Promotion
  • Client
  • Promotion
  • 2LIS_12_VCITM.MANDT == WAKH.MANDT
  • 2LIS_12_VCITM.AKTNR == WAKH.AKTNR
Sales District
  • Client
  • Sales District
  • 2LIS_12_VCITM.MANDT == T171.MANDT
  • 2LIS_12_VCITM.BZIRK == T171.BZIRK
Batch Number
  • Client
  • Batch Number
  • Material Number
  • Plant
  • 2LIS_12_VCITM.MANDT == MCHA.MANDT
  • 2LIS_12_VCITM.CHARG == MCHA.CHARG
  • 2LIS_12_VCITM.MATNR == MCHA.MATNR
  • 2LIS_12_VCITM.WERKS == MCHA.WERKS
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • 2LIS_12_VCITM.MANDT == TVFS.MANDT
  • 2LIS_12_VCITM.FAKSK == TVFS.FAKSP
Billing Block
  • Client
  • Billing Block
  • 2LIS_12_VCITM.MANDT == TVFS.MANDT
  • 2LIS_12_VCITM.FAKSP == TVFS.FAKSP
Weight Unit
  • Client
  • Weight Unit
  • 2LIS_12_VCITM.MANDT == T006.MANDT
  • 2LIS_12_VCITM.GEWEI == T006.MSEHI
Business Area
  • Client
  • Business Area
  • 2LIS_12_VCITM.MANDT == TGSB.MANDT
  • 2LIS_12_VCITM.GSBER == TGSB.GSBER
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • 2LIS_12_VCITM.MANDT == TINC.MANDT
  • 2LIS_12_VCITM.INCO1 == TINC.INCO1
Customer Group
  • Client
  • Customer Group
  • 2LIS_12_VCITM.MANDT == T151.MANDT
  • 2LIS_12_VCITM.KDGRP == T151.KDGRP
Sold-to Party
  • Client
  • Sold-to Party
  • 2LIS_12_VCITM.MANDT == KNA1.MANDT
  • 2LIS_12_VCITM.KUNAG == KNA1.KUNNR
Ship-to Party
  • Client
  • Ship-to Party
  • 2LIS_12_VCITM.MANDT == KNA1.MANDT
  • 2LIS_12_VCITM.KUNNR == KNA1.KUNNR
Customer Group 1
  • Client
  • Customer Group 1
  • 2LIS_12_VCITM.MANDT == TVV1.MANDT
  • 2LIS_12_VCITM.KVGR1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • 2LIS_12_VCITM.MANDT == TVV2.MANDT
  • 2LIS_12_VCITM.KVGR2 == TVV2.KVGR2
Customer Group 3
  • Client
  • Customer Group 3
  • 2LIS_12_VCITM.MANDT == TVV3.MANDT
  • 2LIS_12_VCITM.KVGR3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • 2LIS_12_VCITM.MANDT == TVV4.MANDT
  • 2LIS_12_VCITM.KVGR4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • 2LIS_12_VCITM.MANDT == TVV5.MANDT
  • 2LIS_12_VCITM.KVGR5 == TVV5.KVGR5
Warehouse Number / Warehouse Complex
  • Client
  • Warehouse Number / Warehouse Complex
  • 2LIS_12_VCITM.MANDT == T300.MANDT
  • 2LIS_12_VCITM.LGNUM == T300.LGNUM
Storage location
  • Client
  • Storage location
  • Plant
  • 2LIS_12_VCITM.MANDT == T001L.MANDT
  • 2LIS_12_VCITM.LGORT == T001L.LGORT
  • 2LIS_12_VCITM.WERKS == T001L.WERKS
Storage Bin
  • Client
  • Warehouse Number / Warehouse Complex
  • Storage Bin
  • Storage Type
  • 2LIS_12_VCITM.MANDT == LAGP.MANDT
  • 2LIS_12_VCITM.LGNUM == LAGP.LGNUM
  • 2LIS_12_VCITM.LGPLA == LAGP.LGPLA
  • 2LIS_12_VCITM.LGTYP == LAGP.LGTYP
Storage Type
  • Client
  • Warehouse Number / Warehouse Complex
  • Storage Type
  • 2LIS_12_VCITM.MANDT == T301.MANDT
  • 2LIS_12_VCITM.LGNUM == T301.LGNUM
  • 2LIS_12_VCITM.LGTYP == T301.LGTYP
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • 2LIS_12_VCITM.MANDT == TVLS.MANDT
  • 2LIS_12_VCITM.LIFSK == TVLS.LIFSP
Loading Point
  • Client
  • Loading Point
  • Shipping Point / Receiving Point
  • 2LIS_12_VCITM.MANDT == TVLA.MANDT
  • 2LIS_12_VCITM.LSTEL == TVLA.LSTEL
  • 2LIS_12_VCITM.VSTEL == TVLA.VSTEL
Material Group
  • Client
  • Material Group
  • 2LIS_12_VCITM.MANDT == T023.MANDT
  • 2LIS_12_VCITM.MATKL == T023.MATKL
Material Number
  • Client
  • Material Number
  • 2LIS_12_VCITM.MANDT == MARA.MANDT
  • 2LIS_12_VCITM.MATNR == MARA.MATNR
Material Entered
  • Client
  • Material Entered
  • 2LIS_12_VCITM.MANDT == MARA.MANDT
  • 2LIS_12_VCITM.MATWA == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • 2LIS_12_VCITM.MANDT == T006.MANDT
  • 2LIS_12_VCITM.MEINS == T006.MSEHI
Material Group 1
  • Client
  • Material Group 1
  • 2LIS_12_VCITM.MANDT == TVM1.MANDT
  • 2LIS_12_VCITM.MVGR1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • 2LIS_12_VCITM.MANDT == TVM2.MANDT
  • 2LIS_12_VCITM.MVGR2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • 2LIS_12_VCITM.MANDT == TVM3.MANDT
  • 2LIS_12_VCITM.MVGR3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • 2LIS_12_VCITM.MANDT == TVM4.MANDT
  • 2LIS_12_VCITM.MVGR4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • 2LIS_12_VCITM.MANDT == TVM5.MANDT
  • 2LIS_12_VCITM.MVGR5 == TVM5.MVGR5
Product hierarchy
  • Client
  • Product hierarchy
  • 2LIS_12_VCITM.MANDT == T179.MANDT
  • 2LIS_12_VCITM.PRODH == T179.PRODH
Delivery item category
  • Client
  • Delivery item category
  • 2LIS_12_VCITM.MANDT == TVPT.MANDT
  • 2LIS_12_VCITM.PSTYV == TVPT.PSTYV
Route
  • Client
  • Route
  • 2LIS_12_VCITM.MANDT == TVRO.MANDT
  • 2LIS_12_VCITM.ROUTE == TVRO.ROUTE
Sales office
  • Client
  • Sales office
  • 2LIS_12_VCITM.MANDT == TVBUR.MANDT
  • 2LIS_12_VCITM.VKBUR == TVBUR.VKBUR
Sales group
  • Client
  • Sales group
  • 2LIS_12_VCITM.MANDT == TVKGR.MANDT
  • 2LIS_12_VCITM.VKGRP == TVKGR.VKGRP
Sales Organization
  • Client
  • Sales Organization
  • 2LIS_12_VCITM.MANDT == TVKO.MANDT
  • 2LIS_12_VCITM.VKORG == TVKO.VKORG
Volume unit
  • Client
  • Volume unit
  • 2LIS_12_VCITM.MANDT == T006.MANDT
  • 2LIS_12_VCITM.VOLEH == T006.MSEHI
Sales unit
  • Client
  • Sales unit
  • 2LIS_12_VCITM.MANDT == T006.MANDT
  • 2LIS_12_VCITM.VRKME == T006.MSEHI
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • 2LIS_12_VCITM.MANDT == TVST.MANDT
  • 2LIS_12_VCITM.VSTEL == TVST.VSTEL
Distribution Channel
  • Client
  • Distribution Channel
  • 2LIS_12_VCITM.MANDT == TVTW.MANDT
  • 2LIS_12_VCITM.VTWEG == TVTW.VTWEG
Plant
  • Client
  • Plant
  • 2LIS_12_VCITM.MANDT == T001W.MANDT
  • 2LIS_12_VCITM.WERKS == T001W.WERKS