V_WB2_WBRK_WBRP_0_2

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_WBRK_WBRP_0_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_WBRKWBRP02

CREATE VIEW V_WB2_WBRK_WBRP_0_2 AS
SELECT
  wbrk.wbeln AS wbeln,
  wbrp.posnr AS posnr,
  wbrk.ekorg AS ekorg,
  wbrk.ekgrp AS ekgrp,
  wbrk.vkorg AS vkorg,
  wbrk.vtweg AS vtweg,
  wbrk.spart AS spart,
  wbrk.lifre AS lifnr,
  wbrk.kunre AS kunnr,
  wbrk.kunrg AS kunrg,
  wbrk.vkont AS vkont,
  wbrk.vkgrp AS vkgrp,
  wbrk.vkbur AS vkbur,
  wbrk.waerl AS waerl,
  wbrk.bldat AS bldat,
  wbrk.wfdat AS wfdat,
  wbrk.xblnr AS xblnr,
  wbrk.wrart AS wrart,
  wbrk.lfart AS lfart,
  wbrk.process_type AS process_type,
  wbrk.land1tx AS land1tx,
  wbrk.stcegd AS stcegd,
  wbrk.wdtyp AS wdtyp,
  wbrp.werks AS werks,
  wbrp.matnr AS matnr,
  wbrp.matkl AS matkl,
  wbrp.ekkol AS ekkol,
  wbrp.ltsnr AS ltsnr,
  wbrp.wfkme AS wfkme,
  wbrp.gewei AS gewei,
  wbrp.voleh AS voleh,
  wbrp.punei AS punei,
  wbrp.meins AS meins,
  wbrp.customer AS customer,
  wbrp.kolif AS kolif,
  wbrp.supplier AS supplier,
  wbrp.txdat_from_d AS txdat_from,
  wbrp.kondm AS kondm,
  wbrp.provg AS provg,
  wbrp.rebate_grp AS bonus,
  cast ( '11' as wftypv ) AS lftypv,
  wbrp.ref_doc_nr_1 AS ref_doc_nr_1,
  wbrp.ref_type AS ref_type,
  wbrp.prsdt AS prsdt,
  wbrk.waerl AS waerk,
  wbrk.wfdat AS fkdat,
  wbrk.use_case AS use_case,
  wbrk.abart AS abart,
  wbrp.j_1tpbupl_d AS j_1tpbupl
FROM wbrk
INNER JOIN wbrp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tmzr ON /* join condition not captured in parsed metadata */
;