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

[former_member270360]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

Hello,

Run this report

RSUSR402

[Former Member]

Hi there,

That report has not been maintained since 2004 and the FM it is calling (which is reading USR03) has not been maintained since 2000.

Things have changed since then (the SAP note I mentioned is from 2004), so perhaps SAP should retire that report (or already has in the latest release(s))?

Cheers,

Julius

[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

[Former Member]

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

[former_member270360]

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

[former_member270360]

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

[Former Member]

Possibly you are not authorized to change the default layout to extend the output?

Try SU53 (last failed check) or ST01 auth trace ("reached" auth checks) to see whether there is a restriction to your output layout authority.

Cheers,

Julius

[Bernhard_SAP]

which release do you have with which basis Support package?

[former_member270360]

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

[Bernhard_SAP]

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