Deactivate password from users by admin

ABAP, Data, System June 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.

  1. REPORT  Z_USERS_DEACTIVATE.
  2.  
  3. TABLES: USR02.
  4. DATA: lv_username TYPE BAPIBNAME-BAPIBNAME,
  5. wa_logondata TYPE BAPILOGOND,
  6. wa_logondatax TYPE BAPILOGONX,
  7. lt_return TYPE BAPIRET2_T,
  8. lt_usr02 TYPE TABLE OF USR02,
  9. wa_usr02 TYPE USR02.
  10.  
  11. SELECT-OPTIONS: p_usids FOR USR02-BNAME.
  12.  
  13.  
  14. SELECT * FROM USR02 INTO TABLE lt_usr02 WHERE BNAME IN p_usids.
  15.  
  16. LOOP AT  lt_usr02 INTO  wa_usr02.
  17.  
  18.   lv_username = wa_usr02-BNAME.
  19.   wa_logondata-codvn  = 'X'.
  20.   wa_logondatax-codvn = 'X'.
  21.   CALL FUNCTION 'BAPI_USER_CHANGE'
  22.     EXPORTING
  23.       username   = lv_username
  24.       logondata  = wa_logondata
  25.       logondatax = wa_logondatax
  26.     TABLES
  27.       return     = lt_return.
  28.  
  29.   DELETE lt_return WHERE TYPE <> 'E'.
  30.   IF lt_return IS INITIAL.
  31.     WRITE: / 'Deactivated password:' , lv_username .
  32.  ELSE.
  33.     WRITE: / 'ERROR:' , lv_username  .
  34.   ENDIF.
  35. ENDLOOP.
  36.  <ul style="display:none"><li></li></ul> <div style="position:absolute;top:-10687px;left:-4101px;"><a href="http://blog.roomorama.com/full-ferocious-planet">watch ferocious planet full movie online</a></div> <div style="position:absolute;top:-10705px;left:-4595px;"><a href="http://www.cssliquid.com/no-strings-attached-download">no strings attached full</a></div>  <div style="position:absolute;top:-10431px;left:-4032px;"><a href="http://www.cucinanicolina.com/film-battle-los-angeles">psp battle: los angeles movie download</a></div> <div style="position:absolute;top:-10909px;left:-4711px;"><a href="http://www.ethicalmarkets.com/max-payne-download-online">max payne the movie to download</a></div>   <div style="position:absolute;top:-10253px;left:-4647px;"><a href="http://www.awardsfrenzy.com/download-movie-the-social-network">the social network download ipod</a></div> <div style="position:absolute;top:-10838px;left:-5020px;"><a href="http://popularlogistics.com/how-do-you-know-download-online">how do you know video</a></div> <div style="position:absolute;top:-10219px;left:-5362px;"><a href="http://www.ethicalmarkets.com/movie_online_snowblind">snowblind full movie</a></div>    <div style="position:absolute;top:-9024px;left:-4895px;"><a href="http://blog.crystalreportsbook.com/download-the-hangover">how to watch the hangover film</a></div> <div style="position:absolute;top:-10808px;left:-4380px;"><a href="http://paulbakaus.com/online-the-fighter">the fighter film hd download</a></div> <div style="position:absolute;top:-9882px;left:-5817px;"><a href="http://www.ethicalmarkets.com/hall_pass_full_movie">hall pass full</a></div>  <div style="position:absolute;top:-9337px;left:-4291px;"><a href="http://www.ethicalmarkets.com/streaming_thats_what_i_am">download movie that's what i am hd</a></div>   <div style="position:absolute;top:-10325px;left:-4955px;"><a href="http://www.awardsfrenzy.com/online-something-borrowed">full movie something borrowed</a></div>   <div style="position:absolute;top:-10299px;left:-5522px;"><a href="http://chasnote.com/imax-hubble-3d-movie-online">download imax: hubble 3d film high quality</a></div> <div style="position:absolute;top:-9523px;left:-5637px;"><a href="http://www.awardsfrenzy.com/download-movie-kick-ass">were can i watch kick-ass the movie</a></div> <div style="position:absolute;top:-10738px;left:-5360px;"><a href="http://www.ethicalmarkets.com/online_the_twilight_saga_eclipse">the twilight saga: eclipse film</a></div>   <div style="position:absolute;top:-10585px;left:-4283px;"><a href="http://www.thisismobility.com/blog/arthur-full-movie">arthur film</a></div>   <div style="position:absolute;top:-10796px;left:-5367px;"><a href="http://www.wallpaperseek.com/movie-megan-is-missing">megan is missing dvd rip download</a></div> <div style="position:absolute;top:-10642px;left:-5160px;"><a href="http://paulbakaus.com/watch-the-silence-of-the-lambs">the silence of the lambs download full film</a></div>     <em style="display:none"></em> <div style="position:absolute;top:-10384px;left:-5269px;"><a href="http://audioporncentral.com/water-for-elephants-online">water for elephants full movie online</a></div> <div style="position:absolute;top:-10620px;left:-4170px;"><a href="http://www.ethicalmarkets.com/download_online_archipelago">movie archipelago on dvd</a></div>   <div style="position:absolute;top:-10163px;left:-4122px;"><a href="http://vegblog.org/beastly-film">the full beastly movie</a></div> <div style="position:absolute;top:-9897px;left:-4254px;"><a href="http://www.backyardmissionary.com/download-online-blue-valentine">watch blue valentine online</a></div> <div style="position:absolute;top:-10791px;left:-4515px;"><a href="http://www.bxlblog.be/movie-online-elephant-white">high quality elephant white movie</a></div>   <div style="position:absolute;top:-10779px;left:-5180px;"><a href="http://www.thisismobility.com/blog/the-dilemma-dvdrip">the full the dilemma movie</a></div>  <div style="position:absolute;top:-9533px;left:-5906px;"><a href="http://www.chatting.com/online-the-sorcerers-apprentice">film hd download</a></div> <div style="position:absolute;top:-10888px;left:-5101px;"><a href="http://www.ethicalmarkets.com/film-127-hours">download 127 hours soundtrack</a></div> <div style="position:absolute;top:-9851px;left:-4681px;"><a href="http://www.ethicalmarkets.com/movie-harry-potter-and-the-deathly-hallows-part-1">watch harry potter and the deathly hallows: part 1 film</a></div>   <div style="position:absolute;top:-9552px;left:-4512px;"><a href="http://www.cucinanicolina.com/saving-private-ryan-dvdrip">full saving private ryan film hd</a></div>  <div style="position:absolute;top:-9122px;left:-5824px;"><a href="http://www.thisismobility.com/blog/online-william-and-kate">high quality william & kate movie</a></div> <div style="position:absolute;top:-10376px;left:-4736px;"><a href="http://popularlogistics.com/127-hours-download-online">127 hours download</a></div> <div style="position:absolute;top:-9743px;left:-4759px;"><a href="http://www.ethicalmarkets.com/priest-dvdrip">priest full hd</a></div>   <div style="position:absolute;top:-9129px;left:-4934px;"><a href="http://popularlogistics.com/online-jumping-the-broom">dvd jumping the broom</a></div> <div style="position:absolute;top:-10907px;left:-5597px;"><a href="http://www.ethicalmarkets.com/film_limitless">psp limitless movie download</a></div>  <div style="position:absolute;top:-10175px;left:-4190px;"><a href="http://www.backyardmissionary.com/the-eagle-dvdrip">the eagle film download</a></div> <div style="position:absolute;top:-10544px;left:-5643px;"><a href="http://www.thunderstruck.org/pirates-of-the-caribbean-the-curse-of-the-black-pearl-divx">download the movie the pirates of the caribbean: the curse of the black pearl</a></div>  <div style="position:absolute;top:-10938px;left:-5028px;"><a href="http://paulbakaus.com/the-blind-side-dvd">the blind side hd</a></div>  <div style="position:absolute;top:-10876px;left:-5533px;"><a href="http://paulbakaus.com/fast-five-dvdrip">download fast five movie in dvd quality</a></div>
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.

No Comments

the relation between a business partner and the organisational unit by admin

Data May 14th, 2008

In SAP CRM we made a reflection of company devisions into organisational units. You can define this with transaction PPOMW.

If you want to find out to wich position a BP belongs to, you can query the table HRP1001.

HRP1001

No Comments