2LIS_11_VAKON

Sales Document Condition | #TRAN | Extraction method: CO | Delta: ABR | Component: Sales and Distribution
Tables used: VBAP, VBAK, VBKD, VBUP, VBUK → 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):
KWERT Condition Value
Column Name Description
📏 Sales unit (VRKME):
KWMENG Cumulative order quantity in sales units
📏 Target Quantity UoM (ZIEME):
ZMENG Target Quantity in Sales Units
Column Name Description
AEDAT Last Changed On
ERDAT Date on which the record was created
ERZET Entry time
STADAT Statistics date
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
UVPRS Pricing Incompletion Status (Item) Show values
VBTYP SD Document Category Show values
KHERK Origin of the Condition Show values
KINAK Condition is Inactive Show values
KNTYP Condition Category (Examples: Tax, Freight, Price, Cost) Show values
KOAID Condition Class Show values
KSTAT Condition is used for statistics Show values
KVARC Condition Used for Variant Configuration Show values
VGTYP_AK Sales Document Category of Reference Doc. in Order Header Show values
Column Name Description Domain name
AUART Sales Document Type AUART
BUKRS Company Code BUKRS
KUNNR Sold-to Party KUNNR
KVGR2 Customer Group 2 KVGR2
KVGR3 Customer Group 3 KVGR3
KVGR4 Customer Group 4 KVGR4
KVGR5 Customer Group 5 KVGR5
VKORG Sales Organization VKORG
VTWEG Distribution Channel VTWEG
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
PKUNWE Ship-to Party KUNNR
PVRTNR Sales employee PERNR
STCUR Exchange rate for statistics (Exch.rate at time of creation) KURRF
INCO2 Incoterms (Part 2) INCO2
KURSK Exchange Rate for Price Determination KURRF
KAPPL Application KAPPL
KSCHL Condition Type KSCHL
STUNR Step Number STUNR
VARCOND Variant Condition Key VARCON
ZAEHK Condition Counter ZAEHK
SPARA Division for order header SPART
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID
PERIV Fiscal Year Variant PERIV
Master Data Relations Join Conditions
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • 2LIS_11_VAKON.MANDT == TVAG.MANDT
  • 2LIS_11_VAKON.ABGRU == TVAG.ABGRU
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • 2LIS_11_VAKON.MANDT == TVAU.MANDT
  • 2LIS_11_VAKON.AUGRU == TVAU.AUGRU
Sales District
  • Client
  • Sales District
  • 2LIS_11_VAKON.MANDT == T171.MANDT
  • 2LIS_11_VAKON.BZIRK == T171.BZIRK
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • 2LIS_11_VAKON.MANDT == TVFS.MANDT
  • 2LIS_11_VAKON.FAKSK == TVFS.FAKSP
Billing Block for Item
  • Client
  • Billing Block for Item
  • 2LIS_11_VAKON.MANDT == TVFS.MANDT
  • 2LIS_11_VAKON.FAKSP == TVFS.FAKSP
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • 2LIS_11_VAKON.MANDT == TINC.MANDT
  • 2LIS_11_VAKON.INCO1 == TINC.INCO1
Customer Group
  • Client
  • Customer Group
  • 2LIS_11_VAKON.MANDT == T151.MANDT
  • 2LIS_11_VAKON.KDGRP == T151.KDGRP
Account Assignment Group for this Customer
  • Client
  • Account Assignment Group for this Customer
  • 2LIS_11_VAKON.MANDT == TVKT.MANDT
  • 2LIS_11_VAKON.KTGRD == TVKT.KTGRD
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • 2LIS_11_VAKON.MANDT == TCURV.MANDT
  • 2LIS_11_VAKON.KURST == TCURV.KURST
Customer Group 1
  • Client
  • Customer Group 1
  • 2LIS_11_VAKON.MANDT == TVV1.MANDT
  • 2LIS_11_VAKON.KVGR1 == TVV1.KVGR1
Material Group
  • Client
  • Material Group
  • 2LIS_11_VAKON.MANDT == T023.MANDT
  • 2LIS_11_VAKON.MATKL == T023.MATKL
Material: order item
  • Client
  • Material Number
  • 2LIS_11_VAKON.MANDT == MARA.MANDT
  • 2LIS_11_VAKON.MATNR == MARA.MATNR
Material Entered
  • Client
  • Material Entered
  • 2LIS_11_VAKON.MANDT == MARA.MANDT
  • 2LIS_11_VAKON.MATWA == MARA.MATNR
Material Group 1
  • Client
  • Material Group 1
  • 2LIS_11_VAKON.MANDT == TVM1.MANDT
  • 2LIS_11_VAKON.MVGR1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • 2LIS_11_VAKON.MANDT == TVM2.MANDT
  • 2LIS_11_VAKON.MVGR2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • 2LIS_11_VAKON.MANDT == TVM3.MANDT
  • 2LIS_11_VAKON.MVGR3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • 2LIS_11_VAKON.MANDT == TVM4.MANDT
  • 2LIS_11_VAKON.MVGR4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • 2LIS_11_VAKON.MANDT == TVM5.MANDT
  • 2LIS_11_VAKON.MVGR5 == TVM5.MVGR5
Product hierarchy: order item
  • Client
  • Product hierarchy
  • 2LIS_11_VAKON.MANDT == T179.MANDT
  • 2LIS_11_VAKON.PRODH == T179.PRODH
Sales document item category
  • Client
  • Sales document item category
  • 2LIS_11_VAKON.MANDT == TVPT.MANDT
  • 2LIS_11_VAKON.PSTYV == TVPT.PSTYV
Division in order header
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • 2LIS_11_VAKON.MANDT == TVTA.MANDT
  • 2LIS_11_VAKON.SPART == TVTA.SPART
  • 2LIS_11_VAKON.VKORG == TVTA.VKORG
  • 2LIS_11_VAKON.VTWEG == TVTA.VTWEG
Statistics Currency
  • Client
  • Statistics Currency
  • 2LIS_11_VAKON.MANDT == TCURC.MANDT
  • 2LIS_11_VAKON.STWAE == TCURC.WAERS
Sales group
  • Client
  • Sales office
  • Sales group
  • 2LIS_11_VAKON.MANDT == TVBVK.MANDT
  • 2LIS_11_VAKON.VKBUR == TVBVK.VKBUR
  • 2LIS_11_VAKON.VKGRP == TVBVK.VKGRP
Sales unit
  • Client
  • Sales unit
  • 2LIS_11_VAKON.MANDT == T006.MANDT
  • 2LIS_11_VAKON.VRKME == T006.MSEHI
SD Document Currency
  • Client
  • SD Document Currency
  • SD Document Currency
  • 2LIS_11_VAKON.MANDT == TCURC.MANDT
  • 2LIS_11_VAKON.WAERK == TCURC.WAERS
  • 2LIS_11_VAKON.WAERK_VBAK == TCURC.WAERS
SD Document Currency
  • Client
  • SD Document Currency
  • SD Document Currency
  • 2LIS_11_VAKON.MANDT == TCURC.MANDT
  • 2LIS_11_VAKON.WAERK == TCURC.WAERS
  • 2LIS_11_VAKON.WAERK_VBAK == TCURC.WAERS
Retail promotion
  • Client
  • Promotion
  • 2LIS_11_VAKON.MANDT == WAKH.MANDT
  • 2LIS_11_VAKON.WAKTION == WAKH.AKTNR
Target Quantity UoM
  • Client
  • Target Quantity UoM
  • 2LIS_11_VAKON.MANDT == T006.MANDT
  • 2LIS_11_VAKON.ZIEME == T006.MSEHI
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Division
  • Sales office
  • Sales Organization
  • Distribution Channel
  • 2LIS_11_VAKON.MANDT == TVKBZ.MANDT
  • 2LIS_11_VAKON.SPART == TVKBZ.SPART
  • 2LIS_11_VAKON.VKBUR == TVKBZ.VKBUR
  • 2LIS_11_VAKON.VKORG == TVKBZ.VKORG
  • 2LIS_11_VAKON.VTWEG == TVKBZ.VTWEG