Hi Experts,

I would like to see the SQL code in the DB procedure APS_ORDER_GET_DATA in the standard gATP funtion module /SAPAPO/OM_ORDER_GET_DATA. Is it possible to see it ? Any trace or transaction that can run a trace on Live Cache layer ?

Appreciate your thoughts.

Babu Kilari

asked 17 Feb '15, 07:12

babukilari's gravatar image

accept rate: 0%

Hi Babu. To my knowledge the procedures are compiled C/C++ functions linked to the DB so that netweaver can use the same DB-API. The code is not available and it is not possible to debug into this LC layer.

permanent link

answered 18 Feb '15, 05:06

pedrolima's gravatar image

pedrolima ♦♦
accept rate: 32%

Hi Pedro,

Thank you for your reply. I asked the above question in relation to the AMDP ( ABAP Managed DB Procedures ) in AS ABAP on HANA. I think Live Cache is one of the early predecessors of In Memory type of DB layers and I was thinking if SCM runs on HANA, do we get an oppurtunity to see these DB procedures ? Rather the question should these be different from AMDP. Any insights ?

Appreciate yuor help.

Thanks & Best Regards, Babu Kilari

permanent link

answered 18 Feb '15, 07:36

babukilari's gravatar image

accept rate: 0%


I suppose that in some point in the future LC may be replaced by HANA, and then all the LC routines will be rewritten in HANA procedures. But currently SCM on HANA still uses the same LC and the same compiled LC routines. The HANA only replaces the Oracle/DB2/etc database.

(18 Feb '15, 16:49) pedrolima ♦♦

Hi Pedro,

I totally agree with you on the current scenario. It is just replacing the DB nothing more than that and may be BOP would run a bit faster as I heard. As far as the analytics is concerned, I am curious to know these standard DB procedures would fucntion on HANA DB (ie., XS Server) and more importantly, do we get an oppurtunity to customize them to improve the functionality ? or do they restrict these type of DB procedures to be untouched. Should the answer be wait and see ?

Cheers, Babu Kilari

(19 Feb '15, 05:32) babukilari
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 17 Feb '15, 07:12

question was seen: 2,236 times

last updated: 19 Feb '15, 05:32