P_PPM_SINGLERESPONSIBLEFOROBJ

CDS View

P_PPM_SINGLERESPONSIBLEFOROBJ is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SingleResponsibleForProj view from COMPOSITE Single responsible person for a project 
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'PPPMSNGLRSPFROBJ'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
//@ObjectModel.representativeKey: 'ReferencedObjectUUID'

//@EndUserText.label: 'Returns the calculated single responsible for an object'

define view P_PPM_SingleResponsibleForObj
  as select from           P_PPM_ResponsibleSummaryForObj as respall
    left outer to one join P_PPM_RespSummaryForObjInRange as respdate     on respdate.ReferencedObjectUUID = respall.ReferencedObjectUUID
    
  association [0..1] to I_BusinessPartner    as _BusinessPartner on $projection.BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID
  association [0..1] to I_BusinessUserBasic  as _BusinessUser    on $projection.BusinessPartnerUUID = _BusinessUser.BusinessPartnerUUID
  association [0..1] to I_PPM_Text           as _ProjectRoleName on ( $projection.ProjectRoleUUID = _ProjectRoleName.ReferencedObjectUUID )
                                                              and ( _ProjectRoleName.LanguageCode = $session.system_language )

{
  respall.ReferencedObjectUUID,

  case when respall.NumberOfResponsibles  <> 1 
        and respdate.NumberOfResponsibles >= 1 then respdate.BusinessPartnerUUID
       else respall.BusinessPartnerUUID 
  end as BusinessPartnerUUID,
  
  @ObjectModel.text.association: '_ProjectRoleName'
  respall.ProjectRoleUUID,
  _BusinessUser,
  _BusinessPartner, // do not use, will be removed.

  _ProjectRoleName
}
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PPM_RESPONSIBLESUMMARYFOROBJ",
"P_PPM_RESPSUMMARYFOROBJINRANGE"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_BUSINESSUSERBASIC",
"I_PPM_TEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More