Deleting Archived Data from the Database 

Use

When you choose the processing option Archive and Delete for an archiving session, the archived data is automatically deleted from the system. However, sometimes it may be necessary to start the delete program manually.

You create an archive file and start the write program. The data records are copied to the archive file(s), but the system interrupts processing when the delete program is already running. In this case, you have to delete the archived data in a separate step.

Prerequisites

You have maintained the Customizing settings (in particular the Variants for Test and Production Sessions).

Procedure

  1. Choose Tools ® System Administration ® Administration ® Data Archiving, or start the transaction using the transaction code SARA.
  2. In the screen Archive Management: Initial Screen, enter the object name CONS_ITEM (for journal entries) or CONS_SUM (for totals records), and choose Delete.
  3. In the screen Archive Management: Execute Delete Program, choose Test run if you wish to start the delete program in test mode. (In test mode, no data records are deleted from the database.)

Choose Archive Selection.

The system produces a list of files that contain already archived data.
  1. Select the archive files which are to be deleted from your database.

    2. Return to the previous screen.

  2. Choose Start date.
  3. Enter the start time for the delete program and save your entries.

    4. Return to the previous screen.

  4. Choose Spool params.
  5. Enter the spool parameter information for the delete program and save your entries.

    6. Return to the previous screen.

  6. In the screen Archive Management: Execute Delete Program, choose Execute to start the delete program.

Result

If you started the delete process in the production session, the system deletes the data records from your database according to the archive files you selected.

If you started the delete process in a test run, the system does not delete any data records, but only reads them.

In both cases, you obtain a Log.