P_RAAnlytsSSPriceTestDistance

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_RAAnlytsSSPriceTestDistance.
-- 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.
-- Parameters: P_StartDate : farr_effective_date, P_EndDate : farr_effective_date, P_RAFinCmplncIntervalAsPercent : farr_fcm_ssp_interval_pctg

CREATE VIEW P_RAAnlytsSSPriceTestDistance AS
SELECT
  _RAAnlytsUnitPriceByItem.PerformanceObligation AS PerformanceObligation,
  _RAAnlytsUnitPriceByItem.PerformanceObligationClass AS PerformanceObligationClass,
  _RAAnlytsUnitPriceByItem.RevenueAccountingContract AS RevenueAccountingContract,
  _RAAnlytsUnitPriceByItem.CompanyCode AS CompanyCode,
  _RAAnlytsUnitPriceByItem.AccountingPrinciple AS AccountingPrinciple,
  _RAAnlytsUnitPriceByItem.RAPerfOblgnInceptionDate AS RAPerfOblgnInceptionDate,
  _RAAnlytsUnitPriceByItem.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  _RAAnlytsUnitPriceByItem.SalesDocumentCurrency AS SalesDocumentCurrency,
  _RAAnlytsUnitPriceByItem.ContractualPrcInSlsDocCrcy AS ContractualPrcInSlsDocCrcy,
  _RAAnlytsUnitPriceByItem.SSPriceInSalesDocCrcy AS SSPriceInSalesDocCrcy,
  _RAAnlytsUnitPriceByItem.ContractualUnitPrcInSlsDocCrcy AS ContractualUnitPrcInSlsDocCrcy,
  _RAAnlytsUnitPriceByItem.UnitSSPriceInSalesDocCrcy AS UnitSSPriceInSalesDocCrcy,
  _RAFinCmplncUnitSSPriceByName.UnitSSPriceInSalesDocCrcy AS StandardPrice,
  _RAAnlytsUnitPriceByItem.PerfOblgnContractualQtyUnit AS PerfOblgnContractualQtyUnit,
  _RAAnlytsUnitPriceByItem.PerfOblgnContractualQuantity AS PerfOblgnContractualQuantity,
  _RAAnlytsUnitPriceByItem.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
  _RAAnlytsUnitPriceByItem.PerfOblgnEffectiveQuantity AS PerfOblgnEffectiveQuantity,
  cast((_RAAnlytsUnitPriceByItem.ContractualUnitPrcInSlsDocCrcy - _RAFinCmplncUnitSSPriceByName.UnitSSPriceInSalesDocCrcy)*100 as abap.dec(23,6)) AS DistanceValue,
  cast(_RAFinCmplncUnitSSPriceByName.UnitSSPriceInSalesDocCrcy*$parameters.P_RAFinCmplncIntervalAsPercent as abap.dec(23,6)) AS IntervalValue
FROM P_RAAnlytsUnitPriceByItem AS _RAAnlytsUnitPriceByItem
;