P_SPP_PredictionData06

@AbapCatalog.sqlViewName: 'PSDSPPPDA06'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE

define view P_SPP_PredictionData06
as select from P_SPP_PredictionData00 as Data00
left outer join P_SPP_PredictionData05A2 as Data05A2
  on Data00.YearMonth = Data05A2.YearMonth
    and Data00.PartOfMonth = Data05A2.PartOfMonth
    and Data00.SalesOrganization = Data05A2.SalesOrganization
    and Data00.DistributionChannel = Data05A2.DistributionChannel
    and Data00.Division = Data05A2.Division
    and Data00.SoldToParty = Data05A2.SoldToParty
    and Data00.CustomerGroup = Data05A2.CustomerGroup
    and Data00.Material = Data05A2.Material
    and Data00.MaterialGroup = Data05A2.MaterialGroup
    and Data00.BillingDocumentType = Data05A2.BillingDocumentType
left outer join I_Customer as C
  on Data00.SoldToParty = C.Customer
left outer join I_Product as P
  on Data00.Material = P.Product
left outer join I_SalesOrganization as SO
  on Data00.SalesOrganization = SO.SalesOrganization
{
  key Data00.YearMonth,
  key Data00.PartOfMonth,
  key Data00.SalesOrganization,
  key Data00.DistributionChannel,
  key Data00.Division,
  key Data00.SoldToParty,
  key Data00.CustomerGroup,
  key Data00.Material,
  key Data00.MaterialGroup,
  key Data00.BillingDocumentType,
  
  YearQuarter,
  PartOfQuarter,
  
  CalendarWeek,
  CalendarMonth,
  CalendarQuarter,
  
  Previous1YearMonth,
  Previous1YearQuarter,
 
  CustomerClassification,
  CustomerAccountGroup,
  IsOneTimeAccount,
  IsBusinessPurposeCompleted,
  Industry,
  Country,
  CityName,
  ProductType,
  CompanyCode,
  
  CntByPOM,
  SumAmtByPOM,
  MaxAmtByPOM,
  MinAmtByPOM
}