Monday, December 3, 2018

BW/4HANA: Custom ABAP code in transformations

In BW/4HANA there are some changes with respect to a usage of ABAP code in transformations. In classic BW there are areas called "1st and 2nd global declarations" (*$*$ begin of global ... *$*$ end of global) available where to place ABAP routines. Normally we can use both of the global declaration areas in the classic BW. It only makes a difference in case that the ABAP code shall be able to be reached globally in the transformation we go for 1st global area. The 2nd one is originally used for the transformations which are migrated from an update or transfer rules.

In the BW/4HANA only the first global area is respected. The 2nd global area is not supported by the BW/4HANA – it no longer exists. In reality there is just one global area – called global part but the global part is not supposed to be used, it is optional. All custom code shall be placed in the local part of the routine. The ABAP routine is a methods of a local ABAP class that consist of a predefined definition and an implementation area.

For existing transformations this also means that the transformation that uses 2nd global area won’t be displayed in the Eclipse - in the BW Modeling tools. SAP GUI will be opened instead. Then a manual migration needs to happed in the SAP GUI and code from 2nd global area must be moved to 1st global area in order to migrate such transformation to the BW/4HANA.

Another point is that existing custom ABAP code that shall in BW/4HANA must be ABAP OO compatible. Means statements that are non-compatible with ABAP OO coding needs to be removed and the code must be refactored to be the ABAP OO correct. Examples of non-compatible things can be: obsolete statements used in the code like internal tables with header, includes, etc. Again such transformations will be opened in SAP GUI to make required changes.

No need to mention that all this is only valid in case the transformation is being executed by ABAP runtime. This is to be selected in Runtime Properties of the transformation. Of course there can be routines in SAP HANA SQLScript in case the transformation is being executed by SAP HANA runtime.

More information:
2654109 - Conversion of ABAP/AMDP routines/exits in SAP BW/4HANA to the processing in Eclipse
2639435 - Transformations are opened in SAP GUI instead of in Eclipse
2462639 - BW4SL - Interfaces and Customer-Specific ABAP Development
ABAP Routines in Transformations

Sunday, December 2, 2018

BW/4HANA Simplifications (BW4SL)

- Last update 01Nov2023

One of strengths of BW for HANA aka BW/4HANA (BW/4, B4H, BW4) is simplification. This comes as something that can’t be seen (e.g. removal of approx. more than 5 million lines of ABAP SAP BW code) and also more visible changes that need to be adapted otherwise it will break BW systems once moved to BW/4 e.g.:

- changes to official interfaces (RSNDI, RSDRI)

- deletion of old/obsolete customer exits (CMOD) and BAdI methods for exit variables that are replaced by corresponding enhancement spots

- switch to new request management for all loading processes

- SAP HANA generated views are Calculation Views only (so called OneView model)

To get an overview of all “simplifications” that BW/4 comes with there see so called BW4SL notes available on SAP support site. At the time of writing this blog there were 66 SAP Notes like that. Each of the Note is dealing with particular BW functionality that was changed/simplified. Change is described also with possibilities how to dealt with it - like how to migrate/convert/adjust particular object. Below few examples of the Notes:

2444718 - BW4SL - MultiProviders

2443489 - BW4SL – InfoCubes

2479567 - BW4SL - Transformations

Central Note has number 2421930. All changes are also described in one central PDF document called Simplification List for SAP BW/4HANA:

Simplification List for SAP BW/4HANA 1.0

Simplification List for SAP BW/4HANA 2.0

SAP offers also interactive web page that provides a description of all changes having an impact when converting from SAP BW to SAP BW/4HANA called Simplification Item Catalog (SIC).

 

More information:

Simplification Item Catalog (SIC) -> launchpad.support.sap.com/#/sic

2421930 - Simplification List for SAP BW/4HANA

BW-B4H-CNV – SAP support site component

Online docu BW/4HANA 1.0

Online docu BW/4HANA 2.0

Conversion Guide for SAP BW/4HANA1.0

Conversion Guide for SAP BW/4HANA2.0

Conversion Guide for SAP BW/4HANA2021

Thursday, November 22, 2018

SAP HANA 2.0 express edition (HXE) administration - cheat sheet

I tried today an installation of HXE via preconfigured Virtual Machine image via VirtualBox.
I basically followed this video. Also there is a nice tutorial available with all the details.

For a reference I put here a brief reference of all the steps that are needed to make in order to setup the HXE. In case you are using preconfigured Virtual Machine there are few steps to be performed to configure HXE after importing of Open Virtual Appliance (OVA) file into hypervisor. 

I keep this mostly for me as a kind of cheat sheet :-)

1. first time logon:
user: hxeadm pwd: HXEHana1 (tmp pwd)
system prompts for the pwd change immediately

2. prompt for change of HANA DB master pwd

3. choose whether you use proxy server

4. wait till XSA config is done, this takes quite a significant time to complete, in my case approx. 40 min

5. find out IP address of the HXE server, by running command:
/sbin/ifconfig
-> e.g. 192.168.1.106

6. add the IP address to host OS into host file like:
192.168.1.106         hxehost

7. XS Engine check: open HANA console in browser: http://hxehost:8090
it shall show wheatear XS Engine is running correctly

8. URL of API endpoint enter command:
xs login -u XSA_ADMIN -p "hana master DB pwd" -s SAP
-> see API endpoint: https://hxehost:39030

9. webIDE install check, via command:
xs apps | grep webide
-> see URL: https://hxehost:53075          user: XSA_DEV        pwd: master DB pwd

10. cockpit install check, via command:
xs apps | grep cockpit-admin-web-app
-> see URL: https://hxehost:51047          user: XSA_ADMIN    pwd: master DB pwd

While you trying out all different URLs (webIDE, cockpit, etc.) make sure you open new incognito/private) session in your web browser. Else you will run into an authorization issues as there are supposed to be used different users (XSA_ADMIN, XSA_DEV) for different services.

11. check status of HANA processes, use command:
HDB info

12. stopping HXE, use command:
HDB stop

13. starting HXE again, use command:
HDB start

14. restart of HXE, use command:
HDB stop 
and
HDB start

or
HDB restart

15. switch off virtual machine, use command:
sudo shutdown now

16. see information about version of HXE, use command:
HDB version

17. see information about HXE, use command:
HDB info

16. connecting to HXE with HANA Studio (eclipse):
First install plugins aa a new software in eclipse Help menu to Eclipse from site https://tools.hana.ondemand.com/#hanatools -> e.g. https://tools.hana.ondemand.com/photon in case of Eclipse Photon version. Once plugins are present open new perspective called "SAP HANA Administrator Console". Choose "Add system" and enter info like: host name, instance number, single container, user and password. Afterwards the XSE system will appear in the Eclipse.

More information:

Wednesday, October 31, 2018

SAP TechEd 2018 Las Vegas my experience

Note: The blog is cross posted on my blog at SCN.
Although second TechEd of this season is over now I just want to come back to first one that was in Las Vegas. So here’s my experience…

It was September 17th Monday’s evening when I checked my emails and I saw an email with subject “SAP TechEd Invitation to Register”. I didn’t even care to open the email as I thought that it another marketing email inviting for the TechEd. I continued to read a news feed on my phone for another hour before I wanted to go to bed. After I was done with reading the news hour I checked my emails for last time and the email from Craig Cmehil popped up. This time I opened it and read it. It was really nice surprise to hear that I was selected for the TechEd. As Craig mentioned in the email I should have received an official invitation with details about how to claim my TechEd prize. I realized that he referred to the first email I received on that evening. So it turned out the first email wasn’t marketing one but invitation to the TechEd. I was lucky I opened the 2nd email otherwise I would completely miss my chance to go to the event :-)

So this is how I made it SAP TechEd 2018 in Las Vegas for first time. I was fortunate enough to be selected based on my participation in SAP TechEd 2018 Tutorial Mission contest held back in August. When I participated in the content I had an option to choose TechEd location. I didn’t really expect to be one of lucky winners so I thought to myself it has to be Las Vegas or nothing :-) and it worked out.

As a preparation for conference I read few blogs (e.g. How to Survive SAP Tech-Ed) about it. For someone like me attending for first time the best source of information is Tammy Powlas blog Getting Ready for #SAPTechEd – a @SAPCommunity Call

I arrived to Vegas on October’s 1st Monday evening. Thanks to my friend and SAP mentor Ethan Jewett I attended SAP Mentors Reception. Although a jet lag started to attack me very soon it was it was very pleasant occasion to meet and talk to other SAP mentors. 

On Tuesday I woke up very early and had enough time to register myself for conference. I used some time before registration was opened to familiarize myself with the conference’s venue. Sands Expo Convention Center it large facility and short walk way around it helped me later during the conference to easily navigate between different floor, rooms etc. Just one remark to registration process. Paying attendees were eligible to receive free hoodie. Although I wasn’t one of them as my ticket was provided by SAP to me for free I heard some comments regarding the hoodie. On Tuesday morning only large sizes were available and some people were not happy about that :-) I guess smaller sizes were given away on days before already as registration was opened since Sunday’s evening. 

The TechEd started with key note delivered by Bernd Leukert. Personally I expected some more technical person like Björn Goerke to deliver it. Reason is that this is the technical conference thus the technical people like CTO would fit better. However, I understand that delivering 3 key notes by same person can be little too much. As for the key note an announcements were: a part of “Kubernetes as a Service” and “SAP Cloud Platform Functions” for me the biggest was “SAP Cloud Platform ABAP Environment” is now GA. The SAP CP ABAP Environment also known as project steampunk. Other than that emphasis of the key note was “intelligent enterprise”.

For rest of my TechEd stay I following tracks related to mostly Analytics (Next Gen Data Management (DAT),    Applied Intelligence (AIN),  App Landscapes and Cloud Native Architectures (CNA) and Integration Out-of-the-Box (INT) sessions. In total I attended 27 sessions. I did few exercised at google booth – part of App Space. Unfortunately had no time to do more tutorials in other vendor’s booths. Also not really had time to go through all exhibitor’s booths. I visited only few which I had an interests in their products. In next part of the blog I briefly introduce what I learned during sessions I attended.

As my TechEd package didn’t contain hands-ons I was only visiting few of them and I tried just shadow other people who were working on them. It was actually great to meet new people and engage.

AIN100 – Analytics Overview 101 – Dedicated to SAP’s analytics strategy. Got an overview on what’s are current tools within portfolio.  In this session I learned about SAP Analytics Cloud (SAC) tool. 

CNA222 - A Developer’s View of SAP Cloud Platform, ABAP Environment – one of sessions related to SAP CP ABAP Environment. Overview of use cases for ABAP in CP was provided. Along the others I think possibility to leverage ABAP skills in CP by SAP customers is the biggest benefit of ABAP Environment in the CP that I see. Learned things like: $TMP as development package is not present anymore in the CP; ABAP key words related to web/dynpro, OS, SAP GUI (basically everything which have no sense in cloud environment, see what is whitelisted in blog) are not supported; RESTful ABAP Programming (RAP) intro. Seen demos on: console app; abapGit usage, CDS view creation + ODATA service generation + FIORI Elements preview.

AIN200 – SAP Analytics Cloud and SAP BW/4HANA: Complementing SAP S/4HANA – Got an overview of SAP S/4HANA embedded analytics, apps (Content) available in this area; how it is integrated with SAP BW/4HANA and SAP Analytics Cloud (SAC). Speakers were nicely answering to pretty tricky questions like “do we still need BW if we have embedded analytics?”  J

DAT110 – Project Blueberry – A Sneak Peek – intro to new product Packaged DWH as a Service (DWaaS). It shares same code line as SAP BW/4HANA; to be a first app to run on the SAP CP ABAP Environment; components of SAP “DWaaS”; integration with integration to SAP Data Hub and SAC were discussed.

AIN105 – Overview of SAP Cloud Analytics (SAC), All Analytics on One Platform – Dedicated to analytics as BI/Planning/Predictive/App Design on one platform; Live connections that is used to access data in SAC tool. Very basic feature of the SAC that I learned is that it doesn’t move/store/replicate any data before it is displayed to user.

DAT367 – End-to-End Modeling and Operations with SAP BW/4HANA – hands-on session. In this one we did a creation a new data flow; creation of a Process Chain in the SAP BW/4HANA Administration Cockpit and finally we tried data tiering optimization in BW/4HANA system.

DAT100 – Analytics Clients for SAP BW/4HANA – learned about analytics strategy as big picture, front end tools like SAC, SAP Lumira (mostly about designer edition as for discovery edition won’t get new major feature updates starting in 2019) and SAP Analysis for Microsoft Office were discussed. Great demos were provided. For support of BEx tools in SAP BW/4HANA see SAP Note 2496706.

AIN864 – SAP Analysis for Microsoft Office: Road Map – Learned about upcoming new features of 2.7 version introduced for the tool like: EPM and Analytics plug-ins in MS Excel are now merged into one products; left outer join feature; comments feature; history panel; integration with SAC; etc.

CNA120 – ABAP Strategy – current innovation in ABAP were discussed, in particular:
1. On premise: SAP S/4HANA On Premise
2. Cloud:
2.1 SAP S/4HANA Cloud
2.2 SAP CP ABAP Environment
Other topics: implication on modifications/custom code (move to cloud extensions); must learn topics for ABAP developers like in area of UI: SAP Fiori / SAPUI5, RESTful ABAP Programming model (RAP); area of code pushdown: ABAP SQL, Core Data Services and code pushdown in SAP HANA; area of code securing/managing: ABAP Tools, Development-methodology; area of cloud: In-App extensibility, SAP Cloud Platform. There are many new things going on in ABAP. Really exciting times to be an ABAP developer!

DAT202 – Conversion Paths to SAP BW/4HANA – different possibilities on how to convert BW system to BW/4HANA based system. Few interesting facts about the BW/4HANA that caught my attention: 3k tables were removed, 5 mil of ABAP code lines removed in BW/4HANA in comparison to NetWeaver based BW system.

DAT204 – SAP BW/4HANA: An Agile Architecture for the Intelligent Data Warehouse – different architecture approaches discussed within BW/4HANA like: simplified EDW, flexible EDW, agile DWH and relational Data Lake architecture.

DAT366 – SAP BW/4HANA and SAP SQL Data Warehousing – hands-on session. Example of an integration of SAP and non-SAP data combined in SAP BW/4HANA and SAP SQL Data Warehousing solution. We created Flowgraph in Web IDE tool (DWH) and data flow in BW/4HANA. Data from both sources were accessible in SAP BW/4HANA.

CNA302 – Custom Code Adaptation for SAP S/4HANA – Options of checking custom code when converting to SAP S/4HANA were discussed. Different tools for that were presented like Custom Code Lifecycle Management (CCLM), ABAP Test Cockpit (ATC) etc.

CNA202 – How to Get to SAP S/4HANA Embedded Analytics – capabilities of S/4HANA’s embedded analytics were discussed. Many demos presented.

DAT370 – Experience with Using SAP Analytics Cloud for SAP BW/4HANA – hands-on session. We could practice working with SAC tool in scenarios leveraging local data and live data. It was great session as Ingo Hilgefort went beyond expectation and he provided very deep insight on topics like storytelling in analytics, gave a tips on books for BI people etc.

DAT101– What’s New in Native Development for SAP HANA – delta information between HANA 2 SPS02 and SPS03 were discussed from Client Interfaces, SQL, SQLScript, CDS, Development Tools and XSA perspectives.

INT303 – Using Hana Express with No SAP Experience – Example on how HANA Express edition can be installed and used even in productive manner.

DAT839 – SAP Data Hub: Road Map – SAP Data Hub 2.3 solution was discussed.

CNA210 – Entering the World of Git with ABAP – Great session showcasing power of ABAPGit in conjunction with Continuous Integration (CI) tool Jenkins. In spirit of “CTS goes Git” demo was presented where and ABAP change was done in development system in Eclipse. The change was pushed (exported) to git repository. CI part (pipeline): CI server observed the change in the repository. It created a new build and deployed it into test system. Afterwards the CI server tests the change in test system. In case the test is successful the change is promoted to production system.

CNA216 – A Technical Deep Dive into the ABAP RESTful Programming Model –Technical things about the RESTful ABAP Programming (RAP) model. Stared with business object (BO) and business service details. Demo on how the BO is modeled/implemented via business definition/implementation language. Followed by service definition and binding. Finally, the BO was exposed in SAP Fiori UI service with SAP Fiori Elements Preview called from Eclipse.

CNA415 – Test Driven Development with ABAP – better say it was about how to write testable ABAP code. Great session by Graham Robinson. I had a lot of fun while attending it. Graham showcased in his demo how he can rely on a fact that ABAP code was refactored correctly by leveraging ABAP Unit classes.

DAT203 – Best Practices for Modeling Mixed Scenarios – very helpful session providing an examples of possible mixed scenarios while combining modeling capabilities of BW/4HANA and HANA.

DAT108 – An Outlook on Data Integration Tools from SAP: When to Use What – different use cases of products like SAP Data Services, SAP Cloud Platform Integration for data services, SAP HANA smart data integration / SAP Cloud Platform Smart Data Integration, SAP Landscape Transformation Replication Server and SAP Data Hub were discussed.

DAT876 – SAP BW/4HANA: Road Map – features were discussed from Recent innovations -> Planned innovations (2019) -> Product direction (2020) -> Product vision (2021) point of view. See also here.

DAT815 – Machine Learning in SAP HANA – machine learning capabilities of HANA were discussed.

AIN102 – Application Design with SAP Analytics Cloud – probably best session in analytics area I had a chance to attend. David Stocker discussed a lot of detail on how SAC was designed. Also many background information on how SAP tried to integrate many of their BI front end tools. Can’t wait to try this tool out. Hope there will be trail version available soon!
In closing I’d to say that it was a great experience for me being at the TechEd. A part of gaining knowledge, opportunity to talk to SAP people like product managers, trying out new solutions, and so on the biggest asset of the TechEd is that you meet a lot of new people. It doesn’t matter either you stay few minutes longer after some session finished and discuss the topic further, or you join a bunch of strangers talking about topic you are interested in while waiting in hallway to enter room where another session gonna start soon, or you join people during lunch… basically wherever you go during the TechEd there you will find some new people who share with you a common interest in SAP solutions.

Friday, October 26, 2018

SAP RFC APIs: "Classic" RFC Library and NetWeaver RFC SDK

To enable different computer systems where one of them is SAP to communicate each other so called Remote Function Call (RFC). The RFC is the standard SAP interface for communication between SAP systems. RFC calls a function to be executed in a remote system.

Initially there was only an RFC library which is called now "classic" RFC Library (see my very old blog http://blog.maruskin.eu/2011/11/where-to-download-librfc32dll-rfc.html) is obsolete and replaced by SAP NetWeaver RFC Library.

Later the SAP NetWeaver RFC Library was introduced that is used to interface SAP systems starting from release R/3 4.0B (in case of NW RFC SDK 7.20) and from release 4.6C (in case of NW RFC SDK 7.50) and above including the newest one (NW 75).
Both the things classic and NetWeaver are doing basically same thing. Using the SDK a function in different programming languages can be written that can read/write data out/to SAP system. The newest version (NetWeaver) of course supports the latest technologist such as:  dynamic meta data retrieval, support of all SAP single code pages, new binary protocol (basXML) reduce of data volume when using complex parameter types (nested data types).

Below see overview of different versions and patch levels o of the SAP NetWeaver RFC Library SDK:

SAP NW RFC SDK 7.50 (supported till Dec 31st, 2025)
patch level               release date                                 SAP Note
06                          04.03.2020                                 2840214
05                          23.08.2019                                 2803723
04                          23.05.2019                                 2750411
03                          14.02.2019                                        2696676
02                          24.09.2018                                 2659804
01                          07.05.2018                                  2586468

00                          before 13.12.2017 init delivery      2573881

SAP NW RFC SDK 7.20 (obsolete as of Dec 31st 2018)
patch level              release date             SAP Note
43                          before 20.10.2017    513266
40                          11.08.2016              2299080
39                          20.04.2016              2247044
38                          before 17.11.2015    2229450
24                          before 14.07.2014    2035997
22                          before 02.05.2014    2003530
08                          21.05.2012              1635866
07                          28.09.2011              1609391
06                          25.07.2011              1592501
05                          before 30.05.2011    1591259
04                          before 19.05.2011    1589976
03                          19.05.2011              1562569
02                          24.02.2011              1511433
01                          before 23.09.2010    1511382
         
SAP NW RFC SDK 7.11 (obsolete)
patch level              release date            SAP Note
10                          17.11.2010             1511377
09                          23.09.2010             1474682
08                          10.5.2010               1465290
07                          04.05.2010             1445129
06                          03.02.2010             1409906
05                          29.12.2009             1407615
04                          13.10.2009             1383253
03                          before 17.8.2019     1359377
02                          before 19.05.2009   1278062
01                          in 2008                   1236530

SAP NW RFC SDK 7.10 (obsolete)
patch level              release date             SAP Note
02                          before 11.06.2008    1058327
01                          before 09.10.2007    1056472 

Supported platforms: AIX, HP-UX, LINUX REDHAT, LINUX SUSE, LINUX ORACLE, SOLARIS, WINDOWS, Z/OS, as of SAP NW RFC SDK 7.50 support of MacOS was added.

More information:
2573790 - Installation, Support and Availability of the SAP NetWeaver RFC Library 7.50
1025361 - Support and Availability of the SAP NetWeaver RFC Library 7.20

Thursday, September 20, 2018

miniSAP - SAP NetWeaver 7.52 SPS1, installation

After release of “miniSAP - SAP NetWeaver 7.51 SPS2” which occurred last year on SAP TechEd 2017 this year the SAP is coming with newer version of ABAP stack which is SAP NetWeaver 7.52 SPS1. It looks like that the SAP is starting a good practice releasing the newest versions of their ABAP servers for developers. This is something that many people are very welcoming including myself. Even in the age of cloud computing the cloud is not solution for everyone (speaking here about cost of running SAP in cloud providers from independed SAP developer perspective or even student).

This year I choose OS openSUSE Leap 15.0 (released on 2018-08-21) is higher OS version as openSUSE Leap 42.3 (released in 2017) for the miniSAP NW752SP01.

As usual installation files can be downloaded from SAP Store. You either look it up directly at https://store.sap.com or go to https://tools.hana.ondemand.com/#abap and find a link to the SAP Store there. Alternatively you can go via https://www.sap.com/developer/trials-downloads.html or to save all the hassle go directly to the page with the files. If you have a troubles with downloading the file like I had (see here) getting an error “You are not authorized to download this file” try to delete cookies or use different web browser.

Again within this release an installation procedure is very well described in blog by Julie Plummer that can be found at SAP AS ABAP 751 SP02 Developer Edition to Download. Therefore, I’m not going to describe the installation step by step. I just focus on one issue that I faced. 

In particular, it was related to license file of ASE database. In case your install fails with error like below: 

ERROR      2018-09-15 18:37:19.273 (root/sapinst) (startInstallation) [CInstallerCallBackImpl.cpp:259] id=ind-rel.ind-os.ind-db.assertionFailed errno=CJS-00030 CInstallerCallBackImpl::abortInstallation()
Assertion failed: Unable to verify database access for login SAPSR3. Refer to trace file sapinst_dev.log for further information

ERROR      2018-09-15 18:37:19.274 (root/sapinst) (startInstallation) [iaxxbjsmod.cpp:83] id=modlib.jslib.caughtException errno=MUT-03025
Caught ESAPinstException in module call: Assertion failed: Unable to verify database access for login SAPSR3. Refer to trace file sapinst_dev.log for further information..

ERROR      2018-09-15 18:37:19.537 (root/sapinst) (startInstallation) 
[CSiStepExecute.cpp:1102] id=controller.stepExecuted errno=FCO-00011 CSiStepExecute::execute()
The step syb_step_login_check with step key |offlineadjustment_dialogs|ind|ind|ind|ind|0|0|offlineadjustment_db_post|ind|ind|ind|ind|db_post|0|syb_rename_db_post_dia|ind|ind|ind|ind|syb|0|NW_SYB_DB_REN|ind|ind|ind|ind|syb2|0|syb_step_login_check was executed with status ERROR (Last error reported by the step: Assertion failed: Unable to verify database access for login SAPSR3. Refer to trace file sapinst_dev.log for further information). 

You need to download correct ASE license file (SYBASE_ASE_TestDrive.lic) from location location and put it to folder /sybase/NPL/SYSAM02_0/licenses. Do not forget to set proper owner of the file (chown sybnpl SYBASE_ASE_TestDrive.lic) and group (chgrp sapsys SYBASE_ASE_TestDrive.lic). The correct license file is valid till March 31st 2020. 

Afterwards restart the installation. Once it is successfully over you shall get a message like this:



Enjoy the newest version of the miniSAP!

More information:

miniSAP - SAP NetWeaver 7.51 SPS2, installation

Well; a term miniSAP is not used any more. Nowadays they just call it "SAP NetWeaver AS ABAP Developer Editon" but for me it always will be the miniSAP as it reminds me my SAP early days back in begging’s of 2000’s when I started my SAP career.

After some time when old good versions of miniSAP weren’t available and as all software is moving to cloud there is a brand new version of SAP NetWeaver software - SAP NetWeaver 7.51 SPS2 as of SAP TechEd 2017. First of all, here’s what needs to be downloaded:

1. miniSAP NW 7.51 SPS2 installation files, a link to store.sap.com where installation file can be downloaded from is located at https://tools.hana.ondemand.com/#abap. (edit: physical files for download removed from this site but there a links SAP Store where you can download it). There are 10 files about if size 1,4GB each in RAR files.

2. linux OS, several distributions are available, I chose SUSE Leap for SAP installations, at the time of my installation (fall 2017) the version 42.3 available here: https://software.opensuse.org/distributions/leap

3. virtualization tool, e.g. VM Ware Player or VirtualBox I chose the latter one.

Once all the software is downloaded extract all 10 RAR files into folder. You will need approximately 14.3GB to store downloaded files. After the extraction it will have approximately 26GB including OS linux - openSUSE Leap 42.3. Start your virtualization tool and load image of linux OS. Then start the virtual machine and install the linux OS by choosing Installation on 1st screen. Rest of the OS install is very well described in article Linux for newbies or follow guide here, download info here, FAQs here, another Newbies Guide here and openSAP guide here. All the OS install shall not take more than 20 min at least that was a case on my intel i7 /32 GB memory based machine.

By starting up installation script (install.sh) first a license needs to be accepted (by typing ‘yes’) and then it asks to provide OS user password. Afterwards the installation starts to process files:




If you do not reserve enough space the installation may end up like below one J normally for installation there should be approx. 100GB of hard drive space available.



In case there is enough space the installation normally continues by extracting the files.
Password should follow rules: at least seven chars, big letter, small letter, digits, no special chars.
Below are errors I faced during the install:
1. Error: ‘unable to determine parameter DNS domain name’
Check whether host name and full host name with domain name is fulfilling requirements. Go with the name:   vhcalnplci vhcalnplci.dummy.nodomain





2. Error: ‘unable to verify database access for login SAPSR3’






And during the install change the file that is there in folder /sybase/NPL/SYSAM-2_0/licenses/SYBASE_ASE_TestDrive.lic with the downloaded file. This step is quite a tricky one. I had to make several attempts before I finally succeeded. Issue is that you do know exactly when you shall change the file and that was the biggest challenge. Also you need to be a bit skilled in linux command file as you need to set proper owner of the file (command chown).and group of the file (command chgrp).


More information: