P_SPP_TrainingData05C

DDL: P_SPP_TRAININGDATA05C SQL: PSDSPPTDA05C Type: view COMPOSITE

P_SPP_TrainingData05C is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_SPP_TrainingData04) and exposes 13 fields with key fields YearMonth, SalesOrganization, DistributionChannel, Division, SoldToParty.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
P_SPP_TrainingData04 P_SPP_TrainingData04 from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSDSPPTDA05C 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 YearMonth YearMonth
KEY SalesOrganization SalesOrganization
KEY DistributionChannel DistributionChannel
KEY Division Division
KEY SoldToParty SoldToParty
KEY CustomerGroup CustomerGroup
KEY Material Material
KEY MaterialGroup MaterialGroup
KEY BillingDocumentType BillingDocumentType
CntByMonth
SumAmtByMonth
MaxAmtByMonth
MinAmtByMonth 
@AbapCatalog.sqlViewName: 'PSDSPPTDA05C'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE

define view P_SPP_TrainingData05C
as select from P_SPP_TrainingData04
{
  key YearMonth,
  
  key SalesOrganization,
  key DistributionChannel,
  key Division,
  key SoldToParty,
  key CustomerGroup,
  key Material,
  key MaterialGroup,
  key BillingDocumentType,
  
  count( * ) as CntByMonth,
  sum( Amount ) as SumAmtByMonth,
  max( Amount ) as MaxAmtByMonth,
  min( Amount ) as MinAmtByMonth
}
group by
  YearMonth,
  SalesOrganization,
  DistributionChannel,
  Division,
  SoldToParty,
  CustomerGroup,
  Material,
  MaterialGroup,
  BillingDocumentType
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_SPP_TRAININGDATA04"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More