Skip to Content
Author's profile photo Babu Kilari

DB Procedures in LC Vs AMDP concepts in HANA

I was looking at the DB procedure call APS_ORDER_GET_DATA in one of the gATP FMs /SAPAPO/OM_ORDER_GET_DATA to understand a bit more on the architecture. The above DB procedure simply fetches the data from the Live Cache. But, how does it do ? It makes a connection to your LC server and executes the above mentioned DB procedure in the LC to fetch the data from the memory. My understanding is this DB procedure would execute set of Native SQL scripts that can manipulate the data within the LC memory and give the results back to you. I was trying to look for some SAP notes if there is any tool that can trace the code in it. But, I couldn’t find any. (You’re welcome to share if you know….).  Now, the point is this looks close to what SAP is offering with AMDP (ABAP Managed Database Procedures ) on HANA. With AMDP, you can write your own DB procedures to run on that little XS server i.e., tightly coupled with HANA DB. Not sure if we will be able to manipulate the standard DB procedures using some “exits” in the future. The concept as such tells me that LC processing is one of the predecessors of HANA as it uses the in-memory processing engine. Just my thoughts !!

Assigned Tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hello, Babu.

      On HANA, debugging XS services and procedures is fairly simple using HANA Studio. You only need to find it on the catalog. As far as I know, debugging SQL Script is an improving feature in newer HANA SPs and you should even be able to debug it.

      Check this Babu: http://help.sap.com/openSAP/HANA1/openSAP_HANA1_Week_03_Unit_05_SQLScript_Debugger_Presentation.pdf

      These are some detailed steps on how to debug it using the HANA Studio.

      Hope this helps on your journey to unveil the secrets of HANA. 🙂

      Regards,

      Arthur Braga

      Author's profile photo Babu Kilari
      Babu Kilari
      Blog Post Author

      Hello Arthur,

      Thanks.

      Is it also possible to debug the XS Services of Standard DB Procedures which are specific to Live Cache processing in SCM System ?

      Babu Kilari

      Author's profile photo Former Member
      Former Member

      Hello Babu,

      I have never used a HANA system where the LCAPP plugin (the one which have SCM functions on it) was installed. However, I believe that if the LC procedures were written specifically for HANA, this would be as any HANA procedure is and thus you would be able to get to it. However, if the procedures are wrapped in an extra liveCache specific layer on top of HANA, I wouldn't be able to tell you for sure that you will have access to it.

      Arthur Braga

      Author's profile photo Babu Kilari
      Babu Kilari
      Blog Post Author

      Hello Arthur,

      Well, that's one good reply. Apt information which I was looking for. Great, thanks !!

      Babu Kilari