2LIS_12_VCHDR

Delivery Header Data | #TRAN | Extraction method: CO | Delta: ABR | Component: Sales and Distribution
Tables used: LIKP, VBUK → show details
Column Name Description
VBELN Sales and Distribution Document Number
Column Name Description
Column Name Description
📏 Weight Unit (GEWEI):
BTGEW Total Weight
NTGEW Net weight
📏 Volume unit (VOLEH):
VOLUM Volume
Column Name Description
ERDAT Date on which the record was created
LFDAT Delivery Date
WADAT Planned Goods Movement Date
WADAT_IST Actual Goods Movement Date
Column Name Description
ROCANCEL Indicator: Cancel Data Record Show values
VBTYP 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
PKUNRE Bill-to Party KUNNR
PKUNRG Payer KUNNR
PSPDNR Forwarding Agent LIFNR
PVRTNR Sales employee PERNR
ANZLI No. of deliveries MCZAEHLER
MCBW_ANZPK Extraction BW: Number of Packages per Delivery MCZAEHLER
PERIV Fiscal Year Variant PERIV
WA_DELAY_LF BW Extraction LE: Actual GI Delay - GI Date for Delivery MCZAEHLER
Master Data Relations Join Conditions
Sales District
  • Client
  • Sales District
  • 2LIS_12_VCHDR.MANDT == T171.MANDT
  • 2LIS_12_VCHDR.BZIRK == T171.BZIRK
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • 2LIS_12_VCHDR.MANDT == TVFS.MANDT
  • 2LIS_12_VCHDR.FAKSK == TVFS.FAKSP
Weight Unit
  • Client
  • Weight Unit
  • 2LIS_12_VCHDR.MANDT == T006.MANDT
  • 2LIS_12_VCHDR.GEWEI == T006.MSEHI
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • 2LIS_12_VCHDR.MANDT == TINC.MANDT
  • 2LIS_12_VCHDR.INCO1 == TINC.INCO1
Customer Group
  • Client
  • Customer Group
  • 2LIS_12_VCHDR.MANDT == T151.MANDT
  • 2LIS_12_VCHDR.KDGRP == T151.KDGRP
Sold-to Party
  • Client
  • Sold-to Party
  • 2LIS_12_VCHDR.MANDT == KNA1.MANDT
  • 2LIS_12_VCHDR.KUNAG == KNA1.KUNNR
Ship-to Party
  • Client
  • Ship-to Party
  • 2LIS_12_VCHDR.MANDT == KNA1.MANDT
  • 2LIS_12_VCHDR.KUNNR == KNA1.KUNNR
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • 2LIS_12_VCHDR.MANDT == TVLS.MANDT
  • 2LIS_12_VCHDR.LIFSK == TVLS.LIFSP
Loading Point
  • Client
  • Loading Point
  • Shipping Point / Receiving Point
  • 2LIS_12_VCHDR.MANDT == TVLA.MANDT
  • 2LIS_12_VCHDR.LSTEL == TVLA.LSTEL
  • 2LIS_12_VCHDR.VSTEL == TVLA.VSTEL
Route
  • Client
  • Route
  • 2LIS_12_VCHDR.MANDT == TVRO.MANDT
  • 2LIS_12_VCHDR.ROUTE == TVRO.ROUTE
Sales Organization
  • Client
  • Sales Organization
  • 2LIS_12_VCHDR.MANDT == TVKO.MANDT
  • 2LIS_12_VCHDR.VKORG == TVKO.VKORG
Volume unit
  • Client
  • Volume unit
  • 2LIS_12_VCHDR.MANDT == T006.MANDT
  • 2LIS_12_VCHDR.VOLEH == T006.MSEHI
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • 2LIS_12_VCHDR.MANDT == TVST.MANDT
  • 2LIS_12_VCHDR.VSTEL == TVST.VSTEL