P_SPP_PREDICTIONDATA00

CDS View

P_SPP_PREDICTIONDATA00 is a CDS View in S/4HANA. It contains 10 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 10 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SPP_PredictionData06 view from COMPOSITE

Fields (10)

KeyField CDS FieldsUsed 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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_SPP_PREDICTIONDATE02",
"P_SPP_PREDICTIONDIMENSION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More