Saturday, 25 June 2011

SAP Netweaver Interview Questions with answers - Set 3

SAP Basis Interview Questions - Set3

This article covers interview questions for SAP Basis/Netweaver consultants (Mostly for below 3 years experienced consultants)


1) What is spool overflow ? (0r)
   How to delete old spool requests ?    (0r)
   How to troubleshoot spool overflow ? (0r)
   How to avoid spool overflow issue ? (0r)
   How to check spool numbers? (0r) 
   How to set the spool number in SAP ? (0r)
   How to define storage location (Temse) of spool requests ?

2) What does spool request contain ? (0r)
   Where is the spool request stored ? (or)
   What are different Spool statuses and their significance? (0r)
   Which workprocesses will create spool requests? (0r)
   What is the difference between spool request and output request ? (0r)
   Which workprocess will create output request  or print  

3)  What is the database administration tool supported by SAPfor oracle database? (0r)
    What is BRTOOLS ? (0r)
    How to access BRTOOLS ? (0r)
    How to add or extend datafiles in sap system based on oracle database?

4) How to check the update status ? (Or)
   What is the reason for update deactivation ? (0r)
   How to activate or deactivate the update ? (Or)
   What is the parameter to be set to switch off automatic update deactivation ? (0r)
   How to troubleshoot, if update got deactivated ? (0r)
   What happens for the updates that are in progress, if update got deactivated ?

5) What is a workprocess ? (0r)
  What are the different types of workprocesses and their functionality ? (Or) 
  How to increase/decrease the number of  workprocesses?

6) What is a SAP lock ? (0r)
   Different types of SAP locks ? (Or)
   Difference between Write lock(E) and Enhanced write lock(X) ? (Or)
   How to monitor SAP locks ? (Or)
   How to delete SAP locks ?

7) How to configure an Early watch Alert Report in Solution manager?

Answer : How to configure Early Watch Alert report

8) Explain Oracle architecture

Answer: Oracle Background Processes

9) How to apply a SAP note

Answer: Applying SAP note

10) How to perform Kernel upgrade?

Answer: Will be provided soon

SAP Netweaver Interview Questions with answers - Set 2

SAP Basis Interview Questions - Set 2

This article covers interview questions for SAP Basis/Netweaver consultants (Mostly for below 3 years experienced consultants)


1) How do you troubleshoot a long running transport (or)
   How actions do you take when a transport is running for a lot 
   of time (or)
   How to terminate a long running transport (or)
   A transport is in truck status for unusually long period of 
   time. What could be the reason ? How do you troubleshoot (or)
   Transport is not getting terminated and all your other 
   transports are pending to be imported. How to terminate this 
   long running transport ?

   Answer :

2)  What is an RFC ? What is the significance of RFC  (or)
    How to create an RFC in SAP system ? (or)
    How to different tests you do to check an RFC is functioning  
    well in SAP ? (or)
    How to delete an RFC ?

     Answer :

3) How to configure printer in SAP ? (or)
   What is the Tcode to configure printer in SAP ? (or)
   How to check the spool requests in SAP ?

   Answer :

4) How to check database size ? (or)
   What is the size of your R3 or BIW database ? (or)
   How to check tablespace details in SAP ? (or)
   What all can you check or perform with DB02 transaction ?

Answer :

5) How to view database parameters ? (or)
   Name some of the database parameters ? (or)
   How to view database parameters change history ? (or)
   How to findout which database parameters are changed after a 
   specific date ? (or)
   Some parameters are changed at Database level and after some 
   days performance problems are encountered.You would like to 
   revert the parameters. How to identify which parameters were 
   changed ? (or)
   How to view a value set for a particular database parameter ?

Answer :

6) A user complained that he is facing performance issues if he running a particular transaction/report. He says all other transactions are running fine for him as well as for others. How to you troubleshoot this issue ? (or)
How to activate a trace for a particular user in SAP ? (or)
What is the transaction to activate trace in SAP ? (or)
What are the different traces that can be taken in SAP or ST05 ?
How to do performance analysis of a particular transaction in SAP ?


7) Many users are complaining that their transactions are getting completed and they are encountering TIME_OUT dumps after a very short period. Same is happening well if they are running them as  
background job. How do you handle this scenario ? (or)

   In ST22, you are frequently encountering TIME_OUT dumps. How do you avoid them? (or)

What are the various reasons for TIME_OUT dumps? (or)

What is the parameter in SAP which limits the maximum permitted runtime in the dialog mode?


8) You have forgot SAP login password and donot have any other passwords to login. How do you login to SAP ? (or)

How to activate automatic sap* user in sap? (0r)

Unable to login to newly created client with sap* and default password. How to login now? (0r)

Sap* user got locked. Donot have any other user id to unlock the same. How to login to system again?
Answer :
9) What is lock table overflow ? (0r)
   How to identify lock table over flow issue ? (0r)    
     What is the parameter to be changed to increase lock table size 
     in SAP ? (0r)
     What is the reason for lock table overflow ? (0r)
     How to resolve lock table overflow

  10) What are the prerequisites and uses of  config tool ? (or)
    What are the prerequisites and uses of Visual Administrator ?  
    What are the limitations of Config tool ? (0r)
       What is 
    the difference between Config Tool and Visual Administrator 
    tools in SAP?

SAP Netweaver Interview Questions with answers - Set 1

SAP Basis Interview Questions - Set 1

This article covers interview questions for SAP Basis/Netweaver consultants (Mostly for below 3 years experienced consultants)

Iam sure, these questions are very repetitive and you will surely suceed in the interviews. 

Wish you a happy job search :-)


1) Tell me about yourself 

Answer : 
  •  Please give background to the interviewer about the educational and  professional experience you had like Iam Arun, have completed B.Tech Computer science engg from xxx college, xxxx city
  • Have joined xxxx company and had xx years of  monitoring, implementation ,support experience. Comfortable with Oracle/DB2/MaxDB database, AIX/windows/HP-UX Operating system etc.
  •  If you had any specific exposure like solution manager CHARM implementation, Redwood Jobs scheduler implementation etc, please highlight the same to the interviewer.
  • Please make sure, you highlight the summary of your CV like experienced in SAP ABAP+Java stack, Performance Tuning, worked on various tools like Visual Administrator, Configtool, BMC patrol etc

2) What are your daily activities ?

Answer : You can talk about 
  • Daily monitoring of the landscape
  • Taking proactive measures to avoid issues
  • Backup mechanism
  • Ticket resolution based on some SLA etc
  • Identifying Root Cause for the frequently occuring issues

3) What are the monitoring activities you do ? What transactions do you use for monitoring
ABAP stack or Java stack ?

Answer : Please go thorugh following link to answer the same

4) What are the different status of background jobs ?

Answer :

5) How to find out long running jobs in SAP ? What actions you take on those long running jobs ?
 How do you troubleshoot long running jobs ? What are the different job classes ?


6) What are the basis standard jobs ? What is the significance of those jobs ? 
Name some basis standard jobs ? How to schedule them ? On what frequency they should run ?

Answer :

7) How to change SAP Parameters ?
What is the Tcode you use to change SAP parameter ?

Answer : 

8) Will the SAP parameter changed becomes effective immediately or it needs restart ?


What is the difference between dynamic and static parameter ?

Answer :

9) Do you have any idea about Change and Transport System in SAP ?
Explain about TMS (Transport Management system) in SAP ?
What are the transport tools in SAP ?
What is the functionality of TP and R3trans in SAP ?

Answer :

10) Have you done any transports ? Explain the process to do the same ?

Answer :

Friday, 24 June 2011

Troubleshooting long running transport

This article answers the following queries :

  • How to troubleshoot when a transport is running for unusually long duration and not getting completed or terminated ?
  • How to troubleshoot when a transport is in truck status for a long duration of time ?
  • How to cancel a transport request which is in truck status or running status ?
  • How to terminate a long running transport request to re-import again ?
  • Transport is not getting terminated. How to do terminate?

How to troubleshoot when a transport is running for unusually long duration and not getting completed or terminated ?

Go to transaction STMS_IMPORT and identify the transport which is running since a long duration.

In the below screenshot, transport with the truck symbol is the long running one

Thursday, 23 June 2011

How to import transport into an SAP system ?

This article answers the following query :

  • How to add a transport to the import queue of a SAP system?
  • How to import transport into an SAP system ?
  • What are the different modes of transport request and their significance ?
  • How to check the transport log of a particular transport request ?

Login to the system in which you would like to import a transport request and go to transaction STMS_IMPORT as shown below :

Press Ctrl + F and search for the transport request to be imported into this system.

If the request is not yet added to the import queue, navigate to Extras -> Other Requests -> Add   (as  shown in below screen)

Once you click on add, you will be prompted to enter transport request details as below:

Please enter transport request number and tick Import Again checkbox and press icon.

System then prompts you to confirm to attach transport request to import queue of the system. Press proceed to confirm the same.

Then transport will get added to the import queue.

Now to import the transport, select the transport and press truck button to import the request

Then system prompts you to enter following details :

Please provide Target client number and select immediate radio button to import the request immediately or specify timing or event details in case you would like to carry out the transport at a later point of time.

In the execution tab, select the mode of import synchronous or asynchronous.

If import is executed synchronously, dialog or background process is blocked until import has ended. If import is executed asynchronously, dialog or background process will be released after start of import.

What is the different modes of transport import ? What is the significance of them ?

Once you provide all these details, press tick mark

Click on Yes to confirm import which triggers import of transport into the system and will return the return code after completion.

Once import is done, you can check the status of import in the import log  by selecting the request number in the import queue and press logs icon as shown in screen below :

This will display the overview of transport log as shown below. If all steps are successfully completed then the import is successful. If any of the steps failed, try to identify the reason for failure, troubleshoot and try to import again.

Related Links :

How to create an RFC Connection in SAP ?

This article answers the following queries :

  • How to create an RFC connection ?
  • How to test RFC connection ?
  • How to delete an RFC ?

How to create an RFC destination ?

Go to SM59 transaction :

Click on create icon in the above screen, which leads to below screen

Specify RFC Destination name and description and connection Type in the above screen

Please note respective connection type to be selected from dropdown based on the connection required. Usually 3 is for ABAP system. (Pls find screenshot below)

In the below screen, please select load balancing radio button based on your system setup (i.e if there is load balancing configured for your system, specify it as yes otherwise no)

Please provide Target host details like hostname or ipaddress and system number as below:

As shown below, Proceed to Logon & security tab and provide following details :

Select trusted system as no, in case you would like to connect to a system with a user id and password.

 If you don’t want to get authenticated by credentials specify the system as trusted system which won’t prompt to enter user id/pwd credentials in the below screen.

Please provide Language details like EN (for English), Client details, User id and password for the system you would like to create a connection.

Please leave default values in other tabs (i.e MDMP & Unicode, Special options, Administration) and then click on Save to complete the RFC creation.

How to Test RFC connection ?

If it functioning well it should show output similar to below screen :

If this is fine, come back to earlier screen and execute Unicode test by clicking the button. Output similar to below screen, should be displayed if connection is OK

Also you need to perform authorization test to make sure user id / password credentials provided are correct.

Please navigate as below and perform the test :

Navigate to Utilities -> Test -> Authorisation test and click  the same to execute.

If the RFC configuration is fine, screen shot similar above will appear. Otherwise an error will be displayed based on which you need to troubleshoot to fix the issue.

How to delete an RFC ?

Goto SM59 and select the RFC that is to be deleted as shown below :

And click on delete icon

Click yes to confirm deletion, which deletes the RFC.

Click on Connection test tab to check the connection for the RFC

Related Links :