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. 

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

How to create a Role for SU01 Display - SAP Basis

Role for SU01 Display - SAP Basis

Introduction: As a SAP Basis Consultant / Administrator you may get the requirement that functional consultants require SU01 display authorization.

How to do:

1) This is very simple.

2) Do not think to create a role with SU01 tcode and modify that for display only.

How to add multiple server instances in single MMC - SAP Basis

Introduction: As a SAP Basis Consultant / Administrator you will always feel the requirement to manage/ monitor your organizations all SAP servers from your workstation. This may be achieved by adding multiple server instances (ABAP and JAVA Systems) in a single MMC. Follow below steps to add multiple service instances in single MMC.

How to do:

1) Start SAP MMC