P_SPP_TrainingData05D

DDL: P_SPP_TRAININGDATA05D SQL: PSDSPPTDA05D Type: view COMPOSITE Package: VDM_SD_PREDICTED_SALES

Training Data 05D

P_SPP_TrainingData05D is a Composite CDS View that provides data about "Training Data 05D" in SAP S/4HANA. It reads from 1 data source (P_SPP_TrainingData04) and exposes 13 fields with key fields YearQuarter, SalesOrganization, DistributionChannel, Division, SoldToParty. Part of development package VDM_SD_PREDICTED_SALES.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
P_SPP_TrainingData04 P_SPP_TrainingData04 from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSDSPPTDA05D view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY YearQuarter YearQuarter
KEY SalesOrganization SalesOrganization
KEY DistributionChannel DistributionChannel
KEY Division Division
KEY SoldToParty SoldToParty
KEY CustomerGroup CustomerGroup
KEY Material Material
KEY MaterialGroup MaterialGroup
KEY BillingDocumentType BillingDocumentType
CntByQuarter
SumAmtByQuarter
MaxAmtByQuarter
MinAmtByQuarter 
@AbapCatalog.sqlViewName: 'PSDSPPTDA05D'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE

define view P_SPP_TrainingData05D
as select from P_SPP_TrainingData04
{
  key YearQuarter,
  
  key SalesOrganization,
  key DistributionChannel,
  key Division,
  key SoldToParty,
  key CustomerGroup,
  key Material,
  key MaterialGroup,
  key BillingDocumentType,
  
  count( * ) as CntByQuarter,
  sum( Amount ) as SumAmtByQuarter,
  max( Amount ) as MaxAmtByQuarter,
  min( Amount ) as MinAmtByQuarter
}
group by
  YearQuarter,
  SalesOrganization,
  DistributionChannel,
  Division,
  SoldToParty,
  CustomerGroup,
  Material,
  MaterialGroup,
  BillingDocumentType

Learn More