I_PROJECTTOWBSELEMENTCOUNT

CDS View

Number of WBS Elements per Project

I_PROJECTTOWBSELEMENTCOUNT is a CDS View in S/4HANA. Number of WBS Elements per Project. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PPM_ProjectCostForecastData view left_outer COMPOSITE Project Cost Forecast: ML Training Input
I_PPM_ProjectCostForecastTrng view left_outer COMPOSITE Project Cost Forecast: ML Training Input
@AbapCatalog.sqlViewName: 'IPROWBSCNT'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Number of WBS Elements per Project'
@ClientHandling: {
  type:      #CLIENT_DEPENDENT,
  algorithm: #SESSION_VARIABLE
}

@ObjectModel: {
  usageType:{ sizeCategory: #L,
              dataClass:    #MIXED,
              serviceQuality: #D    }
}
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

define view I_ProjectToWBSElementCount as select from I_WBSElementBasicData as wbs
{
     key wbs.ProjectInternalID,
     cast( count (*) as int2 ) as NumberOfWBSElements

} group by wbs.ProjectInternalID


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WBSELEMENTBASICDATA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/