How to read data form livecache

[Former Member]

Hi,

This is probably not an appropriate forum, however I saw there are many active members hence posting this query.

Can anyone tell me how to read data form livecache (APO). How to know what is database structure, what is table content etc.

Thanks & regards

[Former Member]

liveCache is object oriented database not relative database. You can get data from it with special COM procedures. Use some ABAP functions for reading data.

[Former Member]

Thanks for the info, but then how do I know what data is available. I saw some function modules in APO which uses commands like connect to livecache, execute procedure. My requirement is I need to get some additional field values, how do I get them? And if I don't know what is the structure, what is the field name, field type etc how can I extract/read the information.

[nablan_umar]

To read live-cache data in APO you should use SAP delivered function modules. The function modules are depending on the modules you are working on. For example, PPDS planned or production orders use different than DP/SNP. You can look at BAPI list to look at function modules you can use. For example, for DP and SNP you can use BAPI_PBSRVAPS_GETDETAIL to get key figures(in livecache) from a planning book.

[Former Member]

Thanks for the info, does this mean we can't read data from live cache directly? We have to always use SAP standard function modules / BAPIs to read data?

Sorry for being too specific, but I just wanted a definite answer.

Cheers

[nablan_umar]

So far in my 3 APO implementations, I never write my own codes to read/write live-cache. The com-routines to access data in live-cache are not similiar for all data. You have to look at each function modules individually. They are not like SAP transparent tables where you can use SELECT statement.

[Former Member]

Thanks again!

Regards