HOW TO SAP

HOW TO SAP - MASS UNLOCK USER WITH SQL COMMAND

August 26, 2011  
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  

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  

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

HOW TO SAP - command to login to sap system

August 15, 2011  

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

HOW TO SAP - RUN BDLSS (new)

August 08, 2011  
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
 Continue Reading

HOW TO SAP - Change text on main SAPGui logon screen

August 08, 2011  
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"
 Continue Reading

HOW TO SAP - Tables to find Tcode and Programs

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

 Continue Reading

Selamat Berpuasa to all Muslim friends!

August 01, 2011  

Continue Reading
Subscribe to: Posts (Atom)
Designed By: Blogger Templates | Templatelib