V_WB2_VBRK_VBRP_3

DDL: V_WB2_VBRK_VBRP_3 SQL: VWB2_VBRKVBRP_5 Type: view

Business Volume from Billing Document for Chargeback

V_WB2_VBRK_VBRP_3 is a CDS View that provides data about "Business Volume from Billing Document for Chargeback" in SAP S/4HANA. It reads from 3 data sources (konh, prcd_elements, V_WB2_VBRK_VBRP_1) and exposes 82 fields with key fields vbeln, posnr.

Data Sources (3)

SourceAliasJoin Type
konh konh inner
prcd_elements prcd_elements inner
V_WB2_VBRK_VBRP_1 V_WB2_VBRK_VBRP_1 from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName VWB2_VBRKVBRP_5 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Business Volume from Billing Document for Chargeback view

Fields (82)

KeyFieldSource TableSource FieldDescription
KEY vbeln V_WB2_VBRK_VBRP_1 vbeln SD Sched. Agmt
KEY posnr V_WB2_VBRK_VBRP_1 posnr WBS Element
fkart V_WB2_VBRK_VBRP_1 fkart Ship. cost type
waerk V_WB2_VBRK_VBRP_1 waerk Doc. Currency
vkorg V_WB2_VBRK_VBRP_1 vkorg SD Sales Org.
vtweg V_WB2_VBRK_VBRP_1 vtweg RefDistCh-Cust/Mat.
spart V_WB2_VBRK_VBRP_1 spart Source supplier
kunnr V_WB2_VBRK_VBRP_1 kunnr Stock customer
kunrg V_WB2_VBRK_VBRP_1 kunrg Payer
vbtyp V_WB2_VBRK_VBRP_1 vbtyp TSW Det.Doc typ
bukrs V_WB2_VBRK_VBRP_1 bukrs Value
fkdat V_WB2_VBRK_VBRP_1 fkdat Sett. Date
matnr V_WB2_VBRK_VBRP_1 matnr Vehicle Model
bonus V_WB2_VBRK_VBRP_1 bonus Volume Rebate Group
provg V_WB2_VBRK_VBRP_1 provg Time intvl key
kunwe V_WB2_VBRK_VBRP_1 kunwe Ship-to Party
vkont V_WB2_VBRK_VBRP_1 vkont Tech. CtrAcct
meins V_WB2_VBRK_VBRP_1 meins Valuation Unit
fklmg V_WB2_VBRK_VBRP_1 fklmg Bill.Qty in SKU
netwr V_WB2_VBRK_VBRP_1 netwr Value
mwsbp V_WB2_VBRK_VBRP_1 mwsbp Tax Amount
brtwr V_WB2_VBRK_VBRP_1 brtwr Gross value
kzwi1 V_WB2_VBRK_VBRP_1 kzwi1 Subtotal 1
kzwi2 V_WB2_VBRK_VBRP_1 kzwi2 Subtotal 2
kzwi3 V_WB2_VBRK_VBRP_1 kzwi3 Subtotal 3
kzwi4 V_WB2_VBRK_VBRP_1 kzwi4 Subtotal 4
kzwi5 V_WB2_VBRK_VBRP_1 kzwi5 Subtotal 5
kzwi6 V_WB2_VBRK_VBRP_1 kzwi6 Subtotal 6
bonba V_WB2_VBRK_VBRP_1 bonba Rebate Basis
prctr V_WB2_VBRK_VBRP_1 prctr Profit Centers
mvgr1 V_WB2_VBRK_VBRP_1 mvgr1 MaterialGroup 1
mvgr2 V_WB2_VBRK_VBRP_1 mvgr2 MaterialGroup 2
mvgr3 V_WB2_VBRK_VBRP_1 mvgr3 MaterialGroup 3
mvgr4 V_WB2_VBRK_VBRP_1 mvgr4 MaterialGroup 4
mvgr5 V_WB2_VBRK_VBRP_1 mvgr5 MaterialGroup 5
mwskz V_WB2_VBRK_VBRP_1 mwskz Tax Code
txjcd V_WB2_VBRK_VBRP_1 txjcd Tax Jurisdict.
matkl V_WB2_VBRK_VBRP_1 matkl Product Sold Group
prodh V_WB2_VBRK_VBRP_1 prodh Prod. Hierarchy
fbuda V_WB2_VBRK_VBRP_1 fbuda Services Rendered Date
shkzg V_WB2_VBRK_VBRP_1 shkzg Returns
fkimg V_WB2_VBRK_VBRP_1 fkimg Invoiced Qty
vrkme V_WB2_VBRK_VBRP_1 vrkme UoM for SubItm CCD
ntgew V_WB2_VBRK_VBRP_1 ntgew Net Weight
brgew V_WB2_VBRK_VBRP_1 brgew Weight
gewei V_WB2_VBRK_VBRP_1 gewei Weight Unit
volum V_WB2_VBRK_VBRP_1 volum Volume
voleh V_WB2_VBRK_VBRP_1 voleh Volume Unit
gsber V_WB2_VBRK_VBRP_1 gsber Business Area
kostl V_WB2_VBRK_VBRP_1 kostl Substitute CC
werks V_WB2_VBRK_VBRP_1 werks Receiving Plant
vkgrp V_WB2_VBRK_VBRP_1 vkgrp Sales Group
vkbur V_WB2_VBRK_VBRP_1 vkbur Sales Office
augru V_WB2_VBRK_VBRP_1 augru Sales Document Reason
txdat_from V_WB2_VBRK_VBRP_1 txdat_from Tax Rate Valid-From
land1 V_WB2_VBRK_VBRP_1 land1 Trip Ctry/Reg
regio V_WB2_VBRK_VBRP_1 regio Resident Region
pmatn V_WB2_VBRK_VBRP_1 pmatn Pr. Ref. Matl
ps_psp_pnr V_WB2_VBRK_VBRP_1 ps_psp_pnr WBS Element
aufnr V_WB2_VBRK_VBRP_1 aufnr SettlementOrder
kschl prcd_elements kschl Tax Item Type
num konh ccnum Condition Contract
kondm V_WB2_VBRK_VBRP_1 kondm Mat. Price Grp
lftypv V_WB2_VBRK_VBRP_1 lftypv SourceDocCat
bupla V_WB2_VBRK_VBRP_1 bupla Business place
ref_type V_WB2_VBRK_VBRP_1 ref_type SettlmtRefDocCat
aubel V_WB2_VBRK_VBRP_1 aubel Trigger doc
aupos V_WB2_VBRK_VBRP_1 aupos Item
prsdt V_WB2_VBRK_VBRP_1 prsdt Pricing Date
kvgr1 V_WB2_VBRK_VBRP_1 kvgr1 Customer Grp 1
kvgr2 V_WB2_VBRK_VBRP_1 kvgr2 Customer Grp 2
kvgr3 V_WB2_VBRK_VBRP_1 kvgr3 Customer Grp 3
kvgr4 V_WB2_VBRK_VBRP_1 kvgr4 Customer Grp 4
kvgr5 V_WB2_VBRK_VBRP_1 kvgr5 Customer Grp 5
kdgrp V_WB2_VBRK_VBRP_1 kdgrp Customer group
kdkg1 V_WB2_VBRK_VBRP_1 kdkg1 Condition grp 1
kdkg2 V_WB2_VBRK_VBRP_1 kdkg2 Condition grp 2
kdkg3 V_WB2_VBRK_VBRP_1 kdkg3 Condition grp 3
kdkg4 V_WB2_VBRK_VBRP_1 kdkg4 Condition grp 4
kdkg5 V_WB2_VBRK_VBRP_1 kdkg5 Condition grp 5
j_1tpbupl V_WB2_VBRK_VBRP_1 j_1tpbupl Branch Code
bzirk V_WB2_VBRK_VBRP_1 bzirk Sales District

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view V_WB2_VBRK_VBRP_3.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: VWB2_VBRKVBRP_5

CREATE VIEW V_WB2_VBRK_VBRP_3 AS
SELECT
  V_WB2_VBRK_VBRP_1.vbeln AS vbeln,
  V_WB2_VBRK_VBRP_1.posnr AS posnr,
  V_WB2_VBRK_VBRP_1.fkart AS fkart,
  V_WB2_VBRK_VBRP_1.waerk AS waerk,
  V_WB2_VBRK_VBRP_1.vkorg AS vkorg,
  V_WB2_VBRK_VBRP_1.vtweg AS vtweg,
  V_WB2_VBRK_VBRP_1.spart AS spart,
  V_WB2_VBRK_VBRP_1.kunnr AS kunnr,
  V_WB2_VBRK_VBRP_1.kunrg AS kunrg,
  V_WB2_VBRK_VBRP_1.vbtyp AS vbtyp,
  V_WB2_VBRK_VBRP_1.bukrs AS bukrs,
  V_WB2_VBRK_VBRP_1.fkdat AS fkdat,
  V_WB2_VBRK_VBRP_1.matnr AS matnr,
  V_WB2_VBRK_VBRP_1.bonus AS bonus,
  V_WB2_VBRK_VBRP_1.provg AS provg,
  V_WB2_VBRK_VBRP_1.kunwe AS kunwe,
  V_WB2_VBRK_VBRP_1.vkont AS vkont,
  V_WB2_VBRK_VBRP_1.meins AS meins,
  V_WB2_VBRK_VBRP_1.fklmg AS fklmg,
  V_WB2_VBRK_VBRP_1.netwr AS netwr,
  V_WB2_VBRK_VBRP_1.mwsbp AS mwsbp,
  V_WB2_VBRK_VBRP_1.brtwr AS brtwr,
  V_WB2_VBRK_VBRP_1.kzwi1 AS kzwi1,
  V_WB2_VBRK_VBRP_1.kzwi2 AS kzwi2,
  V_WB2_VBRK_VBRP_1.kzwi3 AS kzwi3,
  V_WB2_VBRK_VBRP_1.kzwi4 AS kzwi4,
  V_WB2_VBRK_VBRP_1.kzwi5 AS kzwi5,
  V_WB2_VBRK_VBRP_1.kzwi6 AS kzwi6,
  V_WB2_VBRK_VBRP_1.bonba AS bonba,
  V_WB2_VBRK_VBRP_1.prctr AS prctr,
  V_WB2_VBRK_VBRP_1.mvgr1 AS mvgr1,
  V_WB2_VBRK_VBRP_1.mvgr2 AS mvgr2,
  V_WB2_VBRK_VBRP_1.mvgr3 AS mvgr3,
  V_WB2_VBRK_VBRP_1.mvgr4 AS mvgr4,
  V_WB2_VBRK_VBRP_1.mvgr5 AS mvgr5,
  V_WB2_VBRK_VBRP_1.mwskz AS mwskz,
  V_WB2_VBRK_VBRP_1.txjcd AS txjcd,
  V_WB2_VBRK_VBRP_1.matkl AS matkl,
  V_WB2_VBRK_VBRP_1.prodh AS prodh,
  V_WB2_VBRK_VBRP_1.fbuda AS fbuda,
  V_WB2_VBRK_VBRP_1.shkzg AS shkzg,
  V_WB2_VBRK_VBRP_1.fkimg AS fkimg,
  V_WB2_VBRK_VBRP_1.vrkme AS vrkme,
  V_WB2_VBRK_VBRP_1.ntgew AS ntgew,
  V_WB2_VBRK_VBRP_1.brgew AS brgew,
  V_WB2_VBRK_VBRP_1.gewei AS gewei,
  V_WB2_VBRK_VBRP_1.volum AS volum,
  V_WB2_VBRK_VBRP_1.voleh AS voleh,
  V_WB2_VBRK_VBRP_1.gsber AS gsber,
  V_WB2_VBRK_VBRP_1.kostl AS kostl,
  V_WB2_VBRK_VBRP_1.werks AS werks,
  V_WB2_VBRK_VBRP_1.vkgrp AS vkgrp,
  V_WB2_VBRK_VBRP_1.vkbur AS vkbur,
  V_WB2_VBRK_VBRP_1.augru AS augru,
  V_WB2_VBRK_VBRP_1.txdat_from AS txdat_from,
  V_WB2_VBRK_VBRP_1.land1 AS land1,
  V_WB2_VBRK_VBRP_1.regio AS regio,
  V_WB2_VBRK_VBRP_1.pmatn AS pmatn,
  V_WB2_VBRK_VBRP_1.ps_psp_pnr AS ps_psp_pnr,
  V_WB2_VBRK_VBRP_1.aufnr AS aufnr,
  prcd_elements.kschl AS kschl,
  konh.ccnum AS num,
  V_WB2_VBRK_VBRP_1.kondm AS kondm,
  V_WB2_VBRK_VBRP_1.lftypv AS lftypv,
  V_WB2_VBRK_VBRP_1.bupla AS bupla,
  V_WB2_VBRK_VBRP_1.ref_type AS ref_type,
  V_WB2_VBRK_VBRP_1.aubel AS aubel,
  V_WB2_VBRK_VBRP_1.aupos AS aupos,
  V_WB2_VBRK_VBRP_1.prsdt AS prsdt,
  V_WB2_VBRK_VBRP_1.kvgr1 AS kvgr1,
  V_WB2_VBRK_VBRP_1.kvgr2 AS kvgr2,
  V_WB2_VBRK_VBRP_1.kvgr3 AS kvgr3,
  V_WB2_VBRK_VBRP_1.kvgr4 AS kvgr4,
  V_WB2_VBRK_VBRP_1.kvgr5 AS kvgr5,
  V_WB2_VBRK_VBRP_1.kdgrp AS kdgrp,
  V_WB2_VBRK_VBRP_1.kdkg1 AS kdkg1,
  V_WB2_VBRK_VBRP_1.kdkg2 AS kdkg2,
  V_WB2_VBRK_VBRP_1.kdkg3 AS kdkg3,
  V_WB2_VBRK_VBRP_1.kdkg4 AS kdkg4,
  V_WB2_VBRK_VBRP_1.kdkg5 AS kdkg5,
  V_WB2_VBRK_VBRP_1.j_1tpbupl AS j_1tpbupl,
  V_WB2_VBRK_VBRP_1.bzirk AS bzirk
FROM V_WB2_VBRK_VBRP_1
INNER JOIN prcd_elements ON /* join condition not captured in parsed metadata */
INNER JOIN konh ON /* join condition not captured in parsed metadata */
;