Page Comparison

E4C Activity objects can be archived. The solution provides three programs to write archive

files, delete data from SAP DB and restore data into DB. For this, a new archive object is created - with a

set of archiving programs for each group consisting of transaction data tables we want to archive and its dependent tables.

Setup

Object /PACG/EACT in transaction AOBJ

consists of the following properties:

The following tables are considered:

• /PACG/ECM_ACTI

• /PACG/ECM_ACTRE

• /PACG/ECM_ACTIR

• STXH

• STXL

• RELGRAPHLK

• Status
  title (s4)PACG 200 sp09

  /PACG/ECM_ACTSP

• Status
  title (s4)PACG 200 sp09

  /PACG/ECM_CACWF

You can enter tables from which data will be

removed but it is not necessary:

Image Added

The “Place file in the storage system” block can be set up directly in the customer environment to ensure that the write session was successful.

Image Added

You can leave all other steps empty. Go to transaction SE38, start program /PACG/ECM_ARC_DLT_E4CACT and create two variants with the same names as entered in AOBJ – Customizing settings. Please make sure that for test variant flag “Test run” is set and for production variant flag “Test run” is empty.

Test process

Run transaction SARA. Select archive object /PACG/EACT and start each step available from the first screen.

Image Added

With the “write” button, create a new screen variant for write program and save it with selection criteria of your choice.

Go back to the main write screen. Set time and printer (make sure you have “spool file only” option selected).

Submit write program.

Image Added

When submitted job is finished (you can check jobs with “job” function button on each screen), start “delete” step from main SARA screen.

Choose proper archive file and submit job like before.

Image Added

First test entire process with “test run” flag active in each step. Make sure no data is missing in DB tables

. After that, run with “test run” flag not active. Make sure that all data are fully removed

from DB tables. Restore all files using program from AOBJ configuration for object /PACG/EACT (this step can’t be run in SARA transaction, you need to use SE38 and execute /PACG/ECM_ARC_RLD_E4CACT) and make sure data are back in DB tables

.