C_PurContrVersionCompareHdr

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_PurContrVersionCompareHdr.
-- 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: CPCVERCOMPHDR

CREATE VIEW C_PurContrVersionCompareHdr AS
SELECT
  cast('' as ebeln_ad) AS PurchaseContractVersionOne,
  cast('' as ebeln_ad) AS PurchaseContractVersionTwo,
  cast('' as kdatb) AS ValidityStartDate,
  cast('' as ernam) AS CreatedByUser,
  cast('' as erdat) AS CreationDate,
  cast('' as batxt) AS PurchasingDocumentTypeName,
  cast('' as esart) AS PurchaseContractType,
  cast('' as mm_a_purg_org_name) AS PurchasingOrganizationName,
  cast('' as ekorg) AS PurchasingOrganization,
  cast('' as butxt) AS CompanyCodeName,
  cast('' as bukrs) AS CompanyCode,
  cast('' as md_supplier_name) AS SupplierName,
  cast('' as md_supplier) AS Supplier,
  cast('' as revno) AS PurchasingDocumentVersion,
  cast('' as vdm_purchasecontract) AS PurchaseContract,
  cast('' as val_text) AS ChangeRequestNote,
  cast('' as contract_description) AS PurchaseContractDescription,
  cast('' as revno) AS PurchasingDocFirstVersion,
  cast('' as revno) AS PurchasingDocSecondVersion,
  cast('' as val_text) AS PurgDocFirstVersTypeText,
  cast('' as val_text) AS PurgDocSecondVersTypeText,
  cast('' as boole_d) AS HasNote
FROM C_PurContrVersionHistory
LEFT OUTER JOIN C_PurContrVersionCompareItm AS _VersionComparison ON PurchaseContractVersionOne = _VersionComparison.PurContrVersOneComprnVal AND PurchaseContractVersionTwo = _VersionComparison.PurContrVersTwoComprnVal  -- association [0..*]
;