Reloading data which is already archived

[Former Member]

Hi Friends,

The customer requirement is to see the data (which has been already archived), in the table BSEG, and not from any transaction like FB03.

Is there any way to reload the data into the database after it is achived?

Because in transaction SARA, it does not show the 'reload' buton for the archiving object FI_DOCUMNT.

Also, one more question. I have retrieved the archive files by mistake from third party tool to SAP.

How can I send them back from SAP to the third party tool (IBM Commonstore)? If I go to the 'Storage' option and then 'retrieve' option in SARA, it does not show the retrieved files in the selecion list.

Thanks & regards,

Kunal Patel.

[Former Member · Accepted solution]

Hi,

>The customer requirement is to see the data (which has been already archived), in the table BSEG

If your customer agreed to archive the data, he should have known that the data will not be anymore in the table. (that is the definition of archiving !)

The golden rule is to archive data that is not anymore needed in the tables.

>Because in transaction SARA, it does not show the 'reload' buton for the archiving object >FI_DOCUMNT.

If there is no 'Reload' button, it's not possible to reload the data.

Regards,

Olivier

[Former Member]

Hello,

If you have an activated archive information structure for FI_DOCUMNT, you should be able to view the archived BSEG data from within the technical view option. You do not need to reload the data to be able to see it.

To check this out, go to transaction SARI, click on Archive Explorer, enter Archiving Object fi_document and clikc on Execute. Enter the relevant selection criteria and click on Execute. Your archived document(s) will be displayed in a list format. Double click on the relevant document number and you should get a pop-up box that will give you an option for the Technical view. This will give you the data in a table view format and will allow you to view the archived BSEG entries.

As for the Retreived files, you only retrieved a "copy" of the file. The original archive file should still be in Commonstore (please verify), so you should be able to just delete the copy at the UNIX level.

Hope this helps.

Best Regards,

Karin Tillotson

[Former Member]

Hi,

Thanks for your reply.

I am getting the below message while accessing the data for 2005 through

transaction FBL3N or even through SARI.

"Error in info structure SAP_FI_DOC_002 analysis program in line 66".

Is this because I retrived the files from Commonstore to SAP? Because in SARI it gives the error just on entering the object name, even before I provide the period for which I retrieved files i.e. 2005.

Kindly advice what to do.

Thanks & Regards,

Kunal Patel.

[Former Member]

Hello Kunal,

It should not matter if you have retrieved the archive files back to the exchange directory. Are you getting any other messages about the info structure? What is the status of the infostructure? If you go to SARI, click on Status, enter archive object and click on either Status Per Archive or Status Per Infostructure - either one should show the "Fill Status". If it is green, you should be able to view the archived data. If it is yellow or red, there are problems.

Please provide some additional information and I will try and help out.

Best Regards,

Karin Tillotson

[Former Member]

Hi,

When I go to the SARI tcode and go to status>status per archive>, it shows red icon for the files that I have retrieved form IBM Commonstore to SAP

And for status>status per infostructure>, it shows yellow icon

Thanks & regards,

Kunal.

[Former Member]

Hello,

There does seem to be something wrong with the infostructure (as the red and yellow lights indicate). Try re-filling the infostructure using one of the archive files that are in red. If it works, the light will turn green and you should be able to see the archived data. If it does not work, the joblog should be able to give additional information on why this isn't working.

To try re-filling the infostructure, go to SARI -> Status ->, enter archive object and click on Status Per Archive. Select one of the files, and click on Fill Structures. Make sure there is enough space in the tablespace for this activity. The job name will start with AIND_BUILD*.

If it is successful, continue re-filling the infostructure until all of the files show a green light.

If not, provide the messages in the joblog and I will try and help further.

Best Regards,

Karin Tillotson

[Former Member]

Hi,

Thanks for your reply...

But I have one query...

For re-filling the infostructure using one of the archive files that are in red, after I go to go to SARI -> Status ->, enter archive object and click on Status Per Archive, I am not getting any option for refilling structures...It is giving option to setup structures or delete structures....

Should I use the setup structures option?

Rgds,

Kunal.

[Former Member]

Hello Kunal,

Yes, use the Setup Structures button. In 4.6C it is called that, in ECC 6.0 it is called Fill Structures.

Regards,

Karin Tillotson

[Former Member]

Hi,

Sorry for asking so many questions...:)

But because this is a production system, for doing any activity in it, I have to convince the client that there wont be any problem.

So, few more questions:

1. What would be the consequences of this filling of data into the structures?

2. By filling data into the infostructures, are we doing reloading, or is this something different?

Because reloading is not required as you said earlier.

3. Also, do I have to do this filling for all the archiving sessions marked in red in SARI>Status>Status per archive?

Thanks once again for your help...

Thanks & regards,

Kunal Patel.

[Former Member]

Hi,

While you are retreiving the data through SARI it is same like reloading the data. There is only slight difference. Through SARI you are reloading only those data which are there in your info structure field.

For example by archiving FI_DOCUMNT you are archiving data from mainly BSES,BSEG,BSAS and BKPF these tables. But while you are retreiving through SARI you can select the fields which are there in BSES which is your requirement.

I hope this will help you to understand things.

Regards

Sirfraz

[Former Member]

Hello Kunal.

To answer your questions:

1) one consequence you could run into by filling the infostructure is running out of space - check with your DBA or Basis group to ensure the tablespace containing the infostructure table has enough space.

2) filling the infostructure is not the same as reloading. Reloading archived data means you are reloading the data into the same tables that it was archived from - NOT recommended. When you fill the archive information structure, you are adding rows to the ZARI* table for only those fields that have been configured for the infostructure.

3) it depends - if there is a certain time period for the data you are looking for, then only select those archive files for filling the infostructure. If the data is needed for all of the financial documents that have been archived, you would need to select all of the files that are "red" (if this is the case, you will need to make sure you have enough space).

If there is only a small time-frame where the BSEG data is needed, you could "retrieve" only those related archive files, ftp them to a test system, and "fill" the infostructure in the test system, so there would be no impact to the production system. Just a thought.

Hope this helps.

Best Regards,

Karin Tillotson

[deidre_logan]

We have just loaded the ZARI* tables for the FI structure.

We are now seeing performance issues in VF03 when trying to retrieve the Accounting documents.

Are there any suggested indexes for these ZARI* tables or does each customer come up with their own indexes?

I can not find anything in OSS.