Dynamic variants are used to pass the selection screen values to the programs.
Technical Tables Clearance Automation – Process Chain - PC_TTC_01
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 |
RSBATCHDATARSBATCHHEADERRSBATCHCTRL |
EDI40EDIDCEDIDSEDID4 |
RSBERRORLOGRSBERRORCHANGED |
RSBKSELECT |
RSODSACTUPDTYPE |
RSDDSTAT* (15 Tables) |
Technical Table Names |
Retention Period in Days |
BALDAT |
90 |
RSBATCHDATARSBATCHHEADERRSBATCHCTRL |
30 |
EDI40EDIDCEDIDSEDID4 |
60 |
RSBERRORLOGRSBERRORCHANGED |
30 |
RSBKSELECT |
No Selections |
RSODSACTUPDTYPE |
No Selections |
RSDDSTAT* (15 Tables) |
365 |
The below specified programs are used to clear the unwanted data.
Technical Table Names |
SAP Standard Programs |
Selections |
BALDAT |
SBAL_DELETE |
1. From Date : 01.01.19002. To Date : Current date - 90 days3. Options - Select Delete Immediately |
RSBATCHDATARSBATCHHEADERRSBATCHCTRL |
RSBM_ERRORLOG_DELETE RSSM_ERRORLOG_CLEANUP |
1. but always older than ... days - 302. delete log = 'X' |
EDI40EDIDCEDIDSEDID4 |
RSBATCH_DEL_MSG_PARM_DTPTEMP |
DEL_MSG : 60DEL_PAR :60DEL_DTP 'X' |
RSBERRORLOGRSBERRORCHANGED |
RSETESTD |
1. Created on <= 30 days2. 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 |
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.