P_WBHK_COM_ITEM_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_COM_ITEM_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: PWBHKCOMIPVH

CREATE VIEW P_WBHK_COM_ITEM_ValueHelp AS
SELECT
  wbhk.tkonn AS tkonn,
  wb2_d_comsub.tposn AS tposn,
  wb2_d_comsub.side AS side,
  wb2_d_comsub.tposn_com AS tposn_com,
  wb2_d_comsub.future AS future,
  wb2_d_comsub.com_cat AS com_cat,
  wb2_d_comsub.hkpstp AS hkpstp,
  wb2_d_comsub.matnr AS matnr,
  wb2_d_comsub.vendor AS vendor,
  wb2_d_comsub.customer AS customer,
  wb2_d_comsub.batch AS batch,
  wb2_d_comsub.ext_ref AS ext_ref,
  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_comsub
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_KNA1_BG AS _CustomerComItem ON customer = _CustomerComItem.customer_account  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_LFA1_BG AS _Supplier ON elifn = _Supplier.vendor_account  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_LFA1_BG AS _SupplierComItem ON vendor = _SupplierComItem.vendor_account  -- association [0..1]
;