SAP Knowledge Base Article - Public

2342550 - Which table needs to be used to create a Custom Report to verify the Roles associated with Admins


This KBA specifies which columns are needed to create a custom report to return Admin Users and their associated Roles


SAP SuccessFactors Learning


The table PA_USER_PRFL_ROLE (PH available) 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

Note: The LMS currently does not have a system report that returns this data.

See Also

We encourage our customers to submit an enhancement request to have this functionality considered within future development cycles.
It can be done at

KBA 2090228 - How to Submit Enhancement Requests for SAP SuccessFactors Products

KBA 2326249 - How to find the latest version of LMS data dictionary


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


SAP SuccessFactors Learning all versions