Posts

Showing posts from August, 2011

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 lockBNAME !='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

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

HOW TO SAP - command to login to sap system

Start > Runsapgui <server> <instance>Example : sapgui r3dev 00

HOW TO SAP - RUN BDLSS (new)

Image
After client copy, you have to perform BDLSS

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





Tcode BDLSS > Start

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

Execute

HOW TO SAP - Change text on main SAPGui logon screen

Image
Note 205487 - Own text on SAPGui logon




Tcode SE61Document Class > General TextCreateNow enter test and save document as "ZLOGIN_SCREEN_INFO"

HOW TO SAP - Tables to find Tcode and Programs

To find tcode, use table TSTCTo find program, user table TRDIR or TRDIRT

Selamat Berpuasa to all Muslim friends!