P_WCOCOH_Settle_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_WCOCOH_Settle_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: PWCBCOCOSETTLVH

CREATE VIEW P_WCOCOH_Settle_ValueHelp AS
SELECT
  cast( num as wcb_coco_num preserving type ) AS num,
  vend_owner,
  cust_owner,
  reference,
  assignment,
  ext_partner,
  created_by,
  created_on,
  rec_time,
  ekorg,
  ekgrp,
  vkorg,
  vtweg,
  spart,
  deact,
  date_from,
  date_to,
  ext_num,
  vkgrp,
  vkbur,
  _ContractType.CndnContrPartnerCat AS owner_type,
  _ContractType.CndnContrHasNoConditions AS no_condition,
  _Customer.customer_name AS name1_kna1,
  _Supplier.supplier_name AS name1_lfa1,
  category,
  kolif,
  bukrs,
  pers_kostl,
  person_owner,
  cast( _ContractType.CndnContrSettlmtType as wb2_rebate_type preserving type ) AS rebate_type,
  _PriorSupplier.vendor_begru AS kolif_begru
FROM wcocoh
LEFT OUTER JOIN R_CndnContrType AS _ContractType ON contract_type = _ContractType.CndnContrType  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_LFA1_BG AS _Supplier ON vend_owner = _Supplier.vendor_account  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_KNA1_BG AS _Customer ON cust_owner = _Customer.customer_account  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_LFA1_BG AS _PriorSupplier ON kolif = _PriorSupplier.vendor_account  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_PERNR_BEGRU AS _PersonWorkAgreement ON person_owner = _PersonWorkAgreement.Pernr  -- association [0..1]
;