P_SPP_TRAININGDATE02

CDS View

P_SPP_TRAININGDATE02 is a CDS View in S/4HANA. It contains 4 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 4 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_SPP_TrainingData05A1 view from COMPOSITE
P_SPP_TrainingData05B1 view from COMPOSITE
P_SPP_TrainingData06 view left_outer COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY PartOfMonth PartOfMonth 1
KEY PartOfQuarter PartOfQuarter 1
KEY YearMonth YearMonth 1
KEY YearQuarter YearQuarter 1 
@AbapCatalog.sqlViewName: 'PSDSPPTD02'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE

define view P_SPP_TrainingDate02
as select from P_SPP_TrainingDate01
{
  key YearMonth,
  key PartOfMonth,
  
  YearQuarter,
  PartOfQuarter,
  
  cast( min( CalendarWeek ) as calendarweek ) as CalendarWeek,
  CalendarMonth,
  CalendarQuarter,
  
  Previous1YearMonth,
  Previous1YearQuarter
}
group by
  YearMonth,
  PartOfMonth,
  YearQuarter,
  PartOfQuarter,
  CalendarMonth,
  CalendarQuarter,
  Previous1YearMonth,
  Previous1YearQuarter
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_SPP_TRAININGDATE01"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More