In case you are experiencing performance issues when executing report RHAUTUPD_NEW, you can follow the recommendations below to improve processing times:
- Please check if you can delete some roles from your production client, which you do not need there (these are especially all the SAP*-roles which are necessary on your development client only). To find such roles, you can use the user information system (transaction S_BCE_68001419, for unused roles);
- Much time can be saved if you use job PFCG_TIME_DEPENDENCY (report RHAUTUPD_NEW) only with the necessary options. Please check if you really need to run, for instance, the HR Organizational Management: Reconciliation…
- Please create two variants for RHAUTUPD_NEW (for your productively used roles), one without the option Cleanups marked and one with this option. Cleanups are only necessary if you have changed authorizations (for example, after importing some deletions). So it is sufficient to schedule RHAUTUPD_NEW with ‘Cleanups’ once a week (or even more seldom).
- The last point is to check general performance on the involved database tables (especially AGR*-, USR*- and UST*- tables), and update for their statistics.
I hope that I could give you some hints for improving the runtime.
Please share your thoughts and experiences on this topic.