P_SPP_TrainingData06

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

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