I_PPM_ProjTaskPublicSectorTP

DDL: I_PPM_PROJTASKPUBLICSECTORTP SQL: IPPMPRJTASKPSMTP Type: view COMPOSITE

Extension fields for PSM on Task level

I_PPM_ProjTaskPublicSectorTP is a Composite CDS View that provides data about "Extension fields for PSM on Task level" in SAP S/4HANA. It reads from 1 data source (I_PPM_ProjectTaskPublicSector) and exposes 16 fields with key field TaskUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PPM_ProjectTaskPublicSector task from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PPM_ProjectTaskTP _ProjectTask _ProjectTask.TaskUUID = $projection.TaskUUID
[1..1] I_PPM_ProjectTP _Root $projection.ProjectUUID = _Root.ProjectUUID

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IPPMPRJTASKPSMTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.writeDraftPersistence PPM_PRO_TSKPSM_D view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Feature BF:PSM_BUDGET_ACCOUNTING_CONTROL, EPPM_PUBLIC_SECTOR 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 (16)

KeyFieldSource TableSource FieldDescription
KEY TaskUUID TaskUUID
WBSElementInternalID WBSElementInternalID
ProjectUUID ProjectUUID
Fund Fund
FundIsFixAssigned FundIsFixAssigned
FunctionalArea I_PPM_ProjectTaskPublicSector FunctionalArea
FunctionalAreaIsFixAssigned FunctionalAreaIsFixAssigned
GrantID GrantID
GrantIsFixAssigned GrantIsFixAssigned
SponsoredProgram SponsoredProgram
_AuthUser _AuthUser
_AuthSubst _AuthSubst
_AuthRole _AuthRole
_AuthGroup _AuthGroup
_ProjectTask _ProjectTask
_Root _Root
@AbapCatalog.sqlViewName: 'IPPMPRJTASKPSMTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel:
  {
    writeDraftPersistence: 'PPM_PRO_TSKPSM_D',
    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true,
    usageType:
    {
      serviceQuality: #D, 
      sizeCategory: #L,
      dataClass: #TRANSACTIONAL
    }
  }
@Feature: 'BF:PSM_BUDGET_ACCOUNTING_CONTROL, EPPM_PUBLIC_SECTOR'
@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_ProjTaskPublicSectorTP
  as select from I_PPM_ProjectTaskPublicSector as task
  association [1..1] to I_PPM_ProjectTaskTP as _ProjectTask on _ProjectTask.TaskUUID = $projection.TaskUUID
  association [1..1] to I_PPM_ProjectTP     as _Root        on $projection.ProjectUUID = _Root.ProjectUUID
{
      @ObjectModel.readOnly:true
  key TaskUUID,
      @ObjectModel.readOnly:true
      WBSElementInternalID,
      @ObjectModel.readOnly:true
      ProjectUUID,
      Fund,
      FundIsFixAssigned,
      task.FunctionalArea as FunctionalArea,
      FunctionalAreaIsFixAssigned,
      GrantID,
      GrantIsFixAssigned,
      SponsoredProgram,

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

      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT ]
      _ProjectTask,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT ]
      _Root
}