I_DevProjRoleStaffing

DDL: I_DEVPROJROLESTAFFING SQL: IDEVPROJROLESTAF Type: view BASIC

PPM Role Staffing Details

I_DevProjRoleStaffing is a Basic CDS View that provides data about "PPM Role Staffing Details" in SAP S/4HANA. It reads from 3 data sources (dpr_bupa_link, I_FMEANodeHierarchy, /s4ppm/role) and exposes 13 fields with key fields ProjectRoleUUID, ProjectUUID, BusinessPartnerUUID. It has 1 association to related views.

3 data source(s) 13 fields

Data Sources (3)

SourceAliasJoin Type
dpr_bupa_link _BupaLink inner
I_FMEANodeHierarchy _Hierarchy inner
/s4ppm/role _Role from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_DevProjRoleEntityLink _EntityLink _EntityLink.BusinessPartnerUUID = _Hierarchy.FMEANodeUUID and _EntityLink.DevProjElmntObjectType = 'TTO' and _EntityLink.IsBusinessPartnerResponsible <> 'X'

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IDEVPROJROLESTAF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label PPM Role Staffing Details view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.modelingPattern #NONE view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ProjectRoleUUID
KEY ProjectUUID /s4ppm/role project_guid
KEY BusinessPartnerUUID dpr_bupa_link bupa_guid
DevProjElmntUUID _EntityLink DevProjElmntUUID
DevProjRoleStfngShadowRoleUUID
StaffingUUID dpr_bupa_link guid
clientNULLasDevProjRoleStfngBeginDate Role Staffing Begin Date
clientNULLasDevProjRoleStfngEndDate Project Staffing End Date
PlannedWorkQuantity dpr_bupa_link work_effort
PlannedWorkQuantityUnit dpr_bupa_link work_unit
DevProjRoleStfngBookingType dpr_bupa_link booking_type
clientNULLasPlannedStartDate Planned Start Date
_EntityLink _EntityLink 
@AbapCatalog.sqlViewName: 'IDEVPROJROLESTAF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'PPM Role Staffing Details'
@ObjectModel: {
    usageType: {
      dataClass:       #TRANSACTIONAL,
      serviceQuality:  #B,
      sizeCategory:    #XL
    },
    supportedCapabilities: [#SQL_DATA_SOURCE,
                            #CDS_MODELING_DATA_SOURCE,
                            #CDS_MODELING_ASSOCIATION_TARGET],
    modelingPattern: #NONE
}
@Metadata.ignorePropagatedAnnotations:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API

define view I_DevProjRoleStaffing
  as select from /s4ppm/role         as _Role
    inner join   I_FMEANodeHierarchy as _Hierarchy on _Hierarchy.FMEAParentNodeUUID = _Role.guid
    inner join   dpr_bupa_link       as _BupaLink  on _BupaLink.participant_guid = _Hierarchy.FMEANodeUUID
  association [1..*] to I_DevProjRoleEntityLink as _EntityLink on  _EntityLink.BusinessPartnerUUID          =  _Hierarchy.FMEANodeUUID
                                                               and _EntityLink.DevProjElmntObjectType       =  'TTO'
                                                               and _EntityLink.IsBusinessPartnerResponsible <> 'X'

{

  key cast(_Role.guid as /s4ppm/tv_entity_guid preserving type )              as ProjectRoleUUID,
  key _Role.project_guid                                                      as ProjectUUID,
  key _BupaLink.bupa_guid                                                     as BusinessPartnerUUID,
      _EntityLink.DevProjElmntUUID                                            as DevProjElmntUUID,
      cast(_Hierarchy.FMEANodeUUID as /s4ppm/tv_entity_guid preserving type ) as DevProjRoleStfngShadowRoleUUID,
      _BupaLink.guid                                                          as StaffingUUID,
      @EndUserText.label: 'Role Staffing Begin Date'
      tstmp_to_dats( _BupaLink.beg_tmstmp ,
                     abap_system_timezone( $session.client,'NULL' ),
                     $session.client,
                     'NULL' )                                                 as DevProjRoleStfngBeginDate,
      @EndUserText.label: 'Project Staffing End Date'
      tstmp_to_dats(  _BupaLink.end_tmstmp,
                           abap_system_timezone( $session.client,'NULL' ),
                           $session.client,
                           'NULL' )                                           as DevProjRoleStfngEndDate,
      @Semantics.quantity.unitOfMeasure : 'PlannedWorkQuantityUnit'
      _BupaLink.work_effort                                                   as PlannedWorkQuantity,
      _BupaLink.work_unit                                                     as PlannedWorkQuantityUnit,
      _BupaLink.booking_type                                                  as DevProjRoleStfngBookingType,
      @EndUserText.label: 'Planned Start Date'
      tstmp_to_dats( _BupaLink.planstart ,
                     abap_system_timezone( $session.client,'NULL' ),
                     $session.client,
                     'NULL' )                                                 as PlannedStartDate,
      @EndUserText.label: 'Role Staffing Planned Finish Date'
      tstmp_to_dats( _BupaLink.planfinish ,
                     abap_system_timezone( $session.client,'NULL' ),
                     $session.client,
                     'NULL' )                                                 as DevProjRoleStfngPlndFinishDate,
      _EntityLink

}
where
  _Hierarchy.FMEANodeHierarchyLevelValue = 2

Learn More