V_WB2_VBRK_VBRP_3
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)
| Source | Alias | Join Type |
|---|---|---|
| konh | konh | inner |
| prcd_elements | prcd_elements | inner |
| V_WB2_VBRK_VBRP_1 | V_WB2_VBRK_VBRP_1 | from |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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 */
;
Learn More
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA