V_WB2_VBRK_VBRP_4

Business Volume from Billing Document for Royalties | view: VWB2_VBRKVBRP_6 | 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
ref_type_2 Additional Reference Document Category Show values
Column Name Description Domain name
lifnr_royalties 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
service_doc_id Service Document ID CRM_OBJECT_ID
service_doc_item_id Service Document Item ID FCO_SRVDOC_ITEM_ID
Master Data Relations Join Conditions
Order Number
  • Order Number
  • Client
  • V_WB2_VBRK_VBRP_4.AUFNR == AUFK.AUFNR
  • V_WB2_VBRK_VBRP_4.MANDT == AUFK.MANDT
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • V_WB2_VBRK_VBRP_4.MANDT == TVAU.MANDT
  • V_WB2_VBRK_VBRP_4.AUGRU == TVAU.AUGRU
Volume rebate group
  • Volume rebate group
  • Client
  • V_WB2_VBRK_VBRP_4.BONUS == TVBO.BONUS
  • V_WB2_VBRK_VBRP_4.MANDT == TVBO.MANDT
Company Code
  • Company Code
  • Client
  • V_WB2_VBRK_VBRP_4.BUKRS == T001.BUKRS
  • V_WB2_VBRK_VBRP_4.MANDT == T001.MANDT
Billing Type
  • Client
  • Billing Type
  • V_WB2_VBRK_VBRP_4.MANDT == TVFK.MANDT
  • V_WB2_VBRK_VBRP_4.FKART == TVFK.FKART
Weight Unit
  • Weight Unit
  • Client
  • V_WB2_VBRK_VBRP_4.GEWEI == T006.MSEHI
  • V_WB2_VBRK_VBRP_4.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • V_WB2_VBRK_VBRP_4.GSBER == TGSB.GSBER
  • V_WB2_VBRK_VBRP_4.MANDT == TGSB.MANDT
Customer group of sales order
  • Client
  • Customer group of sales order
  • V_WB2_VBRK_VBRP_4.MANDT == T151.MANDT
  • V_WB2_VBRK_VBRP_4.KDGRP == T151.KDGRP
Material Price Group
  • Client
  • Material Price Group
  • V_WB2_VBRK_VBRP_4.MANDT == T178.MANDT
  • V_WB2_VBRK_VBRP_4.KONDM == T178.KONDM
Sold-to Party
  • Sold-to Party
  • Client
  • V_WB2_VBRK_VBRP_4.KUNNR == KNA1.KUNNR
  • V_WB2_VBRK_VBRP_4.MANDT == KNA1.MANDT
Payer
  • Client
  • Payer
  • V_WB2_VBRK_VBRP_4.MANDT == KNA1.MANDT
  • V_WB2_VBRK_VBRP_4.KUNRG == KNA1.KUNNR
Customer Group 1
  • Client
  • Customer Group 1
  • V_WB2_VBRK_VBRP_4.MANDT == TVV1.MANDT
  • V_WB2_VBRK_VBRP_4.KVGR1 == TVV1.KVGR1
Customer Group 2
  • Customer Group 2
  • Client
  • V_WB2_VBRK_VBRP_4.KVGR2 == TVV2.KVGR2
  • V_WB2_VBRK_VBRP_4.MANDT == TVV2.MANDT
Customer Group 3
  • Client
  • Customer Group 3
  • V_WB2_VBRK_VBRP_4.MANDT == TVV3.MANDT
  • V_WB2_VBRK_VBRP_4.KVGR3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • V_WB2_VBRK_VBRP_4.MANDT == TVV4.MANDT
  • V_WB2_VBRK_VBRP_4.KVGR4 == TVV4.KVGR4
Customer Group 5
  • Customer Group 5
  • Client
  • V_WB2_VBRK_VBRP_4.KVGR5 == TVV5.KVGR5
  • V_WB2_VBRK_VBRP_4.MANDT == TVV5.MANDT
Material Group
  • Client
  • Material Group
  • V_WB2_VBRK_VBRP_4.MANDT == T023.MANDT
  • V_WB2_VBRK_VBRP_4.MATKL == T023.MATKL
Material Number
  • Client
  • Material Number
  • V_WB2_VBRK_VBRP_4.MANDT == MARA.MANDT
  • V_WB2_VBRK_VBRP_4.MATNR == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • V_WB2_VBRK_VBRP_4.MANDT == T006.MANDT
  • V_WB2_VBRK_VBRP_4.MEINS == T006.MSEHI
Material Group 1
  • Client
  • Material Group 1
  • V_WB2_VBRK_VBRP_4.MANDT == TVM1.MANDT
  • V_WB2_VBRK_VBRP_4.MVGR1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • V_WB2_VBRK_VBRP_4.MANDT == TVM2.MANDT
  • V_WB2_VBRK_VBRP_4.MVGR2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • V_WB2_VBRK_VBRP_4.MANDT == TVM3.MANDT
  • V_WB2_VBRK_VBRP_4.MVGR3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • V_WB2_VBRK_VBRP_4.MANDT == TVM4.MANDT
  • V_WB2_VBRK_VBRP_4.MVGR4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • V_WB2_VBRK_VBRP_4.MANDT == TVM5.MANDT
  • V_WB2_VBRK_VBRP_4.MVGR5 == TVM5.MVGR5
Pricing Reference Material
  • Client
  • Pricing Reference Material
  • V_WB2_VBRK_VBRP_4.MANDT == MARA.MANDT
  • V_WB2_VBRK_VBRP_4.PMATN == MARA.MATNR
Product hierarchy
  • Client
  • Product hierarchy
  • V_WB2_VBRK_VBRP_4.MANDT == T179.MANDT
  • V_WB2_VBRK_VBRP_4.PRODH == T179.PRODH
Commission Group
  • Client
  • Commission Group
  • V_WB2_VBRK_VBRP_4.MANDT == TVPR.MANDT
  • V_WB2_VBRK_VBRP_4.PROVG == TVPR.PROVG
Service Document Type
  • Client
  • Service Document Type
Division
  • Client
  • Division
  • V_WB2_VBRK_VBRP_4.MANDT == TSPA.MANDT
  • V_WB2_VBRK_VBRP_4.SPART == TSPA.SPART
Sales office
  • Client
  • Sales office
  • V_WB2_VBRK_VBRP_4.MANDT == TVBUR.MANDT
  • V_WB2_VBRK_VBRP_4.VKBUR == TVBUR.VKBUR
Sales group
  • Client
  • Sales group
  • V_WB2_VBRK_VBRP_4.MANDT == TVKGR.MANDT
  • V_WB2_VBRK_VBRP_4.VKGRP == TVKGR.VKGRP
Sales Organization
  • Client
  • Sales Organization
  • V_WB2_VBRK_VBRP_4.MANDT == TVKO.MANDT
  • V_WB2_VBRK_VBRP_4.VKORG == TVKO.VKORG
Volume unit
  • Client
  • Volume unit
  • V_WB2_VBRK_VBRP_4.MANDT == T006.MANDT
  • V_WB2_VBRK_VBRP_4.VOLEH == T006.MSEHI
Sales unit
  • Client
  • Sales unit
  • V_WB2_VBRK_VBRP_4.MANDT == T006.MANDT
  • V_WB2_VBRK_VBRP_4.VRKME == T006.MSEHI
Distribution Channel
  • Client
  • Distribution Channel
  • V_WB2_VBRK_VBRP_4.MANDT == TVTW.MANDT
  • V_WB2_VBRK_VBRP_4.VTWEG == TVTW.VTWEG
Plant
  • Client
  • Plant
  • V_WB2_VBRK_VBRP_4.MANDT == T001W.MANDT
  • V_WB2_VBRK_VBRP_4.WERKS == T001W.WERKS