FINOC_PCK_EPRJP

@AbapCatalog.sqlViewName: 'FINOCV_PCK_EPRJP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'OrglChange: EPPM Projects from Runtime'
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
// Selects the EPPM projects from WBS and PRO table

define view FINOC_PCK_EPRJP
  as select distinct from finoc_rt_wbs as wbs
    inner join            prps         as prps on prps.pspnr = wbs.ps_psp_pnr
    inner join            proj         as proj on proj.pspnr = prps.psphi
{
  proj.pspnr          as ps_prj_pnr,
  wbs.ps_psp_pnr      as ps_psp_pnr,
  proj.profl          as profl,
  wbs.orgl_change     as orgl_change,
  wbs.bukrs           as bukrs,
  wbs.reassgmt_status as reassgmt_status,
  wbs.prctr           as prctr
}
where
      proj.profl <> 'P001'  // No customer project

  and proj.profl <> 'P002'  // No internal project

union all select distinct from finoc_rt_pro as pro
  inner join                   proj         as proj on proj.pspnr = pro.ps_prj_pnr
{
  proj.pspnr          as ps_prj_pnr,
  '00000000'          as ps_psp_pnr,
  proj.profl          as profl,
  pro.orgl_change     as orgl_change,
  pro.bukrs           as bukrs,
  pro.reassgmt_status as reassgmt_status,
  pro.prctr           as prctr
}
where
      proj.profl <> 'P001'  // No customer project

  and proj.profl <> 'P002'; // No internal project

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