I_SINGLERESPONSIBLEFORPROJ

CDS View

Single responsible person for a project

I_SINGLERESPONSIBLEFORPROJ is a CDS View in S/4HANA. Single responsible person for a project. It contains 2 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 2 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_EntProjSimilarProjBscData view left_outer COMPOSITE Interface view for the Similar Projects
P_ProjCostItems_OVW view left_outer COMPOSITE Project Cost Line Items

Fields (2)

KeyField CDS FieldsUsed in Views
KEY BusinessPartnerFullName BusinessPartnerFullName 2
KEY BusinessPartnerUUID BusinessPartnerUUID 2 
@AbapCatalog.sqlViewName: 'ISNGLRSPFRPRJ'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Single responsible person for a project'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.personalData.blocking: #REQUIRED
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

define view I_SingleResponsibleForProj
  as select from I_PPM_SingleResponsibleForProj as Responsible
  association [1]    to I_EnterpriseProjectRole as _Role            on  _Role.ProjectUUID         = $projection.ReferencedObjectUUID
                                                                    and _Role.ProjectRoleCategory = 'PM'
  association [0..1] to I_PPM_Text              as _ProjectRoleName on  (
      $projection.projectroleuuid                                                                    = _ProjectRoleName.ReferencedObjectUUID
    )
                                                                    and (
                                                                       _ProjectRoleName.LanguageCode = $session.system_language
                                                                     )
{
  key  Responsible.ProjectSummaryTaskUUID      as ReferencedObjectUUID,
       BusinessPartnerUUID,
       _Role.ProjectRoleUUID,
       _BusinessUser.PersonFullName            as BusinessPartnerFullName,
       _BusinessUser.IsBusinessPurposeCompleted,
       _BusinessUser.AuthorizationGroup,
       _BusinessUser,
       _BusinessPartner,
       _ProjectRoleName

}

Learn More