I need some basic information on SAP: What database platforms are supported? What operating systems are supported? And what kind of support is there for a mobile environment?

Have a look at http://service.sap.com/platforms*. All database and operating system platforms supported by SAP are listed there.

* Authorization required to access the SAP service marketplace.

How many backups are required from preparation to end of an upgrade and at which phases?

Take your daily online backups during the uptime phases as you would normally do. Please note that your system is still being used productively and you cannot afford data loss. In case of disaster, you will restore the daily backup, roll-forward up to the crash and roll-back the upgrade to re-start it from scratch. A backup is definitely needed at the beginning of the downtime phases as it is the point of no return. Another backup is needed before the go-live.

How can I clone an SAP system for a sandbox purpose? For example, our Enterprise production environment runs on 4 application servers and an Oracle database all on AIX OS. I can restore a copy of the database from a backup and copy the /usr and /sapmnt directories from one of the app server to the target sandbox, but what files should be edited/deleted to have the new system run on its own?

Congratulations -- restoring your database and getting it up and running is the hard part.

The rest should be easy.

The following needs to be changed after restoring the SAP file systems:
• The instance, default and start profiles (they reside in the profile directory).
• You need to copy the environment files from the adm homedirectory from your source system. The environment variables values should be changed accordingly.
• Copy and modify the database configuration files (init.ora, init.dba … )
• Don't forget to set the port names and numbers in the services file

What is the best way to create indexes in SAP? I want to avoid problems such as the index not being created in the database level. Should I first create the transport for an index and then create it in the database level?

Customer objects should always be created on the development system and transported to the other systems in your SAP landscape.

Our development system is way out of sync, both configuration- and data-wise. We would like to refresh our development system from the production system. How can this be accomplished? What things we need to be aware of? I know we can restore the production system (PRD) from from tape to the development system (DEV,) but that will wipe out everything including transports, notes history, etc

The system copy guides can be found at http://service.sap.com/instguides*. Different backup/restore procedures exist for the different databases supported by SAP.

If you restore PRD over DEV, it will wipe out everything. You should therefore find a point in time in which development projects finish and are brought into production. You should only re-create DEV from a backup of PRD if both systems are more or less in sync or if your development teams agree that certain developments are lost.
* User authorization needed to access the service marketplace.

What SPRO stands for?

SPRO stands for SAP Project Reference Object
.
It is used to configure the setting as per your client requirement by using the standard setting present in the system. This where you can do all the SAP configuration work. It is also known as the Configuration Menu.

What is full form IMG and SPRO? How are they different from each other?

IMG :- Implementation Guide.
SPRO :- SAP Project Reference Object.

SPRO------>IMG.

Type in the T-Code SPRO under That got to Main Menu which is IMG.

SPRO is basically used to organize the consultant customizing during the SAP Project Phrase.

How to close a window?

If we want to stop a transaction in the middle, Right click on the end button (X) on the top right corner of the window. Then select "stop transaction".
As we dont have STOP icon as we have in WINDOWS, this will help in the same way.

Its a very small tip, but will help a lot.

Tips by : Bhaskar

Name two ways to start a transaction.
- Dynamic Menu
- Command Field

Why do you create user-specific parameters?
They supply defaults to R/3 fields. If a field is indicated, the system automatically fills in default value. Depending on the field definition, the entry can also be replaced with a value entered by the user. (Concept of PARAMETER ID)

Name the three different kinds of messages in the R/3 system. What is the difference between them?
A message can have five different types. These message types have the following effects during list processing:

A (=Abend):
The system displays a message of this message type in a dialog window. After the user confirms the message using ENTER, the system terminates the entire transaction (for example SE38).

E (=Error) or W (=Warning):
The system displays a message of this message type in the status line. After the user chooses ENTER, the system acts as follows:
While creating the basic list, the system terminates the report.
While creating a secondary list, the system terminates the corresponding processing block and keeps displaying the previous list level.

I (=Information):
The system displays a message of this message type in a dialog window. After the user chooses ENTER , the system resumes processing at the current program position.

S (=Success):
The system displays a message of this message type on the output screen in the status line of the currently created list.

What is a data dictionary or repository?
Central catalog that contains the descriptions of an organization's data and provides information about the relationships between the data and its use in programs and screens.
The data descriptions in a Data Dictionary is also called metadata, i.e., data that describes other data.

The ABAP/4 Dictionary stores system-wide data definitions. When you create a new data definition, the Dictionary tool does all the processing necessary to create the definition. You can use the Dictionary tool to look up the "definition" of objects in your R/3 System.

What is a matchcode?
Comparsion key. A matchcode allows you to locate the key of a particular database record (e.g. account number) by entering any field value contained in the record. The system then displays a list of records matching the specifications.

If you want an end user to see a specific menu after logging on the R/3 system, how could you do that?
User maintenance transactions allow the system administrator to create and maintain user master records. This includes the generation and assignment of authorizations and authorization profiles.

Is there a way to determine the amount of data in a client for a given company code (client size by company code)?

Yes there is -- have a look at OSS NOTE 489690: CC INFO, copying large production clients. You can also determine the size and the storage requirement of your clients with reports RSTABLESIZE or RSSPACECHECK (see also note 118823).