V_WB2_VBRK_VBRP_7

DDL: V_WB2_VBRK_VBRP_7 SQL: VWB2_VBRKVBRP_9 Type: view Package: WCB_CC_SETTL_BV_SEL

Business Volume from Billing Doc for Commission - Cleared A/R

V_WB2_VBRK_VBRP_7 is a CDS View that provides data about "Business Volume from Billing Doc for Commission - Cleared A/R" in SAP S/4HANA. It reads from 3 data sources (vbpa, vbpa, wb2_c_parvw_asgn) and exposes 81 fields with key fields vbeln, posnr. Part of development package WCB_CC_SETTL_BV_SEL.

Data Sources (3)

SourceAliasJoin Type
vbpa vbpa_head left_outer
vbpa vbpa_item left_outer
wb2_c_parvw_asgn wb2_c_parvw_asgn inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName VWB2_VBRKVBRP_9 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 Doc for Commission - Cleared A/R view

Fields (81)

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

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