SAP Parameter Read Sequence during SAP System Start-up

During SAP System Start-up following sequence is used for reading the system parameters:

1. SAP Kernel
2. Default Profile
3. Instance Profile

(Please use comment section below for any comment or suggestion.)

SAP Single Stack System and SAP Dual Stack System

SAP ERP6.0  runs on SAP NetWeaver Application Server (SAP NW AS). The SAP ERP6.0 could run of SAP NW AS ABAP or SAP NW AS JAVA or on both.

A SAP system, which runs on either SAP NW AS ABAP or SAP NW AS JAVA is called as Single Stack System.

A SAP system, which runs on both SAP NW AS ABAP and AS JAVA is called as Dual Stack System. 

(Please use comment section below for any comment or suggestion.)

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	…	…	…	…