P_SPP_TRAININGPERIOD
P_SPP_TRAININGPERIOD is a CDS View in S/4HANA. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_SPP_TrainingData01 | view | left_outer | COMPOSITE | |
| P_SPP_TrainingDate01 | view | left_outer | COMPOSITE |
@AbapCatalog.sqlViewName: 'PSDSPPTP'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_SPP_TrainingPeriod
as select from I_CalendarDate
{
key CalendarDate,
concat( left( dats_add_months( CalendarDate, -24, 'FAIL'), 6 ), '01') as TrainingStartDate,
concat( YearMonth, '01') as TrainingEndDate
}
where CalendarDate = $session.system_date
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/