V_WB2_VBRK_VBRP_1

Business Volume from Billing Document | view: VWB2_VBRKVBRP_1 | TRAN | Extraction: Not supported | Component: Chargeback
Tables used: VBRK, VBRP, FOT_TXA_STAT, TVFK
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
kunwe Ship-to Party KUNNR
vkont Contract Account Number CORR_VKONT_KK
prctr Profit Center PRCTR
mwskz Tax on sales/purchases code MWSKZ
txjcd Tax Jurisdiction TXJCD
kostl Cost Center KOSTL
knumv Number of the Document Condition KNUMV
land1 Destination Country/Region LAND1
regio Region (State, Province, County) REGIO
ps_psp_pnr Work Breakdown Structure Element (WBS Element) PS_POSNR
tax_country Tax Reporting Country/Region LAND1
service_doc_id Service Document ID CRM_OBJECT_ID
service_doc_item_id Service Document Item ID FCO_SRVDOC_ITEM_ID
stceg VAT Registration Number STCEG
stceg_l Country/Region of Sales Tax ID Number LAND1
t2ccode_crcy_conv_factor Factor for calculating Amount in company code currency FINS_T2ANY_CRCY_CONV_FACTOR
t2cntry_crcy_conv_factor Factor for calculating Tax Amount in reporting currency FINS_T2ANY_CRCY_CONV_FACTOR
Master Data Relations Join Conditions
Order Number
  • Client
  • Order Number
  • V_WB2_VBRK_VBRP_1.MANDT == AUFK.MANDT
  • V_WB2_VBRK_VBRP_1.AUFNR == AUFK.AUFNR
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • V_WB2_VBRK_VBRP_1.MANDT == TVAU.MANDT
  • V_WB2_VBRK_VBRP_1.AUGRU == TVAU.AUGRU
Volume rebate group
  • Client
  • Volume rebate group
  • V_WB2_VBRK_VBRP_1.MANDT == TVBO.MANDT
  • V_WB2_VBRK_VBRP_1.BONUS == TVBO.BONUS
Company Code
  • Company Code
  • Client
  • V_WB2_VBRK_VBRP_1.BUKRS == T001.BUKRS
  • V_WB2_VBRK_VBRP_1.MANDT == T001.MANDT
Billing Type
  • Client
  • Billing Type
  • V_WB2_VBRK_VBRP_1.MANDT == TVFK.MANDT
  • V_WB2_VBRK_VBRP_1.FKART == TVFK.FKART
Weight Unit
  • Client
  • Weight Unit
  • V_WB2_VBRK_VBRP_1.MANDT == T006.MANDT
  • V_WB2_VBRK_VBRP_1.GEWEI == T006.MSEHI
Business Area
  • Client
  • Business Area
  • V_WB2_VBRK_VBRP_1.MANDT == TGSB.MANDT
  • V_WB2_VBRK_VBRP_1.GSBER == TGSB.GSBER
Customer group of sales order
  • Client
  • Customer group of sales order
  • V_WB2_VBRK_VBRP_1.MANDT == T151.MANDT
  • V_WB2_VBRK_VBRP_1.KDGRP == T151.KDGRP
Material Price Group
  • Client
  • Material Price Group
  • V_WB2_VBRK_VBRP_1.MANDT == T178.MANDT
  • V_WB2_VBRK_VBRP_1.KONDM == T178.KONDM
Sold-to Party
  • Sold-to Party
  • Client
  • V_WB2_VBRK_VBRP_1.KUNNR == KNA1.KUNNR
  • V_WB2_VBRK_VBRP_1.MANDT == KNA1.MANDT
Payer
  • Client
  • Payer
  • V_WB2_VBRK_VBRP_1.MANDT == KNA1.MANDT
  • V_WB2_VBRK_VBRP_1.KUNRG == KNA1.KUNNR
Customer Group 1
  • Client
  • Customer Group 1
  • V_WB2_VBRK_VBRP_1.MANDT == TVV1.MANDT
  • V_WB2_VBRK_VBRP_1.KVGR1 == TVV1.KVGR1
Customer Group 2
  • Customer Group 2
  • Client
  • V_WB2_VBRK_VBRP_1.KVGR2 == TVV2.KVGR2
  • V_WB2_VBRK_VBRP_1.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • V_WB2_VBRK_VBRP_1.KVGR3 == TVV3.KVGR3
  • V_WB2_VBRK_VBRP_1.MANDT == TVV3.MANDT
Customer Group 4
  • Client
  • Customer Group 4
  • V_WB2_VBRK_VBRP_1.MANDT == TVV4.MANDT
  • V_WB2_VBRK_VBRP_1.KVGR4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • V_WB2_VBRK_VBRP_1.MANDT == TVV5.MANDT
  • V_WB2_VBRK_VBRP_1.KVGR5 == TVV5.KVGR5
Material Group
  • Client
  • Material Group
  • V_WB2_VBRK_VBRP_1.MANDT == T023.MANDT
  • V_WB2_VBRK_VBRP_1.MATKL == T023.MATKL
Material Number
  • Client
  • Material Number
  • V_WB2_VBRK_VBRP_1.MANDT == MARA.MANDT
  • V_WB2_VBRK_VBRP_1.MATNR == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • V_WB2_VBRK_VBRP_1.MANDT == T006.MANDT
  • V_WB2_VBRK_VBRP_1.MEINS == T006.MSEHI
Material Group 1
  • Client
  • Material Group 1
  • V_WB2_VBRK_VBRP_1.MANDT == TVM1.MANDT
  • V_WB2_VBRK_VBRP_1.MVGR1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • V_WB2_VBRK_VBRP_1.MANDT == TVM2.MANDT
  • V_WB2_VBRK_VBRP_1.MVGR2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • V_WB2_VBRK_VBRP_1.MANDT == TVM3.MANDT
  • V_WB2_VBRK_VBRP_1.MVGR3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • V_WB2_VBRK_VBRP_1.MANDT == TVM4.MANDT
  • V_WB2_VBRK_VBRP_1.MVGR4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • V_WB2_VBRK_VBRP_1.MANDT == TVM5.MANDT
  • V_WB2_VBRK_VBRP_1.MVGR5 == TVM5.MVGR5
Pricing Reference Material
  • Client
  • Pricing Reference Material
  • V_WB2_VBRK_VBRP_1.MANDT == MARA.MANDT
  • V_WB2_VBRK_VBRP_1.PMATN == MARA.MATNR
Product hierarchy
  • Client
  • Product hierarchy
  • V_WB2_VBRK_VBRP_1.MANDT == T179.MANDT
  • V_WB2_VBRK_VBRP_1.PRODH == T179.PRODH
Commission Group
  • Client
  • Commission Group
  • V_WB2_VBRK_VBRP_1.MANDT == TVPR.MANDT
  • V_WB2_VBRK_VBRP_1.PROVG == TVPR.PROVG
Service Document Type
  • Client
  • Service Document Type
Division
  • Client
  • Division
  • V_WB2_VBRK_VBRP_1.MANDT == TSPA.MANDT
  • V_WB2_VBRK_VBRP_1.SPART == TSPA.SPART
Sales office
  • Client
  • Sales office
  • V_WB2_VBRK_VBRP_1.MANDT == TVBUR.MANDT
  • V_WB2_VBRK_VBRP_1.VKBUR == TVBUR.VKBUR
Sales group
  • Client
  • Sales group
  • V_WB2_VBRK_VBRP_1.MANDT == TVKGR.MANDT
  • V_WB2_VBRK_VBRP_1.VKGRP == TVKGR.VKGRP
Sales Organization
  • Client
  • Sales Organization
  • V_WB2_VBRK_VBRP_1.MANDT == TVKO.MANDT
  • V_WB2_VBRK_VBRP_1.VKORG == TVKO.VKORG
Volume unit
  • Client
  • Volume unit
  • V_WB2_VBRK_VBRP_1.MANDT == T006.MANDT
  • V_WB2_VBRK_VBRP_1.VOLEH == T006.MSEHI
Sales unit
  • Client
  • Sales unit
  • V_WB2_VBRK_VBRP_1.MANDT == T006.MANDT
  • V_WB2_VBRK_VBRP_1.VRKME == T006.MSEHI
Distribution Channel
  • Client
  • Distribution Channel
  • V_WB2_VBRK_VBRP_1.MANDT == TVTW.MANDT
  • V_WB2_VBRK_VBRP_1.VTWEG == TVTW.VTWEG
Plant
  • Client
  • Plant
  • V_WB2_VBRK_VBRP_1.MANDT == T001W.MANDT
  • V_WB2_VBRK_VBRP_1.WERKS == T001W.WERKS