I_PPM_PROJECTTASKPUBLICSECTOR

CDS View

Extension fields for PSM on Task level

I_PPM_PROJECTTASKPUBLICSECTOR is a CDS View in S/4HANA. Extension fields for PSM on Task level. It contains 11 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_EntProjElmntPublicSectorTP view from TRANSACTIONAL Extension fields for PSM on Task level
I_EntProjElmntPublicSectorTP_2 view_entity from TRANSACTIONAL Extension fields for PSM on Task level
I_PPM_ProjTaskPublicSectorTP view from COMPOSITE Extension fields for PSM on Task level

Fields (11)

KeyField CDS FieldsUsed in Views
ControllingArea ControllingArea 1
FunctionalArea FunctionalArea 1
FunctionalAreaIsFixAssigned FunctionalAreaIsFixAssigned 2
Fund Fund 2
FundIsFixAssigned FundIsFixAssigned 2
GrantID GrantID 2
GrantIsFixAssigned GrantIsFixAssigned 2
ProfitCenter ProfitCenter 1
ProjectUUID ProjectUUID 2
SponsoredProgram SponsoredProgram 2
WBSElementInternalID WBSElementInternalID 2
@AbapCatalog.sqlViewName: 'IPPMPROJTASKPSM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE

@Feature: 'BF:PSM_BUDGET_ACCOUNTING_CONTROL, EPPM_PUBLIC_SECTOR'
@ObjectModel.usageType:
{
  serviceQuality: #C,
  dataClass: #TRANSACTIONAL,
  sizeCategory: #L
}
@ObjectModel.representativeKey: 'TaskUUID'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API
@EndUserText.label: 'Extension fields for PSM on Task level'

define view I_PPM_ProjectTaskPublicSector
  as select from I_PPM_Task            as task
    inner join   I_WBSElementBasicData as wbs on wbs.WBSElementInternalID = task.WBSElementInternalID
  association [1..1] to I_PPM_ProjectTask as _ProjectTask on _ProjectTask.TaskUUID = $projection.TaskUUID
  association [1..1] to I_PPM_Project     as _Root        on _Root.ProjectUUID = $projection.ProjectUUID
{
  key task.TaskUUID,
      task.WBSElementInternalID,
      task.ProjectUUID,
      wbs.Fund,
      wbs.FundIsFixAssigned,
      wbs.FunctionalArea,
      wbs.FunctionalAreaIsFixAssigned,
      wbs.GrantID,
      wbs.GrantIsFixAssigned,
      wbs.SponsoredProgram,//2008 Sponsored program


      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,

      _ProjectTask,
      _Root

}