Custom Data Archiving - E4C activities

E4C Activity objects can be archived. The solution provides three programs to write archive file, delete data from SAP DB and restore data into DB. For this a new archive object is created - with a new set of archiving programs for each group consisting of transaction data tables we want to archive and its dependent tables.

Setup

In transaction AOBJ make a copy of the standard object “EXAMPLE” with proper name ZE4CACTIV.

Enter the values shown below:

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 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 form 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 make sure data are back in DB tables.

You can check tables like: /pacg/ecm_acti, /pacg/ecm_actir, /pacg/ecm_actie or simply choose/create activity with internal remarks and long description in transaction /PACG/ECM_ACTI_VC03 (Display E4C Activity) / /PACG/ECM_ACTI_VC01 (Create E4C Activity).