data archiving

[Former Member]

How do you archive old data in SAP and how do you retrieve the same when required?

[Former Member · Accepted solution]

Hi,

You can refer the following link for your querry:

http://help.sap.com/saphelp_nw04s/helpdata/en/2b/086f3b6c980c3be10000000a11402f/frameset.htm

regards,

Siddharth.

[Former Member]

hi swapna,

pl check this notes.

Archiving (transaction SARA)

Data archiving removes bulk data which is no longer required in the System, but which must be retained accessibly, from the database. Data in the R/3 database can only be archived via archiving objects, which describe the data structure. Financial accounting documents, for example are archived via the archiving object FI_DOCUMNT, which comprises the document header, company-code-dependent postings, change documents, SAPscript texts and other elements. The application archiving objects are pre-defined in the system. The archiving programs are scheduled as background jobs, but can run during on-line processing. The system need not be shutdown.

The archiving procedure comprises two main steps:

Create archive files: the data to be archived are first written sequentially into a newly created file. The data then exist twice in the database. These archive files can, e.g. be passed to an archive system, via ArchiveLink.

Execute delete program: the data in the archive files are removed from the database by the delete program.

You can check how the archive filenames and archive destination are setup in transaction FILE

Always remembers to check the setting before any archiving. The settings will determine things like whether the delete programs will start automatically. (it is not advisable to start your delete programs automatically).

You can configure all the customizing settings with transaction AOBJ - Archive Objects.

MM_MATBEL - Archive material document

OMB9 - Archiving - Material document retention period.

The default documents life is 200 days. You need to maintain the documents life for each Plant in your company before you can start archiving. If you did not maintain, you will get a list with 'Valid.period not maintained for tr./ev. type of doc.'.

MM_ACCTIT - Archive accounting interface tables

The documents store in the table are for applications which are to be supplied with the posting data at a later date of MM Inventory Management and MM Invoice Verification.

If you are using 3.x, this archiving object might not be found. You need to import it from sapservX. Read note 89324, 99388, 83076.

Take a look at OSS note 48009 for the detail explanation of which data is updated in the ACCT* tables.

PP_ORDER - Archive production order

OPJH - Production Order retention period. Maintain Retention 1 and 2.

If your set your retention 1 and 2 as 10, that means that after 10 days of setting the delete flag then you can set the deletion indicator. After 10 days of setting the deletion indicator then you can start archiving. Therefore, to archive immediately, you can leave retention 1 and 2 as space. Please take note that retention 1 and 2 act as a safety net if you happened to archive the wrong record. You will have to decide whether to have the retention time gap or not.

FI_DOCUMNT - Archive Financial Accounting Documents

Maintain the account life - transaction OBR7

Maintain the documents life - transaction OBR8

SD_VBRK - Archive Billing Documents

There are no posting date or fiscal year/period selection. You can only specify the billing documents date. In order that you do not archive the wrong record, you have to write a ABAP query or report to print out the various billing documents number ranges you want to archive. You can extract the data from table VBRK - Billing: Header Data.

VN01 - Check all the number ranges for Billing Documents.

Click Overview buttom or Hold the Shift key and press F7.

RV_LIKP - Archiving Deliveries

VORL - Maintain the retention period. Number of days which must have elapsed since the delivery was created, before the

delivery can be archived.

VLAL - Archive deliveries

regards

sadhu kishore

[Former Member]

Hi Kishore,

All the billing documents created by me till now are not being shown. I went through the SAP help portal and followed this process in order to retrieve them:

T.Code: SARA

In the new screen -> Archiving object: SD_VBRK

Click on Storage systems -> Retrieve files

But after this in the Archive administration screen, the "Archive selection" tab has an error flashed next to it saying NOT MAINTAINED. On further selecting "Archive selection" tab, an empty pop-up comes and there are no details of any archived billing documents.

When i tried to check statistics, the archiving showed documents only upto the year 1999.

Does this mean that my billing documents have been archived and then deleted?

[Former Member]

Hi, U said that the billing documents were archived upto 1999 only. The reason for this is that you might have set the residence time which only lets the billing docs up to 1999 to be archived.

On another question on ur biling docs getting archived first and then getting deleted ... It actually depends upon the customising that u have done for that object.U can check this customising in Customizing--> Technical settings within the t.code < sara>.

[reazuddin_md]

Hi Swapna D,

Go through this, may be helpful.

Retrieving Archived Files

Use

Using the SAP Content Management Infrastructure (also contains the ArchiveLink/CMS interface), archive files stored in a storage system can be retrieved into the SAP system for further processing such as evaluation .

Prerequisites

• You are in the Archive Administration; Initial Screen (transaction SARA). You have entered the name of the archiving object in the Object Name field.

• The archive files for retrieval are accessible from Archive Administration.

Procedure

1. Choose Storage System.

The Store/Retrieve Archive Files menu box appears.

2. Choose Retrieve Files.

The Archive Administration: Retrieve Files screen appears.

3. Using Archive Selection, select the archive files you want to retrieve and specify when you want the retrieval to commence.

4. Confirm your retrieval request by choosing Execute.

Result

The selected archive files will be retrieved into the SAP system at the specified time for further processing.

The Storage System function is also available under management in Archive Administration.

Reading Archive Files

Use

In addition to the data in the online database, archived data can also be read or analyzed. When data is analyzed, it is read sequentially and elementary information such as item number, customer and order date is displayed in list form. It is possible to run an analysis for one or several archiving sessions. Not all archiving objects offer an analysis program.

Prerequisites

1. • The archive files to be read are accessible from Archive Administration.

2. • There is at least one read program for the archiving object used.

3. • You are in the Archive Administration: Initial Screen (transaction SARA). You have entered the name of the archiving object in the Object Name field.

Procedure

1. 1. Choose Read.

You access the screen Archive Administration: Start Read Program, where you can schedule your job.

2. 2. In the Batch/Dialog field, specify whether the analysis program is to run in the background (batch) or online (dialog).

3. 3. In the Read Program field, select a read or analysis program and choose Execute.

Depending on the selected archiving object, you access a specific selection screen. For more information, refer to the documentation on the specific archiving object.

4. 4. Enter your selection, and choose Execute.

You access the dialog box Archive Management: Select Files to Read. For more information on file selection, refer to Archive Selection.

5. 5. Select the archive file that you want to read or analyze and confirm the selection by choosing Continue.

The Goto menu offers access to the following:

1. • Customizing

2. • Job Overview: Offers an overview of all archiving jobs and the functions available for processing them. For more information on the job overview, refer to Managing Jobs in the Job Overview.

3. • Management

4. • Database Tables

5. • Infosystem

See also:

Archive Information System

Reporting Information Structures