VAT: BE 0821 621 375
Dendermondsesteenweg 48B / Bus 203
9000 Gent

27 july

My view on the Future of SAP HANA

SAP HANA will take over the world. Well, the SAP World that is...


I've been highly interested in SAP HANA since I first heard about it a few years ago.


Since attending infosessions on SAP Teched 2012 in Madrid, seeing business cases, company presentations and Keynotes from SAP itself, I became more and more intrigued by what SAP HANA is and what it can do.


One statement stuck to my head: "The idea behind SAP HANA is getting rid of Batch jobs".


When you think about it this only means one thing. That customers choosing to eventually migrate to SAP HANA should really consider migrating all SAP Business Suite applications towards SAP HANA and running everything on a SAP HANA platform


Imagine, having a ECC system connected to a SAP HANA DB, together with a BW and CRM system. This gives you realtime data exchange without having to run overnight batch loads leading to out dated numbers and business data before even consulting them.


SAP HANA puts the business even more in the driving seat since you've got your hands on the live data. Moreover you go from a reactive situation into a proactive situation. 


Where do I position myself in the SAP HANA universe? Well, I've achieved my SAP OS/DB Migration certificate in December 2012. And since the moment I booked that course I've done some thinking. Why not to specialize in migrations from conventional DB's towards SAP HANA?


I've followed the HA100R introduction course, plan to follow the new HA200 course to finally be able to obtain my SAP HANA certification.


Let's hope the future brings some SAP HANA experience and opportunities my way. ;-)


React (0 reactions) / Send this post to a friend
18 march

How to force Microsoft Excel to open files in new window

A lot of people working with SAP and office know the drill...


You want to copy data from SAP into Excel, but in the meantime you have another window open. 


The biggest problem is that the default behavior of Excel is not the most user friendly one. It opens every sheet in the same program window, causing me frustration.


So when scanning the internet I found the following:


Give it a try, it works ;-) Take it from me



Send this post to a friend
08 june

Execute OS Commands from within SAP

All of you BC Administrators out there probably know the situation in which you need some info from the OS, but are not allowed to access the OS (due to several reasons).


Well, then this tool will definitely help you out:


Just go to SE38 and execute "RSBDCOS0". you'll be able to execute all allowed commands for the sidadm user.


The commands are logged in SM21, for security reasons.


Another useful tool is "RSORADJV", which shows SQL prompt


Have fun and enjoy!

React (0 reactions) / Send this post to a friend
06 july

SAP HANA (who the f... is SAP HANA)?

Basically SAP HANA is a "In-Memory Business Data Management". Since the introduction of 64bit Operating systems and software the memory limitations have practically disappeared and leveled the road for using DB's which are stored in memory.


On the following links you'll find an interesting overview on the way SAP is thinking of using SAP HANA with BW 7.3. In some companies it will replace the existing BW installations running on the conventional DBs (ORACLE, MS SQL,...) since some SAP customers are noticing that they don't need the reporting functionalities of a their SAP BW systems anymore.  BW itself will never completely disappear, since the necesarry data manipulations you can do with the current SAP BW solutions will still be necessary.


For more info, just have a look on the following links:


React (0 reactions) / Send this post to a friend
17 june

SAP on SQL 2008 (Blog)

I've been working on Wintel machines running SQL DB Servers lately and have been looking for information about the features of MS SQL Server 2008 and the best way to manage it in a SAP Environment.


Now this blog contains the most things you need to know to get started, so (obviously) I recommend it to you ;-)


Enjoy ;-)

React (0 reactions) / Send this post to a friend
18 may

Change Pointers (housekeeping, understanding, etc...)

I came across a problem with Change pointers in SAP recently and in my search on the internet I ended up on this blog:


Very useful. For more blogs go to:

React (0 reactions) / Send this post to a friend
16 april

SAP and Ice Hockey

I stumbled upon this little article on and since ice hockey has a special place in my life I'd figure it would be worth mentioning. This is a perfect example of the versatility of SAP:


 Ice hockey team implements SAP Business All-in-One


The top-flight German hockey team Iserlohn Roosters implemented SAP Business All-in-One. During the implementation they had to import data from different individual applications and interlink figures from various sales areas.


SAP Business All-in-One now automates order management and provides the hockey organization with daily reporting on sponsorship money, shop receipts, and ticket revenues. The solution also includes an interface for barcode printers and point-of-sale systems.


React (0 reactions) / Send this post to a friend
21 march

SapGui on your iDevice (iPhone or iPad)

This little app is a great tool that makes it possible for you to access your SAP system using your beloved iPhone or iPad.


It uses the SAP Webgui (the ITS interface) and gives you access to the transactions you want. In my case I find it quite useful since BC Consultants almost alway access their transactions using the TID itself. Whereas end users will mostly go through the menu.


There lies the only flaw in the program and that is the fact the links in the SAP menu aren't working since iOS devices don't support the double click command as computer based browsers do. The author has published a workaround which proves to be functioning, so it's worth having a look.


To obtain the application you can just go to the App Store and look for SAPPLAPP. It costs 0,79€.


All credits for this app go to the author Thorsten Esser.


Go to his website for more info:

React (0 reactions) / Send this post to a friend