Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

online report from archived data

Former Member

‎2008 Jul 16 3:48 AM

0 Likes
714

We have Ztables as it contains a lot of transactional data growing very fast. hence we are planning to archive this ZTABLES using archiving objects.

but once data is archived we might need to run reports at a later time(a online report ) and still need this data. How can we achive this?

can i have details about the stratergy discussed it anyone tried the same?

or is there some other way? we need to reduce the data in ZTABLES for sure as it will be performance issue. can someone advice the best stratergy 4 the same?

We have Ztables as it contains a lot of transactional data growing very fast. hence we are planning to archive this ZTABLES using archiving objects.

but once data is archived we might need to run reports at a later time(a online report ) and still need this data. How can we achive this?

can i have details about the stratergy discussed it anyone tried the same?

or is there some other way? we need to reduce the data in ZTABLES for sure as it will be performance issue. can someone advice the best stratergy 4 the same?

Reply
2 REPLIES 2
Read only

Former Member

‎2008 Jul 16 6:23 AM

0 Likes
561

Hi,

You could maintain the statistics that is required for th eonline report in a new table and access this table to display the online report.

Make sure you collect the required statistics before you archive the data.

Regards,

Shruthi R

Read only

valter_oliveira
Active Contributor

‎2008 Jul 19 11:19 PM

0 Likes
561

Hello.

When you create an archiving object, you can assign it to an archive infostructure. This is a table that contains some of the fields of the table that you will archive and speeds up the access to archived objects (works like an index).

Check in tcode SARI-Customizing-Create. After creating must activate.

Then, will be created a table ZARIX... where you can see data in se16 like a normal database table.

Example:

Archive Object: SD_VBRK

Archive Infosctrucure: SAP_SD_VBRK_002

Table created: ZARIXSD3 (in my system).


* Acess archive data
SELECT SINGLE gentab FROM aind_str2
  INTO (w_gentab)
 WHERE archindex EQ 'SAP_SD_VBRK_002'
   AND active EQ 'X'.

Also check this link:

http://help.sap.com/saphelp_nw70/helpdata/EN/5c/11af98d55711d2b1f80000e8a5b9a5/frameset.htm

Regards.

Valter Oliveira.