SAP BASIS Interview 2

SAP ERP BASIS Interview Questions sets

Q1. Where to check for system logs of Sap application at os level?
Ans.       1. At OS Level:       /usr/sap/sapsid/sys/instance/work
                2. T-Code:           SM21


Q2. How to know whether a system is Unicode or non-Unicode?
Ans.       1. T-Code:- SM51 Then click on "Release Note" button from application toolbar
2. Logon SAP System, Click on "System" ==> Status
3. At OS Level: command:-  "disp+work -version"
Q3. What are common transport errors?

Ans.       RC (Return code) - 4  indicates imported ended with warning.
Ex:          1. Generation of programs and screens
2. Columns missing and Rows missing.
                RC (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.
RC (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.
                RC (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.


Q4. what is the standard program to check the consistency of partner profiles?

Ans.       RSECHK07
Q5.How to transport users from one client to another?
Ans.       Sol-1:     1. Goto T-code:-  SCC1
2. Choose the Source client from where the Users to be transferred to other client
3. Chose the SAP_USR profile
4. Transport request NO. is generated
5. Release the Transport request and export
6. Import the transport request into target system
                Sol-2:     1. Use the T-code:- SCCL
2. Enter all the required details such as source client and the profile (SAP_USR).
3. Then schedule it in the background(Give some time if necessary so that there is no performance                                 issue).
                Sol-3:     1. Use the T-code:- SCC8
2. You can see selected profile is SAP_USER
3.Choose the System client from where the Users to be transferred to other client.
4. Click on Scheduled as background job.
5.Release the transport and import the transport
                Note: we cannot transport selected users in SAP.

Q6.How many transport request types are there?
Ans.       Four types of transport requests
1. Customizing request
2. Workbench request
3. Transport of copies
4. Relocation



Q7. What is Consolidation route and delivery routes?
Ans.       The route between development to quality is calledconsolidation route.
The route between quality to production is called delivery route.
It is used to transport data dev-->qua-->prod.
Only in Consolidation route the objects can be changed and we can transport to one system to another system but in Delivery route changing the object is not possible and we can't transport it. Simply we can say objects are change and transport is possible in Consolidation and it is not possible in Delivery Route


Q8. What is the importance of the client 000,001 and 006?
Ans.       000 client - it is a default template client which contains SAP templates. It is used for applying patches, language imports, add-ons and configuring STMS.
001 client- It is a backup of 000 client.
066 client- It is a early watch alert client, which is used by SAP for early watch alert reports. If there is any problem with the SAP system then the early watch client throws the alerts.


Q9. What is Bex?
Ans.       BEx (Business Explorer) is the reporting tool used to work with data in the BW database. BEx has a Web-based user interface and is made up of two components, the BEx browser and the BEx analyzer.
The BEx browser provides an organized interface where a user can access and work with any type of document assigned to them in the Business Information Warehouse, such as workbooks, links, and BW Web reports. The BW database itself is segmented into discrete data areas called
InfoCubes that are made up of data and associated metadata. The BEx analyzer allows the user to examine segmented data in a variety of useful combinations, for example when comparing financial data for different fiscal years.

Q10. What SAP tools you use to install SAP patches?
Ans.       SPAM is the sap tool used to install sap patches
But if patches is less then 10MB at that time you will Run transaction SPAM , if patches greater then 10 MB at that time you hav to UN car by using SAPCAR File name and after UNCAR put the file in /usr/sap/trans/EPS/in

Q11. what is the full name of SAP Default user DDIC.
Ans.       DDIC stands for DATA (D) DICTIONARY(DIC)- DDIC

Q12.      How can i check the user login details activity in a month.
Ans.       1. SUIM - has the history of log in by user if you don't have your configuration audit log active.
                                Ex.          SUIM à  User Information System à Change Documents à For Users.
                2. Through SM20 we can check the user login details.
Ex.          By configuring audit log through SM19 and checking log in SM20.
                3. We can check the user activity details for a day/month/year from ST03/ST03N.
st03n - total (under this select the required day/week/month/year ->Transaction Profile ->Standard.
we will get the transaction details of a user

Q13. What JAVA tools to install JAVA Patches?
Ans.       SAP Installer (SAPinst.exe) is used to apply the Java patches.
                In latest sap versions tools like SDM and JSPM are used to deploy the Java patches.
                Even SAP Kernel can be applied using JSPM tool.

Q14. What is the difference between Synchronous and asynchronous transports?
Ans.       Dialog or batch process is blocked until import has ended in synchronous transport.
Dialog or batch process is released after import is started in asynchronous transport.
Two programmer(Threads) at a Same Time is call synchronous and Two Programmer At different time is call Asynchronous.

example: audio and Video at Same time is synchronous audio and Video is different time is Asynchronous.


Q15. How you will do client copy? If SAP * user is not available at all in your system then how u will do client copy?
Ans.       Just goto RZ04 and increase the number of background processes in the specified operation mode.We do a system copy using SCCL transaction.
If SAP* is not available,
 login at OS level as SIDADM and sqlplus /nolog connect /as sysdba;
delete sapsr3.usr02 where mandt='<client no.>' andbname='SAP*';
goto /usr/sap/SID/SYS/profile and change the default profile.
Add the parameter login/no_automatic_user_sapstar=0
0R
goto RZ10,select default profile and extended maintenance and change.
add the parameter login/no_automatic_user_sapstar=0
There will be no chance of having SAP*.It may be locked.If u delete SAP* from database then automatically SAP* is created with password PASS.

OR
You can edit the default profile and add the parameter login_no_automatic_user_sapstar=0
and restart the server...
You can also do it from SAP level if u have a admin authorization user...
login with that user and goto rz10 and edit the parameter login/no_automatic_user_sapstar=0 and restart the server.After changing the value the user SAP* will be changed to PASS.
Using that you can login into new client and can do client copy.

Q16. How can we creat a Z authorization object and what the procedure and the T-code for the same?
Ans.       Tcodes for Creating z authorisation onject - su20,su21.
su20 - create the authorisation field list.
su21 - Create a object class,include the addedauthorisation object. Select the t-code assignment and assign to the needed t-code.
Go to the User profile and add the object manually give the authorization.


Q17.      How to transport from uses from one client to another?
Ans.       1. First export the objects for transport from the
table AQLDB to the transport table AQTDB.
This creates a transport request for the transport system that includes all entries created by the export from table AQTDB (transport dataset). The request covers all the entries from table AQTDB (transport dataset) generated by the export and has a name which corresponds to transport
system conventions (sysKnnnnnn).
In the table AQTDB, the transport dataset is stored under a key which matches the name of the transport request.
If you are transporting within one SAP system (that is only from one client to another),
you can also import the transport dataset from the target client.
In this case, you use the name of the transport request which is specified during the export and matches the key of the transport dataset in the table AQTDB.
During this import, the system reads the transport dataset from the transport table AQTDB into the table AQLDB.
At the same time, it performs numerous checks which ensure that no inconsistencies occur in the table AQLDB.
                2. first ralease or export the object on target system.
now login parent clients and hit T.code- stms -> import overview
now add the request from extra-> other requests->add
select the request and click the import the request now fill the client no.
and then continue...Now your object is import to another clients.


Q18. How to monitor user accessed transactions (Tcode) day wise?
Ans.       T-Code: - ST03 and then follow the path
                ST03 à Load History and Distribution à double click on “Users per instance” à Double Click on “Instance”.
Q19. What are the .sca files and their importance?
Ans.       .sca stands for SAP Component Archive.
SCA Format (Software component Archive) is a usual format for Support package files. Support Packages contain number of patches which are in SDA ( Software Development Archive) Format.
.sca or .sda for SAP deployed Archive
These two are same and it use to deploy the java components,patches and other java developments in the form of .sca,.sda, .war and .jar.

Q20. What is the difference Between Role and Profile?
Ans.       Profiles are the component of the older SAP releases, this was not replaced in the newer versions but a new layer was placed above Profiles, Roles.
Profiles are therefore a subcomponent of Roles, they have a one  to many relationship where when authorization objects overflow one profiles limit it will create a second profile for that Role and so on.
Roles are logically assigned to users to give the newer functionality of Roles (Menus etc), but profiles are assigned to give the authorizations.
Role : It refers to collection of activities like transactions, reports.
Profile: It is set of authorizations that are valid for transactions defined in the role
1. Profile is a set of authorization objects, but a role is a set of profiles.
2.In a profile we can add up to 150 authorization objects, but in role there is no limit.
3. Profile cannot be manually editable, but role can be manually editable.
4.In a profile we cannot create the user menu, but in role we can create the user menu.
5. Profile is the subset of role, but role is not the subset of profile.
6. Profile can be created only for the transaction codes, but in role we can add t-codes, web addresses and reports etc.



Q21. How to schedule background jobs at OS level?
Ans.       Invoke a sap event using an OS script and then have a SAP background job set to run on a sap event. I say this assuming Unix and a job in crontab. I would guess the same thing could be done on a Windows system.
sapevt TRIGGER_NAME -t
pf=d:usrsapDEVsysprofileDEV_DVEBMGS00_SVRNAME nr

Q22. How to define Logon groups? And what is Logon load balancing?
Ans.       Logon group are set using SMLG transaction.
Load balancing:
During the request message server check for the least loaded instance in the group and route the request to that instance.
If instead of logon group we specify the instance then the request is routed to that instance only. Means no load balancing occur in this case.
Q23. What is Consolidation route and delivery routes? How to define Logon groups? And what is Logon load balancing? What is Transport domain and Domain controller?

Ans.       consolidation route:Consolidation route is defined between the development system (consolidated system) and the quality system (integration system)
Delivery route:
Delivery route is the transport route that connects the integration system (Quality system) and the Delivery system (Production system)
Defining Logon Groups:
We can do this though our GUI and always make sure that saplogon.ini is backed up, that consists of all the logon data
Logon Load balancing:
It is used to identify the least loaded application server
Domain controller:
It is the central admin of the system
Transport domain:
It is the place the transport layer and routes can be configured to access this transaction use stms.
Q24. How to install multiple Central Instances on the same physical machine?

Ans.       To have multiple CI in a single physical machine we need to Install Microsoft Cluster Services, then we can install multiple CI with different Instance no with the same SAP<SID> for High Availability.
Q25. Can SAP patches be installed when other users are online?
Ans.       No, We can’t do this because there will be some programs and tables which will get updated when applying support packages.
If some user is using that program or table then the support package manager will not be able to update and it will terminate with dump. So it’s better to apply support packs when there are no users login into system. Performance will also be better if there is no user login into system.
Q26. How to increase tables space, resizing, backups and in what situation are these done?
Ans.       Brtools are use to prefome all the database related task in sap. Always use <SID>adm or ora<SID> user to access brtools. when oracle is used as database in that case brtools is used for performing database related task.
Q27. What are the current kernal patch level and current support patch level?
Ans.       Check into service market place to get the current kernel patch level and current support patch level.
Example:
For ECC6 SAP KERNEL 7.00 32-BIT -> ORACLE -> Windows Server on IA32 32bit, the patch level is 33
Support Patch levels
Basis patch level 15
ABAP Patch level 15
APPL Patch level 12
PI_BASIS 16
ST_PI 6
SAP_BW 17
SAP_APPL 13

Q28. What is supplementation language?
Ans.       The default languages for newly installed system are German and English. SAP support many other languages. Any other language except English/German may not fully translate. TO fill this gap supplement language are installed on the SAP system.
Supplementary Language:
It is the additional language (program) installed on the SAP system when additional language which is not fully translated to the basic language of SAP (English/German).

Q29. What is the procedure to lock a client?
Ans.     
 Question: When creating a logon group for Logon Load Balancing, which of the following CANNOT be specified? A.  Maximum allowable response time.    B.  Maximum number of users who may be logged on to the instance.   C.  Name of the instance defined for the logon group.    D.  Maximum number of sessions per user.   E.  Name of the logon groupQuestion: Which R/3 System user is used for starting external programs using SAP background jobs? A.  DDIC   B.  SAP*   C.  SAPR3   D.  SAPCPIC   E.  <sid>admQuestion: Name the R/3 System transaction used for mointoring a spool requests. A.  SM50   B.  SM51   C.  SPAD   D.  SP01   E.  SM37Question: Which of the following is authorized to maintain R/3 user id parameters? A.  Only the R/3 system administrator.    B.  All R/3 users having an account in the same R/3 client.   C.  Only the user himself.   D.  Only the R/3 system administrator and the user.Question: Given a LAN with an R/3 Central Instance with database (Node: host1, Instance Name:DVEBMGS01, SAPSID:C11), and R/3 Dialog Instance (Node: host2), and several R/3 Frontend PC's what is the name of the profile where the SAPDBHOST parameter is defined? A.  C11_DVEBMGS00_host1   B.  The SAPDBHOST parameter is defined in the database startup profile.   C.  TEMU.PFL   D.  DEFAULT.PFL   E.  START_DVEBMGS01_host1Question: Given and R/3 Central Instance with all services installed, using Instance ID01, and having the SAP ID of C11.  What is the name of the directory where the work process trace files are written (for Windows NT replace the "/" with "\")? A.  /usr/sap/C11/DVEBMGS01/data   B.  /usr/sap/C11/DVEBMGS01/log   C.  /usr/sap/C11/DVEBMGS01/work   D.  The trace files are written in internal database tables.   E.  The trace files are written in the home directory of the database.Question: Which of the following functions is NOT possible using the SAP Online Service System (OSS)?A.    Execute online searches for R/3 Notes. B.     Register problems with the SAP Hotline. C.     Lookup SAP training dates and course offerings. D.    Register changes to SAP objects. E.     Apply for official Internet address from SAP. 

 All is possible