HOW TO SAP

HOW TO SAP - Applying SAP License

April 29, 2011  
  1. Make sure you already received the license from SAP

  2. Tcode slicense

  3. If you just perform system copy, then remove old license.

  4. Click "New Licenses"


  5. Delete off all the old exisitng license.


  6. Now you may import in the new license. Click Install
 Continue Reading

HOW TO SAP - Request SAP LICENSE from SAP

April 29, 2011  
  1. Visit http://service.sap.com/licensekey > Keys & Request > License Key


  2. Select request permanent license key


  3. To seach for installation key, go to tcode slicense


  4. Once found your installation, click New System


  5. Enter all the details need from the screen

  6. For hardware key, refer to tcode slicense.

  7. Continue and SAP will ask for your email address so that they can sent you the license file.


 Continue Reading

HOW TO SAP - How to approve support packages via solman manager

April 28, 2011  
  1. There is a shortcut by running functional module

  2. Tcode se37, enter /TMWFLOW/MO_UI_BASKET_AUTHORIZ

  3. Click on test execute


  4. Press execute


  5. Patch waiting for download will be displayed below. Check and then click confirm download
 Continue Reading

HOW TO SAP - You cannot logon (CUA system assignment missing)

April 27, 2011  
  1. Just reset user password
 Continue Reading

HOW TO SAP - The entered password is not downward compatible (see long text)

April 27, 2011  

  1. Tcode SU01, reset user password and encounter:
    "The entered password is not downward compatible (see long text)"



  2. To resolve, don't type "enter" instead, use mouse and click on Save.
 Continue Reading

HOW TO SAP - Solman to approve support pack - AISUSER

April 27, 2011  
Before you can use solman to approve support pack, you have to add yourself to AISUSER tcode

  1. Tcode AISUSER


  2. Click edit and add your userid and OSS ID eg:6785432 (without S and Zero)

  3. Now you can execute tcode solution_manager and you will see maintain optimizer to approve the download.
 Continue Reading

HOW TO SAP - Client Copy

April 25, 2011  
SCC8 + SCC7- Import/Export (only one system's client is locked at a time)
SCC9 - Remote client copy (both source and target client will be locked)
SCCL - Local import (between local clients in same system)

* We are copying client from one system to another using SCC8. It will create a transport number.
* For client export, you can specify more then 1 processors.
  1. Execute SCC8


  2. Click schedule as background job


  3. Check Immediate and click schedule job


  4. Continue



  5. Transport will be created


  6. Check status from SCC3 > Export >
  7. Run STMS and import the 3 transport. Starting with
    HRPO0000XXX
    HRPT0000XXX
    HRPX0000XXX
  8. Run SCC7 after finish transporting client.

  9. Click Start Immediate or Schedule as background


 Continue Reading

HOW TO SAP - Estimate I/O cost (expensive sql)

April 22, 2011  
  1. Dbacockpit or db02

  2. SQL Statement


  3. Double click on any sql statement


  4. Click Explain tree


  5. You will see the estimate I/O cost
 Continue Reading

HOW TO SAP - Create Database in MS SQL 2008

April 08, 2011  










  1. Two types of database – system database(MS SQL) and user database (HRT)


  2. Master:  MS SQL database. Contains info of all physically files, configuration.
  3. Model :  template dataabase
  4. msdb : manage sql server agent configuration.
  5. tempdb:  store temporary tables

  6. Right click databases > new database

  7. Enter TST as database name

  8. For the 1st data file , the extenstion should end as *.mdf

  9. Click Add (for new data files)
  10. Logical name TSTDATA2, Path M:\TST\Data2\, File name : TSTDATA2.ndf
  11. For other data files, remember extension should be *.ndf

  12. TST_Log path is M:\TST\Log1, File name: TSTLOG.ldf
  13. Remember logfiles extension is *.ldf

  14. Double click cell under Autogrowth. Settings can be change here.

  15. Ok
  16. Ok
  17.  Database created.
 Continue Reading

HOW TO SAP - Upgrade Kernel

April 01, 2011  
  1. Kernel upgrade is simple.

  2. Once downloaded and uncar the *.sar files

  3. Stop sap and sap services

  4. Do a backup of the exe folder in our case its
    \usr\sap\sid\dvebmgs00\exe

  5. Then replace the uncar files into exe folder.

  6. Now restart SAP.

  7. If fail, restore back the exe folder

    :D
 Continue Reading

How to use sap car

April 01, 2011  
  1. Backup any folder or files before you process.
  2. First search for sapcar.exe. Its usually located at \usr\sap\sid\dvebmgs00\exe
  3. To uncar your *.sar files, run this command
    SAPCAR -xvf  dw_294.sar
  4. All files in dw_294.sar will be uncar into the directory where sapcar.exe is located.

  5. To list a file (preview) you may execute
    SAPCAR -tvsf dw_294.sar > c:\list.txt

  6. This way, it will not uncar any files but list out the files for you in list.txt.
    Find the file in drive C: 
 Continue Reading
Subscribe to: Posts (Atom)
Designed By: Blogger Templates | Templatelib