Subscribe:

Ads 468x60px

Pages

HOW TO SAP - MASS UNLOCK USER WITH SQL COMMAND

Unlock support team :     
update sid.USR02 set UFLAG=0 where MANDT='110' and BNAME in
('DDIC',
 'SAP*',
 'ALEREMOTE',
 'WF-BATCH',
 'TMSADM',
 'ITOUSER',
 'SAPCPIC',
 'SAPJSF',
 'J2EE_ADMIN',
 'J2EE_GUEST',
 'SAP ADMIN'
)         
          


OR you may unlock all user with
Unlock user :     
update sid.USR02 set UFLAG=0 where MANDT='110'      

HOW TO MASS LOCK USER with SQL COMMAND


Execute this SQL command
  • update SID.USR02 set UFLAG=64 where MANDT='110' and BNAME != 'SAP*';    
  • Explain : UFLAG=64 means lock
  • BNAME !='SAP*' means lock everyone except SAP*

Alternately, try the below SQL command:

use HRS
UPDATE [hrs].[USR02]
SET UFLAG = '64'
WHERE (UFLAG = '0') 
AND NOT (BNAME like 'SAP%' OR BNAME = 'DDIC' OR BNAME = 'TMSADM' 
         OR BNAME like 'J2EE%' OR BNAME like 'SLD%' OR BNAME = 'JCO_DATA'
         OR BNAME = 'BASIS_ADMIN')

HOW TO SAP - SAPCAR all *.car files


  1. First search for sapcar.exe. Its usually located at \usr\sap\sid\dvebmgs00\exe
  2. Copy the sapcar.exe to the folder where you saved all the *.sar files.
  3. Start > Run > cmd > browser to the folder with *.sar files
  4. Execute SAPPCAR -xvf  ".sar"
Without " " it will not work.

HOW TO SAP - command to login to sap system


  1. Start > Run
  2. sapgui <server> <instance>
  3. Example : sapgui r3dev 00

HOW TO SAP - RUN BDLSS (new)

After client copy, you have to perform BDLSS

http://help.sap.com/saphelp_nw04/helpdata/EN/33/c823dbaea911d6b29500508b6b8a93/content.htm





  1. Tcode BDLSS > Start

  2. Enter the Source client and target client (newly created client)

  3. Execute

HOW TO SAP - Change text on main SAPGui logon screen

Note 205487 - Own text on SAPGui logon




  1. Tcode SE61
  2. Document Class > General Text
  3. Create
  4. Now enter test and save document as "ZLOGIN_SCREEN_INFO"

HOW TO SAP - Tables to find Tcode and Programs

  1. To find tcode, use table TSTC
  2. To find program, user table TRDIR or TRDIRT

Selamat Berpuasa to all Muslim friends!


Related Posts Plugin for WordPress, Blogger...