Data Archiving

Helps to free up space in DB, which will improve system performance and reduce IT’s carbon footprint!

Pre-requisitesDetermine data retention period to handle audits (Finance team)
Determine data retention period for transactional analysis(Analytics team)
Determine archived files retention period and also back up (IT team)
TCODEsDB02 – Database size analysis – Largest table, indexes.
DBACOCKPIT
DB15 Tables of Archiving Object
TAANA – Table Analysis
SARA – Archive Administration
Execution steps1. Maintain Archive File Path
2. Maintain Residence Time
3. Maintain Infostructure
4. Check Network graphic to check dependency objects
5. Run Preprocessing program if applicable (example MM_EKKO, it sets deletion flag on record)
6. Run Write program
7. Run Deletion program
8. Run Postprocessing program if applicable (example FI_DOCUMNT, it deletes secondary indexes)
Step 1Request System Administrator to set up Logical Path
FILERefer Note 35992  for file naming standards

Result:

Step 2 Maintain Residence Time, example for PO
Step 3.Maintain Infostructure
TCODESARA->Archive Information System-Customizing->Find Infostructure for Archiving object and activate.
System will generate table for Infostructure

Step 4.Run Preprocessing Program to set deletion indicator
TCODESARA or SE38
Program RM06EV70
NoteOnly few objects need preprocessing program execution. Check SARA for which objects need pre-processing
Step 5.Run Write Program to Archive
TCODESARA or SE38
Program RM06EW70
Step 6.Run deletion program
TCODESARA or SE38
Program RM06ED70
NoteSelect file which generated in Step5 and execute
Step 7.Test scenario, call PO number which is Archived
TCODEME23N
TCODESE16 – EKKO

hlep.comDisplaying Archiving Objects and Tables | SAP Help Portal
Notes 1933813(EBAN)
GroupObject A of the GroupObject B of the GroupObject C of the GroupObject D of the GroupRecommended Order Within the GroupRecommended Order of the Groups
1MM_MATBELMM_INVBELMM_REBELMM_HDEL  
2MM_EKKO    2 before 3,2 before 13
3RV_LIKPSD_VBRKSD_VBAKSD_CONDA, B, C, D 
4RL_TA     
5WRECH    5 before 6
6WBUWCI   6 before 7
7WREG    7 before 8
8WZR    8 before 9
9WLFWSI    
10MM_ACCTIT    10 before 11,10 before 15
11FI_DOCUMNT    11 before 12
12PCA_OBJECT    12 before 13
13CO_ITEMCO_COSTCTRCO_ML_BELCO_ML_IDXA, B 
14WB2     
15MM_MATNR     
Sequence of Objects in Archiving