P_CndnContr_Eligible_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_CndnContr_Eligible_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: PWCBCOCOELIVH

CREATE VIEW P_CndnContr_Eligible_ValueHelp AS
SELECT
  wcocoi.num AS num,
  wcocoi.item_guid AS item_guid,
  wcocoi.list_num AS list_num,
  wcocoh.PurchasingOrganization AS ekorg,
  wcocoh.PurchasingGroup AS ekgrp,
  wcocoh.SalesOrganization AS vkorg,
  wcocoh.DistributionChannel AS vtweg,
  wcocoh.Division AS spart,
  wcocoi.reference AS reference,
  wcocoi.date_from AS date_from_i,
  wcocoi.date_to AS date_to_i,
  wcocoh.ExternalDocumentReferenceID AS ext_num,
  wcocoh.Supplier AS vend_owner,
  wcocoh.Customer AS cust_owner,
  wcocoh.PriorSupplier AS kolif,
  wcocoh.ConditionDocumentValidFromDate AS date_from,
  wcocoh.ConditionDocumentValidToDate AS date_to,
  wcocoh.CndnDocActivationStatus AS deact,
  wcocoh.CompanyCode AS bukrs,
  wcocoh.CndnDocWorkerCostCenter AS pers_kostl,
  _ContractType.CndnContrPartnerCat AS owner_type,
  _ContractType.CndnContrHasNoConditions AS no_condition,
  _EligibleCustomer.customer_name AS name1_kna1,
  _EligibleSupplier.supplier_name AS name1_lfa1,
  _Plant.PlantName AS plant_name,
  _ContractType.CndnContrSettlmtType AS rebate_type,
  _PriorSupplier.vendor_begru AS kolif_begru
FROM wcocoi
INNER JOIN R_ConditionDocument AS wcocoh ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_CndnContrType AS _ContractType ON contract_type = _ContractType.CndnContrType  -- association [0..1]
LEFT OUTER JOIN R_CndnContrTypeText AS _ContractTypeText ON contract_type = _ContractTypeText.CndnContrType  -- association [0..*]
LEFT OUTER JOIN P_WLF_CDS_LFA1_BG AS _EligibleSupplier ON eligible_vendor = _EligibleSupplier.vendor_account  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_KNA1_BG AS _EligibleCustomer ON eligible_cust = _EligibleCustomer.customer_account  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_LFA1_BG AS _Supplier ON wcocoh.Supplier = _Supplier.vendor_account  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_KNA1_BG AS _Customer ON wcocoh.Customer = _Customer.customer_account  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_LFA1_BG AS _PriorSupplier ON wcocoh.PriorSupplier = _PriorSupplier.vendor_account  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_PERNR_BEGRU AS _PersonWorkAgreement ON wcocoh.PersonWorkAgreement = _PersonWorkAgreement.Pernr  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON eligible_plant = _Plant.Plant  -- association [0..1]
;