P_SI4_TRAININGDATA09

CDS View

Sales Performance Prediction

P_SI4_TRAININGDATA09 is a CDS View in S/4HANA. Sales Performance Prediction. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SI4_TrainingData10 view from COMPOSITE Sales Performance Prediction

Fields (2)

KeyField CDS FieldsUsed in Views
KEY Division Division 1
KEY SalesOrganization SalesOrganization 1 
@AbapCatalog.sqlViewName: 'PSDSI4TD09'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE

define view P_SI4_TrainingData09
as select from P_SI4_TrainingData08 as TD8
left outer join P_SI4_TrainingData04B as TD4B
 on TD8.Previous1YearQuarter = TD4B.YearQuarter
  and TD8.SoldToParty = TD4B.SoldToParty
  and TD8.SalesOrganization = TD4B.SalesOrganization
  and TD8.DistributionChannel = TD4B.DistributionChannel
  and TD8.Division = TD4B.Division
  and TD8.Material = TD4B.Material
  and TD8.MaterialGroup = TD4B.MaterialGroup
  and TD8.CustomerGroup = TD4B.CustomerGroup
{
  key TD8.YearMonth,
  key TD8.PartOfMonth,
  key TD8.SoldToParty,
  key TD8.SalesOrganization,
  key TD8.DistributionChannel,
  key TD8.Division,
  key TD8.Material,
  key TD8.MaterialGroup,
  key TD8.CustomerGroup,

  TD8.YearQuarter,
  TD8.PartOfQuarter,
  
  TD8.CalendarYear,
  TD8.CalendarQuarter,
  TD8.CalendarMonth,
  TD8.CalendarWeek,
  
  TD8.Previous1YearQuarter,
  TD8.Previous1YearMonth,
  
  TD8.TargetAmount,
  
  TD8.CntByPOM,
  TD8.SumAmtByPOM,
  TD8.MaxAmtByPOM,
  TD8.MinAmtByPOM,

  TD8.CntByPOQ,
  TD8.SumAmtByPOQ,
  TD8.MaxAmtByPOQ,
  TD8.MinAmtByPOQ,

  TD8.CntByPre1Month,
  TD8.SumAmtByPre1Month,
  TD8.MaxAmtByPre1Month,
  TD8.MinAmtByPre1Month,

  TD4B.Cnt as CntByPre1Quarter,
  TD4B.SumAmt as SumAmtByPre1Quarter,
  TD4B.MaxAmt as MaxAmtByPre1Quarter,
  TD4B.MinAmt as MinAmtByPre1Quarter
}

Learn More