I_PPM_ProjectPublicSector

@AbapCatalog.sqlViewName: 'IPPMPRJPSM'

@VDM: {
    viewType: #COMPOSITE,
    lifecycle.contract.type: #SAP_INTERNAL_API
}
@AbapCatalog.preserveKey:true

@AbapCatalog.compiler.compareFilter: true
@AccessControl: {
    authorizationCheck:     #CHECK,
    personalData.blocking:  #BLOCKED_DATA_EXCLUDED
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
   compositionRoot: false,
   representativeKey: 'ProjectUUID',
   alternativeKey: [ { id : 'ProjectSummaryTaskUUID', uniqueness: #UNIQUE } ],
   usageType: {
     serviceQuality:  #D,
     dataClass:       #MIXED,
     sizeCategory:    #L
    }
}

@feature: 'BF:PSM_BUDGET_ACCOUNTING_CONTROL, EPPM_PUBLIC_SECTOR'

@EndUserText.label: 'Extension for Public Sector Fields'
define view I_PPM_ProjectPublicSector
  as select from I_PPM_ProjectSummaryTask as pst
    inner join   I_WBSElementBasicData    as wbs on wbs.WBSElementInternalID = pst.WBSElementInternalID

  association [1..1] to I_PPM_Project as _Root on $projection.ProjectUUID = _Root.ProjectUUID
{
  key pst.ProjectUUID,
      pst.ProjectSummaryTaskUUID,
      pst.ProjectInternalID,
      pst.WBSElementInternalID,
      //    @Consumption.hidden: true

      //   prj.ControllingArea,    // only for auth check

      //  @Consumption.hidden: true

      //  prj.ProfitCenter,       // only for auth check

      wbs.Fund,
      wbs.FundIsFixAssigned,
      wbs.FunctionalArea,
      wbs.FunctionalAreaIsFixAssigned,
      wbs.GrantID,
      wbs.GrantIsFixAssigned,
      //2008 sponsored program

      wbs.SponsoredProgram,

      wbs.ControllingArea, // For Authorization similar to Joint Venture Accounting

      wbs.ProfitCenter, // For Authorization similar to Joint Venture Accounting


      @Consumption.hidden: true
      _AuthUser,
      @Consumption.hidden: true
      _AuthSubst,
      @Consumption.hidden: true
      _AuthRole,
      @Consumption.hidden: true
      _AuthGroup,

      _Root
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_PROJECTSUMMARYTASK",
"I_WBSELEMENTBASICDATA"
],
"ASSOCIATED":
[
"I_PPM_AUTHZNBYSUBSTITH",
"I_PPM_AUTHZNBYUSERROLEH",
"I_PPM_AUTHZNBYUSRGRPH",
"I_PPM_AUTHZNBYUSRH",
"I_PPM_PROJECT"
],
"BASE":
[
"I_PPM_PROJECTSUMMARYTASK"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/