P_WBHK_PRASP_ValueHelp

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 P_WBHK_PRASP_ValueHelp.
-- 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: PWBHKPRASPVH

CREATE VIEW P_WBHK_PRASP_ValueHelp AS
SELECT
  wbhk.tkonn AS tkonn,
  wb2_d_prasp.tposn AS tposn,
  wb2_d_prasp.side AS side,
  wb2_d_prasp.tposn_com AS tposn_com,
  wb2_d_prasp.pr_aspect AS pr_aspect,
  wb2_d_prasp.pr_count AS pr_count,
  wb2_d_prasp.future AS future,
  wb2_d_prasp.ext_ref AS ext_ref,
  wb2_d_prasp.assgmt_rel AS assgmt_rel,
  wb2_d_prasp.cond_type AS cond_type,
  wb2_d_prasp.cond_type2 AS cond_type2,
  wb2_d_prasp.cond_type3 AS cond_type3,
  wb2_d_prasp.cond_type4 AS cond_type4,
  wbhk.tkonn_ex AS tkonn_ex,
  wbhk.tctyp AS tctyp,
  wbhk.tksachb AS tksachb,
  wbhk.kunnr AS kunnr,
  wbhd.elifn AS elifn,
  wbhk.vkorg AS vkorg,
  wbhk.vtweg AS vtweg,
  wbhk.spart AS spart,
  wbhd.ekorg AS ekorg,
  wbhd.ekgrp AS ekgrp,
  wbhk.ernam AS ernam,
  wbhk.erdat AS erdat,
  wbhk.erzeit AS erzeit,
  wbhk.aenam AS aenam,
  wbhk.aedat AS aedat,
  wbhk.aezeit AS aezeit,
  wbhk.tccat AS tccat,
  _Supplier.vendor_begru AS vendor_begru
FROM wb2_d_prasp
INNER JOIN wbhk ON /* join condition not captured in parsed metadata */
INNER JOIN wbhi ON /* join condition not captured in parsed metadata */
INNER JOIN wbhd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN knvv AS _CustomerSalesArea ON kunnr = _CustomerSalesArea.kunnr AND vkorg = _CustomerSalesArea.vkorg AND tvta.vtwku = _CustomerSalesArea.vtweg AND tvta.spaku = _CustomerSalesArea.spart  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_LFA1_BG AS _Supplier ON elifn = _Supplier.vendor_account  -- association [0..1]
;