I_PrdtdSlsPerfApplyingData

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_PrdtdSlsPerfApplyingData.
-- 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: ISDPSPAD

CREATE VIEW I_PrdtdSlsPerfApplyingData AS
SELECT
  YearMonth,
  cast( PartOfMonth as spp_pom ) AS SalesVolumePartOfMonth,
  SalesOrganization,
  DistributionChannel,
  Division,
  SoldToParty,
  CustomerGroup,
  Material,
  MaterialGroup,
  BillingDocumentType,
  YearQuarter,
  cast( PartOfQuarter as spp_poq ) AS SalesVolumePrtOfQtr,
  CalendarWeek,
  CalendarMonth,
  CalendarQuarter,
  CustomerClassification,
  CustomerAccountGroup,
  IsOneTimeAccount,
  IsBusinessPurposeCompleted,
  Industry,
  Country,
  CityName,
  ProductType,
  CompanyCode,
  cast( 'EUR' as vdm_v_display_currency ) AS DisplayCurrency,
  cast( TargetAmount as spp_tgt_amt_in_dc ) AS SalesVolumeTargetAmtInDC,
  cast( CntByPOM as spp_sls_vol_pom_num ) AS NumberOfSlsVolByPrtOfMnth,
  cast( SumAmtByPOM as spp_sls_vol_pom_sum_amt_in_dc ) AS SlsVolPrtOfMnthSumAmtInDC,
  cast( MaxAmtByPOM as spp_sls_vol_pom_max_amt_in_dc ) AS SlsVolPrtOfMnthMaxAmtInDC,
  cast( MinAmtByPOM as spp_sls_vol_pom_min_amt_in_dc ) AS SlsVolPrtOfMnthMinAmtInDC,
  cast( CntByPOQ as spp_sls_vol_poq_num ) AS NumberOfSlsVolByPrtOfQtr,
  cast( SumAmtByPOQ as spp_sls_vol_poq_sum_amt_in_dc ) AS SlsVolPrtOfQtrSumAmtInDC,
  cast( MaxAmtByPOQ as spp_sls_vol_poq_max_amt_in_dc ) AS SlsVolPrtOfQtrMaxAmtInDC,
  cast( MinAmtByPOQ as spp_sls_vol_poq_min_amt_in_dc ) AS SlsVolPrtOfQtrMinAmtInDC,
  cast( CntByPre1Month as spp_sls_vol_pm_num ) AS NumberOfSlsVolByPrevMnth,
  cast( SumAmtByPre1Month as spp_sls_vol_pm_sum_amt_in_dc ) AS SlsVolPrevMnthSumAmtInDC,
  cast( MaxAmtByPre1Month as spp_sls_vol_pm_max_amt_in_dc ) AS SlsVolPrevMnthMaxAmtInDC,
  cast( MinAmtByPre1Month as spp_sls_vol_pm_min_amt_in_dc ) AS SlsVolPrevMnthMinAmtInDC,
  cast( CntByPre1Quarter as spp_sls_vol_pq_num ) AS NumberOfSlsVolByPrevQtr,
  cast( SumAmtByPre1Quarter as spp_sls_vol_pq_sum_amt_in_dc ) AS SlsVolPrevQtrSumAmtInDC,
  cast( MaxAmtByPre1Quarter as spp_sls_vol_pq_max_amt_in_dc ) AS SlsVolPrevQtrMaxAmtInDC,
  cast( MinAmtByPre1Quarter as spp_sls_vol_pq_min_amt_in_dc ) AS SlsVolPrevQtrMinAmtInDC,
  cast( DiffCountByPOM as spp_sv_diff_mnth_num ) AS NumberOfSlsVolDiffByMonth,
  cast( DiffSumAmtByPOM as spp_sv_diff_mnth_sum_amt_in_dc ) AS SlsVolDiffMnthSumAmtInDC,
  cast( DiffMaxAmtByPOM as spp_sv_diff_mnth_max_amt_in_dc ) AS SlsVolDiffMnthMaxAmtInDC,
  cast( DiffMinAmtByPOM as spp_sv_diff_mnth_min_amt_in_dc ) AS SlsVolDiffMnthMinAmtInDC,
  cast( DiffCountByPOQ as spp_sv_diff_qtr_num ) AS NumberOfSlsVolDiffByQtr,
  cast( DiffSumAmtByPOQ as spp_sv_diff_qtr_sum_amt_in_dc ) AS SlsVolDiffQtrSumAmtInDC,
  cast( DiffMaxAmtByPOQ as spp_sv_diff_qtr_max_amt_in_dc ) AS SlsVolDiffQtrMaxAmtInDC,
  cast( DiffMinAmtByPOQ as spp_sv_diff_qtr_min_amt_in_dc ) AS SlsVolDiffQtrMinAmtInDC
FROM P_SPP_PredictionData
;