2LIS_13_VDKON

Billing Document Condition | #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):
KWERT Condition Value
Column Name Description
📏 Sales unit (VRKME):
FKIMG Actual billed quantity
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
Column Name Description
ROCANCEL Indicator: Cancel Data Record Show values
FKTYP Billing Category Show values
VBTYP SD Document Category Show values
POSAR Item Type Show values
KINAK Condition is Inactive Show values
KSTAT Condition is used for statistics Show values
KOAID Condition Class Show values
KNTYP Condition Category (Examples: Tax, Freight, Price, Cost) Show values
KHERK Origin of the Condition Show values
KVARC Condition Used for Variant Configuration 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
ERNAM Name of Person Responsible for Creating the Object USNAM
KOSTL Cost Center KOSTL
KURSK Exchange Rate for Price Determination KURRF
PKUNRE Bill-to Party KUNNR
PKUNWE Ship-to Party KUNNR
PSPDNR Forwarding Agent LIFNR
PSTYV Sales document item category PSTYV
PVRTNR Sales employee PERNR
VGBEL Document number of the reference document VBELN
VGPOS Item number of the reference item POSNR
STUNR Step Number STUNR
KAPPL Application KAPPL
KSCHL Condition Type KSCHL
VARCOND Variant Condition Key VARCON
ZAEHK Condition Counter ZAEHK
PERIV Fiscal Year Variant PERIV
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID
LOGSYS Logical system LOGSYS
Master Data Relations Join Conditions
Promotion
  • Client
  • Promotion
  • 2LIS_13_VDKON.MANDT == WAKH.MANDT
  • 2LIS_13_VDKON.AKTNR == WAKH.AKTNR
Volume rebate group
  • Client
  • Volume rebate group
  • 2LIS_13_VDKON.MANDT == TVBO.MANDT
  • 2LIS_13_VDKON.BONUS == TVBO.BONUS
Billing Type
  • Client
  • Billing Type
  • 2LIS_13_VDKON.MANDT == TVFK.MANDT
  • 2LIS_13_VDKON.FKART == TVFK.FKART
Controlling Area
  • Client
  • Controlling Area
  • 2LIS_13_VDKON.MANDT == TKA01.MANDT
  • 2LIS_13_VDKON.KOKRS == TKA01.KOKRS
Sold-to Party
  • Client
  • Sold-to Party
  • 2LIS_13_VDKON.MANDT == KNA1.MANDT
  • 2LIS_13_VDKON.KUNAG == KNA1.KUNNR
Payer
  • Client
  • Payer
  • 2LIS_13_VDKON.MANDT == KNA1.MANDT
  • 2LIS_13_VDKON.KUNRG == KNA1.KUNNR
Customer Group 1
  • Client
  • Customer Group 1
  • 2LIS_13_VDKON.MANDT == TVV1.MANDT
  • 2LIS_13_VDKON.KVGR1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • 2LIS_13_VDKON.MANDT == TVV2.MANDT
  • 2LIS_13_VDKON.KVGR2 == TVV2.KVGR2
Customer Group 3
  • Client
  • Customer Group 3
  • 2LIS_13_VDKON.MANDT == TVV3.MANDT
  • 2LIS_13_VDKON.KVGR3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • 2LIS_13_VDKON.MANDT == TVV4.MANDT
  • 2LIS_13_VDKON.KVGR4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • 2LIS_13_VDKON.MANDT == TVV5.MANDT
  • 2LIS_13_VDKON.KVGR5 == TVV5.KVGR5
Material Group
  • Client
  • Material Group
  • 2LIS_13_VDKON.MANDT == T023.MANDT
  • 2LIS_13_VDKON.MATKL == T023.MATKL
Material Number
  • Client
  • Material Number
  • 2LIS_13_VDKON.MANDT == MARA.MANDT
  • 2LIS_13_VDKON.MATNR == MARA.MATNR
Material Entered
  • Client
  • Material Entered
  • 2LIS_13_VDKON.MANDT == MARA.MANDT
  • 2LIS_13_VDKON.MATWA == MARA.MATNR
Material Group 1
  • Client
  • Material Group 1
  • 2LIS_13_VDKON.MANDT == TVM1.MANDT
  • 2LIS_13_VDKON.MVGR1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • 2LIS_13_VDKON.MANDT == TVM2.MANDT
  • 2LIS_13_VDKON.MVGR2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • 2LIS_13_VDKON.MANDT == TVM3.MANDT
  • 2LIS_13_VDKON.MVGR3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • 2LIS_13_VDKON.MANDT == TVM4.MANDT
  • 2LIS_13_VDKON.MVGR4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • 2LIS_13_VDKON.MANDT == TVM5.MANDT
  • 2LIS_13_VDKON.MVGR5 == TVM5.MVGR5
Product hierarchy
  • Client
  • Product hierarchy
  • 2LIS_13_VDKON.MANDT == T179.MANDT
  • 2LIS_13_VDKON.PRODH == T179.PRODH
Commission Group
  • Client
  • Commission Group
  • 2LIS_13_VDKON.MANDT == TVPR.MANDT
  • 2LIS_13_VDKON.PROVG == TVPR.PROVG
Division for order header
  • Client
  • Division for order header
  • 2LIS_13_VDKON.MANDT == TSPA.MANDT
  • 2LIS_13_VDKON.SPARA == TSPA.SPART
Division
  • Client
  • Division
  • 2LIS_13_VDKON.MANDT == TSPA.MANDT
  • 2LIS_13_VDKON.SPART == TSPA.SPART
Statistics Currency
  • Client
  • Statistics Currency
  • 2LIS_13_VDKON.MANDT == TCURC.MANDT
  • 2LIS_13_VDKON.STWAE == TCURC.WAERS
Sales office
  • Client
  • Sales office
  • 2LIS_13_VDKON.MANDT == TVBUR.MANDT
  • 2LIS_13_VDKON.VKBUR == TVBUR.VKBUR
Sales group
  • Client
  • Sales group
  • 2LIS_13_VDKON.MANDT == TVKGR.MANDT
  • 2LIS_13_VDKON.VKGRP == TVKGR.VKGRP
Sales Organization
  • Client
  • Sales Organization
  • 2LIS_13_VDKON.MANDT == TVKO.MANDT
  • 2LIS_13_VDKON.VKORG == TVKO.VKORG
Sales unit
  • Client
  • Sales unit
  • 2LIS_13_VDKON.MANDT == T006.MANDT
  • 2LIS_13_VDKON.VRKME == T006.MSEHI
Distribution Channel
  • Client
  • Distribution Channel
  • 2LIS_13_VDKON.MANDT == TVTW.MANDT
  • 2LIS_13_VDKON.VTWEG == TVTW.VTWEG