SAP BI Real Time Interview Questions (Part -1)

Q: What is the purpose of table T000?

A: Table T000 contains a list of defined clients, which you can maintain with transaction SCC4.

Q: What is the purpose of table USR02?
A: This table stores User IDs and passwords.

Q: How do you create a password exception list?
A: Place the answers in table USR40.

Q: What is the purpose of table TADIR?
A: Table TADIR contains object directory entries.

Q: What is the purpose of table TDEVC?
A: Table TDEVC contains development classes and packages.

Q: What are the transaction codes associated with changing requests, request headers, or request object lists?
A: The following tables hold information about change requests.
E070 Change request headers
E071 Change re quest object lists

Q: How can you get a list of the users with development access on a particular system?
A: Table DEVACCESS

Q: Where can you find a list of object keys included in a transport?
A: E071K Object keys contained within transports

Q: How can you tell if a transport entry is in the process of being imported?
A: Check table TRBAT

Q: How can you find a list of objects that have been repaired in the system?
A: ADIRACCESS List of repaired objects and their access keys


Q: How do you Disable Multiple Logins in the Same Client?
A: To disable multiple user logins within the same client implement this parameter in the instance profile:
login/disable_multi_gui_login = 1

If you do not use this parameter in your system, users have the ability to ignore the warning window at the time they try to login to the same client.

Activating this parameter in your system will make you look good if you get audited!

How about exceptional logins?
In case you're wondering how to allow multiple logins for certain key users you can implement
parameter login/multi_login_users. You can list the user IDs that should be ignored if the parameter above is active in your system.

Q: How can you View Locked Transactions?
A: As you know, you can lock/unlock transaction codes via SM01. But, how do you go about viewing the transactions that are locked in the system? You need to look in field CINFO, table TSTC.

Within SAP, you can use either SE11 or SE16 to browse the table contents. Make sure you enter "A0" as the "HEX01 data element for SYST" starting value and "A9" as the ending value.
This will list all the transactions locked in the
system.
Note: The CINFO field description is "HEX01 data element for SYST".