A_DevRoleTaskAssignment

DDL: A_DEVROLETASKASSIGNMENT Type: view_entity CONSUMPTION

API View for Task Role Assignment

A_DevRoleTaskAssignment is a Consumption CDS View that provides data about "API View for Task Role Assignment" in SAP S/4HANA. It reads from 1 data source (R_DevRoleTaskAssignmentTP) and exposes 12 fields with key fields DevProjElmntUUID, ProjectRoleUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_DevRoleTaskAssignmentTP R_DevRoleTaskAssignmentTP projection

Associations (3)

CardinalityTargetAliasCondition
[1..*] A_DevProjRoleStaffing _Staffing $projection.ProjectRoleUUID = _Staffing.ProjectRoleUUID and $projection.DevProjElmntUUID = _Staffing.DevProjElmntUUID and $projection.DevRoleTskAssgmtShadowRoleUUID = _Staffing.DevProjRoleStfngShadowRoleUUID
[0..*] A_DevelopmentProjectElement _ProjectElement ( $projection.DevProjElmntUUID = _ProjectElement.DevProjElmntUUID ) and ( _ProjectElement.DevProjElmntObjectType = 'TTO' or _ProjectElement.DevProjElmntObjectType = 'TPO' )
[1..*] A_DevelopmentProjectRole _Role $projection.ProjectRoleUUID = _Role.ProjectRoleUUID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label API View for Task Role Assignment view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
OData.entityType.name DevRoleTaskAssignment_Type view
Metadata.ignorePropagatedAnnotations true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY DevProjElmntUUID DevProjElmntUUID
KEY ProjectRoleUUID ProjectRoleUUID
DevRoleTskAssgmtUUID DevRoleTskAssgmtUUID
DevProjElmntObjectType DevProjElmntObjectType
DevRoleTskAssgmtShadowRoleUUID DevRoleTskAssgmtShadowRoleUUID
PlannedStartDate PlannedStartDate
DevRoleTskAssgmtPlndFinishDate DevRoleTskAssgmtPlndFinishDate
PlannedWorkQuantity PlannedWorkQuantity
PlannedWorkQuantityUnit PlannedWorkQuantityUnit
_Role _Role
_Staffing _Staffing
_ProjectElement _ProjectElement
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'API View for Task Role Assignment'
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM: {
    viewType: #CONSUMPTION,
    lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@OData.entityType.name: 'DevRoleTaskAssignment_Type'
@Metadata.ignorePropagatedAnnotations: true
define view entity A_DevRoleTaskAssignment
  as projection on R_DevRoleTaskAssignmentTP
  association [1..*] to A_DevProjRoleStaffing       as _Staffing       on  $projection.ProjectRoleUUID                = _Staffing.ProjectRoleUUID
                                                                       and $projection.DevProjElmntUUID               = _Staffing.DevProjElmntUUID
                                                                       and $projection.DevRoleTskAssgmtShadowRoleUUID = _Staffing.DevProjRoleStfngShadowRoleUUID
  association [0..*] to A_DevelopmentProjectElement as _ProjectElement on  (
      $projection.DevProjElmntUUID                                                                                  = _ProjectElement.DevProjElmntUUID
    )
                                                                       and (
                                                                          _ProjectElement.DevProjElmntObjectType    = 'TTO'
                                                                          or _ProjectElement.DevProjElmntObjectType = 'TPO'
                                                                        )
  association [1..*] to A_DevelopmentProjectRole    as _Role           on  $projection.ProjectRoleUUID = _Role.ProjectRoleUUID
{
  key DevProjElmntUUID,
  key ProjectRoleUUID,
      DevRoleTskAssgmtUUID,
      DevProjElmntObjectType,
      DevRoleTskAssgmtShadowRoleUUID,
      PlannedStartDate,
      DevRoleTskAssgmtPlndFinishDate,
      @Semantics.quantity.unitOfMeasure: 'PlannedWorkQuantityUnit'
      PlannedWorkQuantity,
      PlannedWorkQuantityUnit,

      _Role,
      _Staffing,
      _ProjectElement
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_DEVROLETASKASSIGNMENTTP"
],
"ASSOCIATED":
[
"A_DEVELOPMENTPROJECTELEMENT",
"A_DEVELOPMENTPROJECTROLE",
"A_DEVPROJROLESTAFFING"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/