We have an open hub table which is having past 6 years data (around 600GB).
Due to the size constraint, we have got a requirement to retain only the records newer than 365 days in the OH table and to delete the other records.
We have DATE0 field to capture the date on when the record is inserted into the OH table.
We can write an ABAP program to delete the records from the table by checking the date value in DATE0 field.
Is there any other way to perform this activity in OH table like performing selective deletion in a DSO/Infocube?