P_PROJECTCOSTSUM

CDS View

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

Used by 2 CDS view(s) 1 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PPM_ProjectCostForecastData view left_outer COMPOSITE Project Cost Forecast: ML Training Input
I_PPM_ProjectCostForecastTrng view from COMPOSITE Project Cost Forecast: ML Training Input

Fields (1)

KeyField CDS FieldsUsed in Views
KEY ProjectInternalID ProjectInternalID 1 
@AbapCatalog.sqlViewName: 'PPROCSTSUM'
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED

@ClientHandling: {
  type:      #CLIENT_DEPENDENT,
  algorithm: #SESSION_VARIABLE
}

@ObjectModel: {
  usageType:{ sizeCategory: #XXL,
              dataClass:    #MIXED,
              serviceQuality: #D    }
}

define view P_ProjectCostSum as select from P_EnterpriseProjectCosts as costline
                                                           
{

     key costline.ProjectInternalID,     
     @DefaultAggregation: #SUM
     sum (costline.AmountInGlobalCurrency) as ActualAmountInGlobalCurrency 

} where costline.PlanningCategory = 'ACT01' and costline.ProjectInternalID <> '00000000' and IsSettled = 'X'
group by costline.ProjectInternalID

Learn More