cancel
Showing results for 
Search instead for 
Did you mean: 

Live Cache in APO

Former Member
0 Kudos

HI Gurus,

We are extracting data from APO to BW and its working fine.

My query is , in APO how the data is stored in Live cache (ie) in any table structure ?.

Can we able to see the live cache data in any tables (Not in planning area).

Thanx in adv.

Guru.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

In Live cache data is stored based on Time series and order series.

You can extract the data through BAPIs

LC can store data in Order Objects(more relevant for dp and snp) or Time series(more relevant for forecasting and gat

liveCache is one of the database used in APO system.

APO system has 2 database APODB and liveCache.

Generally master data and some other data are stored in APODB.

And some part of transaction data (most of the part) are stored

in liveCache.

For APODB, you can use normal DB like Oracle, MSSQL, DB2, MAXDB.

For liveCache, their is no choice. (liveCache is one of the function

of MAXDB).

From new SCM release, you can use MAXDB for APODB and liveCache.

(But still there is 2 kinds of DB).

If you have DB knowlege, maybe you can get rough image of liveCache.

(Compared to normal DB, liveCache has more bigger datacache. So

all data can be stored in dataCache. <Off course this require

certain amount physical memory>).

Since most of the data are stored in dataCache (it is better to be

stored in datacache. Otherwise expensive disk access occur), APO

application can access data speedly.

(liveCache data is accessed by special routins that are called

from function module start with /sapapo/OM*)

liveCache is often called memory based database. But actually it also

has DB (disk). So same as other DB, DB(disk) has all data. And

its copy is stored in dataCache (memory). The difference between

other DB and liveCache is, it is recommended to store all the data

in dataCache in liveCache, and if most of the data is stored in

liveCache, this means data is on memory. Therefore liveCache is

called memory based database.

Thanks

Sreeni

Edited by: Sreenivasu on Apr 23, 2009 1:00 PM

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Raj,

Check these tables

/SAPAPO/BWEXDSRC APO -> BW: Data Source - Extractor

/SAPAPO/BWEXTRAC APO -> BW: Extractors for Transactional Data

/SAPAPO/BWEXTRFM APO -> BW: Formula to Calculate a Key Figure

/SAPAPO/BWEXTRIN APO -> BW: Dependent Extractors

/SAPAPO/BWEXTRMP APO -> BW: Mapping Extractor Structure Field

Regards

R. Senthil Mareeswaran.

Former Member
0 Kudos

Raj,

If you only want to see the data, some 'standard' livecache data is viewable using standard transactions.

/SAPAPO/OM19 Livecache Browser

/SAPAPO/OM16 Data Viewer

If you want to extract or report this data, then you will need to enlist the services of a Livecache ABAPer.

Regards,

DB49

Former Member
0 Kudos

Hi Guru,

In APO transaction data is not stored in tables like R3. If you want to view / check / extract transaction data then you willl have to use standard BAPI's. These BAPI's are available for diferent kind of data like sales orders, manufacturing orders, stocks, planned independent requirements, etc

Best regards,

Vaibhav