HOW TO SAP

HOW TO SAP - MASS UNLOCK USER WITH SQL COMMAND

August 26, 2011 sql command, unlock user,

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' Continue Reading

HOW TO MASS LOCK USER with SQL COMMAND

August 26, 2011 lock user, 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')

Continue Reading

HOW TO SAP - SAPCAR all *.car files

August 16, 2011 sapcar,

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

Without " " it will not work.

Continue Reading

HOW TO SAP - command to login to sap system

August 15, 2011 command, sapgui,

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

Continue Reading

HOW TO SAP - RUN BDLSS (new)

August 08, 2011 BDLSS,

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

Continue Reading

Subscribe to: Posts (Atom)

Designed By: Blogger Templates | Templatelib