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.

  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.
No Comments

Installation of the sapgui 640 client by admin

System May 9th, 2008

This article will describe how you can install the sapgui 640 client on a windows machine.
 

SAP GUI is an abbreviation for "SAP Graphical User Interface".

Before you begin:
  • Make sure you are logged into your windows computer with administrator rights so u can install software;
  • It's also better to remove any previous installation of the sapgui client from your system. This can be done using the  "Add/Remove Programs" from the configuration screen;
  • Check if you have enough diskspace available, between 100-150MB;
  • If u have to download the installation files use Internet Explorer 5.0 or later.

 

Files: 

installation file:  http://service.sap.com/installations

patches: http://service.sap.com/patches/

 

Installation process: 

sapgui netweaver 640 splash screen

 

step1

 

step 2

 

step 3

sapgui

 SAP GUI

r3 addon

  R/3 Add-on

general add-on

  General Add-on

development tools

  Development Tools

legacy components

  Legacy components

BW add-on

  BW Add-on

Bi add-on

  BI Add-on

CRM add-on

  CRM Add-on

KW add-on

  KW Add-on

SCM add-on

  SCM Add-on

SEM add-on

  SEM Add-on

 

 

Installing sapgui

 

Completed installation

 

 

 

 

 

No Comments

SAP GUI tips ands tricks by admin

System May 9th, 2008

Remove the annoying click sound and copy the server logon to other computers.

 

Sound

When i first logged into SAP GUI is was really annoyed by the click-click-click sound. You can disable it by toggling the “audio - off” option in the visual design.  You can access this screen by choosing following menuitem.

 

new visual design

 

 

Logon file

In your sap logon screen you can have a lot of servers defined. If you want to replicate them to another client you just have to copy the following .ini file.

 

C:\WINDOWS\saplogon.ini

 

2 Comments

Monitoring work processes by admin

System May 9th, 2008

In this article we are going to cover Work processes in more detail.

 

Work processes are unix tasks that can be identified by using following unix command.

 ps -ef|grep dw

There are 5 type of processes and 4 types of status : 

Type's 

DIA   Dialog Interactive dialogs 
 BTC  Batch  Background tasks
 UPD  Update  Database updates (critical)
 UP2 UPDATE   Database updates(non-critical)
 ENQ  Enqueue  locking/releasing SAP objects
 SPO Spools   Data formatting and printer spools

Status

Running   executing a request
 Waiting  idle
 Hold a WP can only serve a single user. If there are many work processes on "hold" then the system performance will suffer
 Ended aborted

 

Transactions SM50  gives a process overview for a particular application* server. If you want view the processes of another server go to SM51 and choose the server u want.

work processes with sm50

And if u would like to see all the processes running accros your systems (inlcuding all application servers) use the SM66 Global Work process overview.

 

 * SAP uses the generic term application server to define a computer that receives connections from SAP clients, but the actual connections are managed by SAP dialog servers.

No Comments