V_WB2_VBRK_VBRP_5

Business Volume from Billing Document for Commission | view: VWB2_VBRKVBRP_7 | TRAN | Extraction: Not supported | Component: Chargeback
Tables used: VBRK, VBRP, VBPA, FOT_TXA_STAT, TVFK, WB2_C_PARVW_ASGN
Column Name Description
vbeln FK Billing Document
posnr Billing Item
Column Name Description
💲 SD Document Currency (waerk):
netwr Net Value of Billing item in Document Currency
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
bonba Rebate Basis 1
Column Name Description
📏 Base Unit of Measure (meins):
fklmg Billing quantity in stock keeping unit
📏 Sales unit (vrkme):
fkimg Actual billed quantity
📏 Weight Unit (gewei):
ntgew Net weight
brgew Gross weight
📏 Volume unit (voleh):
volum Volume
Column Name Description
fkdat Billing Date
fbuda Date on which services are rendered
txdat_from Valid-From Date of the Tax Rate
prsdt Date for Pricing and Exchange Rate
Column Name Description
vbtyp SD Document Category Show values
shkzg Returns item Show values
lftypv Document Category of Source Document Show values
ref_type Reference Document Category in Settlement Management Show values
Column Name Description Domain name
lifnr_commission Account Number of Supplier LIFNR
kunwe Ship-to Party KUNNR
prctr Profit Center PRCTR
mwskz Tax on sales/purchases code MWSKZ
txjcd Tax Jurisdiction TXJCD
kostl Cost Center KOSTL
land1 Destination Country/Region LAND1
regio Region (State, Province, County) REGIO
ps_psp_pnr Work Breakdown Structure Element (WBS Element) PS_POSNR
Master Data Relations Join Conditions
Order Number
  • Order Number
  • Client
  • V_WB2_VBRK_VBRP_5.AUFNR == AUFK.AUFNR
  • V_WB2_VBRK_VBRP_5.MANDT == AUFK.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • V_WB2_VBRK_VBRP_5.AUGRU == TVAU.AUGRU
  • V_WB2_VBRK_VBRP_5.MANDT == TVAU.MANDT
Volume rebate group
  • Volume rebate group
  • Client
  • V_WB2_VBRK_VBRP_5.BONUS == TVBO.BONUS
  • V_WB2_VBRK_VBRP_5.MANDT == TVBO.MANDT
Company Code
  • Company Code
  • Client
  • V_WB2_VBRK_VBRP_5.BUKRS == T001.BUKRS
  • V_WB2_VBRK_VBRP_5.MANDT == T001.MANDT
Billing Type
  • Billing Type
  • Client
  • V_WB2_VBRK_VBRP_5.FKART == TVFK.FKART
  • V_WB2_VBRK_VBRP_5.MANDT == TVFK.MANDT
Weight Unit
  • Weight Unit
  • Client
  • V_WB2_VBRK_VBRP_5.GEWEI == T006.MSEHI
  • V_WB2_VBRK_VBRP_5.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • V_WB2_VBRK_VBRP_5.GSBER == TGSB.GSBER
  • V_WB2_VBRK_VBRP_5.MANDT == TGSB.MANDT
Customer group of sales order
  • Customer group of sales order
  • Client
  • V_WB2_VBRK_VBRP_5.KDGRP == T151.KDGRP
  • V_WB2_VBRK_VBRP_5.MANDT == T151.MANDT
Material Price Group
  • Material Price Group
  • Client
  • V_WB2_VBRK_VBRP_5.KONDM == T178.KONDM
  • V_WB2_VBRK_VBRP_5.MANDT == T178.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • V_WB2_VBRK_VBRP_5.KUNNR == KNA1.KUNNR
  • V_WB2_VBRK_VBRP_5.MANDT == KNA1.MANDT
Payer
  • Payer
  • Client
  • V_WB2_VBRK_VBRP_5.KUNRG == KNA1.KUNNR
  • V_WB2_VBRK_VBRP_5.MANDT == KNA1.MANDT
Customer Group 1
  • Customer Group 1
  • Client
  • V_WB2_VBRK_VBRP_5.KVGR1 == TVV1.KVGR1
  • V_WB2_VBRK_VBRP_5.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • V_WB2_VBRK_VBRP_5.KVGR2 == TVV2.KVGR2
  • V_WB2_VBRK_VBRP_5.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • V_WB2_VBRK_VBRP_5.KVGR3 == TVV3.KVGR3
  • V_WB2_VBRK_VBRP_5.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • V_WB2_VBRK_VBRP_5.KVGR4 == TVV4.KVGR4
  • V_WB2_VBRK_VBRP_5.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • V_WB2_VBRK_VBRP_5.KVGR5 == TVV5.KVGR5
  • V_WB2_VBRK_VBRP_5.MANDT == TVV5.MANDT
Material Group
  • Client
  • Material Group
  • V_WB2_VBRK_VBRP_5.MANDT == T023.MANDT
  • V_WB2_VBRK_VBRP_5.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • V_WB2_VBRK_VBRP_5.MATNR == MARA.MATNR
  • V_WB2_VBRK_VBRP_5.MANDT == MARA.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • V_WB2_VBRK_VBRP_5.MANDT == T006.MANDT
  • V_WB2_VBRK_VBRP_5.MEINS == T006.MSEHI
Material Group 1
  • Material Group 1
  • Client
  • V_WB2_VBRK_VBRP_5.MVGR1 == TVM1.MVGR1
  • V_WB2_VBRK_VBRP_5.MANDT == TVM1.MANDT
Material Group 2
  • Client
  • Material Group 2
  • V_WB2_VBRK_VBRP_5.MANDT == TVM2.MANDT
  • V_WB2_VBRK_VBRP_5.MVGR2 == TVM2.MVGR2
Material Group 3
  • Material Group 3
  • Client
  • V_WB2_VBRK_VBRP_5.MVGR3 == TVM3.MVGR3
  • V_WB2_VBRK_VBRP_5.MANDT == TVM3.MANDT
Material Group 4
  • Client
  • Material Group 4
  • V_WB2_VBRK_VBRP_5.MANDT == TVM4.MANDT
  • V_WB2_VBRK_VBRP_5.MVGR4 == TVM4.MVGR4
Material Group 5
  • Material Group 5
  • Client
  • V_WB2_VBRK_VBRP_5.MVGR5 == TVM5.MVGR5
  • V_WB2_VBRK_VBRP_5.MANDT == TVM5.MANDT
Pricing Reference Material
  • Pricing Reference Material
  • Client
  • V_WB2_VBRK_VBRP_5.PMATN == MARA.MATNR
  • V_WB2_VBRK_VBRP_5.MANDT == MARA.MANDT
Product hierarchy
  • Client
  • Product hierarchy
  • V_WB2_VBRK_VBRP_5.MANDT == T179.MANDT
  • V_WB2_VBRK_VBRP_5.PRODH == T179.PRODH
Commission Group
  • Commission Group
  • Client
  • V_WB2_VBRK_VBRP_5.PROVG == TVPR.PROVG
  • V_WB2_VBRK_VBRP_5.MANDT == TVPR.MANDT
Division
  • Division
  • Client
  • V_WB2_VBRK_VBRP_5.SPART == TSPA.SPART
  • V_WB2_VBRK_VBRP_5.MANDT == TSPA.MANDT
Sales office
  • Sales office
  • Client
  • V_WB2_VBRK_VBRP_5.VKBUR == TVBUR.VKBUR
  • V_WB2_VBRK_VBRP_5.MANDT == TVBUR.MANDT
Sales group
  • Client
  • Sales group
  • V_WB2_VBRK_VBRP_5.MANDT == TVKGR.MANDT
  • V_WB2_VBRK_VBRP_5.VKGRP == TVKGR.VKGRP
Sales Organization
  • Client
  • Sales Organization
  • V_WB2_VBRK_VBRP_5.MANDT == TVKO.MANDT
  • V_WB2_VBRK_VBRP_5.VKORG == TVKO.VKORG
Volume unit
  • Volume unit
  • Client
  • V_WB2_VBRK_VBRP_5.VOLEH == T006.MSEHI
  • V_WB2_VBRK_VBRP_5.MANDT == T006.MANDT
Sales unit
  • Sales unit
  • Client
  • V_WB2_VBRK_VBRP_5.VRKME == T006.MSEHI
  • V_WB2_VBRK_VBRP_5.MANDT == T006.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • V_WB2_VBRK_VBRP_5.VTWEG == TVTW.VTWEG
  • V_WB2_VBRK_VBRP_5.MANDT == TVTW.MANDT
Plant
  • Client
  • Plant
  • V_WB2_VBRK_VBRP_5.MANDT == T001W.MANDT
  • V_WB2_VBRK_VBRP_5.WERKS == T001W.WERKS