Helps to free up space in DB, which will improve system performance and reduce IT’s carbon footprint!
| Pre-requisites | Determine 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) |
| TCODEs | DB02 – Database size analysis – Largest table, indexes. DBACOCKPIT DB15 Tables of Archiving Object TAANA – Table Analysis SARA – Archive Administration |
| Execution steps | 1. 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 1 | Request System Administrator to set up Logical Path |
| FILE | Refer Note 35992 for file naming standards |
Result:




| Step 2 | Maintain Residence Time, example for PO |


| Step 3. | Maintain Infostructure |
| TCODE | SARA->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 |
| TCODE | SARA or SE38 Program RM06EV70 |
| Note | Only few objects need preprocessing program execution. Check SARA for which objects need pre-processing |

| Step 5. | Run Write Program to Archive |
| TCODE | SARA or SE38 Program RM06EW70 |


| Step 6. | Run deletion program |
| TCODE | SARA or SE38 Program RM06ED70 |
| Note | Select file which generated in Step5 and execute |


| Step 7. | Test scenario, call PO number which is Archived |
| TCODE | ME23N |
| TCODE | SE16 – EKKO |


| hlep.com | Displaying Archiving Objects and Tables | SAP Help Portal |
| Notes 1933813(EBAN) |
| Group | Object A of the Group | Object B of the Group | Object C of the Group | Object D of the Group | Recommended Order Within the Group | Recommended Order of the Groups |
| 1 | MM_MATBEL | MM_INVBEL | MM_REBEL | MM_HDEL | ||
| 2 | MM_EKKO | 2 before 3,2 before 13 | ||||
| 3 | RV_LIKP | SD_VBRK | SD_VBAK | SD_COND | A, B, C, D | |
| 4 | RL_TA | |||||
| 5 | WRECH | 5 before 6 | ||||
| 6 | WBU | WCI | 6 before 7 | |||
| 7 | WREG | 7 before 8 | ||||
| 8 | WZR | 8 before 9 | ||||
| 9 | WLF | WSI | ||||
| 10 | MM_ACCTIT | 10 before 11,10 before 15 | ||||
| 11 | FI_DOCUMNT | 11 before 12 | ||||
| 12 | PCA_OBJECT | 12 before 13 | ||||
| 13 | CO_ITEM | CO_COSTCTR | CO_ML_BEL | CO_ML_IDX | A, B | |
| 14 | WB2 | |||||
| 15 | MM_MATNR |