I_PPM_ProjectTaskPublicSector

DDL: I_PPM_PROJECTTASKPUBLICSECTOR SQL: IPPMPROJTASKPSM Type: view COMPOSITE Package: PPM_OBJECTS_DEPRECATED

Extension fields for PSM on Task level

I_PPM_ProjectTaskPublicSector is a Composite CDS View that provides data about "Extension fields for PSM on Task level" in SAP S/4HANA. It reads from 2 data sources (I_PPM_Task, I_WBSElementBasicData) and exposes 18 fields with key field TaskUUID. It has 2 associations to related views. Part of development package PPM_OBJECTS_DEPRECATED.

Data Sources (2)

SourceAliasJoin Type
I_PPM_Task task from
I_WBSElementBasicData wbs inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PPM_ProjectTask _ProjectTask _ProjectTask.TaskUUID = $projection.TaskUUID
[1..1] I_PPM_Project _Root _Root.ProjectUUID = $projection.ProjectUUID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IPPMPROJTASKPSM view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor R_EntProjElementPublicSector view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
Feature BF:PSM_BUDGET_ACCOUNTING_CONTROL, EPPM_PUBLIC_SECTOR view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey TaskUUID view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Extension fields for PSM on Task level view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY TaskUUID I_PPM_Task TaskUUID
WBSElementInternalID I_PPM_Task WBSElementInternalID
ProjectUUID I_PPM_Task ProjectUUID
Fund I_WBSElementBasicData Fund
FundIsFixAssigned I_WBSElementBasicData FundIsFixAssigned
FunctionalArea I_WBSElementBasicData FunctionalArea
FunctionalAreaIsFixAssigned I_WBSElementBasicData FunctionalAreaIsFixAssigned
GrantID I_WBSElementBasicData GrantID
GrantIsFixAssigned I_WBSElementBasicData GrantIsFixAssigned
SponsoredProgram I_WBSElementBasicData SponsoredProgram
ControllingArea I_WBSElementBasicData ControllingArea
ProfitCenter I_WBSElementBasicData ProfitCenter
_AuthUser _AuthUser
_AuthSubst _AuthSubst
_AuthRole _AuthRole
_AuthGroup _AuthGroup
_ProjectTask _ProjectTask
_Root _Root
@AbapCatalog.sqlViewName: 'IPPMPROJTASKPSM'
@VDM.lifecycle:
       { status:    #DEPRECATED,
         successor: 'R_EntProjElementPublicSector' }
@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

}