P_SI4_TrainingData10

@AbapCatalog.sqlViewName: 'PSDSI4TD10'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE

define view P_SI4_TrainingData10
as select from P_SI4_TrainingData09 as TD9
left outer join I_Customer as C
  on SoldToParty = C.Customer
left outer join I_Product as P
  on Material = P.Product
left outer join I_SalesOrganization as SO
  on TD9.SalesOrganization = SO.SalesOrganization
left outer join P_SI4_Period as Period
  on Period.CalendarDate = Period.CalendarDate
{
  key YearMonth,
  key PartOfMonth,
  key SoldToParty,
  key TD9.SalesOrganization,
  key DistributionChannel,
  key TD9.Division,
  key Material,
  
  MaterialGroup,
  CustomerGroup,

  cast( '' as md_customer_name ) as CustomerName,
  C.CreatedByUser,
  C.CustomerClassification,
  C.CustomerAccountGroup,
  C.IsOneTimeAccount,
  C.IsBusinessPurposeCompleted,
  C.Industry,
  C.Country,
  C.CityName,
  P.ProductType,
  SO.CompanyCode,
  SO.IntercompanyBillingCustomer,
  
  // YearQuarter,

  PartOfQuarter,
  
  CalendarYear,
  CalendarQuarter,
  CalendarMonth,
  CalendarWeek,
  
  TargetAmount,
  
  CntByPOM as CountByPOM,
  SumAmtByPOM,
  MaxAmtByPOM,
  MinAmtByPOM,
  cast(
    case
      when CntByPOM != 0 and CntByPOM is not null
        then DIV(SumAmtByPOM, CntByPOM)
      else 0
    end
  as netwr) as AvgAmtByPOM,

  CntByPOQ as CountByPOQ,
  SumAmtByPOQ,
  MaxAmtByPOQ,
  MinAmtByPOQ,
  cast(
    case
      when CntByPOQ != 0 and CntByPOQ is not null
        then DIV(SumAmtByPOQ, CntByPOQ)
      else 0
    end
  as netwr) as AvgAmtByPOQ,

  CntByPre1Month as CountByPre1Month,
  SumAmtByPre1Month,
  MaxAmtByPre1Month,
  MinAmtByPre1Month,
  cast(
    case
      when CntByPre1Month != 0 and CntByPre1Month is not null
        then DIV(SumAmtByPre1Month, CntByPre1Month)
      else 0
    end
  as netwr) as AvgAmtByPre1Month,

  CntByPre1Quarter as CountByPre1Quarter,
  SumAmtByPre1Quarter,
  MaxAmtByPre1Quarter,
  MinAmtByPre1Quarter,
  cast(
    case
      when CntByPre1Quarter != 0 and CntByPre1Quarter is not null
        then DIV(SumAmtByPre1Quarter, CntByPre1Quarter)
      else 0
    end
  as netwr) as AvgAmtByPre1Quarter,
  
  cast( CntByPOM - CntByPre1Month as int4) as DiffCountByPOM,
  cast( SumAmtByPOM - SumAmtByPre1Month as netwr) as DiffSumAmtByPOM,
  cast( MaxAmtByPOM - MaxAmtByPre1Month as netwr) as DiffMaxAmtByPOM,
  cast( MinAmtByPOM - MinAmtByPre1Month as netwr) as DiffMinAmtByPOM,
  
  cast( CntByPOQ - CntByPre1Quarter as int4) as DiffCountByPOQ,
  cast( SumAmtByPOQ - SumAmtByPre1Quarter as netwr) as DiffSumAmtByPOQ,
  cast( MaxAmtByPOQ - MaxAmtByPre1Quarter as netwr) as DiffMaxAmtByPOQ,
  cast( MinAmtByPOQ - MinAmtByPre1Quarter as netwr) as DiffMinAmtByPOQ,

  cast( 0 as netwr) as AvgCountByPOM,
  cast( 0 as netwr) as AvgCountByPOQ,
  
  cast( 0 as netwr) as SumAmtByPre2Month,
  cast( 0 as netwr) as SumAmtByPre3Month,
  cast( 0 as netwr) as SumAmtByPre4Month,
  cast( 0 as netwr) as SumAmtByPre5Month,
  cast( 0 as netwr) as SumAmtByPre6Month,

  cast( 0 as netwr) as DeltaAmtByMoM1,
  cast( 0 as netwr) as DeltaAmtByMoM2,
  cast( 0 as netwr) as DeltaAmtByMoM3,
  cast( 0 as netwr) as DeltaAmtByMoM4,
  cast( 0 as netwr) as DeltaAmtByMoM5,
  cast( 0 as netwr) as DeltaAmtByMoM6,
  
  cast( 0 as netwr) as DeltaAmtByYoY1,
  cast( 0 as netwr) as DeltaAmtByYoY2,
  cast( 0 as netwr) as DeltaAmtByYoY3,
  cast( 0 as netwr) as DeltaAmtByYoY4,
  cast( 0 as netwr) as DeltaAmtByYoY5,
  cast( 0 as netwr) as DeltaAmtByYoY6,

  cast( 0 as netwr) as AvgAmtByLast2Month,
  cast( 0 as netwr) as AvgAmtByLast3Month,
  
  cast( 0 as netwr) as SumAmtRatioByLast3Month1,
  cast( 0 as netwr) as SumAmtRatioByLast3Month2,
  cast( 0 as netwr) as SumAmtRatioByLast3Month3,

  cast( 0 as netwr) as DiffAmtByPOM1,
  cast( 0 as netwr) as DiffAmtByPOM2,
  
  Period.CurrentYearMonth,
  Period.NextYearMonth
}