P_SPP_TRAININGDATE02
Training Date 02
P_SPP_TRAININGDATE02 is a CDS View in S/4HANA. Training Date 02. It contains 4 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_SPP_TrainingData05A1 | view | from | COMPOSITE | Training Data 05A1 |
| P_SPP_TrainingData05B1 | view | from | COMPOSITE | Training Data 05B1 |
| P_SPP_TrainingData06 | view | left_outer | COMPOSITE | Training Data 06 |
Fields (4)
| Key | Field | CDS Fields | Used 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