SAP Brief History and SAP Releases

SAP Brief History:

• SAP stands for  Systems Applications & Products in Data Processing
• SAP was founded in 1972 by five former IBM employees.

SAP Releases:

• SAP R/1 : 1973
• SAP R/2 : 1979-80
• SAP R/3 4.0B : 1992

How to check Tablespace with BRTOOLS

How to check Tablespace with BRTOOLS


STEPS:

1) login with <SID>adm or ora<SID>.

2) Input Command : brtools
 
3) Enter 2 for Space Management.

4) Enter 7 for Additional Space Functions. 

SAP Basis Interview Questions

SAP Basis Interview Questions:

1. What are the steps to start and stop SAP system? 
2. How do you troubleshoot when your SAP system goes down?
3. What are the Database Start-up AND Shutdown Steps?
4. What is System Refresh? when and why it is done? 
5. What is the difference between SAP_ALL & SAP_NEW?
6. How to Lock or Unlock a Client in SAP?
7. How do you update the Kernel? 

How to Copy only Subtotal Rows : Excel

How to Copy only Subtotal Rows : Excel

Many times while working in Excel, we need to copy only subtotal rows. Following are the way to copy only subtotal rows in Excel.

Formula for transposing data from Row to Column: MS Excel

Formula for transposing data from Row to Column

Recently I have encountered a situation where I have to transpose the row data to column in Excel. The manual process was totally impossible due to high volume of data. One can easily understand the requirement from the below format: 

Original File Format:

Emp Code	Emp Name	Sal Month-01	Sal Month-02	…	Sal Month-41
111	Emp1	123	124	124	145
112	Emp2	…	…	…	…
113	Emp3	…	…	…	…
…	…	…	…	…	…
999	Emp999	…	…	…	…