I_RAAnalyticsSSPriceTestCube

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 I_RAAnalyticsSSPriceTestCube.
-- 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_cds_reporting_date_from, P_EndDate : farr_cds_reporting_date_to, P_ValuationThresholdPercent : farr_fcm_ssp_threshold_pctg, P_RAFinCmplncIntervalAsPct : farr_fcm_ssp_interval_pctg, P_SizeOfInterval : farr_fc_interval_scope

CREATE VIEW I_RAAnalyticsSSPriceTestCube AS
SELECT
  _RAAnalyticsSSPriceTest.PerformanceObligation AS PerformanceObligation,
  _RAAnalyticsSSPriceTest.RevenueAccountingContract AS RevenueAccountingContract,
  _RAAnalyticsSSPriceTest.PerformanceObligationClass AS PerformanceObligationClass,
  _RAAnalyticsSSPriceTest.RAPerfOblgnInceptionDate AS RAPerfOblgnInceptionDate,
  _CalendarDate.YearQuarter AS YearQuarter,
  _RAAnalyticsSSPriceTest.CompanyCode AS CompanyCode,
  _RAAnalyticsSSPriceTest.AccountingPrinciple AS AccountingPrinciple,
  _RAAnalyticsSSPriceTest.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  cast(concat(concat(_CalendarDate.CalendarYear, '.Q'), _CalendarDate.CalendarQuarter) as farr_cds_year_quarter_str) AS YearQuarterName,
  _RAAnalyticsSSPriceTest.SalesDocumentCurrency AS SalesDocumentCurrency,
  _RAAnalyticsSSPriceTest.ContractualPrcInSlsDocCrcy AS ContractualPrcInSlsDocCrcy,
  _RAAnalyticsSSPriceTest.SSPriceInSalesDocCrcy AS SSPriceInSalesDocCrcy,
  _RAAnalyticsSSPriceTest.PerfOblgnContractualQtyUnit AS PerfOblgnContractualQtyUnit,
  _RAAnalyticsSSPriceTest.PerfOblgnContractualQuantity AS PerfOblgnContractualQuantity,
  _RAAnalyticsSSPriceTest.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
  cast(_RAAnalyticsSSPriceTest.PerfOblgnEffectiveQuantity as farr_cds_effective_quantity preserving type) AS PerfOblgnEffectiveQuantity,
  cast(_RAAnalyticsSSPriceTest.ContractualUnitPrcInSlsDocCrcy as farr_cds_unit_tp) AS UnitContractualPrcInSlsDocCrcy,
  cast(_RAAnalyticsSSPriceTest.UnitSSPriceInSalesDocCrcy as farr_cds_ssp_per_unit) AS PerUnitSSPriceInSlsDocCrcy,
  cast(_RAAnalyticsSSPriceTest.StandardPrice as farr_cds_fcm_standard_ssp) AS StandardPrice,
  cast(_RAAnalyticsSSPriceTest.RAFinCmplncIntervalScopeValue as farr_cds_fcm_interval_number preserving type) AS RAAnalyticNumberOfIntervals,
  cast('%' as farr_cds_ratio_unit) AS RatioUnit,
  cast($parameters.P_RAFinCmplncIntervalAsPct as farr_fcm_ssp_interval_pctg preserving type) AS RAFinCmplncIntervalAsPercent,
  cast($parameters.P_SizeOfInterval as farr_cds_fcm_interval_scope) AS RAFinCmplncIntervalScopeValue,
  cast($parameters.P_ValuationThresholdPercent as farr_fcm_ssp_threshold_pctg preserving type) AS RAFinCmplncThresholdAsPercent,
  cast(_RAAnalyticsSSPriceTest.RAFinCmplncIntervalScpAmtHigh as farr_cds_interval_scope_amount) AS RAFinCmplncIntervalScopeAmount,
  _RAPerformaneObligation.BusinessPartner AS BusinessPartner,
  _RAPerformaneObligation.Customer AS Customer,
  _RAPerformaneObligation.PerformanceObligationStartDate AS PerformanceObligationStartDate,
  _RAPerformaneObligation.PerformanceObligationEndDate AS PerformanceObligationEndDate,
  _RAPerformaneObligation.CostCenter AS CostCenter,
  _RAPerformaneObligation.ProfitCenter AS ProfitCenter,
  _RevenueAccountingContract.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM P_RAAnalyticsSSPrcIntvlAmtTxt
LEFT OUTER JOIN I_RevenueAccountingContract AS _RevenueAccountingContract ON _RAAnalyticsSSPriceTest.RevenueAccountingContract = _RevenueAccountingContract.RevenueAccountingContract  -- association [0..1]
LEFT OUTER JOIN I_RAPerformanceObligation AS _RAPerformaneObligation ON _RAAnalyticsSSPriceTest.PerformanceObligation = _RAPerformaneObligation.PerformanceObligation  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON _RAAnalyticsSSPriceTest.RAPerfOblgnInceptionDate = _CalendarDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PerfOblgnContractualQtyUnit ON PerfOblgnContractualQtyUnit = _PerfOblgnContractualQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PerfOblgnEffectiveQtyUnit ON PerfOblgnEffectiveQuantityUnit = _PerfOblgnEffectiveQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _RAAnalyticsSSPriceTest.CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_AccountingPrinciple AS _AccountingPrinciple ON _RAAnalyticsSSPriceTest.AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple  -- association [0..1]
;