sapstart

Deactivate password from users by admin

ABAP, Data, System September 29th, 2008

When you have to deactivate the pasword of a large list of userts, you could use this script. For a smaller set of users you can also use Trx SU10.

First of all you need a list of all users…

Then you can copy paste all values of BNAME into this report.

REPORT Z_USERS_DEACTIVATE.
TABLES: USR02.
DATA: lv_username TYPE BAPIBNAME-BAPIBNAME,
wa_logondata TYPE BAPILOGOND,
wa_logondatax TYPE BAPILOGONX,
lt_return TYPE BAPIRET2_T,
lt_usr02 TYPE TABLE OF USR02,
wa_usr02 TYPE USR02.
SELECT-OPTIONS: p_usids FOR USR02-BNAME.
SELECT * FROM USR02 INTO TABLE lt_usr02 WHERE BNAME IN p_usids.
LOOP AT lt_usr02 INTO wa_usr02.
lv_username = wa_usr02-BNAME.
wa_logondata-codvn = 'X'.
wa_logondatax-codvn = 'X'.
CALL FUNCTION 'BAPI_USER_CHANGE'
EXPORTING
username = lv_username
logondata = wa_logondata
logondatax = wa_logondatax
TABLES
return = lt_return.
DELETE lt_return WHERE TYPE <> 'E'.
IF lt_return IS INITIAL.
WRITE: / 'Deactivated password:' , lv_username .
ELSE.
WRITE: / 'ERROR:' , lv_username .
ENDIF.
ENDLOOP.

No Comments

Creating a BP for each organisational unit by admin

Data May 16th, 2008

If you want to create a business partner for each organisational unit you must specify this in customising.
After defining this setting, a BP will be created automatically when you create an OU.

You can find the menu in customizing:

In the first item you can define wether you want to create a BP for each organisation unit.

If you have already units in you organisational plan, you can use the second item in the menu to synchronise them. You can do this one by one or in bulk.

When you execute the query you can see all the units in your plan when a status(red/green). For the ones with a red light there is no BP defined. If you select the record and use the “start repair” button, a new business partner will be created for that ou.