Showing posts from January, 2008

How to Implement support packages Execute SPAM. Choose Support Package

How to Implement support packages

Execute SPAM. Choose Support Package > Load Packages > From Front End

Locate the CAR file and click OPEN

Select decompress

In case of you get following message, just press Yes to all

Click Display/Define button
Click on your component (eg: SAP_BASIS)
Select the highest level and click OK
It will load the SP to the Queue.
Now click Transport (truck) button
Here you choose to start in dialog or backround
Finish and confirm Queue

Step by step how to create a batch file to replace saplogin.ini

Step by step how to create a batch file to replace saplogin.ini

At times we might need to update items in Sap Logon pad.

The fastest way to do so is to replace the saplogin.ini. (located c:’windows’)

Now to backup your original saplogon.ini - just rename it to

Open saplogon.ini in a notepad. This is how it looks like:

Copy paste all the text at the bottom of the screen and paste it into a new notepad. Rename the text file to

Open the batch file and replace IP address with your own servers below

The above IP address correspond to below system number.

Now you can replace your server description accordingly

Lastly, replace the system name.

Save the "SAPLOGON-BATCH-SAMPL.BAT" on the desktop

Double click the batch file and it will replace your saplogin.ini.

::* File : Replace existing SAPLOGON.INI
::* Created : 00:43 15/12/2007
::* Version : 1.0
::* Copyright (C) 2007

Steps by step to query user with certain plants using Business Explorer.

Steps by step to query user with certain plants using Business Explorer.
In organizational level, plant value is actually an object field called "WERKS"


Launch Business Explorer

Select user master data with authorization

Enter username and execute. Results will be displayed is the excel sheet.

Right click on a cell > Add Drilldown According to > Field Name

Now filter again. Right click > Add Drilldown according to > Authoriz. value low

Keep filtered value

Congratulation! You have listed only plant company code for the user

Find Role inside a Composite role

Step by step to find a role which is used by certain composite role


Execute SE16 and enter Table name AGR_AGRS.

Enter the role into Child_AGR and execute

Here, you can see that role "HKTHH1XQNOTA" has a composite role of "HK1THH_KLIENGMU"

Type of processing in SAP - Online and Batch

Type of processing in SAP - Online and Batch

In a SAP R/3 Production environment, business transactions are carried out in the following modes:
-Online Processing
-Batch Processing

Batch Process is a Job, where SAP R/3 reports/Programs are executed in the background as per the scheduled time. Business Process requirements & System Loads are considered for scheduling background Job. A background scheduler is active within the instances of the SAP R/3 System. For Background processing one background work process is assigned to the background Job till the job completes.

Background jobs run in a special type of work process—the background work process—that is different from dialog work processes in two ways:

1. A dialog work process has a run-time limit that prevents users from interactively running especially long reports. By default, the system terminates any dialog work process in a transaction that exceeds 300 seconds. Although the value of the limit can be changed (in the system profil…

Step by step to create new job using SM36

Step by step to create new job using SM36Guide:

Execute SM36

Enter the Job Name. Click on Step button

A step can be:
- An ABAP program
- An external command- An external program

Enter the ABAP program name. Select the Variant. Click on Check and Save button
*Variant is a predefine set of value which program RSBTCPRIDEL used in our case.

A job can be triggered to run:
-At a predefined date and time
-At the occurrence of a predefined event
Click on the Start Condition button

Background jobs can be prioritized as:
Class Priority
Class A High Priority
Class B Medium Priority
Class C Low Priority
Click on Date/Time button. Enter the scheduled start date and time.

Click on Period Values button. Select the period values. Click on Check and Save button.

Click on Check and Save button

Click on Save button.

The status of the job can be seen at the bottom of the page.

How to manage jobs from the Job Overview - SM37

How to manage jobs from the Job Overview - SM37

Execute SM37

To select jobs to display and manage, refine your job selection by filling out each tab as required. Only jobs that meet all of your specification will be selected.

For job selection with more selection criteria, use the flexible job selection interface by choosing the Flexible job selection button in the toolbar.

Note:Any selection criteria you’ve defined here in the Simple Job Selection area will be transferred to the flexible job interface appropriately.

Explanation for each selection field:
- Jobname: Name of the job as an identifier, which can contain a wildcard (*) to select jobs with related names or by using the wildcard alone
- Username: Name of the user who designed and planned the job (the wildcard is allowed here as well)
- Start date: The start condition of the job, which could be a time frame or an event that the job is waiting for. Specifying both will yield jobs whose starting condition is either of the two cond…

Type of Standard Jobs in SAP system

What are the type of Standard Jobs in SAP system
’There are a number of housekeeping jobs that must periodically run in a live R/3 installation, for example, to delete outdated jobs or spool objects. Please refer to SNote 16083 – Standard Jobs, reorganization jobs for more details.Below are some examples.

User: Creating User in SAP

How to create user in SAP


Execute SU01

Enter user name and press CREATE (notepad)

Enter necessary details such as Firstname and Lastname

Click on Logon Data Tab and enter password a password eg: enjoysap123

Click Save (floppy disk icon). Now you can informed the user that his/her account has been created.

STMS - Steps to perform transport

Consultant & Abapers will request transport from client to client. Once request has been approved, Basis will transport the request using T-CODE STMS

1. On the command field, enter STMS. You will see the above screen. Now, click the red color truck on upper left of the screen.

2. Double click on the target system. In this case, I am going to transport from Development server to Production server. I’ll double click on PRD.

3. Press refresh once to update the transport list.

4. Click on the ‘transport request que (Ctrl-F6) if you see a green colored arrow. Press ok when a window popup.

5. Once completed, click on Import request button (Ctrl-F11)

6. Enter your target client. In my case, its client 800.

7. Click on option tab and untick leave transport request in queue for later import. See above picture. Now click ok.

8. Click ok to confirm when a new windows pop up.

9. Transport has been completed.

News: SAP is still doing great!

From eweek.comSalaries for SAP specializations increased 15.2 percent in 2006, according to research released in February by Foote Partners, a New Canaan, Conn., IT workforce research firm. Data from the first two quarters of 2007 suggests little abatement of this trend.“Right now, anybody who is working in the SAP world, either with functional or technical skills, is doing great,” said Jim Lanzalotto, vice president of strategy and marketing for Yoh, a recruiting and outsourcing firm, based in Philadelphia. “The demands are for specialized skills, and if you’ve got to pick the right market to be a specialist in, the world of SAP is hot.”ERP-related roles accounted for two of the best-paying IT jobs in the second quarter of 2007, according to the second quarter 2007 Yoh Index of Technology Wages, released July 23. SAP technical consultants came in first, with average hourly pay rates of $85.53, and ERP (enterprise resource planning) functional consultants came in eight dollars behind …

Deleting Master Data - user claim and vendor list

Enter OBR2 to open deleting master dataIf you get the below error this is due to existing data
Open FBL1N to check existing data
If you see this there are data, please reserver the entry

Procedure Cache Hit Ratio for database

What is it?
The hit ratio is a mean value that gives a snapshot of a short period of time before the analysis. This value should always be above 95%, even during periods of heavy workload. If the hit ratio is significantly below 95%, the data cache could be too small.
To check the hit ratio:
1. Execute ST04

2. If the hit ratio is below 95%, you will have to increase it.

SAP Basis - Daily check list

Basis perform health check daily on the system. Below are the activity most command check list activity.

SAP Logon Connection Test

1. Double click on all below instance to check if you are able to login.

2. If login were successful, this means server is alive and has no connectivity issue. A new screen will pop up. See below

3. Now you are ready to perform the next activity

DB12/DB13 Create and Check backup status for DB2
1. On the command field, key in DB12 and below screen will be displayed. It shows the summary of the backup status.

2. On command field, enter DB13. This T-code is used to perform backup. You can also check the backup status.
3. In DB13, select a desired cell which you plan to perform your backup. Double click on the cell

4. Choose Full database backup to device

5. Backup mode: Offline

6. Device directory: ‘ d:’backup’ (this is just a folder which your backup could be stored)

7. Below is a sample picture.

DB02 Check Database size for DB2
1. Use DB02 to check DB size
2. Database cur…