Showing posts from April, 2011

HOW TO SAP - Applying SAP License

Make sure you already received the license from SAP

Tcode slicense

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

Click "New Licenses"

Delete off all the old exisitng license.

Now you may import in the new license. Click Install


Visit > Keys & Request > License Key

Select request permanent license key

To seach for installation key, go to tcode slicense

Once found your installation, click New System

Enter all the details need from the screen

For hardware key, refer to tcode slicense.

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

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

There is a shortcut by running functional module


Click on test execute

Press execute

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

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

Just reset user password

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

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

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

HOW TO SAP - Solman to approve support pack - AISUSER

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


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

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

HOW TO SAP - Client Copy

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. Execute SCC8

Click schedule as background job

Check Immediate and click schedule job


Transport will be created

Check status from SCC3 > Export >
Run STMS and import the 3 transport. Starting with
Run SCC7 after finish transporting client.

Click Start Immediate or Schedule as background

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

Dbacockpit or db02

SQL Statement

Double click on any sql statement

Click Explain tree

You will see the estimate I/O cost

HOW TO SAP - Create Database in MS SQL 2008

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

Master:  MS SQL database. Contains info of all physically files, configuration.Model :  template dataabasemsdb : manage sql server agent configuration.tempdb:  store temporary tables

Right click databases > new database

Enter TST as database name

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

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

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

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


HOW TO SAP - Upgrade Kernel

Kernel upgrade is simple.

Once downloaded and uncar the *.sar files

Stop sap and sap services

Do a backup of the exe folder in our case its

Then replace the uncar files into exe folder.

Now restart SAP.

If fail, restore back the exe folder


How to use sap car

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

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

This way, it will not uncar any files but list out the files for you in list.txt.
Find the file in drive C: