V_WB2_VBRK_VBRP_TPM_1

Business Volume from Billing Document with Campaign | view: VWB2_VBRKVBRP_3 | TRAN | Extraction: Not supported | Component: Chargeback
Tables used: CMPB_ASGN, VBRK, VBRP, CMPB_MAP, 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
Column Name Description Domain name
fkart Billing Type FKART
vkorg Sales Organization VKORG
vtweg Distribution Channel VTWEG
KUNNR Sold-to Party KUNNR
kunrg Payer KUNNR
bukrs Company Code BUKRS
CAMPAIGN_GUID Generic project planning: GUID from external R/3 system SYSUUID
CAMPAIGN Campaign ID CMPGN_ID_R3
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
tax_country Tax Reporting Country/Region LAND1
stceg VAT Registration Number STCEG
stceg_l Country/Region of Sales Tax ID Number LAND1
Master Data Relations Join Conditions
Order Number
  • Order Number
  • Client
  • V_WB2_VBRK_VBRP_TPM_1.AUFNR == AUFK.AUFNR
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == AUFK.MANDT
Weight Unit
  • Weight Unit
  • Client
  • V_WB2_VBRK_VBRP_TPM_1.GEWEI == T006.MSEHI
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • V_WB2_VBRK_VBRP_TPM_1.GSBER == TGSB.GSBER
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == TGSB.MANDT
Material Price Group
  • Material Price Group
  • Client
  • V_WB2_VBRK_VBRP_TPM_1.KONDM == T178.KONDM
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == T178.MANDT
Material Group
  • Material Group
  • Client
  • V_WB2_VBRK_VBRP_TPM_1.MATKL == T023.MATKL
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == T023.MANDT
Material Number
  • Client
  • Material Number
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == MARA.MANDT
  • V_WB2_VBRK_VBRP_TPM_1.MATNR == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == T006.MANDT
  • V_WB2_VBRK_VBRP_TPM_1.MEINS == T006.MSEHI
Material Group 1
  • Material Group 1
  • Client
  • V_WB2_VBRK_VBRP_TPM_1.MVGR1 == TVM1.MVGR1
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == TVM1.MANDT
Material Group 2
  • Material Group 2
  • Client
  • V_WB2_VBRK_VBRP_TPM_1.MVGR2 == TVM2.MVGR2
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == TVM2.MANDT
Material Group 3
  • Client
  • Material Group 3
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == TVM3.MANDT
  • V_WB2_VBRK_VBRP_TPM_1.MVGR3 == TVM3.MVGR3
Material Group 4
  • Material Group 4
  • Client
  • V_WB2_VBRK_VBRP_TPM_1.MVGR4 == TVM4.MVGR4
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == TVM4.MANDT
Material Group 5
  • Client
  • Material Group 5
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == TVM5.MANDT
  • V_WB2_VBRK_VBRP_TPM_1.MVGR5 == TVM5.MVGR5
Pricing Reference Material
  • Client
  • Pricing Reference Material
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == MARA.MANDT
  • V_WB2_VBRK_VBRP_TPM_1.PMATN == MARA.MATNR
Product hierarchy
  • Product hierarchy
  • Client
  • V_WB2_VBRK_VBRP_TPM_1.PRODH == T179.PRODH
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == T179.MANDT
Commission Group
  • Client
  • Commission Group
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == TVPR.MANDT
  • V_WB2_VBRK_VBRP_TPM_1.PROVG == TVPR.PROVG
Division
  • Division
  • Client
  • V_WB2_VBRK_VBRP_TPM_1.SPART == TSPA.SPART
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == TSPA.MANDT
Sales office
  • Sales office
  • Client
  • V_WB2_VBRK_VBRP_TPM_1.VKBUR == TVBUR.VKBUR
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == TVBUR.MANDT
Sales group
  • Client
  • Sales group
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == TVKGR.MANDT
  • V_WB2_VBRK_VBRP_TPM_1.VKGRP == TVKGR.VKGRP
Volume unit
  • Volume unit
  • Client
  • V_WB2_VBRK_VBRP_TPM_1.VOLEH == T006.MSEHI
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == T006.MANDT
Sales unit
  • Sales unit
  • Client
  • V_WB2_VBRK_VBRP_TPM_1.VRKME == T006.MSEHI
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == T006.MANDT
Plant
  • Client
  • Plant
  • V_WB2_VBRK_VBRP_TPM_1.MANDT == T001W.MANDT
  • V_WB2_VBRK_VBRP_TPM_1.WERKS == T001W.WERKS