P_ENGMNTPROJPLNDATAATTRIBUTES

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog:{
    sqlViewName: 'PEPPLNDTATT',
    compiler.compareFilter: true,
    preserveKey: true
}
@VDM: {
    viewType: #COMPOSITE,
    private: true,
    lifecycle.contract.type: #NONE
}
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: {
    usageType: {
        sizeCategory: #XL,
        serviceQuality: #C,
        dataClass: #MIXED
    }
}
@Metadata: {
    ignorePropagatedAnnotations: true
}
define view P_EngmntProjPlnDataAttributes
  as select from P_PlngDataAggrgnByDelivOrg as A
{
  key A.EngagementProject,
      A.EngagementProjectCategory,
      A.EngagementProjectType,
      A.EngagementProjectServiceOrg,
      A.EngagementProjFinPlanUUID,
      A.Customer,
      A.EngmntProjReviewYearPeriod,
      A.EngagementProjectReviewStatus,
      A.EngagementProjectStage,
      CurrentYearPeriod,
      A.WorkPackage,
      A.EngmtProjFinPlanVersion,
      A.WorkItem,

      A.Currency,
      A.EngagementProjectResource,
      A.EngagementProjectResourceType,
      A.BillingControlCategory,
      A.EngagementProjectServiceOrg                                                                                         as DemandServiceOrg,
      A.ResourceDemand                                                                                                      as ResourceDemand,
      case
      when                                                                                                                           //as EngmntProjectDeliveryOrg,

      EngmntProjectDeliveryOrg <> ''
      then EngmntProjectDeliveryOrg
      when DeliveryOrganization <> ''
      then DeliveryOrganization
      else ''
      end                                                                                                                   as EngmntProjectDeliveryOrg,

      cast ( cast ((SupplyCostAmt + RemainingDemandCostAmt + PlannedExpenseCost ) as abap.curr( 23, 2 )) as /cpd/pfp_curr ) as PlndCostAmt,

      case
      when A.IsUnitBased <> 'X' then
      cast ( cast ((SupplyEffortQty + RemainingDemandEffortQty )  as abap.quan( 15, 3 ) ) as megxxx)
      else
      //Populate Unit Quantity of Unit Based Work Package as Planned Effort Quantity

      A.PlndEffortQty
      end                                                                                                                   as PlndEffortQty,


      case
      when A.IsUnitBased <> 'X' then
      cast ( cast ((SupplyRevnAmt  + RemainingDemandRevnAmt + PlannedExpenseRevenue )     as abap.curr( 23, 2 )) as /cpd/pfp_curr )
      else
      //Populate Revenue of the Unit Work Package as Planned Revenue Amount

      A.PlndRevnAmt
      end                                                                                                                   as PlndRevnAmt,


      case
      when A.IsUnitBased <> 'X' then
      A.PlndEffortQty
      end                                                                                                                   as DemandEffortQty,

      A.PlndCostAmt                                                                                                         as DemandCostAmt,

      A.PlndRevnAmt                                                                                                         as DemandRevAmt,

      A.ActualPlanDeviationCost                                                                                             as ActualPlanDeviationCost,

      A.ActualPlanDeviationEffort                                                                                           as ActualPlanDeviationEffort,

      SupplyEffortQty,
      A.FiscalYear,
      A.FiscalPeriod,
      concat (A.FiscalYear,A.FiscalPeriod)                                                                                  as FiscalYearPeriod,
      //A.EngmntProjReviewYearPeriod,

      A.UnitOfMeasure                                                                                                       as UnitOfMeasure,
      IsUnitBased,
      A.IsMyProject,
      A.ProjectManager,
      A.ProjectManagerName,
      A.ProjectManagerExternalID,
      A.ProjectAccountant,
      A.ProjectAccountantName,
      A.ProjectAccountantExternalID,
      A.ProjectController,
      A.ProjectControllerName,
      A.ProjectControllerExternalID,
      A.Projectpartner,
      A.ProjectPartnerName,
      A.ProjectPartnerExternalID,
      A.ProjectVisibility,
      A.ProjectProfileCode,      
      A.EngmntProjectHeaderCompanyCode,
      A.EngagementProjectCostCenter,
      A.ProfitCenter
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PLNGDATAAGGRGNBYDELIVORG"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/