on 04-23-2009 11:08 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.