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:
![](https://wetechideas.com/wp-content/uploads/2023/02/image-31.png?w=861)
![](https://wetechideas.com/wp-content/uploads/2023/02/image-29.png?w=943)
![](https://wetechideas.com/wp-content/uploads/2023/02/image-30.png?w=1024)
![](https://wetechideas.com/wp-content/uploads/2023/02/image-28.png?w=761)
Step 2 | Maintain Residence Time, example for PO |
![](https://wetechideas.com/wp-content/uploads/2023/02/image-32.png?w=865)
![](https://wetechideas.com/wp-content/uploads/2023/02/image-33.png?w=463)
Step 3. | Maintain Infostructure |
TCODE | SARA->Archive Information System-Customizing->Find Infostructure for Archiving object and activate. System will generate table for Infostructure |
![](https://wetechideas.com/wp-content/uploads/2023/02/image-34.png?w=1024)
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 |
![](https://wetechideas.com/wp-content/uploads/2023/02/image-35.png?w=1024)
Step 5. | Run Write Program to Archive |
TCODE | SARA or SE38 Program RM06EW70 |
![](https://wetechideas.com/wp-content/uploads/2023/02/image-36.png?w=808)
![](https://wetechideas.com/wp-content/uploads/2023/02/image-37.png?w=1015)
Step 6. | Run deletion program |
TCODE | SARA or SE38 Program RM06ED70 |
Note | Select file which generated in Step5 and execute |
![](https://wetechideas.com/wp-content/uploads/2023/02/image-39.png?w=628)
![](https://wetechideas.com/wp-content/uploads/2023/02/image-40.png?w=1024)
Step 7. | Test scenario, call PO number which is Archived |
TCODE | ME23N |
TCODE | SE16 – EKKO |
![](https://wetechideas.com/wp-content/uploads/2023/02/image-41.png?w=1024)
![](https://wetechideas.com/wp-content/uploads/2023/02/image-42.png?w=926)
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 |