Skip to Content

Mass saving (download) of SAP user ids locally on the PC

Hello,

Is there a way to mass save (download) a list of SAP user ids locally on the PC, the same way as we can do for SAP authorization roles, through trans. code PFCG, Mass Download ?

The purpose is to save the attributes of the following tabs of trans SU01 : 'Address', 'Defaults', 'Parameters' and especially 'Roles'

Thank you in advance for your cooperation.

Best regards.

Reda Khalifa

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

8 Answers

  • Best Answer
    Posted on Jul 07, 2008 at 04:39 PM

    Dear Bernhard,

    Thank you for your interest and sorry for being late in replying.

    We are using SAP ECC 6.0, Kernel 7.00, Kernel Patch no. 135, Basis Support Package SAPKB70010 Level 0010

    Best regards.

    Reda Khalifa

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Reda,

      then the button shall be available...

      But remember, that it is present at the result screen of RSUSR002 (that suim report).

      So make your selection for the users, then press execute.

      You shall get the list of selected users. On that screen the 'change Layout' button shall be present. Or press Ctrl+F8 to get that function.

      b.rgds, bernhard

  • author's profile photo Former Member
    Former Member
    Posted on May 27, 2008 at 03:20 PM

    There is always some danger in downloading data from SAP tables, because you might be downloading the wrong table or not selecting ("seeing") all the fields of the table from SE16 & Co. Not knowing about [SAP note 96607|https://service.sap.com/sap/support/notes/96607] is a nice example of this danger.

    The function module which Trond mentioned is the interface which SAP provides to "upload" user data INTO the correct SAP tables, correctly and consistently. It also makes the correct application authority-checks when doing this (though that is subject to your SP level), and is even remote-enabled for ease of use (if you, or the SYSTEM user for the connection, are authorized).

    The function module to "download" the existing user data FROM the correct SAP tables and structures is: BAPI_USER_GET_DETAIL.

    You would however need a list of the users to start with (see also function module BAPI_USER_GET_LIST - though I am not 100% sure about the exact name of this one and not logged on).

    Cheers,

    Julius

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 28, 2008 at 11:31 AM

    Hi there,

    would it be sufficient for you to use TCode SUIM--> Users by complex .....and modify the display variant to include simply everything?

    Kind regards,

    Richard

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 27, 2008 at 02:51 PM

    Reda,

    I don't know if there's anything like that, but you can try to do this:

    Enter transaction SE16, and start downloading tables: USR02, USER_ADDR, AGR_USERS. All those tables contain the information you mentioned.

    If you need to create those users again simply create a CATT.

    BR,

    Lucas

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 27, 2008 at 02:51 PM

    I don't believe there is a standard SAP download program. However, you should be able to write one fairly easy, by focusing on tables USR02, AGR_USERS and so on. Then, for subsequent upload purposes, you could either run a CATT (e-Catt) or use BAPI_USER_CREATE.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 28, 2008 at 10:41 AM

    Hello,

    Run this report

    RSUSR402

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I checked this with SAP and my statement about report RSUSR402 is not correct. It is not obsolete and serves it's specific purpose.

      The correct answer is the SUIM report tree path to "Users by complex selection criteria" mentioned by Richard H. To add the fields, click on the "Change Layout" push-button (an icon which looks like a Rubic Cube) and select the fields you want; then download.

      For user parameters in particular, if these are needed then a custom report calling FM BAPI_USER_GET_DETAIL does the job.

      Cheers,

      Julius

  • Posted on May 28, 2008 at 12:41 PM

    Hello Richard,

    First of all thank you very much for your interest.

    Could you please guide me on what exactly to set up - after issuing trans. SUIM, Users By Complex Selection Criteria, Users By Complex Selection Criteria; what exactly should I change to let the result include the parameters & authorization roles which are attributed to the users.

    Thank you & best regards.

    Reda Khalifa

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 06, 2008 at 09:46 PM

    Hello Julius,

    Thank you very much for your interest.

    I issued trans. SUIM, then User, then Users by Complex Selection Criteria, then Users by Complex Selection Criteria.

    In the final screen which I received, there was no button for 'Change Layout'; the buttons available were : Execute (F8), Get Variant...(Shift + F5), Program Documentation (Shift + F1)

    In the toolbar, there is a button labeled 'Customize Local Layout (Alt + F12)', which produces a pull-down menu, in which I could not find any 'Change Layout' option.

    Appreciate your patience.

    Best regards.

    Reda Khalifa

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.