P_SPP_PredictionPeriod

DDL: P_SPP_PREDICTIONPERIOD SQL: PSDSPPPP Type: view COMPOSITE Package: VDM_SD_PREDICTED_SALES

Prediction Period

P_SPP_PredictionPeriod is a Composite CDS View that provides data about "Prediction Period" in SAP S/4HANA. It reads from 1 data source (I_CalendarDate) and exposes 7 fields with key field CalendarDate. Part of development package VDM_SD_PREDICTED_SALES.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_CalendarDate I_CalendarDate from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSDSPPPP view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CalendarDate CalendarDate
PredictionStartDate1
PredictionStartDate2
PredictionStartDate3
PredictionEndDate
CurrentYearMonth YearMonth
NextYearMonth 
@AbapCatalog.sqlViewName: 'PSDSPPPP'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE

define view P_SPP_PredictionPeriod
as select from I_CalendarDate
{
  key CalendarDate,
  
  // Prediction dimension selection:

  //   PredictionStartDate2 -> PredictionEndDate

  // Prediction period selection

  //   PredictionStartDate3 -> PredictionEndDate

  // Data used for prediction

  //   PredictionStartDate1 -> PredictionEndDate

  concat( left( dats_add_months( CalendarDate,  -6, 'FAIL'), 6 ), '01') as PredictionStartDate1,
  concat( left( dats_add_months( CalendarDate,  -3, 'FAIL'), 6 ), '01') as PredictionStartDate2,
  concat( YearMonth, '01') as PredictionStartDate3,
  concat( left( dats_add_months( CalendarDate,  2, 'FAIL'), 6 ), '01') as PredictionEndDate,
  
  cast(
    case
      when CalendarDay >= '01' and CalendarDay <= '10'
        then 1
      when CalendarDay >= '11' and CalendarDay <= '20'
        then 2
      else 2
    end
  as sp_pom ) as CurrentPartOfMonth,
  
  YearMonth as CurrentYearMonth,
  left( dats_add_months( CalendarDate,  1, 'FAIL'), 6 ) as NextYearMonth
}
where CalendarDate = $session.system_date

Learn More