Custom Data Archiving - E4C activities

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:

Open

Open

 

The following tables are considered:

• /PACG/ECM_ACTI

• /PACG/ECM_ACTRE

• /PACG/ECM_ACTIR

• STXH

• STXL

• RELGRAPHLK

• (s4)PACG 200 sp09 /PACG/ECM_ACTSP

• (s4)PACG 200 sp09 /PACG/ECM_CACWF

You can enter tables from which data will be removed but it is not necessary:

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.

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.

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.

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.

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.