I_PPM_PROJECTROLETEXT

CDS View

Project Role Text

I_PPM_PROJECTROLETEXT is a CDS View in S/4HANA. Project Role Text. It contains 1 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 1 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_PPM_BuPaWorkingOnObject view left_outer COMPOSITE Provide Business Partners working on the object
I_PPM_CollectedSeverityForTask view left_outer COMPOSITE Collected Severity For Task
I_PPM_ProjectManagerForObject view left_outer COMPOSITE Provide Project Manager for referenced object
I_PPM_SingleResponsibleForObj view left_outer COMPOSITE Returns the calculated single responsible for an object

Fields (1)

KeyField CDS FieldsUsed in Views
ProjectRoleName ProjectRoleName 3 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel: {
   dataCategory: #TEXT,
   representativeKey:  'ProjectRoleUUID',
   usageType: {
     serviceQuality:  #C,
     dataClass:       #MIXED,
     sizeCategory:    #S
    }
}

@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'IPPMPROROLETEXT'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Project Role Text'
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API 

define view I_PPM_ProjectRoleText
  as select from    I_PPM_ProjectRole as role
    left outer join I_PPM_ProjectRoot as ProjectRoot on role.ProjectUUID = ProjectRoot.ProjectUUID  
    left outer join I_PPM_Text        as TextLogon   on (
         TextLogon.LanguageCode                                                       = $session.system_language
       )
                                                     and(
                                                       TextLogon.ReferencedObjectUUID = role.ProjectRoleUUID
                                                     )
    left outer join I_PPM_Text        as TextMaster  on (
        TextMaster.LanguageCode                                                        = ProjectRoot.MasterLanguage
      )
                                                     and(
                                                       TextMaster.ReferencedObjectUUID = role.ProjectRoleUUID
                                                     )
{
    @ObjectModel.text.element: ['ProjectRoleName']
key role.ProjectRoleUUID,

    @EndUserText.label: 'Object Description'
    @Semantics.text: true            -- identifies the first text field
    @UI.hidden: true
    cast( case
         when TextLogon.ObjectName > '' then
              TextLogon.ObjectName
         else (
         case
              when TextMaster.ObjectName > '' then
              TextMaster.ObjectName
              else role.ProjectRole
         end
         )
      end as dpr_project_name ) as ProjectRoleName,
 //Authorization check relevant data   

      role.ProjectSummaryTaskUUID,
      role.ProjectInternalID,
      role.WBSElementInternalID,
      role._I_Project,
      role._ProjObj,
      role._AuthUser,
      role._AuthSubst,
      role._AuthRole,
      role._AuthGroup 
}                                                        
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_PROJECTROLE",
"I_PPM_PROJECTROOT",
"I_PPM_TEXT"
],
"ASSOCIATED":
[
"I_PPM_AUTHZNBYSUBSTITH",
"I_PPM_AUTHZNBYUSERROLEH",
"I_PPM_AUTHZNBYUSRGRPH",
"I_PPM_AUTHZNBYUSRH",
"I_PROJECTBASICDATA",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[
"I_PPM_PROJECTROLE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More