P_SPP_PREDICTIONDATA05A2

CDS View

Prediction Data0 5A2

P_SPP_PREDICTIONDATA05A2 is a CDS View in S/4HANA. Prediction Data0 5A2. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SPP_PredictionData06 view left_outer COMPOSITE Prediction Data 06 
@AbapCatalog.sqlViewName: 'PSDSPPPDA05A2'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE

define view P_SPP_PredictionData05A2
as select from P_SPP_PredictionData05A1
{
  key YearMonth,
  key PartOfMonth,
  
  key SalesOrganization,
  key DistributionChannel,
  key Division,
  key SoldToParty,
  key CustomerGroup,
  key Material,
  key MaterialGroup,
  key BillingDocumentType,
  
  count( * ) as CntByPOM,
  sum( Amount ) as SumAmtByPOM,
  max( Amount ) as MaxAmtByPOM,
  min( Amount ) as MinAmtByPOM
}
where PartOfMonth != 3
  and ( SalesOrganization is not null and SalesOrganization != '')
group by
  YearMonth,
  PartOfMonth,
  SalesOrganization,
  DistributionChannel,
  Division,
  SoldToParty,
  CustomerGroup,
  Material,
  MaterialGroup,
  BillingDocumentType

Learn More