V_Wb2_Vbrk_Vbrp_Tpm

CCS: Business Volume from Sales for TPM | view: VWB2_VBRKVBRP_2 | TRAN | Extraction: Not supported | Component: Chargeback
Tables used: VBRK, VBRP, CMPB_MAP, FOT_TXA_STAT, TVFK
Column Name Description
vbeln FK Billing Document
posnr Billing Item
Column Name Description
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
fklmg Billing quantity in stock keeping unit
fkimg Actual billed quantity
brgew Gross weight
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
bukrs Company Code BUKRS
CAMPAIGN Campaign ID CMPGN_ID_R3
prctr Profit Center PRCTR
mwskz Tax on sales/purchases code MWSKZ
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
  • Client
  • Order Number
  • V_WB2_VBRK_VBRP_TPM.MANDT == AUFK.MANDT
  • V_WB2_VBRK_VBRP_TPM.AUFNR == AUFK.AUFNR
Weight Unit
  • Client
  • Weight Unit
  • V_WB2_VBRK_VBRP_TPM.MANDT == T006.MANDT
  • V_WB2_VBRK_VBRP_TPM.GEWEI == T006.MSEHI
Business Area
  • Business Area
  • Client
  • V_WB2_VBRK_VBRP_TPM.GSBER == TGSB.GSBER
  • V_WB2_VBRK_VBRP_TPM.MANDT == TGSB.MANDT
Material Price Group
  • Material Price Group
  • Client
  • V_WB2_VBRK_VBRP_TPM.KONDM == T178.KONDM
  • V_WB2_VBRK_VBRP_TPM.MANDT == T178.MANDT
Material Group
  • Client
  • Material Group
  • V_WB2_VBRK_VBRP_TPM.MANDT == T023.MANDT
  • V_WB2_VBRK_VBRP_TPM.MATKL == T023.MATKL
Material Number
  • Client
  • Material Number
  • V_WB2_VBRK_VBRP_TPM.MANDT == MARA.MANDT
  • V_WB2_VBRK_VBRP_TPM.MATNR == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • V_WB2_VBRK_VBRP_TPM.MANDT == T006.MANDT
  • V_WB2_VBRK_VBRP_TPM.MEINS == T006.MSEHI
Material Group 1
  • Client
  • Material Group 1
  • V_WB2_VBRK_VBRP_TPM.MANDT == TVM1.MANDT
  • V_WB2_VBRK_VBRP_TPM.MVGR1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • V_WB2_VBRK_VBRP_TPM.MANDT == TVM2.MANDT
  • V_WB2_VBRK_VBRP_TPM.MVGR2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • V_WB2_VBRK_VBRP_TPM.MANDT == TVM3.MANDT
  • V_WB2_VBRK_VBRP_TPM.MVGR3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • V_WB2_VBRK_VBRP_TPM.MANDT == TVM4.MANDT
  • V_WB2_VBRK_VBRP_TPM.MVGR4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • V_WB2_VBRK_VBRP_TPM.MANDT == TVM5.MANDT
  • V_WB2_VBRK_VBRP_TPM.MVGR5 == TVM5.MVGR5
Pricing Reference Material
  • Pricing Reference Material
  • Client
  • V_WB2_VBRK_VBRP_TPM.PMATN == MARA.MATNR
  • V_WB2_VBRK_VBRP_TPM.MANDT == MARA.MANDT
Product hierarchy
  • Client
  • Product hierarchy
  • V_WB2_VBRK_VBRP_TPM.MANDT == T179.MANDT
  • V_WB2_VBRK_VBRP_TPM.PRODH == T179.PRODH
Commission Group
  • Client
  • Commission Group
  • V_WB2_VBRK_VBRP_TPM.MANDT == TVPR.MANDT
  • V_WB2_VBRK_VBRP_TPM.PROVG == TVPR.PROVG
Division
  • Client
  • Division
  • V_WB2_VBRK_VBRP_TPM.MANDT == TSPA.MANDT
  • V_WB2_VBRK_VBRP_TPM.SPART == TSPA.SPART
Sales office
  • Client
  • Sales office
  • V_WB2_VBRK_VBRP_TPM.MANDT == TVBUR.MANDT
  • V_WB2_VBRK_VBRP_TPM.VKBUR == TVBUR.VKBUR
Sales group
  • Client
  • Sales group
  • V_WB2_VBRK_VBRP_TPM.MANDT == TVKGR.MANDT
  • V_WB2_VBRK_VBRP_TPM.VKGRP == TVKGR.VKGRP
Volume unit
  • Client
  • Volume unit
  • V_WB2_VBRK_VBRP_TPM.MANDT == T006.MANDT
  • V_WB2_VBRK_VBRP_TPM.VOLEH == T006.MSEHI
Sales unit
  • Client
  • Sales unit
  • V_WB2_VBRK_VBRP_TPM.MANDT == T006.MANDT
  • V_WB2_VBRK_VBRP_TPM.VRKME == T006.MSEHI
Plant
  • Client
  • Plant
  • V_WB2_VBRK_VBRP_TPM.MANDT == T001W.MANDT
  • V_WB2_VBRK_VBRP_TPM.WERKS == T001W.WERKS