C_PurContrVersionCompareItm

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_PurContrVersionCompareItm.
-- 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: CPCVERCOMPITM

CREATE VIEW C_PurContrVersionCompareItm AS
SELECT
  cast('00000000000000000000000000' as mmpur_node_id ) AS PurContrVersComprnNodeID,
  cast(0 as mmpur_hierarchy_level ) AS PurContrVersComparHierLvl,
  cast('00000000000000000000000000' as mmpur_parent_node_id ) AS PurContrVersComprnParNodeID,
  cast('' as mmpur_drill_state ) AS PurContrVersComprnStsTxt,
  cast('' as mmpur_node_name ) AS PurContrVersComprnNodeTxt,
  cast('' as mmpur_attribute ) AS PurContrVersComprnFldName,
  cast('' as mmpur_vers_comp_value1 ) AS PurContrVersOneComprnVal,
  cast('' as mmpur_vers_comp_value2 ) AS PurContrVersTwoComprnVal,
  cast('' as nte_ntyname) AS PurchasingDocumentNoteType,
  cast('' as nte_objectid) AS PurchasingDocumentNoteObjectID
FROM C_PurContrVersionHistory
LEFT OUTER JOIN C_PurContrVersionCompareHdr AS _VersionComparisonHDR ON PurContrVersOneComprnVal = _VersionComparisonHDR.PurchaseContractVersionOne AND PurContrVersTwoComprnVal = _VersionComparisonHDR.PurchaseContractVersionTwo  -- association [1..1]
;