Sap Basis Interview Questions with answers

1. What are Homogenous system copy and Heterogeneous system copy and

Homogenous

homogeneous system copy is performed when the target SAP system is supposed to be installed on the same operating system and                                          the same database system as the source SAP system. The contents of the database is copied from the source system. 

Hererogeneous

Heterogeneous system copy is performed when the target SAP system differs in either operating system or  database system ,or both 

2.How you will do client copy?

 Client copy are three type

 Local client copy (SCCl)

 Remote client copy(SCC9)

 Client Export and Import(SCC8and SCC9)

3. If SAP* is not available then how u will do?

    Using T-code RZ10 change  the parameter Login/no_automatic_user_sapstar=0

     RZ10 is static parameter so we have to restart the instance ,after restartin changes

Will be applicable

4. After client copy is table space and database sizes will be increased or not?

    

Yes.   DB Size & Tablespace size will definitely increase after
client copy. 

5. How to do client copy fast?

    Increasing the background work process

(or)

Selecting Parallel Processing and setting all required configuration to make client Copy Fast.

6. What are various profiles available for client copy?

    SAP_ALL  -all client-specific data w/o change documents

    SAP_APPL-customizing and application data w/o change docs

    SAP_APPX -sap_all w/o authorization profiles and roles

    SAP_CUSV - customizing and user,variants

    SAP_CUSX - customizing w/o authorization profiles and roles

    SAP_CUST  - customizing

    SAP_USER  -user master records and authorization profiles

    SAP_UCSV -customizing ,user master records and user variants

    SAP_PROF  -only Authorization profiles and roles

    SAP_UCUS -customizing and user master records

    SAP_UONL -user without authorization profiles and roles

7. How to do transport’s between Production and Development?

          

           Using T-code STMS_IMPORT ,

8. How to apply OCS Patches?

    
  Using T-code SPAM

9. How to do client copy?

Client copy are three type

1.Local client copy (SCCl)

2.Remote client copy(SCC9)

3.Client Export and Import(SCC8and SCC9)

10. How to do transports from OS level?

Logon with <SID>adm go to command prompt.

Go to path /usr/sap/trans/bin/

Assume Your DEV to QAS

First add request to buffer.

tp addtobuffer DEVKXXXXX QAS pf=/usr/sap/trans/bin/tp_domain_<SID>.PFL

Now import Phase

tp import DEVKXXXXX QAS client=XXX pf=/usr/sap/trans/bin/tp_domain_<SID>.pfl

Check for the return codes.

11. Where the transport data files will be placed?

       Transport data files ara placed in

      

Path-/usr/sap/trans/datafiles-datafiles start with R(RO,RT,RX)

        /usr/sap/trans/cofiles   -cofiles start with   K(KO,KT,KX)

  

12. How to make security authorization reports?

    

    Using T-code SUIM

13. In which table failed user login attempts will be there?

     

RSUSR006 to check unsuccessful login and locked user

SE16 to browse tables

Tables:

USR02 we can monitor why the user is locked

If the value is 0 the user is not locked

If the value is 64 the user is locked by admin

If the value is 124 the user is locked because of wrong password

14. How to see the t able entry values?

     Using T-code SE16, All tables are stored in DD02L table

,

15. How you will give new authorizations?

    

      Using T-code pfcg,

16. Have you participated in Kernel upgrading and OCS Patches?

      YES

17. Have you done any up gradations?
       

      NO

18. How to configure TMS?
      

      -Loging to 000 client

      -To call the T-code STMS

      -It will display the one pop up box to configer the domain controller

      -Specify the description

      -Transport domain name :Domain_<SID>

      -Save the configuration

Creating virtual system –

 

-        Execute STMS(Domain controller)--- menu overview – system – sap system – create – virtual system

Creating transport routers

   

-        Click on transport routes – from over view menu configuration –standard configuration –three system in group

19. What is transport domain?

       Domain contains more than one transport groups and having only one domain controller

20. What is Consolidation route and delivery routes? How you will identify them?
      

   Consolidation route-  This is the route exits in between Integration system and Consolidation system

   Delivery router-- This is the route exits in between Consolidation system and Recipient system

             transport domain :it is the place the transport layer and routes can be configured to access this transaction use stms

21. Transport error codes and their description?

 Return code (4) indicates imported ended with warning.

Ex:

1.     Generation of programs and screens

2.     Columns missing and Rows missing.

Return code (8) indicates not imported ended with error

Ex:

1.     Syntax error.

2.     Program generation error.

3.     Dictionary activation error.

4.     Method execution error. 

Return code (12) indicates import is cancelled.

Ex:

1.     Import is cancelled due to object missing.

2.     Objects are not active.

3.     Program terminated due to job “RDDEXECL” is not working.

Return code (16) indicates import is cancelled.

Ex:

1.     Import cancelled due to system down while importing.

2.     Import cancelled due to user expires while

importing

3.     Import cancelled due to insufficient roles.

22. The transaction should not be displayed in User Easy access menu. How to do user auditing in sap? What will u audit?

         - Using T-code SM19 and SM20 check the security audit logs

                      

Using ST03 with below procedure:

1.      Start the Workload Monitor by calling transaction ST03.

       2.      Choose the instance and period to be analyzed by double-clicking.

       3.      Choose  Analysis Views -> Transaction Profile ->  Details -> <transaction code>.

       4.      The system displays the usual output area, in which the requested workload is displayed.

You can use even STAD or STAT also

                   

23. How to find users used transaction codes which are not authorized for?

         Go to SUIM  à Transactions à  executed for users

          What is the transaction code to list users who have access to a specific transactions such SM69 and authorization objects.

24. How to schedule online and offline backup which takes every day, every week. How to monitor it

            Online backup – When no system down time it is acceptable ,it is also called as Hard backup. A hard backup can be done even user access.

      Offline backup – This backup is perform when data base is stopped . This is the safest way to take the backup. It is also called as cold backup

Backup schedule in DB13

Backup monitored in DB12

Online backup take every day

Offline backup take every week

25. How will u send mail after completion of backup?.

 You can configure your own Monitoring tree in RZ20 with the following MTE names CCMS_ORA_backup_db_run_pfcl and  CCMS_ORA_backup_db_run_smcl which will give the last backup run and the last successful backup completed or not.

After creating the MTE assign the Auto reaction method to these MTE. This auto reaction method should contain the email id to which the alert should be sent.

29. How to lock or unlock a transaction code using sm01?

  

Using T-code SM01.Look for the transaction you want and then check the “Locke” box.Because some transaction are  “dangerous “ a user without the proper training may accidently corrupt or destroy the system.

                                         

(Or)

       SM01 is a very useful transaction. Not only can you lock transactions from being used at all in the system, but as a general SAP use it can also be used to look up transaction codes, whether for functional information or simply because you forgot which code you need! 1. In SM01, Type the T.Code which u want to lock (for example here, ST03)  and press Enter do not select the Tickbox, Directly click on the tcode and press Lock/Unlock button.

30. How to setup RFC connection in ecc6 tells me steps involved?

-       Using T-code SM59 create RFC connection

-       Go to SM59

-       Click the connection type [R/3 connection, R/2 connection,Tcp/IP]

-       Click on create

Name of RFC connection

Type of RFC connection

Description of RFc connection

-       Go to Technical setting Tab

Specify the Gateway Host/IP adderss

-       Go to Logon security

Client No:<source> ,user id ,pwd,Language

-       Save

-                                                             Test the connection(This is used to test whether we are able to connect to the destination and also it will send some sample date and check at what speed it is sent )

34. What is the database backup strategy in your company?

       

      Online backup every day

      Offline backup every two days

      We are using veritas net backup

35. What is upgrade process? And how u will do that?

       It is used to update the database tables permanently by reading from the temp tables

-       User submit the request

-       Dialogue handle the request

-       Obtain lock from Enqueue so the data consistency is achieced and the records are only for display for other users

-       Updates the request in Temp tables (VBHDR, VBDATA,VBMOD, VBERROR)

-       Get the transaction ID from NRIV (  Number range interval Table)

-       Update get initiated to the update the VB* content permanently into the database

-       Update inherits the locks

-       Update the database in transaction ID

-       Update release the lock from the record in SM12

-       Update monitored using transaction SM13

                              (Or)

-      An upgrade updates an existing SAP system to a new release. The upgrade contains program code and data changes or introduces new areas of functionality.

36. How u will give new authorizations?

  Using T-code PFCG

  

 SU21-creating new authorizations

 SU24-Authorizatio Objects

37. How to adjust user master records? If user master record doesn’t adjust what will you do?  

     

     We can set the option in PFCG to compare automatically .

     Choose the role and display/change button. 
      Goto Utilities -->Settings 

     Just select Automatic user adjustment when saving role   

User Master Reconciliation:  In order to make the roles created or modified to the user we have perform the following

Ø Schedule the PFCG_Time_dependency program periodically to update/reconcile the user master records from time to time  by       defining a background job

Ø Run PFUD (profile update) to reconcile/update the user master record

Ø Use user compare after assigning the role to the user

38. How to check Kernel, tp versions?

        Method 1:

-                      Logon to the Sap instance any client

-                      Go to transaction code SM51

-                      On the SAP servers screen click on the server for which you need to know the information and click on the release notes button

        Method 2:

-                      Logon to the Sap instance any client

-                      Go to menu system –status

-                      Click on the other kernel info at the bottom, look down until you find the kernel patch number

        Method 3:

-                      Logon to the Sap instance

-                      Go to run type cmd and go to command prompt

-                      Now go to Usr/SAP/<SID>/sys/exe/run and type disp+work and press enter

-                      Scroll the listing till you find a line beginning patch number. To the right is the patch number for the SAP instance hosted on this server

Go to command prompt –  just Enter  “tp”  it will display the tp version

39. what is user master record

    The concept of user master records User master records defines the user accounts for enabling access to the SAP system. The user master record is mainly used for user administrative and Authorization management (Role Administration). Normally, the user master record contains the user id as well as a wealth of other information which can be used by SAP system administratorsin managing users effectively.
For example, the user master record contains information which validates a user log on session. User master record  stores important information like users access rights to SAP, user's passwords, the authorization profiles and so on. User master records can be accessed using the Transaction T Code SU01. In t-code SU01, users can be displayed by user id or in case one does not know the user id, users can be displayed using all possible entries.
You need authorizations to create or maintain user master records:

·      Authorization to create and/or maintain user master records and to assign a user group (Auth.object S_USER_GRP).

·      Authorization for the authorization profiles you want to assign to users (Auth.objectS_USER_PRO).

·      Authorization to create and maintain authorizations (object S_USER_AUTH).

·      Authorization to protect roles. You can use this authorization object to determine which roles may be processed and which activities (Create, Display, Change and so on) are available for the role(s) (object S_USER_AGR).

·      Authorization for transactions that you may assign to the role and for which you can assign authorization at the start of the transaction in the Profile Generator (objectS_USER_TCD).

·      Authorization to restrict the values which a system administrator can insert or change in a role in the Profile generator (S_USER_VAL)

41. What are common background jobs that will run in your system?

     

sap_collector_for_job statistics : collects statistical data to analyze the average runtime of periodically scheduled jobs                                                                                          
sap_reorg_jobs                           :  deletes all logs of successfully executed jobs
Sap_reorg_jobstatistic               :  reorganizes the runtime statistics of the background jobs
sap_reorg_batch input               :  deletes process batch input session and their logs as well as all logs for which session no longer exist
sap_reorg_spool                         :    deletes outdated spool objects
sap_reorg_abapdumps               :    deletes entries from runtime errors
sap_reorg_priparams                  :    reorganizes the print parameters
sap_ccms_moni_batch_db                 :    system monitoring etc

43. How to schedule background jobs at OS level?

     log into you Operating System with the SIDadm user id (at the Operating System level) and go to directory /usr/sap/SID/SYS/exe/run

- Run the SAPEVT executable as follows:

sapevt YOUR_EVENT -t pf=/usr/sap/SID/SYS/profile/DEV_DVEBMGS00_server001 nr=01

This will raise the event, and cause the job scheduled within SAP to execute

                           (OR)

Actually we cannot completely schedule background at OSLevel but we can trigger a background job which has alreadyscheduled by using sapevt tool syntax as follows.

sapevt <event name> nr=<instance name> name=<host name>

44. How to add authorizations, how you will maintain profiles?

1.Use T-code PFCG.

2.Enter Authorisation Group.

3.Click on change mode.

4.Open tab 'User

5.Add user SAMPLE1

6.Save

7.Compare the same role either in Display/Change mode.

46. Transport request types and its syntax?

        1.Work bench request -

        2.Cutomisation requet -

        3.transport of copies   - 

        4.Relocation                -

47. Where will u find transport error logs?

   

      you can see the logs in /usr/sap/trans/logs( Alog , Ulog, Slog)   in Os level .For change request log you can view at sap level with

transaction SE01

                                   (Or)

SE10 -- > transport tab at right -- > select transport from list -- > click on log symbol from tool bar

50. How to define instances and operation modes?

Operation modes are used to switching between dialog to background, background to dialog without restarting the server.

  The T codes used are RZ04, SM63, and SM21

RZ04 to define a OP Mode

SM63 to create a time schedule

Time schedule is of two times 1) Normal (24 hours) and 2) Exceptional.

SM21 to monitor system log

          Steps to Setup OP mode:

• Define the Operation mode.
• Create Instance definitions.
• Assign a instance definition to an operative mode.
• Define the distribution of work process for OP Modes.  This distribution is a mix of dialog and batch work process
• Assign the OP Modes
• Define or set the schedule when the modes will switch and to what mode it will switch to

              We cannot delete a OP mode directly, first we have to delete the time schedule and then Delete OP Mode