2LIS_11_VAHDR

Sales Document Header Data | #TRAN | Extraction method: CO | Delta: ABR | Component: Sales and Distribution
Tables used: VBAK, VBUK → show details
Column Name Description
VBELN Sales and Distribution Document Number
Column Name Description
Column Name Description
Column Name Description
ANGDT Quotation/Inquiry is Valid From
BNDDT Date Until Which Bid/Quotation is Binding (Valid-To Date)
ERDAT Date on which the record was created
VDATU Requested Delivery Date
Column Name Description
ROCANCEL Indicator: Cancel Data Record Show values
VBTYP SD Document Category Show values
VGTYP_AK Sales Document Category of Reference Doc. in Order Header Show values
Column Name Description Domain name
BUKRS Company Code BUKRS
PVRTNR Sales employee PERNR
SPARA Division for order header SPART
ANZAU Number of Orders MCZAEHLER
PERIV Fiscal Year Variant PERIV
Master Data Relations Join Conditions
Order type in order header
  • Client
  • Sales Document Type
  • 2LIS_11_VAHDR.MANDT == TVAK.MANDT
  • 2LIS_11_VAHDR.AUART == TVAK.AUART
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • 2LIS_11_VAHDR.MANDT == TVAU.MANDT
  • 2LIS_11_VAHDR.AUGRU == TVAU.AUGRU
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • 2LIS_11_VAHDR.MANDT == TVFS.MANDT
  • 2LIS_11_VAHDR.FAKSK == TVFS.FAKSP
Sold-to Party
  • Client
  • Sold-to Party
  • 2LIS_11_VAHDR.MANDT == KNA1.MANDT
  • 2LIS_11_VAHDR.KUNNR == KNA1.KUNNR
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • 2LIS_11_VAHDR.MANDT == TCURV.MANDT
  • 2LIS_11_VAHDR.KURST == TCURV.KURST
Customer Group 1
  • Client
  • Customer Group 1
  • 2LIS_11_VAHDR.MANDT == TVV1.MANDT
  • 2LIS_11_VAHDR.KVGR1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • 2LIS_11_VAHDR.MANDT == TVV2.MANDT
  • 2LIS_11_VAHDR.KVGR2 == TVV2.KVGR2
Customer Group 3
  • Client
  • Customer Group 3
  • 2LIS_11_VAHDR.MANDT == TVV3.MANDT
  • 2LIS_11_VAHDR.KVGR3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • 2LIS_11_VAHDR.MANDT == TVV4.MANDT
  • 2LIS_11_VAHDR.KVGR4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • 2LIS_11_VAHDR.MANDT == TVV5.MANDT
  • 2LIS_11_VAHDR.KVGR5 == TVV5.KVGR5
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • 2LIS_11_VAHDR.MANDT == TVLS.MANDT
  • 2LIS_11_VAHDR.LIFSK == TVLS.LIFSP
Statistics Currency
  • Client
  • Statistics Currency
  • 2LIS_11_VAHDR.MANDT == TCURC.MANDT
  • 2LIS_11_VAHDR.STWAE == TCURC.WAERS
Sales group
  • Client
  • Sales office
  • Sales group
  • 2LIS_11_VAHDR.MANDT == TVBVK.MANDT
  • 2LIS_11_VAHDR.VKBUR == TVBVK.VKBUR
  • 2LIS_11_VAHDR.VKGRP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • 2LIS_11_VAHDR.MANDT == TVKO.MANDT
  • 2LIS_11_VAHDR.VKORG == TVKO.VKORG
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • 2LIS_11_VAHDR.MANDT == TVKOV.MANDT
  • 2LIS_11_VAHDR.VKORG == TVKOV.VKORG
  • 2LIS_11_VAHDR.VTWEG == TVKOV.VTWEG
Currency in order header
  • Client
  • SD Document Currency
  • 2LIS_11_VAHDR.MANDT == TCURC.MANDT
  • 2LIS_11_VAHDR.WAERK == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • ?
  • Sales office
  • Sales Organization
  • Distribution Channel
  • 2LIS_11_VAHDR.MANDT == TVKBZ.MANDT
  • 2LIS_11_VAHDR.[column in domain "SPART"] == TVKBZ.SPART
  • 2LIS_11_VAHDR.VKBUR == TVKBZ.VKBUR
  • 2LIS_11_VAHDR.VKORG == TVKBZ.VKORG
  • 2LIS_11_VAHDR.VTWEG == TVKBZ.VTWEG