topic Re: online report from archived data in Application Development and Automation Discussions

online report from archived data

Former Member — Wed, 16 Jul 2008 02:48:16 GMT

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?

Re: online report from archived data

Former Member — Wed, 16 Jul 2008 05:23:39 GMT

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

Re: online report from archived data

valter_oliveira — Sat, 19 Jul 2008 22:19:05 GMT

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.