SAP Directory

This is the overal directory structure in SAP system.
Unix based: use /
Windows based: use <drive>:\

Shared directory:
/sapmnt/<SID>/profile è SAP instance profile
/sapmnt/<SID>/global è SAP central system log
/sapmnt/<SID>/exe è SAP executable application directory

Main directory:
/usr/sap è physical parent directory
/usr/sap/trans è transport directory
/usr/sap/<SID> è SAP system parent directory
/usr/sap/<SID>/SYS è contain common & global SAP system files (i.e. profile, global, and exe directory)
/usr/sap/<SID>/<instance_name> è contain SAP instance specific directories (i.e. data, log, and work)
/sapmnt è directory structure for sharing common files to all system belonging into the same group
/sapmnt/<SID> è link or share folder of directory /usr/sap/<SID>/SYS
/oracle è directory of the whole database system
/oracle/stage è directory that used for database installation and upgrades
/oracle/<SID> è directory of the whole database application and data files

Final directory:
/sapmnt/<SID>/exe è contain all SAP runtime program
/sapmnt/<SID>/exe/opt è contain optimized program
/sapmnt/<SID>/exe/dbg è program can run under symbolic debuggers
/sapmnt/<SID>/exe/run è actual runtime program (SAP kernel)
/sapmnt/<SID>/global è contain global & common data shared by all instance (i.e. central system logs & batch job logs)
/sapmnt/<SID>/profile è contain instance profile (startup, default, instance-spesific)

Temporary directory (normally refreshed when SAP instance is restarted):
/usr/sap/<SID>/<instance_name>/data è contain virtual storage data (i.e. user context & roll area)
/usr/sap/<SID>/<instance_name>/log è log entries generated by instance
/usr/sap/<SID>/<instance_name>/work è holds all error message & trace information for the instance process

Transport directory:
/usr/sap/trans è main transport directory
/usr/sap/trans/bin è contain TPPARAM file (global transport parameter)
/usr/sap/trans/data è contain transport data file
/usr/sap/trans/log è transport logs, trace and statistic file
/usr/sap/trans/buffer è special buffer with the SID of every system in the transport group (including control information)
/usr/sap/trans/cofiles è control file directory
/usr/sap/trans/sapnames è contain information of SAP User that performs export and keep tracks of each transport status
/usr/sap/trans/tmp è temporary directory
/usr/sap/trans/actlog è action log files (managed by SAP system)
/usr/sap/trans/olddata è archived transport files
/usr/sap/trans/backup è directory of logical backup with R3trans program
/usr/sap/trans/serial è contain serialization of tp

Tips&Trick: Copy hundreds of rows of Excel formulas in three steps

Taken from: http://blogs.techrepublic.com.com/msoffice/?p=348

Excel provides a number of ways to copy formulas. You can use Excel’s Autofill feature or, as an alternative, select the cells you wish to copy to, enter the formula in the active cell, and then press [Ctrl][Enter]. These methods are fine for copying formulas down a column of cells — unless the column extends down hundreds of rows.

For example, say Column A in your worksheet lists 100 products and Column B lists the wholesale price of each. You would like to enter a formula that calculates the retail price for each product and displays the results in Column C. Selecting 100 cells is a time-consuming and error-prone process, but you can copy the formula down Column C without having to select the cells. Follow these steps for foolproof cell copying:

1. Click in C2 and enter =B2*300%.
2. Press [Ctrl][Enter].
3. Double-click the fill handle (the small black square in the lower right-hand corner of the cell).

Excel will stop copying the formula when it reaches a row with a blank cell in Column B. To ensure that you copied the formula correctly, click in C1 and then press [Ctrl][Shift][End].

Speed Up Boot and Shutdown Times

Shorten the time it takes for your desktop to appear when you turn on your PC, and make XP shut down faster as well.
Taken from http://www.techrepublic.com

No matter how fast your PC boots, it’s not fast enough. Here are several hacks to get you right to your desktop as quickly as possible after startup.

Perform a Boot Defragment
There’s a simple way to speed up XP startup: make your system do a boot defragment, which will put all the boot files next to one another on your hard disk. When boot files are in close proximity to one another, your system will start faster.
On most systems, boot defragment should be enabled by default, but it might not be on yours, or it might have been changed inadvertently. To make sure that boot defragment is enabled on your system, run the Registry Editor [Hack #83] and go to:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Dfrg\BootOptimizeFunction
Edit the Enable string value to Y if it is not already set to Y. Exit the Registry and reboot. The next time you reboot, you’ll do a boot defragment.
I’ve found many web sites recommending a way of speeding up boot times that might in fact slow down the amount of time it takes to boot up and will probably slow down launching applications as well.
The tip recommends going to your C:\WINDOWS\Prefetch directory and emptying it every week. Windows uses this directory to speed up launching applications. It analyzes the files you use during startup and the applications you launch, and it creates an index to where those files and applications are located on your hard disk.
By using this index, XP can launch files and applications faster. So, by emptying the directory, you are most likely slowing down launching applications. In my tests, I’ve also found that after emptying the directory, it takes my PC a few seconds longer to get to my desktop after bootup.

Hack Your BIOS for Faster Startups
When you turn on your PC, it goes through a set of startup procedures in its
BIOS before it gets to starting XP. So, if you speed up those initial startup
procedures, you’ll make your system start faster.
You can speed up your startup procedures by changing the BIOS with the
built-in setup utility. How you run this utility varies from PC to PC, but you
typically get to it by pressing the Delete, F1, or F10 keys during startup.
You’ll come to a menu with a variety of choices. Here are the choices to
make for faster system startups:
Quick Power On Self Test (POST)
When you choose this option, your system runs an abbreviated POST
rather than the normal, lengthy one.
Boot Up Floppy Seek
Disable this option. When it’s enabled, your system spends a few extra
seconds looking for your floppy drive—a relatively pointless procedure,
especially considering how infrequently you use your floppy drive.
Boot Delay
Some systems let you delay booting after you turn on your PC so that
your hard drive gets a chance to start spinning before bootup. Most
likely, you don’t need to have this boot delay, so turn it off. If you run
into problems, however, you can turn it back on.

Fine-Tune Your Registry for Faster Startups
Over time, your Registry can become bloated with unused entries, slowing down your system startup because your system loads them every time you start up your PC.
Get a Registry clean-up tool to delete unneeded Registry entries and speed up startup times. Registry First Aid, shown in Figure, is an excellent Registry clean-up tool. It combs your Registry for outdated and useless entries and then lets you choose which entries to delete and which to keep. It also creates a full Registry backup so that you can restore the Registry if you run into a problem.

Registry First Aid is shareware and free to try, but it costs $21 if you decide to keep using it. Download it from http://www.rosecitysoftware.com/Reg1Aid/index.html.
After you clean out your Registry, you might want to try compacting it to get rid of unused space. The Registry Compactor, available from http://www.rosecitysoftware.com/RegistryCompactor/index.html, will do the trick. Compacting your Registry reduces its size and decreases loading time. It’s shareware and free to try, but it costs $19.95 if you decide to keep it.

Speed Up Shutdown Times
It’s not only startup times that you’d like to speed up; you can also make sure that your system shuts down faster. If shutting down XP takes what seems to be an inordinate amount of time, here are a couple of steps you can take to speed up the shutdown process:
Don’t have XP clear your paging file at shutdown
For security reasons, you can have XP clear your paging file (pagefile.sys) of its contents whenever you shut down. Your paging file is used to store temporary files and data, but when your system shuts down, information stays in the file.
Some people prefer to have the paging file cleared at shutdown because sensitive information, such as unencrypted passwords, sometimes ends up in the file. However, clearing the paging file can slow
shutdown times significantly, so if extreme security isn’t a high priority, you might not want to clear it.
To shut down XP without clearing your paging file, run the Registry Editor and go to:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management
Change the value of ClearPageFileAtShutdown to 0. Close the Registry and restart your computer. Whenever you turn off XP from now on, the paging file won’t be cleared, and you should be able to shut down more quickly.
Turn off unnecessary services
Services take time to shut down, so the fewer you run, the faster you can shut down.