I_SingleResponsibleForProj

DDL: I_SINGLERESPONSIBLEFORPROJ SQL: ISNGLRSPFRPRJ Type: view COMPOSITE Package: ODATA_PS_COS_PROJ_OVERVIEW

Single responsible person for a project

I_SingleResponsibleForProj is a Composite CDS View that provides data about "Single responsible person for a project" in SAP S/4HANA. It reads from 1 data source (I_PPM_SingleResponsibleForProj) and exposes 9 fields with key field ReferencedObjectUUID. It has 2 associations to related views. Part of development package ODATA_PS_COS_PROJ_OVERVIEW.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_PPM_SingleResponsibleForProj Responsible from

Associations (2)

CardinalityTargetAliasCondition
[1] I_EnterpriseProjectRole _Role _Role.ProjectUUID = $projection.ReferencedObjectUUID and _Role.ProjectRoleCategory = 'PM'
[0..1] I_PPM_Text _ProjectRoleName ( $projection.projectroleuuid = _ProjectRoleName.ReferencedObjectUUID ) and ( _ProjectRoleName.LanguageCode = $session.system_language )

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISNGLRSPFRPRJ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Single responsible person for a project view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.personalData.blocking #REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ReferencedObjectUUID I_PPM_SingleResponsibleForProj ProjectSummaryTaskUUID
BusinessPartnerUUID BusinessPartnerUUID
ProjectRoleUUID _Role ProjectRoleUUID
BusinessPartnerFullName _BusinessUser PersonFullName
IsBusinessPurposeCompleted _BusinessUser IsBusinessPurposeCompleted
AuthorizationGroup _BusinessUser AuthorizationGroup
_BusinessUser _BusinessUser
_BusinessPartner _BusinessPartner
_ProjectRoleName _ProjectRoleName 
@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