V_WB2_RBKP_RSEG_2

DDL: V_WB2_RBKP_RSEG_2 SQL: VWB2_RBKP_RSEG_2 Type: view

Business Volume from Supplier Invoice (online and batch)

V_WB2_RBKP_RSEG_2 is a CDS View that provides data about "Business Volume from Supplier Invoice (online and batch)" in SAP S/4HANA. It reads from 4 data sources (ekko, ekpo, V_WB2_RSEG_RBDRSEG_UNION, rbkp) and exposes 40 fields with key fields belnr, gjahr, buzei.

Data Sources (4)

SourceAliasJoin Type
ekko ekko inner
ekpo ekpo inner
V_WB2_RSEG_RBDRSEG_UNION r_item inner
rbkp rbkp from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName VWB2_RBKP_RSEG_2 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 Supplier Invoice (online and batch) view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY belnr rbkp belnr SD Document
KEY gjahr rbkp gjahr Settlement Year
KEY buzei V_WB2_RSEG_RBDRSEG_UNION buzei Posting View Item
blart rbkp blart Rep. rec. doc. type
bldat rbkp bldat Journal Entry Date
budat rbkp budat Posting Date
bukrs rbkp bukrs Value
ekorg ekko ekorg Purchasing Org.
ekgrp ekko ekgrp Sub. purchasing grp
llief ekko llief Goods Supplier
lifnr_po ekko lifnr Vendor no.
lifnr rbkp lifnr Vendor no.
waers rbkp waers Transaction Currency
landl rbkp landl Supply C/R
matnr V_WB2_RSEG_RBDRSEG_UNION matnr Vehicle Model
werks V_WB2_RSEG_RBDRSEG_UNION werks Receiving Plant
bstme V_WB2_RSEG_RBDRSEG_UNION bstme Unit.Order
gewei ekpo gewei Weight Unit
voleh ekpo voleh Volume Unit
punei ekpo punei Points Unit
shkzg V_WB2_RSEG_RBDRSEG_UNION shkzg Returns
mwskz V_WB2_RSEG_RBDRSEG_UNION mwskz Tax Code
txjcd V_WB2_RSEG_RBDRSEG_UNION txjcd Tax Jurisdict.
kolif ekpo kolif Prior Supplier
ltsnr ekpo ltsnr Suppl. Subrange
mtart ekpo mtart Product Type
matkl ekpo matkl Product Sold Group
ekkol ekpo ekkol Condition Group
gsber rbkp gsber Business Area
aktnr ekpo aktnr Promotion
prctr ekpo ko_prctr Profit Center
txdat_from V_WB2_RSEG_RBDRSEG_UNION txdat_from Tax Rate Valid-From
satnr ekpo satnr Cross-plant CM
ps_psp_pnr ekpo ps_psp_pnr WBS Element
bupla rbkp bupla Business place
tax_country V_WB2_RSEG_RBDRSEG_UNION tax_country Tax Ctry/Rgn
stceg rbkp stceg VAT Reg. No.
egmld rbkp egmld Reporting C/R
j_1tpbupl rbkp j_1tpbupl Branch Code
xekbz V_WB2_RSEG_RBDRSEG_UNION xekbz Item Category

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_RBKP_RSEG_2.
-- 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_RBKP_RSEG_2

CREATE VIEW V_WB2_RBKP_RSEG_2 AS
SELECT
  rbkp.belnr AS belnr,
  rbkp.gjahr AS gjahr,
  r_item.buzei AS buzei,
  rbkp.blart AS blart,
  rbkp.bldat AS bldat,
  rbkp.budat AS budat,
  rbkp.bukrs AS bukrs,
  ekko.ekorg AS ekorg,
  ekko.ekgrp AS ekgrp,
  ekko.llief AS llief,
  ekko.lifnr AS lifnr_po,
  rbkp.lifnr AS lifnr,
  rbkp.waers AS waers,
  rbkp.landl AS landl,
  r_item.matnr AS matnr,
  r_item.werks AS werks,
  r_item.bstme AS bstme,
  ekpo.gewei AS gewei,
  ekpo.voleh AS voleh,
  ekpo.punei AS punei,
  r_item.shkzg AS shkzg,
  r_item.mwskz AS mwskz,
  r_item.txjcd AS txjcd,
  ekpo.kolif AS kolif,
  ekpo.ltsnr AS ltsnr,
  ekpo.mtart AS mtart,
  ekpo.matkl AS matkl,
  ekpo.ekkol AS ekkol,
  rbkp.gsber AS gsber,
  ekpo.aktnr AS aktnr,
  ekpo.ko_prctr AS prctr,
  r_item.txdat_from AS txdat_from,
  ekpo.satnr AS satnr,
  ekpo.ps_psp_pnr AS ps_psp_pnr,
  rbkp.bupla AS bupla,
  r_item.tax_country AS tax_country,
  rbkp.stceg AS stceg,
  rbkp.egmld AS egmld,
  rbkp.j_1tpbupl AS j_1tpbupl,
  r_item.xekbz AS xekbz
FROM rbkp
INNER JOIN V_WB2_RSEG_RBDRSEG_UNION AS r_item ON /* join condition not captured in parsed metadata */
INNER JOIN ekko ON /* join condition not captured in parsed metadata */
INNER JOIN ekpo ON /* join condition not captured in parsed metadata */
;