Time dependent Master Data cleanup
We are storing the Status of Equipments (Live or Decommissioned) in a time-dependent InfoObj. This InfoObj is used in an ODS. Now it appears that the logic we were using for determining the status dates of pipes was wrong and we need to modify the extraction logic (we're using generic extraction by FM). Changing the logic can be done - but the problem is that the new values will mess up in the Q-table.
For example, say an Eq went live on 1-Jan-2007 as per earlier logic. If the new logic says it went live on 1-Mar-2007, then this will be added to the Q-table and it will show the pipe as live even in the interval 1-Jan-2007 to 28-Mar-2007, which is wrong. So basically I need to clean up the wrong values in the master data.
This characteristic is used in an ODS, and deleting the data in the ODS is not feasible. I know it is not possible to delete the Master data without deleting the ODS. But is there any workaround I could use, if someone has faced a similar situation?