SAP Knowledge Base Article - Public

2342550 - Which table needs to be used to create a Custom report on Admin its associated Roles


  • This KBA specifies which columns are needed to create a custom report to return Admin Users and their associated Roles
  • The LMS currently does not have a system report that returns this data


SAP SuccessFactors Learning Management System (LMS)


The table PA_USER_PRFL_ROLE contains the data related to Admins and their associated Role

  • USER_NAME contains the admin ID
  • ROLE_ID contains the role ID
  • LST_UPD_USR is the ID of the user who last updated the Admin role
  • LST_UPD_TSTMP is when the Admin role was last updated

An Enhancement Request exists to add an LMS Role Assignment Audit Report.  Please review, vote up and add comments to help Product Management decide what to add in our upcoming releases:

See Also

Enhancement Request 48058


LMS Learning SF SuccessFactors Admin Role Custom report PRD Tool BIRT return show audit assign system out of box standard , KBA , LOD-SF-LMS , SuccessFactors Learning , LOD-SF-LMS-REP , Reporting Data , How To


SAP SuccessFactors Learning all versions