I_PPM_ProjectTaskPublicSector
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)
| Source | Alias | Join Type |
|---|---|---|
| I_PPM_Task | task | from |
| I_WBSElementBasicData | wbs | inner |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_PPM_ProjectTask | _ProjectTask | _ProjectTask.TaskUUID = $projection.TaskUUID |
| [1..1] | I_PPM_Project | _Root | _Root.ProjectUUID = $projection.ProjectUUID |
Annotations (16)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA