P_SPP_PREDICTIONDATA00
Prediction Data 00
P_SPP_PREDICTIONDATA00 is a CDS View in S/4HANA. Prediction Data 00. It contains 10 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_SPP_PredictionData06 | view | from | COMPOSITE | Prediction Data 06 |
Fields (10)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillingDocumentType | BillingDocumentType | 1 |
| KEY | CustomerGroup | CustomerGroup | 1 |
| KEY | DistributionChannel | DistributionChannel | 1 |
| KEY | Division | Division | 1 |
| KEY | Material | Material | 1 |
| KEY | MaterialGroup | MaterialGroup | 1 |
| KEY | PartOfMonth | PartOfMonth | 1 |
| KEY | SalesOrganization | SalesOrganization | 1 |
| KEY | SoldToParty | SoldToParty | 1 |
| KEY | YearMonth | YearMonth | 1 |
@AbapCatalog.sqlViewName: 'PSDSPPPDA00'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_SPP_PredictionData00
as select from P_SPP_PredictionDate02
left outer join P_SPP_PredictionDimension
on YearMonth = YearMonth
{
key YearMonth,
key PartOfMonth,
SalesOrganization,
DistributionChannel,
Division,
SoldToParty,
CustomerGroup,
Material,
MaterialGroup,
BillingDocumentType,
YearQuarter,
PartOfQuarter,
CalendarWeek,
CalendarMonth,
CalendarQuarter,
Previous1YearMonth,
Previous1YearQuarter
}
where ( YearMonth = CurrentYearMonth or YearMonth = NextYearMonth )
and PartOfMonth = CurrentPartOfMonth