How to apply a note in SAP system ?

How to apply a note in SAP system ?

 This article answers the following queries :

•      What is SAP note ?
•      What is the use of SNOTE transaction code ?
•      How to apply a SAP note in SAP system?

What is SAP Note ?

SAP releases  notes on regular basis to provide the corrections/minor improvements to the existing bugs/issues/functionalities. Since periodicity of release of Support packages is very less, to resolve customer issues SAP releases notes to customers on regular basis to fix bugs.

 What is the use of SNOTE transaction code ?

A note can be applied in SAP system using SNOTE transaction.

 How to apply a note in SAP System ?

Before applying any note, please download SAP note. Go to SNOTE transaction and navigate as shown below and download the note that is to be applied

Enter the note number to be downloaded and press execute button to download the note as shown below 

 

You can view the downloaded note in the “New” section under SAP notes as shown below.

Once the note got downloaded, to implement the note, select the note as shown below and click on execute button to implement SAP note

After that, system prompts you to confirm that you have read the note. Please make sure you have read the note thoroughly before you implement the note. Please find out the applicability of the note to your system by cross-checking with the system SAP release/version/database etc.

As shown above press Yes button to confirm that you have read the note and proceed further. 

 

In the information popup window, press continue as shown above.

After that, systems prompts for transportable workbench request. Please click on create request button as shown in  below screen.

In the create request popup screen, please provide request details and save to create request as shown below screens 

After that, list of changes that are being made will be displayed as shown below. Click on continue button to proceed to apply the changes

 Click on continue button in the  below screen to proceed further

Once the SAP got implemented successfully, it moves from New section to Processing section as shown below

Enter your email address:

Delivered by FeedBurner

Read More

How to terminate a user session in SAP?

This article answers the following queries :

•     How to terminate a user session in SAP ?
•     How to kill or terminate a process in SAP ?
•     How to log off a user either locally or system-wide in SAP ?

 Sometimes  there will be a requirement to terminate a user session.

For example: An user has run a report or program with inappropriate selection criteria, which leads work process going to PRIV mode occupying so much memory impacting performance of the system. In those cases, you will have to check with the user and terminate his session or logoff user system wide if he is no longer working.

To terminate a user from the system either locally or system wide :

Go to SM04 transaction. Select the user to be terminated. In the below example am terminating user TEST from the system.

Go to User -> Log off user -> Local   (To log off user from this instance alone)

Go to User -> Log off user -> System-Wide (To log off user from all the instances of the system)

How to terminate a process in SAP ?

If you would like to terminate a particular process of a user which is impacting a system proceed as follows :

Go to SM50 and identify the process and highlight the same. Go to Process -> Cancel without core and execute the same.

System prompts you to confirm the deletion of process.

Click on Yes to confirm the termination. System terminates the process and prompts a message on the screen confirming the same as below

Please note in the above scenario, a process can be terminated through “Process -> Cancel with core” option also but in this case core file will get generated regarding the same

Enter your email address:

Delivered by FeedBurner

Read More

What is Dpmon tool ? How to use it ?

This article answers the following query :

• What is dpmon tool ? How to use it ?

What is dpmon tool ?

dpmon is an auxiliary tool provided by SAP to use from operating system level. This tool provides the functionalities similar to workprocess overview of SAP (SM50 or SM66).

This tool will be of great use if by any reason, we are not able to login to SAP system through SAP GUI. We can use dpmon and login to SAP system at operating system level and we can identify the reasons for the issue and we can action accordingly.

How to open dpmon tool ?

(Am demonstrating the usage of dpmon tool based on AIX or HP-UX operating systems)

Login to Central Instance(CI) host of the SAP system using  <sidadm> userid.

After logging in goto the CI, please go to the profiles path.

You can use any of the following commands to go to the profiles directory

cd /usr/sap/<SID>/SYS/profile          (or)

cd /sapmnt/<SID>/profile                   (or)

cdpro

Please find below screenshot

Use the command as shown below :

dpmon pf=<profilename>

It displays “Dispatcher Queue Statistics as below”. In this screenshot we can figure out if any dispatcher waits are there

Click on l in the above screenshot to view work process overview as below :

From the above screen, we can make out if all the dialog workprocesses are full.

In that case, PID of a problematic process can be taken and that process can be killed at Oslevel by Kill -9 <PID>. After that you can login to the system as you have just killed one dialog process and it is free so that it will allow you to login to the SAP system from SAPGUI.

In addition to that, following are the commands that can be executed in dpmon tool in the above screen :

Press k  to kill workprocess (with core)

Press s to stop workprocess

Press q to quit from dpmon tool

Enter your email address:

Delivered by FeedBurner

Read More

How to troubleshoot when no one is able to login to SAP system (ABAP stack)?

This article answers the following queries :

• How to troubleshoot when no one is able to login to SAP system (ABAP stack)?

• What could be the reasons if no one is able to login to SAP system (ABAP stack)?

Sometimes users may complain that they are  :

i)       Unable to login to SAP system from SAPGUI

ii)      Other users who have already logged in may complain that system is not responding

iii)    Some users who have already logged in may complain that system is very slow and response time is very high

Please note that in most of the above cases even SAP basis administrator cannot login to SAP system through GUI. So, he should use database, operating system tools (like PuTTy) and dpmon to identify the issue and troubleshoot.

The most likely reasons for all the above scenarios could be

i)          Oraarch is full and system is not able to respond to user queries due to that and all dialog processes are occupied within a while due to that and system is not allowing any other users to login due to lack of dialog workprocesses

Solution :  As even basis administrator cannot login through SAP GUI at this point of time, Please check at operating system level. If you find that oraarch filesystem is 100% full, please trigger archive log backup immediately and make sure there is enough space. Once there is sufficient space, system will start processing and all the dialog users activities will be resumed and within a while there will be free  workprocesses to login and issue will get resolved

ii)           Some critical filesystem at Oslevel is full and system is not able to perform any activity due to that. Within a while all the dialog workprocesses are full and no other user is allowed to login

Solution :  As even administrator cannot login through SAP GUI at this point of            time, Please check at oslevel whether any filesystem is 100% full. If so, please contact OS team and make sure sufficient space is free either by requesting them to add  more space or by deleting some unnecessary files

iii)        Some tablespace like PSAPSR3 is 100% full and system is not able to perform requests of existing users. Within due time all the workprocesses will get occupied and system will stop responding and it won’t allow any other new user to login due to lack of free workprocesses

Solution :  (In Unix related Operating systems (AIX, HP-UX), login to system                 through <ORASID> user and run brtools to run whether any tablespace is 100% full. If so, please add some datafiles and make sure sufficient free space is created. After that system automatically resumes processing.

iv)    Update got deactivated and system is not able to perform updates and thus all dialog/background workprocesses are full within due time and system is not allowing any other users to login

Solution : In some cases, in all the above error cases i) , ii) and iii) , SAP system may deactivate update automatically to prevent loss of data. So, after fixing the respective issue, we need to manually activate the update through SM13 so that system will resume processing. But you can activate the update only if system allows you to login through SAP GUI.

If you are not able to login to SAP system through SAPGUI, please use dpmon tool to do the same.


How to use dpmon tool

v)          Other scenario could be some processes has gone into PRIV mode consuming so much memory. This leads to memory bottlenecks and all other users requests will either take lot of time to process thus experiencing slowness or high response times.

After a while it also may happen that all dialog workprocesses got full and no other user will be able to login due to lack of free workprocesses

Solution :  This has 2 scenarios :

i) If you are able to login to SAP system through SAPGUI, please goto SM66 and identify the processes that have gone into PRIV mode. After identifying the transactions that are being run in PRIV mode, please check with respective user and terminate the processes or logoff the users from the system after confirmation that his process is non critical and can be terminated.

Terminating user session

ii) If even basis administrator could not login to SAP system, then use dpmon tool to identify the processes that have gone to PRIV mode.

How to use dpmon tool ?

 After identifying processes that have gone to PRIV mode, cross check with the user and after confirmation that his session can be terminated, kill his session by providing PID number

For example: In AIX or HP-UX use command below

Kill -9 <PID>

In the above command, PID is process identification number.

After that system will release all the memory allocated to PRIV mode processes and will sytem will start processing normally.

Enter your email address:

Delivered by FeedBurner

Read More

How to run a report in SAP?

This article answers the following queries:

• How to run a report or program in SAP?
• What is the need of RSBTCDEL program?
• How to delete old background or batch jobs in SAP?
• How to run a report in background in SAP ?

----------------------------------------------------------------------------------------

In SAP environment, there will be frequent requirement by ABAPers /functional/technical team to run various reports. This can be done through SE38 transaction code.

Go to transaction SE38 as shown below and provide the program/report name which you would like to run.

In the below example, am running a report / program RSBTCDEL which is used to delete old background jobs

Click on execute button to run the report. Depending on the program/report, you will be prompted to enter the input parameters(variants) so that system can action the same.

In the below report, am selecting to delete all batch jobs that are with username BASIS , older than 30 days and which are finished or canceled.

Click on execute button, once you have provided the inputs. Then the program will run in dialog mode and the status similar to below screen will appear on the status bar.

How to run a report or program in background mode in SAP?

In case you would like to run the program in background, please follow these steps:

Navigate to Program -> Execute in Background as shown below

Once you execute as shown above, program will run in the background.

Enter your email address:

Delivered by FeedBurner

Read More

How to view the contents of any table in SAP ?

This article answers the following queries :

• How to view the contents of any table in SAP ?

• What is the use of data browser in SAP ?

• What is the transaction code for data browser in SAP ?

• How to find out number of records in a table in SAP?

Data Browser  in SAP is used to

                      

• View the contents of a table
• Find out number of records in a table

Data Browser can be accessed by transaction code SE16 in SAP.

Go to transaction SE16 as shown below :

Please provide the tablename of which you would like to view the details  and click the highlighted button in the above screen to view the following screen.

In the above example, we are viewing the contents of T000 table

Click on “Number of Entries” pushbutton to find out number of rows in the table.

Click on close to close the above window and click on execute button to view the contents of the table as below.

Enter your email address:

Delivered by FeedBurner

Read More