A_DevelopmentProjectElement
Project Element Details
A_DevelopmentProjectElement is a Consumption CDS View that provides data about "Project Element Details" in SAP S/4HANA. It reads from 1 data source (R_DevelopmentProjectElementTP) and exposes 50 fields with key field DevProjElmntUUID. It has 6 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_DevelopmentProjectElementTP | R_DevelopmentProjectElementTP | projection |
Associations (6)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | A_DevProjRoleStaffing | _Staffing | $projection.DevProjElmntUUID = _Staffing.DevProjElmntUUID |
| [1..*] | A_DevProjectElementResponsible | _ProjectElmntResponsible | ( $projection.DevProjElmntUUID = _ProjectElmntResponsible.DevProjElmntUUID ) or ( $projection.DevProjElmntOriginalTaskUUID = _ProjectElmntResponsible.DevProjElmntUUID ) and ( _ProjectElmntResponsible.DevProjElmntRespObjType = 'TPO' or _ProjectElmntResponsible.DevProjElmntRespObjType = 'TTO' or _ProjectElmntResponsible.DevProjElmntRespObjType = 'PPO' or _ProjectElmntResponsible.DevProjElmntRespObjType = 'CPO' or _ProjectElmntResponsible.DevProjElmntRespObjType = 'CTO' or _ProjectElmntResponsible.DevProjElmntRespObjType = 'ITO' ) |
| [0..*] | A_DevProjTaskRelationship | _TaskRelationship | $projection.DevProjElmntUUID = _TaskRelationship.PredecessorTaskUUID or $projection.DevProjElmntUUID = _TaskRelationship.SuccessorTaskUUID |
| [1..*] | A_DevProjElementStatus | _ProjectElementStatus | ( $projection.DevProjElmntUUID = _ProjectElementStatus.DevProjElmntUUID and $projection.IsMirroredTask = '' ) or ( $projection.DevProjElmntOriginalTaskUUID = _ProjectElementStatus.DevProjElmntUUID ) |
| [0..*] | A_DevRoleTaskAssignment | _TaskRoleAssignment | $projection.DevProjElmntUUID = _TaskRoleAssignment.DevProjElmntUUID and _TaskRoleAssignment.DevProjElmntObjectType = 'TTO' ---Extension |
| [1..1] | E_DevelopmentProjectElement | _Extension | $projection.DevProjElmntUUID = _Extension.TaskUUID |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Project Element Details | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| VDM.viewType | #CONSUMPTION | view | |
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view | |
| OData.entityType.name | DevelopmentProjectElement_Type | view |
Fields (50)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | DevProjElmntUUID | DevProjElmntUUID | ||
| ProjectElementDescription | ProjectElementDescription | |||
| DevProjElmntObjectType | DevProjElmntObjectType | |||
| ProjectUUID | ProjectUUID | |||
| DevelopmentProjectElement | DevelopmentProjectElement | |||
| SortingNumber | SortingNumber | |||
| DevProjHierarchySortNumber | DevProjHierarchySortNumber | |||
| DevProjElmntType | DevProjElmntType | |||
| DevProjElmntProcessType | DevProjElmntProcessType | |||
| StartConstraintType | StartConstraintType | |||
| StartConstraintDate | StartConstraintDate | |||
| DevProjFinishConstraintType | DevProjFinishConstraintType | |||
| FinishConstraintDate | FinishConstraintDate | |||
| EarliestStartDate | EarliestStartDate | |||
| EarliestFinishDate | EarliestFinishDate | |||
| LatestStartDate | LatestStartDate | |||
| LatestFinishDate | LatestFinishDate | |||
| ProjectElementDuration | ProjectElementDuration | |||
| DurationUnit | DurationUnit | |||
| DevProjElmntTotalFloat | DevProjElmntTotalFloat | |||
| FactoryCalendar | FactoryCalendar | |||
| PlannedWorkQuantity | PlannedWorkQuantity | |||
| PlannedWorkQuantityUnit | PlannedWorkQuantityUnit | |||
| DevProjElmntRmngWrkQuantity | DevProjElmntRmngWrkQuantity | |||
| RemainingWorkQuantityUnit | RemainingWorkQuantityUnit | |||
| IsMilestoneTask | IsMilestoneTask | |||
| IsObligatory | IsObligatory | |||
| IsApprovalRelevant | IsApprovalRelevant | |||
| IsMirroredTask | IsMirroredTask | |||
| DevProjElmntGroupingText | DevProjElmntGroupingText | |||
| DevProjElmntSearchFieldText | DevProjElmntSearchFieldText | |||
| ActualStartDate | ActualStartDate | |||
| ActualFinishDate | ActualFinishDate | |||
| PercentageOfCompletion | PercentageOfCompletion | |||
| DevProjElmntActlWorkQuantity | DevProjElmntActlWorkQuantity | |||
| ActualWorkQuantityUnit | ActualWorkQuantityUnit | |||
| CreatedByUser | CreatedByUser | |||
| CreationDateTime | CreationDateTime | |||
| LastChangedByUser | LastChangedByUser | |||
| LastChangeDateTime | LastChangeDateTime | |||
| DevProjElmntParentTaskUUID | DevProjElmntParentTaskUUID | |||
| DevProjElmntOriginalTaskUUID | DevProjElmntOriginalTaskUUID | |||
| CheckListItemIsNotRelevant | CheckListItemIsNotRelevant | |||
| CheckListItemIsNotOkay | CheckListItemIsNotOkay | |||
| CheckListItemIsOkay | CheckListItemIsOkay | |||
| _Staffing | _Staffing | |||
| _ProjectElmntResponsible | _ProjectElmntResponsible | |||
| _TaskRelationship | _TaskRelationship | |||
| _ProjectElementStatus | _ProjectElementStatus | |||
| _TaskRoleAssignment | _TaskRoleAssignment |
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Project Element Details'
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel: {
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #C,
sizeCategory: #XL
}
}
@VDM: {
viewType: #CONSUMPTION,
lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@OData.entityType.name:'DevelopmentProjectElement_Type'
@VDM.usage.type:[#TRANSACTIONAL_PROCESSING_SERVICE]
define view entity A_DevelopmentProjectElement
as projection on R_DevelopmentProjectElementTP as _ProjectElement
association [0..*] to A_DevProjRoleStaffing as _Staffing on $projection.DevProjElmntUUID = _Staffing.DevProjElmntUUID
association [1..*] to A_DevProjectElementResponsible as _ProjectElmntResponsible on (
$projection.DevProjElmntUUID = _ProjectElmntResponsible.DevProjElmntUUID
)
or (
$projection.DevProjElmntOriginalTaskUUID = _ProjectElmntResponsible.DevProjElmntUUID
)
and (
_ProjectElmntResponsible.DevProjElmntRespObjType = 'TPO'
or _ProjectElmntResponsible.DevProjElmntRespObjType = 'TTO'
or _ProjectElmntResponsible.DevProjElmntRespObjType = 'PPO'
or _ProjectElmntResponsible.DevProjElmntRespObjType = 'CPO'
or _ProjectElmntResponsible.DevProjElmntRespObjType = 'CTO'
or _ProjectElmntResponsible.DevProjElmntRespObjType = 'ITO'
)
association [0..*] to A_DevProjTaskRelationship as _TaskRelationship on $projection.DevProjElmntUUID = _TaskRelationship.PredecessorTaskUUID
or $projection.DevProjElmntUUID = _TaskRelationship.SuccessorTaskUUID
association [1..*] to A_DevProjElementStatus as _ProjectElementStatus on (
$projection.DevProjElmntUUID = _ProjectElementStatus.DevProjElmntUUID
and $projection.IsMirroredTask = ''
)
or (
$projection.DevProjElmntOriginalTaskUUID = _ProjectElementStatus.DevProjElmntUUID
)
association [0..*] to A_DevRoleTaskAssignment as _TaskRoleAssignment on $projection.DevProjElmntUUID = _TaskRoleAssignment.DevProjElmntUUID
and _TaskRoleAssignment.DevProjElmntObjectType = 'TTO'
---Extension Association
association [1..1] to E_DevelopmentProjectElement as _Extension on $projection.DevProjElmntUUID = _Extension.TaskUUID
{
key DevProjElmntUUID,
ProjectElementDescription,
DevProjElmntObjectType,
ProjectUUID,
DevelopmentProjectElement,
SortingNumber,
DevProjHierarchySortNumber,
DevProjElmntType,
DevProjElmntProcessType,
StartConstraintType,
StartConstraintDate,
DevProjFinishConstraintType,
FinishConstraintDate,
EarliestStartDate,
EarliestFinishDate,
LatestStartDate,
LatestFinishDate,
ProjectElementDuration,
DurationUnit,
DevProjElmntTotalFloat,
FactoryCalendar,
@Semantics.quantity.unitOfMeasure : 'PlannedWorkQuantityUnit'
PlannedWorkQuantity,
PlannedWorkQuantityUnit,
@Semantics.quantity.unitOfMeasure : 'RemainingWorkQuantityUnit'
DevProjElmntRmngWrkQuantity,
RemainingWorkQuantityUnit,
IsMilestoneTask,
IsObligatory,
IsApprovalRelevant,
IsMirroredTask,
DevProjElmntGroupingText,
DevProjElmntSearchFieldText,
ActualStartDate,
ActualFinishDate,
PercentageOfCompletion,
@Semantics.quantity.unitOfMeasure : 'ActualWorkQuantityUnit'
DevProjElmntActlWorkQuantity,
ActualWorkQuantityUnit,
CreatedByUser,
CreationDateTime,
LastChangedByUser,
LastChangeDateTime,
ForecastedStartDate,
ForecastedFinishDate,
DevProjElmntParentTaskUUID,
DevProjElmntOriginalTaskUUID,
CheckListItemIsNotRelevant,
CheckListItemIsNotOkay,
CheckListItemIsOkay,
/* Associations */
_Staffing,
_ProjectElmntResponsible,
_TaskRelationship,
_ProjectElementStatus,
_TaskRoleAssignment,
_Project : redirected to parent A_DevelopmentProject
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_DEVELOPMENTPROJECTELEMENTTP"
],
"ASSOCIATED":
[
"A_DEVELOPMENTPROJECT",
"A_DEVPROJECTELEMENTRESPONSIBLE",
"A_DEVPROJELEMENTSTATUS",
"A_DEVPROJROLESTAFFING",
"A_DEVPROJTASKRELATIONSHIP",
"A_DEVROLETASKASSIGNMENT",
"R_DEVELOPMENTPROJECTTP"
],
"BASE":
[
"R_DEVELOPMENTPROJECTELEMENTTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
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