I_DevProjResponsible

DDL: I_DEVPROJRESPONSIBLE SQL: IDEVPROJRESPON Type: view COMPOSITE

Responsible Details

I_DevProjResponsible is a Composite CDS View that provides data about "Responsible Details" in SAP S/4HANA. It reads from 2 data sources (I_PPM_BusinessPartnerForObject, I_PPM_Task) and exposes 9 fields with key fields BusinessPartnerUUID, ProjectUUID, DevProjElmntUUID. It has 1 association to related views.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_PPM_BusinessPartnerForObject _Bupa from
I_PPM_Task _Task inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PPM_ProjectRoleText _Role _Role.ProjectRoleUUID = _Bupa.ProjectRoleUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IDEVPROJRESPON view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Responsible Details view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID I_PPM_BusinessPartnerForObject BusinessPartnerUUID
KEY ProjectUUID I_PPM_Task ProjectUUID
KEY DevProjElmntUUID I_PPM_Task TaskUUID
ProjectRoleUUID I_PPM_BusinessPartnerForObject ProjectRoleUUID
BusinessPartner
IsBusinessPurposeCompleted
BusinessPartnerIsBlocked
DevProjRespObjectType I_PPM_Task ObjectType
_Role _Role 
@AbapCatalog.sqlViewName: 'IDEVPROJRESPON'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Responsible Details'
@ObjectModel: {
    usageType: {
      dataClass:       #MIXED,
      serviceQuality:  #D,
      sizeCategory:    #XL
    }
}
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API
define view I_DevProjResponsible
  as select from I_PPM_BusinessPartnerForObject as _Bupa
    inner join   I_PPM_Task                     as _Task on _Task.TaskUUID = _Bupa.ReferencedObjectUUID
  association [1..1] to I_PPM_ProjectRoleText as _Role on _Role.ProjectRoleUUID = _Bupa.ProjectRoleUUID
  //  association [1..1] to I_InterObjectLink     as _ObjLink on  $projection.TaskUUID    = _ObjLink.TaskUUID

  //                                                          and _ObjLink.ObjectLinkType = '0MPM_MIRRORED'

{
  key  _Bupa.BusinessPartnerUUID           as BusinessPartnerUUID,  
  key  _Task.ProjectUUID                   as ProjectUUID,
  key  _Task.TaskUUID                      as DevProjElmntUUID,
       _Bupa.ProjectRoleUUID               as ProjectRoleUUID,
       _Bupa._BusinessUser.BusinessPartner as BusinessPartner,
       _Bupa._BusinessUser.IsBusinessPurposeCompleted,
       _Bupa._BusinessUser._User._BusinessPartner.BusinessPartnerIsBlocked,
       _Task.ObjectType                    as DevProjRespObjectType,

       _Role
}
where
  _Bupa.IsBusinessPartnerResponsible = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_BUSINESSUSERBASIC",
"I_PPM_BUSINESSPARTNERFOROBJECT",
"I_PPM_TASK",
"I_USER"
],
"ASSOCIATED":
[
"I_PPM_PROJECTROLETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More