V_WB2_VBRK_VBRP_1

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_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_VBRKVBRP_1

CREATE VIEW V_WB2_VBRK_VBRP_1 AS
SELECT
  vbrp.vbeln AS vbeln,
  vbrp.posnr AS posnr,
  vbrk.fkart AS fkart,
  vbrp.waerk AS waerk,
  vbrk.vkorg AS vkorg,
  vbrk.vtweg AS vtweg,
  vbrp.spart AS spart,
  vbrk.kunag AS kunnr,
  vbrk.kunrg AS kunrg,
  vbrk.vbtyp AS vbtyp,
  vbrk.bukrs AS bukrs,
  vbrk.fkdat AS fkdat,
  vbrp.matnr AS matnr,
  vbrp.bonus AS bonus,
  vbrp.provg AS provg,
  vbrp.kunwe_ana AS kunwe,
  vbrk.vkont AS vkont,
  vbrp.meins AS meins,
  vbrp.prctr AS prctr,
  vbrp.mvgr1 AS mvgr1,
  vbrp.mvgr2 AS mvgr2,
  vbrp.mvgr3 AS mvgr3,
  vbrp.mvgr4 AS mvgr4,
  vbrp.mvgr5 AS mvgr5,
  vbrp.mwsk1 AS mwskz,
  vbrp.txjcd AS txjcd,
  vbrp.matkl AS matkl,
  vbrp.prodh AS prodh,
  vbrp.fbuda AS fbuda,
  vbrp.shkzg AS shkzg,
  vbrp.vrkme AS vrkme,
  vbrp.gewei AS gewei,
  vbrp.voleh AS voleh,
  vbrp.gsber AS gsber,
  vbrp.kostl AS kostl,
  vbrp.werks AS werks,
  vbrp.vkgrp AS vkgrp,
  vbrp.vkbur AS vkbur,
  vbrp.augru_auft AS augru,
  vbrp.txdat_from AS txdat_from,
  vbrk.knumv AS knumv,
  vbrk.land1 AS land1,
  vbrk.regio AS regio,
  vbrp.pmatn AS pmatn,
  vbrp.ps_psp_pnr AS ps_psp_pnr,
  vbrp.pospa AS pospa,
  vbrp.aufnr AS aufnr,
  vbrp.kondm AS kondm,
  cast ( '14' as wftypv ) AS lftypv,
  vbrk.bupla AS bupla,
  aubel,
  aupos,
  vbrp.prsdt AS prsdt,
  vbrk.stceg AS stceg,
  vbrk.stceg_l AS stceg_l,
  vbrp.kvgr1 AS kvgr1,
  vbrp.kvgr2 AS kvgr2,
  vbrp.kvgr3 AS kvgr3,
  vbrp.kvgr4 AS kvgr4,
  vbrp.kvgr5 AS kvgr5,
  vbrp.kdgrp_auft AS kdgrp,
  vbrp.kdkg1 AS kdkg1,
  vbrp.kdkg2 AS kdkg2,
  vbrp.kdkg3 AS kdkg3,
  vbrp.kdkg4 AS kdkg4,
  vbrp.kdkg5 AS kdkg5,
  vbrk.j_1tpbupl AS j_1tpbupl,
  vbrp.aktnr AS aktnr,
  vbrk.clrst AS clrst
FROM vbrp
INNER JOIN vbrk ON /* join condition not captured in parsed metadata */
INNER JOIN tvfk ON /* join condition not captured in parsed metadata */
;