C_PurgInfoRecdVarcCalc

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_PurgInfoRecdVarcCalc.
-- 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: CPIRVARCCALC

CREATE VIEW C_PurgInfoRecdVarcCalc AS
SELECT
  PurchasingInfoRecord,
  PurchasingOrganization,
  PurchasingInfoRecordCategory,
  Plant,
  cast(ConditionValidityEndDate as abap.char(8)) AS ConditionValidityEndDate,
  ConditionRecord,
  ConditionValidityStartDate,
  ConditionType,
  Currency,
  NetAmount,
  FuturePriceValidityStartDate,
  case when NetAmount is not null and _PIRPriceVariance.NetAmount is not null and _PIRPriceVariance.NetAmount > 0 then division((NetAmount - _PIRPriceVariance.NetAmount ) * 100, _PIRPriceVariance.NetAmount, 2) else 0 end as PriceVarianceInPct AS NetAmount2else0endasPriceVarianceInPct
FROM P_PurgInfoRecdHistVarcCalc
LEFT OUTER JOIN P_PurgInfoRecdPrcCalc AS _PIRPriceVariance ON _PIRPriceVariance.PurchasingInfoRecord = PurchasingInfoRecord AND _PIRPriceVariance.PurchasingOrganization = PurchasingOrganization AND _PIRPriceVariance.Plant = Plant AND _PIRPriceVariance.PurchasingInfoRecordCategory = PurchasingInfoRecordCategory AND _PIRPriceVariance.ConditionValidityEndDate = FuturePriceValidityStartDate  -- association [0..1]
;