Technical Tables Clearance Automation – Process Chain - PC_TTC_01
Introduction
Technical table's clearance is a process of clearing the unwanted data from the system.
This activity has been initiated to save space before HANA migration. The top technical tables have been identified based on memory utilization and then it is planned to automate the clearance of unwanted data periodically.
The following tables have been considered as part of this process.
Technical Table Names |
BALDAT |
RSBATCHDATA RSBATCHHEADER RSBATCHCTRL |
EDI40 EDIDC EDIDS EDID4 |
RSBERRORLOG RSBERRORCHANGED |
RSBKSELECT |
RSODSACTUPDTYPE |
RSDDSTAT* (15 Tables) |
Data Retention Periods
Technical Table Names | Retention Period in Days |
BALDAT | 90 |
RSBATCHDATA RSBATCHHEADER RSBATCHCTRL | 30 |
EDI40EDIDCEDIDSEDID4 | 60 |
RSBERRORLOG RSBERRORCHANGED | 30 |
RSBKSELECT | No Selections |
RSODSACTUPDTYPE | No Selections |
RSDDSTAT* (15 Tables) | 365 |
Programs to delete the unwanted data
The below specified programs are used to clear the unwanted data.
Technical Table Names | SAP Standard Programs | Variants | Selections |
BALDAT | SBAL_DELETE | ZVAR_SLG2_1 | 1. From Date : 01.01.1900 2. To Date : Current date - 90 days3. Options - Select Delete Immediately |
RSBATCHDATA RSBATCHHEADER RSBATCHCTRL | RSBM_ERRORLOG_DELETE RSSM_ERRORLOG_CLEANUP | ZVAR_DTP_EL - | 1. but always older than ... days - 30 2. delete log = 'X' |
EDI40 EDIDC EDIDS EDID4 | RSBATCH_DEL_MSG_PARM_DTPTEMP | ZVAR_RSBATCH | DEL_MSG : 60DEL_PAR :60DEL_DTP 'X' |
RSBERRORLOG RSBERRORCHANGED | RSETESTD | ZVAR_EDI_1 | 1. Created on <= 30 days 2. Test Run = ' ' (uncheck) |
RSBKSELECT | RSBK_CONDENSE_RSBKSELECT | - | No inputs required. Directly execute in the background |
RSODSACTUPDTYPE | RSODSO_CLEANUP_RSODSACTUPDTYPE | - | No inputs required. Directly execute in the background |
RSDDSTAT* (15 Tables) | RSDDSTAT_DATA_DELETE | 1. Which data to be deleted ? : Select all the check buttons. 2. Date up untill which data is to be deleted ?: Free date selection : Up to date <= 365 days |
Automation
The process chain PC_TTC_01 is created to automate the clearance of unwanted data from certain technical tables.
Dynamic variants are used to pass the selection screen values to the programs.
Schedule
The process chain 'PC_TTC_01' is scheduled on every Sunday at 2 PM IST i.e. 9.30 AM GMT+1(France time)