P_EngmntProjPlanDataByRscre

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog:{
    sqlViewName: 'PPEPLNDTBYRSC',
    compiler.compareFilter: true,
    preserveKey: true
}
@VDM: {
    viewType: #COMPOSITE,
    private: true,
    lifecycle.contract.type: #NONE
}
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: {
    usageType: {
        sizeCategory: #XL,
        serviceQuality: #C,
        dataClass: #MASTER
    }
}
@Metadata: {
    ignorePropagatedAnnotations: true
}

define view P_EngmntProjPlanDataByRscre
  as select from P_EngmntProjPlnDataAttributes 
       inner join I_Ledger as Ledger on Ledger.IsLeadingLedger = 'X'
{
  //P_EngmntProjPlnDataAttributes

  EngagementProject,
  EngagementProjectCategory,
  EngagementProjectType,
  EngagementProjectServiceOrg,
  Customer,
  EngagementProjFinPlanUUID,
  EngmntProjReviewYearPeriod,
  EngagementProjectReviewStatus, 
  EngagementProjectStage,
  CurrentYearPeriod,
  WorkPackage,
  EngmtProjFinPlanVersion,
  WorkItem,
  @Semantics.currencyCode: true
  Currency,
  EngagementProjectResource,
  EngagementProjectResourceType,
  EngmntProjectDeliveryOrg,
  @Semantics.unitOfMeasure: true
  UnitOfMeasure,
  IsMyProject,
  ProjectManager,
  ProjectManagerExternalID,
  ProjectAccountantExternalID,
  ProjectControllerExternalID,
  ProjectPartnerExternalID,

  @Semantics.amount.currencyCode: 'Currency'
  sum(PlndCostAmt)               as PlndCostAmt,
  @Semantics.amount.currencyCode: 'Currency'
  sum(PlndRevnAmt)               as PlndRevnAmt,
  @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
  sum(PlndEffortQty)             as PlndEffortQty,
  
  Ledger.Ledger as Ledger,
  ProjectVisibility,
  ProjectProfileCode,      
  EngmntProjectHeaderCompanyCode,
  EngagementProjectCostCenter,
  ProfitCenter 
  
} where EngmtProjFinPlanVersion = '1'
group by
  EngagementProject,
  EngagementProjectCategory,
  EngagementProjectType,
  EngagementProjectServiceOrg,
  Customer,
  EngagementProjFinPlanUUID,
  EngmntProjReviewYearPeriod,
  EngagementProjectReviewStatus,  
  EngagementProjectStage,
  CurrentYearPeriod,
  WorkPackage,
  EngmtProjFinPlanVersion,
  WorkItem,
  Currency,
  EngagementProjectResource,
  EngagementProjectResourceType,
  EngmntProjectDeliveryOrg,
  UnitOfMeasure,
  IsMyProject,
  ProjectManager,
  ProjectManagerExternalID,
  ProjectAccountantExternalID,
  ProjectControllerExternalID,
  ProjectPartnerExternalID,
  Ledger.Ledger,
  ProjectVisibility,
  ProjectProfileCode,      
  EngmntProjectHeaderCompanyCode,
  EngagementProjectCostCenter,
  ProfitCenter 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGER",
"P_ENGMNTPROJPLNDATAATTRIBUTES"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/