V_WB2_RBKP_RSEG_1

DDL: V_WB2_RBKP_RSEG_1 SQL: VWB2_RBKP_RSEG_1 Type: view

Business Volume from Supplier Invoice

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

Data Sources (4)

SourceAliasJoin Type
ekko ekko inner
ekpo ekpo inner
rbkp rbkp from
rseg rseg inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName VWB2_RBKP_RSEG_1 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 view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY belnr rbkp belnr SD Document
KEY gjahr rbkp gjahr Settlement Year
KEY buzei rseg 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 rseg matnr Vehicle Model
werks rseg werks Receiving Plant
bstme rseg bstme Unit.Order
gewei ekpo gewei Weight Unit
voleh ekpo voleh Volume Unit
punei ekpo punei Points Unit
shkzg rseg shkzg Returns
mwskz rseg mwskz Tax Code
txjcd rseg 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
kostl ekpo kostl Substitute CC
txdat_from rseg 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 rseg tax_country Tax Ctry/Rgn
stceg rbkp stceg VAT Reg. No.
egmld rbkp egmld Reporting C/R
j_1tpbupl rbkp j_1tpbupl Branch Code
knttp ekpo knttp AcctAssgnCat:CC
kzbws ekpo kzbws Valuation
sobkz ekpo sobkz Special Stock
xekbz rseg 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_1.
-- 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_1

CREATE VIEW V_WB2_RBKP_RSEG_1 AS
SELECT
  rbkp.belnr AS belnr,
  rbkp.gjahr AS gjahr,
  rseg.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,
  rseg.matnr AS matnr,
  rseg.werks AS werks,
  rseg.bstme AS bstme,
  ekpo.gewei AS gewei,
  ekpo.voleh AS voleh,
  ekpo.punei AS punei,
  rseg.shkzg AS shkzg,
  rseg.mwskz AS mwskz,
  rseg.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,
  ekpo.kostl AS kostl,
  rseg.txdat_from AS txdat_from,
  ekpo.satnr AS satnr,
  ekpo.ps_psp_pnr AS ps_psp_pnr,
  rbkp.bupla AS bupla,
  rseg.tax_country AS tax_country,
  rbkp.stceg AS stceg,
  rbkp.egmld AS egmld,
  rbkp.j_1tpbupl AS j_1tpbupl,
  ekpo.knttp AS knttp,
  ekpo.kzbws AS kzbws,
  ekpo.sobkz AS sobkz,
  rseg.xekbz AS xekbz
FROM rbkp
INNER JOIN rseg 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 */
;