P_EngmntProjReviewData

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog: {
    sqlViewName: 'PEPREVIEWDATA',
    compiler.compareFilter: true,
    preserveKey: true
}
@AccessControl: {
    authorizationCheck: #NOT_REQUIRED,
    personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@ObjectModel: {
    usageType.serviceQuality: #D,
    usageType.sizeCategory: #XXL,
    usageType.dataClass: #MIXED
}

@VDM: {
    private: true,
    viewType: #COMPOSITE,
    lifecycle.contract.type: #NONE
}
@Metadata.ignorePropagatedAnnotations: true
define view P_EngmntProjReviewData
  with parameters
    //    @Consumption.hidden: true

    @Environment.systemField: #SYSTEM_DATE
    P_Date             : sydatum,

    @Consumption.hidden: true
    @Consumption.derivation: { lookupEntity: 'I_FiscalCalendarDate',
                                  resultElement: 'FiscalYearPeriod',
                                  binding:      [ { targetElement : 'CalendarDate'      , type : #PARAMETER ,  value : 'P_Date' } ,
                                                  { targetElement : 'FiscalYearVariant' , type : #CONSTANT  ,  value : 'K4'     } ]
                                 }
    P_FiscalYearPeriod : fis_jahrper
  as select from           I_EngagementProject           as EngagementProject

    inner join             I_EngagementProjFinancialPlan as EngagementProjFinancialPlan on EngagementProject.EngagementProjectUUID = EngagementProjFinancialPlan.EngagementProjectUUID
  //                                                                                        and EngagementProject.EngagementProjectCategory = 'C'

  //                                                                                        and EngagementProject.EngagementProjectStage    = 'P003'


    left outer join        I_WorkPackageAll              as WorkPackage                 on EngagementProjFinancialPlan.EngagementProjFinPlanUUID = WorkPackage.EngagementProjFinPlanUUID

    inner join             P_EngmntProjPlnActlWithFrcst1 as ProjectReview               on  ProjectReview.EngagementProject = EngagementProject.EngagementProject
                                                                                        and ProjectReview.WorkPackage       = WorkPackage.WorkPackage

    left outer to one join I_FiscalYearPeriod            as FiscalYearPeriod            on  EngagementProjFinancialPlan.EngmntProjReviewYearPeriod = FiscalYearPeriod.FiscalYearPeriod
                                                                                        and FiscalYearPeriod.FiscalYearVariant                     = 'K4'


    left outer join        I_SalesDocumentItemBasic      as SalesOrderItem              on  WorkPackage.SalesOrderItem = SalesOrderItem.SalesDocumentItem
                                                                                        and WorkPackage.SalesOrder     = SalesOrderItem.SalesDocument

{
  cast(ProjectReview.EngagementProject as /cpd/project preserving type )                   as EngagementProject,

  EngagementProject.EngagementProjectUUID,

  EngagementProject.ProjectStartDate                                                       as ProjectStartDate,

  EngagementProject.ProjectEndDate                                                         as ProjectEndDate,

  EngagementProject.ProjectVisibility,

  ProjectReview.Customer                                                                   as Customer,

  EngagementProject._Customer.BPCustomerName                                               as CustomerName,
  EngagementProject._Customer.AddressID,
  EngagementProject._Customer.IsBusinessPurposeCompleted,

  ProjectReview.EngagementProjectStage                                                     as EngagementProjectStage,

  ProjectReview.EngagementProjectCategory                                                  as EngagementProjectCategory,

  ProjectReview.EngagementProjectServiceOrg                                                as EngagementProjectServiceOrg,

  ProjectReview.EngagementProjectType                                                      as EngagementProjectType,

  cast( EngagementProject.LastChangeDateTime as /cpd/sc_changedon )                        as ProjectLastChangedDateTime,

  EngagementProjFinancialPlan.EngagementProjFinPlanUUID,

  cast('1' as abap.char(1))                                                                as EngmtProjFinPlanVersion,

  ProjectReview.EngmntProjReviewYearPeriod,

  ProjectReview.EngagementProjectReviewStatus,

  FiscalYearPeriod.FiscalYearVariant                                                       as FiscalYearVariant,

  cast(FiscalYearPeriod.FiscalYear   as /cpd/review_year  preserving type )                as EngmntProjReviewYear,

  cast(FiscalYearPeriod.FiscalPeriod  as /cpd/review_period preserving type )              as EngmntProjReviewPeriod,


  WorkPackage.SalesOrder,

  WorkPackage.SalesOrderItem,

  SalesOrderItem.SalesDocumentItemCategory,

  SalesOrderItem.SalesDocumentItemText,

  SalesOrderItem.TransactionCurrency,



  cast (WorkPackage.WorkPackage as /cpd/workpackage)                                       as WorkPackage,

  cast(ProjectReview.WorkItem as  /cpd/workitem )                                          as WorkItem,

  WorkPackage.WorkPackageName                                                              as WorkPackageName,

  ''                                                                                       as WBSElementIsBillingElement,

  WorkPackage.WorkPackageType,

  WorkPackage.WorkPackageStartDate                                                         as WorkPackageStartDate,

  WorkPackage.WorkPackageEndDate                                                           as WorkPackageEndDate,

  WorkPackage.IsDeleted,

  IsUnitBased,

  ResourceIsOfUnitWorkPackage,

  ProjectReview.EngmntProjectDeliveryOrg                                                   as EngmntProjectDeliveryOrg,

  ProjectReview.EngagementProjectResourceType                                              as EngagementProjectResourceType,

  cast (ProjectReview.EngagementProjectResource as /cpd/resource)                          as EngagementProjectResource,


  ProjectReview.Currency                                                                   as Currency,
  ProjectReview.UnitOfMeasure                                                              as UnitOfMeasure,


  cast(0 as netwr_ap)                                                                      as TotalNetAmount,


  cast(ProjectReview.ActlEffortQty as /cpd/actual_effort)                                  as ActlEffortQty,

  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  ActlEffortQtyUpToRevPerd
  else  ActualEffortUpToCurPerd
  end                                                                                      as ActualEffortUpToFsclYrPerd,
  ActualEffortUpToCurPerd,
  ActlEffortQtyUpToRevPerd,


  ActualUnitQty,
  ActlUnitQtyUpToCurPerd                                                                   as ActlUnitUpToCurPerdQty,
  ActlUnitQtyUpToRevPerd                                                                   as ActlUnitUpToRevPerdQty,
  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  ActlUnitQtyUpToRevPerd
  else  ActlUnitQtyUpToCurPerd
  end                                                                                      as ActlUnitUpToFsclPerdQty,

  AddlResourceActualQuantity,
  AddlRsceUpToCurPerdActlQty,
  AddlRsceUpToRevPerdActlQty,
  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  AddlRsceUpToRevPerdActlQty
  else AddlRsceUpToCurPerdActlQty
  end                                                                                      as AddlRsceUpToFsclPerdActlQty,



  cast(ProjectReview.ActlCostAmt as /cpd/actual_cost preserving type )                     as ActlCostAmt,
  ActualCostUpToCurPerd,
  ActlCostAmtUpToRevPerd,
  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  ActlCostAmtUpToRevPerd
  else ActualCostUpToCurPerd
  end                                                                                      as ActualCostUpToFsclYrPerd,

  ActlCostInCoCodeCrcy,


  ActualExpenseCost,
  ActlExpCostUpToCurPerd,
  ActlExpenseCostUpToRevPerd,

  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  ActlExpenseCostUpToRevPerd
  else
  ActlExpCostUpToCurPerd
  end                                                                                      as ActlExpenseCostUpToFsclYrPerd,
  //Plan Details - Current Version

  ProjectReview.PlanUnitQuantity,
  SupplyEffortQty,
  cast(ProjectReview.PlndEffortQty  as   /cpd/planned_effort preserving type )             as PlndEffortQty,
  PlndEffortQtyUpToRevPerd,
  PlndEffortUpToCurPerd,

  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  PlndEffortQtyUpToRevPerd
  else PlndEffortUpToCurPerd
  end                                                                                      as PlndEffortUpToFsclYrPerd,

  cast(ProjectReview.ActualPlanDeviationEffort as  /cpd/effort_deviation preserving type ) as ActualPlanDeviationEffort,

  AddlResourcePlannedQuantity,
  AddlRsceActlPlanDeviationQty,
  AdjustedOthRscePlndQty,


  cast(ProjectReview.PlndCostAmt    as /cpd/plan_cost preserving type )                    as PlndCostAmt,
  cast(ProjectReview.ActualPlanDeviationCost as /cpd/cost_deviation preserving type )      as ActualPlanDeviationCost,


  PlannedEffortCostAmt,
  PlannedCostUpToCurPerd,
  PlndCostAmtUpToRevPerd,
  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  PlndCostAmtUpToRevPerd
  else PlannedCostUpToCurPerd
  end                                                                                      as PlannedCostUpToFsclYrPerd,

  AddlResourcePlannedCostAmount,

  cast(ProjectReview.PlndRevnAmt  as /cpd/plan_revenue preserving type )                   as PlndRevnAmt,
  PlndRevnAmtUpToRevPerd,
  PlannedRevnUpToCurPerd,
  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  PlndRevnAmtUpToRevPerd
  else PlannedRevnUpToCurPerd
  end                                                                                      as PlannedRevnUpToFsclYrPerd,

  PlannedExpenseCost,
  PlndExpenseCostUpToRevPerd,
  PlndExpCostUpToCurPerd,

  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  PlndExpenseCostUpToRevPerd
  else
  PlndExpCostUpToCurPerd
  end                                                                                      as PlndExpenseCostUpToFsclYrPerd,
  ActualPlanDeviationExpnCost,

  // PlannedCostRate,


  //Plan Details - Base Line


  BaselinePlndEffortQty,
  BaselinePlannedQuantity,


  BaselinePlndCostAmt,
  BaselinePlndRevnAmt,

  AdjustedRemainingEffort,
  AdjustedRemngEffortToFsclPerd,

  AdjustedRemainingEffortCost,
  AdjstdRemngEffortCstToFsclPerd,
  AdjustedRemainingExpnCost,


  AdjustedRemainingCostPlnAmt,

  AddlRsceEstToCmpltQty,

  AddlRsceEstToCmpltCostAmount,

  EstToCmpltCostUpToCurPerd,
  EstToCmpltCostUpToRevPerd,
  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  ProjectReview.EstToCmpltCostUpToRevPerd
  else
  ProjectReview.EstToCmpltCostUpToCurPerd
  end                                                                                      as EstToCmpltUpToFsclPerdAmt,


  AddlRsceEtcUpToCurPerdQty,
  AddlRsceEtcUpToRevPerdQty,
  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  ProjectReview.AddlRsceEtcUpToRevPerdQty
  else
  ProjectReview.AddlRsceEtcUpToCurPerdQty
  end                                                                                      as AddlRsceEstToCmpltUpToFsclQty,

  AddlRsceEtcCostUpToRevPerdAmt,
  AddlRsceEtcCostUpToCurPerdAmt,

  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  ProjectReview.AddlRsceEtcCostUpToRevPerdAmt
  else
  ProjectReview.AddlRsceEtcCostUpToCurPerdAmt
  end                                                                                      as AddlRsceEstToCmpltUpToFsclAmt,

  EstToCmpltEffortUpToRevPerd,
  EstToCmpltEffortUpToCurPerd,
  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  ProjectReview.EstToCmpltEffortUpToRevPerd
  else
  ProjectReview.EstToCmpltEffortUpToCurPerd
  end                                                                                      as EstToCmpltUpToFsclPerdQty,

  EstToCmpltEffCostUpToCurPerd,
  EstToCmpltEffCostUpToRevPerd,

  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  ProjectReview.EstToCmpltEffCostUpToRevPerd
  else
  ProjectReview.EstToCmpltEffCostUpToCurPerd
  end                                                                                      as EstToCmpltEffUpToFsclPerdAmt,

  EstToCmpltExpnCostUpToCurPerd,
  EstToCmpltExpnCostUpToRevPerd,

  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  ProjectReview.EstToCmpltExpnCostUpToRevPerd
  else
  ProjectReview.EstToCmpltExpnCostUpToCurPerd
  end                                                                                      as EstToCmpltExpnUpToFsclPerdAmt,


  EstimateAtCompletionCost,
  EstAtCompltnCostUpToCurPerd,
  EstAtCompltnCostUpToRevPerd,
  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  ProjectReview.EstAtCompltnCostUpToRevPerd
  else
  ProjectReview.EstAtCompltnCostUpToCurPerd
  end                                                                                      as EstAtCompltnUpToFsclPerdAmt,

  EstAtCompltnEffortUpToCurPerd,
  EstAtCompltnEffortUpToRevPerd,
  EstimateAtCompletionEffort,
  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  ProjectReview.EstAtCompltnEffortUpToRevPerd
  else
  ProjectReview.EstAtCompltnEffortUpToCurPerd
  end                                                                                      as EstAtCmpltUpToFsclPerdQty,

  AddlRsceEstAtCompltnQty,

  EstimateAtCompletionExpnCost,
  EstAtCmpltExpnCostUpToCurPerd                                                            as EstAtCmpltExpnUpToCurPerdAmt,
  EstAtCmpltExpnCostUpToRevPerd                                                            as EstAtCmpltExpnUpToRevPerdAmt,

  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  ProjectReview.EstAtCmpltExpnCostUpToRevPerd
  else
  ProjectReview.EstAtCmpltExpnCostUpToCurPerd
  end                                                                                      as EstAtCmpltExpnUpToFsclPerdAmt,

  DerivedEstAtCompltnCostUpToCur,
  DerivedEstAtCompltnCostUpToRev,

  case when ProjectReview.EngmntProjReviewYearPeriod = :P_FiscalYearPeriod
  then
  ProjectReview.DerivedEstAtCompltnCostUpToRev
  else
  ProjectReview.DerivedEstAtCompltnCostUpToCur
  end                                                                                      as DerivdEstAtCompltnUpToFsclAmt,

  CompltnRateInPctUpToCurPerd,
  CompltnRateInPctUpToRevPerd,

  PlndMarginPct,

  // Filter Push Down Characterstics

  ProjectReview.IsMyProject,
  ProjectManagerExternalID,
  ProjectAccountantExternalID,
  ProjectControllerExternalID,
  ProjectPartnerExternalID                                                                 as ProjectPartnerExternalID,
  ProjectReview.ProjectManager,
  ProjectAccountant,
  ProjectController,
  Projectpartner                                                                           as ProjectPartner,
  ProjectManagerName,
  ProjectAccountantName,
  ProjectControllerName,
  ProjectPartnerName                                                                       as ProjectPartnerName,
  ProjectReview.Ledger                                                                     as Ledger,
  ProjectReview.ProjectProfileCode,
  ProjectReview.EngmntProjectHeaderCompanyCode,
  ProjectReview.EngagementProjectCostCenter,
  ProjectReview.ProfitCenter
}
union all select from    I_EngmntProjAssgmtToSessionUsr as EngagementProject

  inner join             I_EngagementProjectItem        as B                on  EngagementProject.EngagementProject = B.EngagementProject
                                                                            and B.EngagementProjectItemType         = '0SOH'

  left outer join        I_Customer                     as Customer         on EngagementProject.Customer = Customer.Customer
//  left outer join        I_WorkPackageAll          as WorkPackage      on EngagementProject.EngagementProjFinPlanUUID = WorkPackage.EngagementProjFinPlanUUID


  left outer to one join I_FiscalYearPeriod             as FiscalYearPeriod on  EngagementProject.EngmntProjReviewYearPeriod = FiscalYearPeriod.FiscalYearPeriod
                                                                            and FiscalYearPeriod.FiscalYearVariant           = 'K4'


  left outer join        I_SalesDocumentItemBasic       as SalesOrderItem   on  B.EngagementProjectItem = SalesOrderItem.SalesDocument
                                                                            and SalesOrderItem.SalesDocumentRjcnReason is initial //Exclude rejected SO Items from "Revenue Sold"

                                                                                                                          
  left outer join        I_WBSElementBasicData          as WBSElement       on SalesOrderItem.WBSElement = WBSElement.WBSElementInternalID

  inner join             I_Ledger                       as Ledger           on Ledger.IsLeadingLedger = 'X'

{
  cast(EngagementProject.EngagementProject as /cpd/project preserving type )  as EngagementProject,

  EngagementProject.EngagementProjectUUID,

  EngagementProject.ProjectStartDate                                          as ProjectStartDate,

  EngagementProject.ProjectEndDate                                            as ProjectEndDate,

  //  EngagementProject.EngagementProjectName,


  EngagementProject.ProjectVisibility,

  EngagementProject.Customer                                                  as Customer,

  Customer.BPCustomerName                                                     as CustomerName,
  Customer.AddressID,
  Customer.IsBusinessPurposeCompleted,

  EngagementProject.EngagementProjectStage                                    as EngagementProjectStage,

  EngagementProject.EngagementProjectCategory                                 as EngagementProjectCategory,

  EngagementProject.EngagementProjectServiceOrg                               as EngagementProjectServiceOrg,

  EngagementProject.EngagementProjectType                                     as EngagementProjectType,

  cast( EngagementProject.LastChangeDateTime as /cpd/sc_changedon )           as ProjectLastChangedDateTime,

  EngagementProject.EngagementProjFinPlanUUID,

  cast('1' as abap.char(1))                                                   as EngmtProjFinPlanVersion,

  EngagementProject.EngmntProjReviewYearPeriod,

  EngagementProject.EngagementProjectReviewStatus,

  FiscalYearPeriod.FiscalYearVariant                                          as FiscalYearVariant,

  cast(FiscalYearPeriod.FiscalYear   as /cpd/review_year  preserving type )   as EngmntProjReviewYear,

  cast(FiscalYearPeriod.FiscalPeriod  as /cpd/review_period preserving type ) as EngmntProjReviewPeriod,


  SalesOrderItem.SalesDocument                                                as SalesOrder,

  SalesOrderItem.SalesDocumentItem                                            as SalesOrderItem,

  SalesOrderItem.SalesDocumentItemCategory,

  SalesOrderItem.SalesDocumentItemText,

  SalesOrderItem.TransactionCurrency,



  cast ( WBSElement.WBSElement as /cpd/workpackage)                           as WorkPackage,

  cast('' as  /cpd/workitem )                                                 as WorkItem,

  WBSElement.WBSDescription                                                   as WorkPackageName,

  'X'                                                                         as WBSElementIsBillingElement,

  ''                                                                          as WorkPackageType,

  ''                                                                          as WorkPackageStartDate,

  ''                                                                          as WorkPackageEndDate,

  ''                                                                          as IsDeleted,

  // ''                                                                          as WorkPackageUnit,


  ''                                                                          as IsUnitBased,

  0                                                                           as ResourceIsOfUnitWorkPackage,

  ''                                                                          as EngmntProjectDeliveryOrg,

  ''                                                                          as EngagementProjectResourceType,

  ''                                                                          as EngagementProjectResource,


  EngagementProject.Currency                                                  as Currency,

  cast('' as co_meinh)                                                        as UnitOfMeasure,


  SalesOrderItem.NetAmount                                                    as TotalNetAmount,


  0                                                                           as ActlEffortQty,
  0                                                                           as ActualEffortUpToFsclYrPerd,
  0                                                                           as ActualEffortUpToCurPerd,
  0                                                                           as ActlEffortQtyUpToRevPerd,


  0                                                                           as ActualUnitQty,
  0                                                                           as ActlUnitUpToCurPerdQty,
  0                                                                           as ActlUnitUpToRevPerdQty,
  0                                                                           as ActlUnitUpToFsclPerdQty,

  0                                                                           as AddlResourceActualQuantity,
  0                                                                           as AddlRsceUpToCurPerdActlQty,
  0                                                                           as AddlRsceUpToRevPerdActlQty,
  0                                                                           as AddlRsceUpToFsclPerdActlQty,


  0                                                                           as ActlCostAmt,
  0                                                                           as ActualCostUpToCurPerd,
  0                                                                           as ActlCostAmtUpToRevPerd,
  0                                                                           as ActualCostUpToFsclYrPerd,

  0                                                                           as ActlCostInCoCodeCrcy,


  0                                                                           as ActualExpenseCost,
  0                                                                           as ActlExpCostUpToCurPerd,
  0                                                                           as ActlExpenseCostUpToRevPerd,
  0                                                                           as ActlExpenseCostUpToFsclYrPerd,

  //Plan Details - Current Version

  0                                                                           as PlanUnitQuantity,
  0                                                                           as SupplyEffortQty,
  0                                                                           as PlndEffortQty,
  0                                                                           as PlndEffortQtyUpToRevPerd,
  0                                                                           as PlndEffortUpToCurPerd,
  0                                                                           as PlndEffortUpToFsclYrPerd,
  0                                                                           as ActualPlanDeviationEffort,

  0                                                                           as AddlResourcePlannedQuantity,
  0                                                                           as AddlRsceActlPlanDeviationQty,
  0                                                                           as AdjustedOthRscePlndQty,


  0                                                                           as PlndCostAmt,
  0                                                                           as ActualPlanDeviationCost,


  0                                                                           as PlannedEffortCostAmt,
  0                                                                           as PlannedCostUpToCurPerd,
  0                                                                           as PlndCostAmtUpToRevPerd,
  0                                                                           as PlannedCostUpToFsclYrPerd,

  0                                                                           as AddlResourcePlannedCostAmount,

  0                                                                           as PlndRevnAmt,
  0                                                                           as PlndRevnAmtUpToRevPerd,
  0                                                                           as PlannedRevnUpToCurPerd,
  0                                                                           as PlannedRevnUpToFsclYrPerd,

  0                                                                           as PlannedExpenseCost,
  0                                                                           as PlndExpenseCostUpToRevPerd,
  0                                                                           as PlndExpCostUpToCurPerd,
  0                                                                           as PlndExpenseCostUpToFsclYrPerd,
  0                                                                           as ActualPlanDeviationExpnCost,

  // 0                                                                           as PlannedCostRate,


  //Plan Details - Base Line


  0                                                                           as BaselinePlndEffortQty,
  0                                                                           as BaselinePlannedQuantity,


  0                                                                           as BaselinePlndCostAmt,
  0                                                                           as BaselinePlndRevnAmt,

  0                                                                           as AdjustedRemainingEffort,
  0                                                                           as AdjustedRemngEffortToFsclPerd,

  0                                                                           as AdjustedRemainingEffortCost,
  0                                                                           as AdjstdRemngEffortCstToFsclPerd,
  0                                                                           as AdjustedRemainingExpnCost,


  0                                                                           as AdjustedRemainingCostPlnAmt,

  0                                                                           as AddlRsceEstToCmpltQty,

  0                                                                           as AddlRsceEstToCmpltCostAmount,

  0                                                                           as EstToCmpltCostUpToCurPerd,
  0                                                                           as EstToCmpltCostUpToRevPerd,
  0                                                                           as EstToCmpltUpToFsclPerdAmt,

  0                                                                           as AddlRsceEtcUpToCurPerdQty,
  0                                                                           as AddlRsceEtcUpToRevPerdQty,
  0                                                                           as AddlRsceEstToCmpltUpToFsclQty,

  0                                                                           as AddlRsceEtcCostUpToRevPerdAmt,
  0                                                                           as AddlRsceEtcCostUpToCurPerdAmt,
  0                                                                           as AddlRsceEstToCmpltUpToFsclAmt,

  0                                                                           as EstToCmpltEffortUpToRevPerd,
  0                                                                           as EstToCmpltEffortUpToCurPerd,
  0                                                                           as EstToCmpltUpToFsclPerdQty,

  0                                                                           as EstToCmpltEffCostUpToCurPerd,
  0                                                                           as EstToCmpltEffCostUpToRevPerd,
  0                                                                           as EstToCmpltEffUpToFsclPerdAmt,

  0                                                                           as EstToCmpltExpnCostUpToCurPerd,
  0                                                                           as EstToCmpltExpnCostUpToRevPerd,
  0                                                                           as EstToCmpltExpnUpToFsclPerdAmt,



  0                                                                           as EstimateAtCompletionCost,
  0                                                                           as EstAtCompltnCostUpToCurPerd,
  0                                                                           as EstAtCompltnCostUpToRevPerd,
  0                                                                           as EstAtCompltnUpToFsclPerdAmt,


  0                                                                           as EstAtCompltnEffortUpToCurPerd,
  0                                                                           as EstAtCompltnEffortUpToRevPerd,
  0                                                                           as EstimateAtCompletionEffort,
  0                                                                           as EstAtCmpltUpToFsclPerdQty,

  0                                                                           as AddlRsceEstAtCompltnQty,

  0                                                                           as EstimateAtCompletionExpnCost,
  0                                                                           as EstAtCmpltExpnUpToCurPerdAmt,
  0                                                                           as EstAtCmpltExpnUpToRevPerdAmt,
  0                                                                           as EstAtCmpltExpnUpToFsclPerdAmt,

  0                                                                           as DerivedEstAtCompltnCostUpToCur,
  0                                                                           as DerivedEstAtCompltnCostUpToRev,
  0                                                                           as DerivdEstAtCompltnUpToFsclAmt,

  0                                                                           as CompltnRateInPctUpToCurPerd,
  0                                                                           as CompltnRateInPctUpToRevPerd,

  0                                                                           as PlndMarginPct,

  // Filter Push Down Characterstics

  EngagementProject.IsMyProject,
  ProjectManagerExternalID,
  ProjectAccountantExternalID,
  ProjectControllerExternalID,
  ProjectPartnerExternalID                                                    as ProjectPartnerExternalID,
  ProjManagerUserID                                                           as ProjectManager,
  ProjAccountantUserID                                                        as ProjectAccountant,
  ProjControllerUserID                                                        as ProjectController,
  ProjPartnerUserID                                                           as ProjectPartner,
  ProjectManagerName,
  ProjectAccountantName,
  ProjectControllerName,
  ProjectPartnerName                                                          as ProjectPartnerName,
  Ledger.Ledger                                                               as Ledger,
  EngagementProject.ProjectProfileCode,
  EngagementProject.EngmntProjectHeaderCompanyCode,
  EngagementProject.EngagementProjectCostCenter,
  EngagementProject.ProfitCenter
}