C_PurchaseContractValHelp

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 C_PurchaseContractValHelp.
-- 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: CPURCONTRVH

CREATE VIEW C_PurchaseContractValHelp AS
SELECT
  PurchaseContract.PurchaseContract AS PurchaseContract,
  PurchaseContract.Supplier AS Supplier,
  PurchaseContract.DocumentCurrency AS DocumentCurrency,
  case PurchaseContract.ValidityStartDate when (' ') then '00000000' else PurchaseContract.ValidityStartDate end as ValidityStartDate AS ValidityStartDateendasValidityStartDate,
  case PurchaseContract.ValidityEndDate when (' ') then '00000000' else PurchaseContract.ValidityEndDate end as ValidityEndDate AS ValidityEndDateendasValidityEndDate,
  PurchaseContract.PurchasingOrganization AS PurchasingOrganization,
  PurchaseContract.PurchasingGroup AS PurchasingGroup
FROM I_PurchaseContract AS PurchaseContract
LEFT OUTER JOIN C_PurchasingOrgValueHelp AS _PurchasingOrgValueHelp ON _PurchasingOrgValueHelp.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGroupValueHelp ON _PurchasingGroupValueHelp.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN C_MM_SupplierValueHelp AS _SupplierValueHelp ON _SupplierValueHelp.Supplier = Supplier  -- association [0..*]
;