Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
Thank you,
The SAP Community team.
The SAP Community wiki will be closed to new content submissions from December 7 6:00 p.m. CET to December 11 6:00 p.m. CET.
All content created during this period will not be available/restorable after December 11.
We apologize for the inconvenience, but we need to take this action to improve and maintain the SAP Community wiki performance.
Please plan your tasks accordingly.
Skip to end of metadata
Go to start of metadata

Mass population of a Business Role

Here is a way how to do mass population of a Business Role with a text file.  

This is an easy way to populate a BR and if it’s needed some validation rules can be set

Here is an example how the text (.csv ) file should look like:  

Into  the job folder is created a job, that will read the file and write in Identity Store  

  • First pass will read the data from a txt file and will store it in a temporary table
  • Second pass will read the data from a temporary table and the will add the privileges to the Business Roles(validation rules can be added here, as well into the first pass we can have some validations)

The first pass(Read data from txt file) is used for filling the temporary table with the data from the file  

The second pass(Mass assign of privileges to Business Roles) will fill the Business Roles   


  • A way to validate the data from the file is with a select into the Source-tab, where can be made a check if the privileges are existing into the IS

If the reconcile is OFF, into the job can be added additional pass(Reconcile) to trigger a reconcile after the upload