Skip to Content
avatar image
Former Member

Mass update on SU01 Logon Data tab (Alias field)

Hi

I need to upload an excel spreadsheet with a user id (123456) and then update the Alias field on SU01 via the Logon Data tab with the same user id (but with an alphabetical letter in front). Eg. E123456.

Is there a standard method or something I can use to do these updates?

Regards

Debbie

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 04, 2017 at 11:52 AM

    Hi - have you looked at transaction SU10? I also recommend searching for this question

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 05, 2017 at 08:55 AM

    Hi

    I have had a look and cannot see it working for me.

    I have searched and will try searching again.

    Was hoping someone has a quick answer for me. I have spent a lot of time in investigating and still am.

    Need to upload a spreadsheet with thousands of entries.

    Regards

    Debbie

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 21, 2017 at 05:21 PM

    Hi Debbie,

    There is no quick solution for your case. SU10 will require some manual copying & pasting and could be somehow cumbersome if you have loads of users.

    However, you could create a program either in ABAP or in Java. It would be simple to implement it as there are BAPIs for all your requirements:

    1) Get a list of users: BAPI_USER_GETLIST. Use this BAPI to retrieve a list of users that are relevant to your business case (for instance: get all user IDs begining with 1* or Load the user list from Excel). If you have all users in Excel and they already exist on the ABAP system you may use BAPI_USER_GET_DETAIL for each excel line.

    2) Loop though the user's array returned on the previous step and call BAPI_USER_CHANGE mapping the details from GETLIST into the structures and import parameters of USER_CHANGE. Then use your rule (append letter 'E' to the user ID) and map this value to the ALIAS field which is available as import parameter.

    As said, you may do this by coding in ABAP or use JCO to program in Java to create a very simple process that updates a list of users.

    There is a blog that shows an example on how to upload an excel sheet that will update parameters on SU01 using ABAP.

    Regards,
    Ivan

    Add comment
    10|10000 characters needed characters exceeded