Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

To update user data

Former Member
0 Kudos

Hi All,

I am facing a new issue to update some information in user data for all the users.

This is a big task as the users are in thousands.

Is there any bapi or nything like which I should trigger only once and it would update the user with required data.

I know I can try with SECATT,but I dont know exactly,how to do that?

Please tell me exact solution.

1 ACCEPTED SOLUTION

jurjen_heeck
Active Contributor
0 Kudos

> I am facing a new issue to update some information in user data for all the users.

It also depends which information you need to update.

11 REPLIES 11

jurjen_heeck
Active Contributor
0 Kudos

> I am facing a new issue to update some information in user data for all the users.

It also depends which information you need to update.

0 Kudos

okay,say licence data for different users.

Edited by: Sweety Gill on Mar 25, 2009 3:22 PM

0 Kudos

SU10 will do fine for license data

0 Kudos

Hi Sweety ,

If it is the license data you can update using su10 transction. Else you can do using ecatt scripts.

1) First GO to SECATT transaction and create / record an test script for what purpose you need to use the script like role creation , user creation , etc.. make sure that script should always be in text format. and then save the script on your local machine in text format(.txt tab delimited)

2) then open the script file in excel and enter the all the users and what changes to be made to the users inthe excel and use one dummy user so that script will take that as reference and will make changes to all users accordingly.

3) Now save the file in text format again.

4) now run the script file through secatt --> upload the text file and then execute.

Regards

Kanti

0 Kudos

I have tried with Secatt,but I am getting errors.

Please can you tell me some link where I can get step by step Information (except help.sap.com as this link I have already chaecked) on SDN.

0 Kudos

Hi Sweety ,

Link provided by Lodewijk contains all the information and it helps you out.

Regards

kantikiran

0 Kudos

Hello,

When SAP has provided SU10. You can execute very easily to mass change the users.

Hope you must have tried with SU10. If you need any further help, please let me know.

Regards,

Ravi

0 Kudos

Licence data may be changed in SU10 but for only some licence types.

When we copy our Prod system back to refresh our QA system, I have to change all of the user licences to Multi-Client/System type. This licence type requires you to define the chargeable system, client and user name. You cannot do this in SU10, nor as a mass change in USMM.

I use LSMW for this type of change. Record the changing of one user. you will reocrd a lot of data field but will only need to maintain some of them when you do your data upload. Iin my case we load data to:

USR02-BNAME the userid you wish to update

US930-USERTYP the licence type (we use 11 for multi client)

US930-SYSID the production (or primary access) system ID

US930-MANDT2 the production (or primary access) cleitn

US930-ANAME the userid again (ie the one that holds the main licence in the prod/primary system)

I maintain the upload data in .txt fiel in XL and can upload records by the hundreds. In my case the first and last data field contain the same value (UserID) so this makes it even easier.

fredrik_borlie
Contributor
0 Kudos

>

> Is there any bapi or nything like which I should trigger only once and it would update the user with required data.

BAPI_USER_CHANGE is what you are asking for.

I also recommend NOT to use SECATT in production since it primarily is a TEST tool.

For massuploads use either the designated SAP transaction, in this case SU10. Or use the LSMW.

You can wrap the BAPI with an excel list as input. Or you can even launch a Batch Input Session to update the designated data.

Finally, at my former employer I wrote a small ABAP which connected to the corporate LDAP and retrieved the data and performed a BAPI_USER_CHANGE with the correct data.

This solution will take a good ABAPer 1 hour or two to create.

How to configure LDAG you can find here:

http://help.sap.com/erp2005_ehp_04/helpdata/EN/e6/0bfa3823e5d841e10000000a11402f/frameset.htm

Good luck!

/fredrik

0 Kudos

Fredrik raises a good point => Why are you having to update this data and will you need to do it again in future.

It might make sense to use a reliable data source to obtain this information from automatically and on a continious basis.

Cheers,

Julius