HOW TO SAP

Step by step manual guide with screenshot for Basis, Security Authorization & Abap

Popular Posts

  • HOW TO SAP - STMS transport hang with truck icon
    At times transport will hang with status Truck icon Check https://forums.sdn.sap.com/thread.jspa?threadID=972797&tstart=100 Logi...
  • Webdynpro - User session (HTTP/SMTP/..) closed after timeout
    There are two solution for this. Solution 1: Follow SAP note  1948291 - User session (HTTP/SMTP/..) closed aft by increasing the http...
  • HOW TO SAP - Change retention settings in ST03
    ST03 Collector and DB performance > Performance Database > Workload Collector Database > Reorganization > Control Settin...

Blog Archive

  • ►  2019 (14)
    • ►  July (4)
    • ►  June (8)
    • ►  May (2)
  • ►  2018 (1)
    • ►  January (1)
  • ►  2017 (65)
    • ►  December (16)
    • ►  November (18)
    • ►  October (26)
    • ►  September (1)
    • ►  August (3)
    • ►  June (1)
  • ►  2014 (1)
    • ►  August (1)
  • ►  2013 (2)
    • ►  December (1)
    • ►  March (1)
  • ►  2012 (5)
    • ►  June (3)
    • ►  February (2)
  • ▼  2011 (88)
    • ►  October (3)
    • ►  September (8)
    • ▼  August (8)
      • HOW TO SAP - MASS UNLOCK USER WITH SQL COMMAND
      • HOW TO MASS LOCK USER with SQL COMMAND
      • HOW TO SAP - SAPCAR all *.car files
      • HOW TO SAP - command to login to sap system
      • HOW TO SAP - RUN BDLSS (new)
      • HOW TO SAP - Change text on main SAPGui logon screen
      • HOW TO SAP - Tables to find Tcode and Programs
      • Selamat Berpuasa to all Muslim friends!
    • ►  July (4)
    • ►  June (14)
    • ►  May (22)
    • ►  April (11)
    • ►  March (14)
    • ►  February (2)
    • ►  January (2)
  • ►  2010 (1)
    • ►  October (1)
  • ►  2009 (17)
    • ►  October (12)
    • ►  September (1)
    • ►  August (3)
    • ►  June (1)
  • ►  2008 (20)
    • ►  January (20)
2013-2017. Powered by Blogger.
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,

  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   command, sapgui,

  1. Start > Run
  2. sapgui <server> <instance>
  3. 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





  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   change main login screen tex,
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   table program, table tcode,
  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
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)
Designed By: Blogger Templates | Templatelib