Skip to Content
Author's profile photo Stephen Johannes

CRM on Hana a few announcement observations

Earlier this week SAP announced at SAPPHIRE Madrid that SAP CRM would be on put on HANA as part of a larger application offering called SAP 360 Customer.  This solution would surround the existing SAP CRM and sales on demand solutions.  I was not at SAPPHIRE Madrid, but was able to get a sneak peak of the SAP CRM on HANA and like all of you went through the publicly made materials on the solution.  That being said I feel that most analysts don’t fully get ramifications of what this means when it comes to current on-premise SAP CRM soslution.  Even though SAP can make statements like X amount faster it means nothing if we don’t understand the bottlenecks of the current SAP CRM system and how HANA can turbocharge the system.

SAP CRM: A search based system

For those of you who don’t work with an actual SAP CRM product on a daily basis as either a user of the system, tech support/consultant or developer may not realize that user interface requires you to either create or search for data as your first step in dealing with any type of data.  We can divide these searches into two primary types: master data and business transactions.  I’m not going to go into the full data model, as one could write part of a book on that topic 😉 but let’s take a quick look at the difference between the two.  Master data in CRM terminology is generally the same as ERP Master Data.  CRM Master Data includes data such as customers, prospects, contact persons and employees which in SAP CRM terminology are business partners.  In addition goods or services that may be sold are known as products.  Business Transactions describe an interaction between business partners where a communication or exchange of goods or services takes place.  Common examples are customer visits(activities), customer complaints, sales orders, service requests, etc.  In CRM we have two primary ways of looking up data.  We can take a “customer centric” approach or “interaction centric” approach.  The customer centric approach involves finding the overview screen of an account and then looking at the related data.  The interaction centric approach involves looking for a particular type of interaction in the system for a broad range of criteria.

As you can tell from either approach we must search for data before it is brought up.  In the customer centric approach we bring up a business partner and then several “searches” are executed in the background that show the related data.  This related data includes transactions that are related to that business partner and in addition other partners that are related.  For an interaction centric approach we bring up a search screen for a particular type of interaction(sales orders, complaints, leads, etc) and then provide criteria that may cross one or many business partners.  In both cases however we are always executing the same technical search code in the background the difference is that on part of the UI the search has been automatically limited to a single business partner where in the interaction centric approach we not limited to a single business partner unless we choose this.  In both cases the searches executed end up being part of the day-to-day usage of the business users of a SAP CRM system.

Business Transction Search Performance Problems

The business transaction search can be very slow if there were no optimizations to made to it.   The reason being is that business users rightfully demand the ability to search on almost any attribute of a business transaction.  As we understand that if we try to perform searches on a OLTP data model we always encounter tradeoffs when search.  The code for searching for business transaction in SAP CRM is quite complex and can make your head spin when you look at it for the first time. Some of the early attempts to optimize the search involve built-in tables within CRM to index the data for searches.  The most infamous table CRMD_ORDER_INDEX is a table that adds no business value beyond making transaction search feasible in SAP CRM. 

Speed up Search, Speed up SAP CRM

As SAP has realized that search is a key bottleneck in SAP CRM attempts have been made to speed it up.  With introduction of Enterprise Search tools using the TREX SAP has been able to offer ways to speed up search by adding on additional layers.  However the drawback of these approaches is that data must still be indexed and requies additional landscapes to manage.  This is where the promise of of SAP CRM on HANA comes in play.  For the first time in the history of SAP CRM we can actually remove layers to gain performance optimization.  By using in-memory computing to power the search on the same database our searches have the promise of not causing the “wheel of death” on the SAP CRM system to be shown.  That promise of speeding up a fundamental use case within SAP CRM why I see the true value of putting SAP CRM on HANA.  Once we no longer have to worry about performance there are so many other creative things we can dream up such as “real-time segmentation of our customers” instead of waiting for sales data to be available and a batch job to run to put our customers in the correct market segment.

Wait aren’t you some salesperson, or getting paid for this?

As I said earlier beyond getting a sneak peak, I have no paid involvement with promoting this.  My opinions reflect the materials made available to me about the solution and my experience working with a current SAP CRM 7.0 on standard database from a technical support perspective.  The wheel of death is the number one complaint of my CRM users and any solution that promises to eliminate that grabs my attention.  As the old saying goes the “devil is in the details”, it will be interesting to see the cost, time, and effort to migrate existing SAP CRM customers to the platform.  If the cost and effort are reasonable and can provide the expected ROI, I would expect the general excitement and adoption to be faster than the webclient UI.  Yes we can always throw more hardware at a SAP CRM system to make it faster, but I think this is case where instead we are trying to treat the cause of the problems instead of the symptoms.  I think the real debate will be on ROI and effort and not on the fact that performance will increase.  That being said this is not recommendation to drop what you are doing and go install this immediately.  Rather I feel that all SAP CRM Customers must take a hard look at this solution and can not look the other way anymore when it comes to HANA. 

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Thomas Wailgum
      Thomas Wailgum

      Thanks Stephen for sharing your thoughts. I think, as you correctly point out, the devil will be in the details. It's going to be interesting to see traditional SAP CRM customers' appetite for any new CRM-related expenditures going forward--even if it is for the almighty HANA.

      Author's profile photo Hendrik Neumann
      Hendrik Neumann

      Hi Stephen,

      very good blog. I think you make a very good point with the observation that from a speed up search follows a speed up system. One pain less for the customers. No more: "close those assignment blocks or you'll get gray hair waiting for the opportunity to open" 😉

      Still the point of integration into other systems could slow down the overall experience. Just thinking about IPC for pricing or MM lookups via middleware.. will be interesting to see how SAP tackles that - especially with ERP on HANA later on.

      Furthermore I'm very interested in how SAP handles the many buffer layers in 1Order transaction handling.. since HANA best practice is totally different from that paradigm (at least as far as I did understand it), putting everything down into the database.

      Interesting times for CRM!



      Author's profile photo Ashutosh Mutsaddi
      Ashutosh Mutsaddi

      Thanks Stephen. That's quite a comprehensive article!

      As you have rightly pointed out, time will tell if SAP CRM works great with HANA. But if it does, it will also encourage other non-SAP customers to run their CRM systems on HANA. And that would be a large clientele! So, the stakes are very high for SAP and HANA.

      - Ashu

      Author's profile photo Former Member
      Former Member

      Hi Stephen

      very nicely explained ,

      as a CRM developer  i would be interested in knowing, will it change the way we access the data from CRM.


      Author's profile photo Former Member
      Former Member

      Hi Stephen,

      Good blog, explained well in a simple manner.

      Our company would like to try out few use cases in CRM on HANA., Is this available in AWS Cloud ?



      Author's profile photo Matthias Wild
      Matthias Wild