V_Wb2_Vbrk_Vbrp_Tpm

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_Tpm.
-- 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_2

CREATE VIEW V_Wb2_Vbrk_Vbrp_Tpm 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,
  vbrk.spart AS spart,
  vbrk.kunag AS kunnr,
  vbrp.kunwe_ana AS kunwe,
  vbrk.vbtyp AS vbtyp,
  vbrk.bukrs AS bukrs,
  vbrk.fkdat AS fkdat,
  cmpb_map.cmpgn_id AS CAMPAIGN,
  vbrp.matnr AS matnr,
  vbrp.meins AS meins,
  vbrp.netwr AS netwr,
  vbrp.brtwr AS brtwr,
  vbrp.kzwi1 AS kzwi1,
  vbrp.kzwi2 AS kzwi2,
  vbrp.kzwi3 AS kzwi3,
  vbrp.kzwi4 AS kzwi4,
  vbrp.kzwi5 AS kzwi5,
  vbrp.kzwi6 AS kzwi6,
  vbrp.bonba AS bonba,
  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.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.txdat_from AS txdat_from,
  vbrk.land1 AS land1,
  vbrk.regio AS regio,
  vbrp.pmatn AS pmatn,
  vbrp.ps_psp_pnr AS ps_psp_pnr,
  vbrp.aufnr AS aufnr,
  vbrp.kondm AS kondm,
  vbrp.provg AS provg,
  cast ( '14' as wftypv ) AS lftypv,
  vbrk.bupla AS bupla,
  vbrp.aubel AS aubel,
  vbrp.aupos AS 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
FROM vbrp
INNER JOIN vbrk ON /* join condition not captured in parsed metadata */
INNER JOIN tvfk ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cmpb_map ON /* join condition not captured in parsed metadata */
;