P_ProjectPredictionDateCalc

DDL: P_PROJECTPREDICTIONDATECALC SQL: PPREDDTECALC Type: view COMPOSITE

P_ProjectPredictionDateCalc is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_ProjPredictionDteCalcintmd) and exposes 5 fields with key field ProjectInternalID.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
P_ProjPredictionDteCalcintmd P_ProjPredictionDteCalcintmd from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPREDDTECALC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ProjectInternalID ProjectInternalID
Project Project
PredictedAmtInGlobalCurrency
UpperPredictionAmtInGlobCrcy
LowerPredictionAmtInGlobCrcy 
@AbapCatalog.sqlViewName: 'PPREDDTECALC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType:#COMPOSITE
@VDM.private: true
@AbapCatalog.preserveKey:true
@ObjectModel: {usageType: {
       serviceQuality:  #C,
       dataClass:       #MIXED,
       sizeCategory:    #S
   }
 }

define view P_ProjectPredictionDateCalc
  as select from P_ProjPredictionDteCalcintmd
{
  key ProjectInternalID,
      Project,
      //  PlanningCategory,

      sum( PredictedAmtInGlobalCurrency ) as PredictedAmtInGlobalCurrency,
      sum( UpperPredictionAmtInGlobCrcy ) as UpperPredictionAmtInGlobCrcy,
      sum( LowerPredictionAmtInGlobCrcy ) as LowerPredictionAmtInGlobCrcy
      //  GlobalCurrency,

      //  PostingDate   as PredictedCostPostingDate,

      //  CreationDate  as PredictedCostCreationDate

}
group by
  Project,
  ProjectInternalID

Learn More