A_DevelopmentProjectElement

DDL: A_DEVELOPMENTPROJECTELEMENT Type: view_entity CONSUMPTION

Development Project Element Details

A_DevelopmentProjectElement is a Consumption CDS View that provides data about "Development 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. It is exposed through 1 OData service (API_DEVELOPMENTPROJECT).

Data Sources (1)

SourceAliasJoin Type
R_DevelopmentProjectElementTP R_DevelopmentProjectElementTP projection

Associations (6)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Development 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

OData Services (1)

ServiceBindingVersionContractRelease
API_DEVELOPMENTPROJECT API_DEVELOPMENTPROJECT V4 C2 C1

Fields (50)

KeyFieldSource TableSource FieldDescription
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: 'Development 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,
      @ObjectModel.sapObjectNodeTypeReference: 'DevelopmentProjectObjectType'
      DevProjElmntObjectType,
      ProjectUUID,
      DevelopmentProjectElement,
      SortingNumber,
      DevProjHierarchySortNumber,
      @ObjectModel.sapObjectNodeTypeReference: 'DevelopmentProjectElementType'
      DevProjElmntType,
      @ObjectModel.sapObjectNodeTypeReference: 'DevelopmentProjectProcessType'
      DevProjElmntProcessType,
      @ObjectModel.sapObjectNodeTypeReference: 'DevProjectConstraintType'
      StartConstraintType,
      StartConstraintDate,
      @ObjectModel.sapObjectNodeTypeReference: 'DevProjectConstraintType'
      DevProjFinishConstraintType,
      FinishConstraintDate,
      EarliestStartDate,
      EarliestFinishDate,
      LatestStartDate,
      LatestFinishDate,
      ProjectElementDuration,
      @ObjectModel.sapObjectNodeTypeReference: 'UnitOfMeasure'
      DurationUnit,
      DevProjElmntTotalFloat,
      FactoryCalendar,
      @Semantics.quantity.unitOfMeasure : 'PlannedWorkQuantityUnit'
      PlannedWorkQuantity,
      @ObjectModel.sapObjectNodeTypeReference: 'UnitOfMeasure'
      PlannedWorkQuantityUnit,
      @Semantics.quantity.unitOfMeasure : 'RemainingWorkQuantityUnit'
      DevProjElmntRmngWrkQuantity,
      @ObjectModel.sapObjectNodeTypeReference: 'UnitOfMeasure'
      RemainingWorkQuantityUnit,
      IsMilestoneTask,
      IsObligatory,
      IsApprovalRelevant,
      IsMirroredTask,
      DevProjElmntGroupingText,
      DevProjElmntSearchFieldText,
      ActualStartDate,
      ActualFinishDate,
      PercentageOfCompletion,
      @Semantics.quantity.unitOfMeasure : 'ActualWorkQuantityUnit'
      DevProjElmntActlWorkQuantity,
      @ObjectModel.sapObjectNodeTypeReference: 'UnitOfMeasure'
      ActualWorkQuantityUnit,
      CreatedByUser,
      CreationDateTime,
      LastChangedByUser,
      LastChangeDateTime,
      ForecastedStartDate,
      ForecastedFinishDate,
      DevProjElmntParentTaskUUID,
      DevProjElmntOriginalTaskUUID,
      CheckListItemIsNotRelevant,
      CheckListItemIsNotOkay,
      CheckListItemIsOkay,
      /* Associations */
      _Staffing,
      _ProjectElmntResponsible,
      _TaskRelationship,
      _ProjectElementStatus,
      _TaskRoleAssignment,
      _Project : redirected to parent A_DevelopmentProject
}