C_CustomerProjectPlndActlData

DDL: C_CUSTOMERPROJECTPLNDACTLDATA SQL: CCPPLNDACTLDATA Type: view CONSUMPTION

Total Planned and Actual Data of Projects

C_CustomerProjectPlndActlData is a Consumption CDS View that provides data about "Total Planned and Actual Data of Projects" in SAP S/4HANA. It reads from 1 data source (P_EngmntProjPlanActual) and exposes 8 fields with key fields CustomerProjectUUID, CustomerProject. It has 1 association to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
P_EngmntProjPlanActual CustomerProject from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CustomerProject _CustomerProject $projection.CustomerProject = _CustomerProject.CustomerProject

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CCPPLNDACTLDATA view
EndUserText.label Total Planned and Actual Data of Projects view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CustomerProjectUUID P_EngmntProjPlanActual EngagementProjectUUID
KEY CustomerProject P_EngmntProjPlanActual EngagementProject
Currency P_EngmntProjPlanActual Currency
CustomerProjectPlannedCost
ActualCost
CustomerProjectPlannedRevenue
CustProjWrkPckgActualRevenue
_CustomerProject _CustomerProject 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CCPPLNDACTLDATA'
@EndUserText.label: 'Total Planned and Actual Data of Projects'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:  #MIXED
@AccessControl.authorizationCheck:#CHECK
@ObjectModel.usageType.serviceQuality: #D
@AccessControl: {
  personalData: {
    blocking: #NOT_REQUIRED
  }
}
define view C_CustomerProjectPlndActlData
  as select from P_EngmntProjPlanActual as CustomerProject


  association [0..1] to I_CustomerProject as _CustomerProject on $projection.CustomerProject = _CustomerProject.CustomerProject


{
  key CustomerProject.EngagementProjectUUID                          as CustomerProjectUUID,
  key CustomerProject.EngagementProject                              as CustomerProject,
  
      @Semantics.currencyCode: true
      CustomerProject.Currency,
      
      @Semantics.amount.currencyCode: 'Currency'
      sum(CustomerProject.PlndCostAmt)                               as CustomerProjectPlannedCost, 
        
      @Semantics.amount.currencyCode: 'Currency'  
      sum(CustomerProject.ActlCostAmt)                               as ActualCost,    
      
      @Semantics.amount.currencyCode: 'Currency'
      sum(CustomerProject.PlndRevnAmt)                               as CustomerProjectPlannedRevenue, 
      
      @Semantics.amount.currencyCode: 'Currency'    
      sum(CustomerProject.ActlRevnAmt)                               as CustProjWrkPckgActualRevenue,
      
      _CustomerProject
}
group by
  CustomerProject.EngagementProjectUUID,
  CustomerProject.Currency,
  CustomerProject.EngagementProject  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ENGMNTPROJPLANACTUAL"
],
"ASSOCIATED":
[
"I_CUSTOMERPROJECT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More