2LIS_13_VDITM

Billing Document Item Data | #TRAN | Extraction method: CO | Delta: ABR | Component: Sales and Distribution
Tables used: VBRP, VBRK, VBUK, VBUP → show details
Column Name Description
VBELN Sales and Distribution Document Number
POSNR Item number of the SD document
Column Name Description
💲 SD Document Currency (WAERK):
BONBA Rebate Basis 1
BRTWR Gross Value of the Billing Item in Document Currency
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
NETWR Net Value of Billing item in Document Currency
SKFBP Amount eligible for cash discount in document currency
WAVWR Cost in Document Currency
Column Name Description
📏 Weight Unit (GEWEI):
BRGEW Gross weight
NTGEW Net weight
📏 Sales unit (VRKME):
FKIMG Actual billed quantity
📏 Base Unit of Measure (MEINS):
FKLMG Billing quantity in stock keeping unit
LMENG Required quantity for mat.management in stockkeeping units
SMENG Scale Quantity in base unit of measure
📏 Volume unit (VOLEH):
VOLUM Volume
Column Name Description
AEDAT Last Changed On
FKDAT Billing Date
ERDAT Date on which the record was created
FBUDA Date on which services are rendered
KURSK_DAT Translation date
PRSDT Date for Pricing and Exchange Rate
STADAT Statistics date
VDATU Date of update for statistics updating
Column Name Description
ROCANCEL Indicator: Cancel Data Record Show values
FKTYP Billing Category Show values
VBTYP SD Document Category Show values
FAREG Rule in billing plan/invoice plan Show values
POSAR Item Type Show values
Column Name Description Domain name
BUKRS Company Code BUKRS
BZIRK Sales District BZIRK
KDGRP Customer Group KDGRP
KURRF Exchange Rate for Postings to Financial Accounting KURRF
BWAPPLNM Application Component RSAPPLNM
BWVORG SAP BW transaction key NUM3
EAN11 International Article Number (EAN/UPC) EAN11
KOSTL Cost Center KOSTL
KURSK Exchange Rate for Price Determination KURRF
PKUNRE Bill-to Party KUNNR
PKUNWE Ship-to Party KUNNR
PSTYV Sales document item category PSTYV
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
VGBEL Document number of the reference document VBELN
VGPOS Item number of the reference item POSNR
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID
ANZFKPOS Number of billing 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
Promotion
  • Client
  • Promotion
  • 2LIS_13_VDITM.MANDT == WAKH.MANDT
  • 2LIS_13_VDITM.AKTNR == WAKH.AKTNR
Volume rebate group
  • Client
  • Volume rebate group
  • 2LIS_13_VDITM.MANDT == TVBO.MANDT
  • 2LIS_13_VDITM.BONUS == TVBO.BONUS
Batch Number
  • Client
  • Batch Number
  • Material Number
  • Plant
  • 2LIS_13_VDITM.MANDT == MCHA.MANDT
  • 2LIS_13_VDITM.CHARG == MCHA.CHARG
  • 2LIS_13_VDITM.MATNR == MCHA.MATNR
  • 2LIS_13_VDITM.WERKS == MCHA.WERKS
Billing Type
  • Client
  • Billing Type
  • 2LIS_13_VDITM.MANDT == TVFK.MANDT
  • 2LIS_13_VDITM.FKART == TVFK.FKART
Weight Unit
  • Client
  • Weight Unit
  • 2LIS_13_VDITM.MANDT == T006.MANDT
  • 2LIS_13_VDITM.GEWEI == T006.MSEHI
Sales Deal
  • Client
  • Sales Deal
  • 2LIS_13_VDITM.MANDT == KONA.MANDT
  • 2LIS_13_VDITM.KNUMA_AG == KONA.KNUMA
Controlling Area
  • Client
  • Controlling Area
  • 2LIS_13_VDITM.MANDT == TKA01.MANDT
  • 2LIS_13_VDITM.KOKRS == TKA01.KOKRS
Sold-to Party
  • Client
  • Sold-to Party
  • 2LIS_13_VDITM.MANDT == KNA1.MANDT
  • 2LIS_13_VDITM.KUNAG == KNA1.KUNNR
Payer
  • Client
  • Payer
  • 2LIS_13_VDITM.MANDT == KNA1.MANDT
  • 2LIS_13_VDITM.KUNRG == KNA1.KUNNR
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • 2LIS_13_VDITM.MANDT == TCURV.MANDT
  • 2LIS_13_VDITM.KURST == TCURV.KURST
Customer Group 1
  • Client
  • Customer Group 1
  • 2LIS_13_VDITM.MANDT == TVV1.MANDT
  • 2LIS_13_VDITM.KVGR1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • 2LIS_13_VDITM.MANDT == TVV2.MANDT
  • 2LIS_13_VDITM.KVGR2 == TVV2.KVGR2
Customer Group 3
  • Client
  • Customer Group 3
  • 2LIS_13_VDITM.MANDT == TVV3.MANDT
  • 2LIS_13_VDITM.KVGR3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • 2LIS_13_VDITM.MANDT == TVV4.MANDT
  • 2LIS_13_VDITM.KVGR4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • 2LIS_13_VDITM.MANDT == TVV5.MANDT
  • 2LIS_13_VDITM.KVGR5 == TVV5.KVGR5
Storage location
  • Client
  • Storage location
  • Plant
  • 2LIS_13_VDITM.MANDT == T001L.MANDT
  • 2LIS_13_VDITM.LGORT == T001L.LGORT
  • 2LIS_13_VDITM.WERKS == T001L.WERKS
Material Group
  • Client
  • Material Group
  • 2LIS_13_VDITM.MANDT == T023.MANDT
  • 2LIS_13_VDITM.MATKL == T023.MATKL
Material Number
  • Client
  • Material Number
  • 2LIS_13_VDITM.MANDT == MARA.MANDT
  • 2LIS_13_VDITM.MATNR == MARA.MATNR
Material Entered
  • Client
  • Material Entered
  • 2LIS_13_VDITM.MANDT == MARA.MANDT
  • 2LIS_13_VDITM.MATWA == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • 2LIS_13_VDITM.MANDT == T006.MANDT
  • 2LIS_13_VDITM.MEINS == T006.MSEHI
Material Group 1
  • Client
  • Material Group 1
  • 2LIS_13_VDITM.MANDT == TVM1.MANDT
  • 2LIS_13_VDITM.MVGR1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • 2LIS_13_VDITM.MANDT == TVM2.MANDT
  • 2LIS_13_VDITM.MVGR2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • 2LIS_13_VDITM.MANDT == TVM3.MANDT
  • 2LIS_13_VDITM.MVGR3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • 2LIS_13_VDITM.MANDT == TVM4.MANDT
  • 2LIS_13_VDITM.MVGR4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • 2LIS_13_VDITM.MANDT == TVM5.MANDT
  • 2LIS_13_VDITM.MVGR5 == TVM5.MVGR5
Product hierarchy
  • Client
  • Product hierarchy
  • 2LIS_13_VDITM.MANDT == T179.MANDT
  • 2LIS_13_VDITM.PRODH == T179.PRODH
Commission Group
  • Client
  • Commission Group
  • 2LIS_13_VDITM.MANDT == TVPR.MANDT
  • 2LIS_13_VDITM.PROVG == TVPR.PROVG
Division for order header
  • Client
  • Division for order header
  • 2LIS_13_VDITM.MANDT == TSPA.MANDT
  • 2LIS_13_VDITM.SPARA == TSPA.SPART
Division
  • Client
  • Division
  • 2LIS_13_VDITM.MANDT == TSPA.MANDT
  • 2LIS_13_VDITM.SPART == TSPA.SPART
Statistics Currency
  • Client
  • Statistics Currency
  • 2LIS_13_VDITM.MANDT == TCURC.MANDT
  • 2LIS_13_VDITM.STWAE == TCURC.WAERS
Sales office
  • Client
  • Sales office
  • 2LIS_13_VDITM.MANDT == TVBUR.MANDT
  • 2LIS_13_VDITM.VKBUR == TVBUR.VKBUR
Sales group
  • Client
  • Sales group
  • 2LIS_13_VDITM.MANDT == TVKGR.MANDT
  • 2LIS_13_VDITM.VKGRP == TVKGR.VKGRP
Sales Organization
  • Client
  • Sales Organization
  • 2LIS_13_VDITM.MANDT == TVKO.MANDT
  • 2LIS_13_VDITM.VKORG == TVKO.VKORG
Volume unit
  • Client
  • Volume unit
  • 2LIS_13_VDITM.MANDT == T006.MANDT
  • 2LIS_13_VDITM.VOLEH == T006.MSEHI
Sales unit
  • Client
  • Sales unit
  • 2LIS_13_VDITM.MANDT == T006.MANDT
  • 2LIS_13_VDITM.VRKME == T006.MSEHI
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • 2LIS_13_VDITM.MANDT == TVST.MANDT
  • 2LIS_13_VDITM.VSTEL == TVST.VSTEL
Distribution Channel
  • Client
  • Distribution Channel
  • 2LIS_13_VDITM.MANDT == TVTW.MANDT
  • 2LIS_13_VDITM.VTWEG == TVTW.VTWEG
Plant
  • Client
  • Plant
  • 2LIS_13_VDITM.MANDT == T001W.MANDT
  • 2LIS_13_VDITM.WERKS == T001W.WERKS