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 !!
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
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
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
Hello Arthur,
Well, that's one good reply. Apt information which I was looking for. Great, thanks !!
Babu Kilari