topic Re: How to read data form livecache in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-to-read-data-form-livecache/m-p/802368#M41006 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Fri, 20 Aug 2004 16:08:56 GMT nablan_umar 2004-08-20T16:08:56Z How to read data form livecache https://community.sap.com/t5/application-development-and-automation-discussions/how-to-read-data-form-livecache/m-p/802365#M41003 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This is probably not an appropriate forum, however I saw there are many active members hence posting this query.</P><P></P><P>Can anyone tell me how to read data form livecache (APO). How to know what is database structure, what is table content etc.</P><P></P><P>Thanks &amp; regards</P></BODY></HTML> Fri, 20 Aug 2004 10:14:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-read-data-form-livecache/m-p/802365#M41003 Former Member 2004-08-20T10:14:06Z Re: How to read data form livecache https://community.sap.com/t5/application-development-and-automation-discussions/how-to-read-data-form-livecache/m-p/802366#M41004 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Fri, 20 Aug 2004 12:29:54 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-read-data-form-livecache/m-p/802366#M41004 Former Member 2004-08-20T12:29:54Z Re: How to read data form livecache https://community.sap.com/t5/application-development-and-automation-discussions/how-to-read-data-form-livecache/m-p/802367#M41005 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Fri, 20 Aug 2004 12:45:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-read-data-form-livecache/m-p/802367#M41005 Former Member 2004-08-20T12:45:28Z Re: How to read data form livecache https://community.sap.com/t5/application-development-and-automation-discussions/how-to-read-data-form-livecache/m-p/802368#M41006 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Fri, 20 Aug 2004 16:08:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-read-data-form-livecache/m-p/802368#M41006 nablan_umar 2004-08-20T16:08:56Z Re: How to read data form livecache https://community.sap.com/t5/application-development-and-automation-discussions/how-to-read-data-form-livecache/m-p/802369#M41007 <HTML><HEAD></HEAD><BODY><P>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? </P><P></P><P>Sorry for being too specific, but I just wanted a definite answer.</P><P></P><P>Cheers</P></BODY></HTML> Mon, 23 Aug 2004 12:46:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-read-data-form-livecache/m-p/802369#M41007 Former Member 2004-08-23T12:46:01Z Re: How to read data form livecache https://community.sap.com/t5/application-development-and-automation-discussions/how-to-read-data-form-livecache/m-p/802370#M41008 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Mon, 23 Aug 2004 20:50:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-read-data-form-livecache/m-p/802370#M41008 nablan_umar 2004-08-23T20:50:30Z Re: How to read data form livecache https://community.sap.com/t5/application-development-and-automation-discussions/how-to-read-data-form-livecache/m-p/802371#M41009 <HTML><HEAD></HEAD><BODY><P>Thanks again!</P><P></P><P>Regards</P></BODY></HTML> Tue, 24 Aug 2004 10:13:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-read-data-form-livecache/m-p/802371#M41009 Former Member 2004-08-24T10:13:52Z