Just little about C#, .NET, SQL Server, SharePoint and SAP

Archive for August, 2007


Posted by zieglers on August 27, 2007

 SAP Drop

Most of the time you hear the word ‘ERP’ along with SAP. So what is ERP and what is SAP?

Here is a small description for them.

*** What is ERP? ***
*ERP stands for Enterprise Resource Planning.
Enterprise Resource Planning systems integrate all data and processes of an organization into unified system.
The key feature of an ERP system is it uses a single or unified database to store data for the various system modules.
Various Modules which comes under ERP are listed below:

a.            Manufacturing

b.           Supply Chain

c.            Financials

d.           CRM

e.           Human Resources

f.             Warehouse management

*** What is SAP? ***
*SAP stands for Systems Applications and Products in data processing.
SAP is the 4th largest software company in the world. It ranks after Microsoft, IBM and Oracle.
SAP Head quarters are in Walldorf, Germany. SAP was founded in 1972 by five former IBM engineers.

SAP released SAP R/2 version initially. The architecture of R/2 system is Mainframe architecture.
Later SAP R/3 is released which is different from R/2 architecture. R stands for Real time. 3 stands for 3 tier architecture.
There are over 100,800 installations at more than 28,000 companies.

SAP products are used by 12 million people in more than 120 countries.



Posted in IT Stuff, SAP | 1 Comment »

SAP R/3 IDES 4.7*200 SR1 Installation on Windows 2003 R3 and SQL Server 2005

Posted by zieglers on August 26, 2007


 In this post, I’d like to share my experience on installing SAP R/3 IDES 4.7*200 SR1. IDES stands for ‘International Demonstration and Education System’. That means SAP R/3 IDES comes with many example scenarios, best practices and preconfigured environment for demonstration and education purposes. 

To have a clean and more manageable installation environment, I decided to do the installation on a virtual hard drive (.vhd). Basically, I installed SAP R/3 to a virtual machine. It took quite a long time but eventually I managed to complete the installation after 3 days J




 Installation Environment 

I got a 250 GB usb external hard drive and formatted it to NTFS (This also takes at least 2 hours.). Then I copied necessary installation DVDs/CDs to that drive and extracted them there. If you do just opposite, it can also take a couple of more hours as well. I’ll mention installation CDs in the following section in detail. I created an additional 130 GB virtual hdd just to host SAP installation and attached it to VPC as drive E:. I recommend you to install and keep all SAP related files in another partition for the ease of manageability and monitoring. System Details are as follows:      


  • OS: Windows Server 2003 R2
  • RAM: 1280 MB
  • HDD:  C: 20 GB, E: 130 GB
  • DB: MS SQL Server 2005 Enterprise Edition
    • Collation: Binary order, for use with the 850 (Multilingual) Character Set.


 All installation media mentioned below can be downloaded from SAP Market Place. https://websmp207.sap-ag.de/swdc (logon required) 

 SAP GUI: Installations and Upgrades à SAP Frontend Components à SAP GUI FOR WINDOWS à 6.20 / 6.40 / 7.10 (In the context of this post, I used SAP GUI for Windows 6.20) 

 Installation Guide: (IWNSQL_A110.pdf)SAP® R/3 Enterprise ABAP on Windows:MS SQL Server Using SAP R/3 Enterprise Core 4.70,SAP R/3 Enterprise Extension Set 2.00, Service Release 1Document Version 1.10 – August 24, 2004  

 Installation Type: SAP R/3 Enterprise as a central systemCentral instance and database instance of the SAP R/3 Enterprise system are installed on one host 

Installation DVDs/CDs:


Installations and Upgrades à SAP Application Components à SAP R/3 ENTERPRISE à SAP R/3 ENTERPRISE 47X200 à IDES-Version à Windows Server à MS SQL Server





I did a local installation, which means central instance and database instance are on the same host machine. Firstly you need to complete a central installation and then proceed with the database installation. 

SAP Instance Installation Required CD or DVDs Central instance:

·        Database DVD (MS SQL Server 2005 Enterprise Installation DVD)

·        SAP Installation Master CD (51032936_13)

·        SAP Kernel CD (51030499)

·        SAP Web AS Java DVD (includes CD IGS folder IGS_SOFT for the installation of IGS) (51030724_1) 

Database instance for a non-MCOD installation:

·        Database DVD (MS SQL Server 2005 Enterprise Installation DVD)

·        SAP Installation Master CD (51032936_13)

·        SAP Kernel CD (51030499)

·        All Export CDs (51030584_1 … 51030584_16)




Once everything is ready and all the installation files are extracted, then you are ready to go. At the installation phase you need to choose a unique SAP System ID (for 3 letters). After choosing this ID, make sure that you are not changing it anywhere in the installation. Also you need to come up with 3 system ids: SAP Admin, SQL DB Admin, and SAP Service Admin. 

Make sure that you made the collation with SQL_Latin1_850_CP_Binary, otherwise your installation won’t proceed.  

First you need to make the central installation and then the database installation. For central installation you don’t need all export files. It takes relatively shorter than database installation.  For the database installation, Database Load part takes time. It can take from couple of hours to 1-2 days depending on the host system. Also SAP* and DDIC user passwords should be changed during the installation. 



Once the installation has been completed successfully, you can start your SAP system. To do this, open SAP Management Console and right click to your recently installed SAP system and click ‘Start’. In a minute or two, all three processes should turn to green. If everything goes ok, the result should be as follows:




Now you can login to SAP using your SAP GUI. Make sure that you install your SAP GUI before central installation. You can also get SAP GUI from SAP Market Place.






If you have any troubles or questions about the installations, let’s discuss them here. 

Cheers, J 


Found this post helpful? Please donate..


Posted in IT Stuff, SAP, SQL Server 2005 | 12 Comments »