repairing data loaded from 2LIS_11_VAITM

[Former Member]

Hi,

Due to an oversight, the fiscal year variant for 2007 was not loaded in before the change of the year and we had data loading problems before this was corrected. After the variant problem was fixed, the delta loads have been OK but we have missing or erroneous data in BW for a few hundred records from that first day. The data flow looks like:

Sales Orders Cube <- Sales Orders ODS <- Sales Order IS <- 2LIS_11_VAITM

What I would like to do is delete out the records that were loaded during the suspect time (a few thousand records at most) and load them in again. I have read note 739863 and believe that the best thing to do is apply a repair request. I have the steps as the following:

1. use the logistics cockpit to delete the setup table and fill it with records from the period in question

2. selectively delete the data from the ODS from that same time period

3. Create an infopackage to as a full data upload into the PSA only and select the full repair request flag.

4. Run the infopackage and examine the results in the PSA.

5. If the PSA data looks OK, update the data targets.

Am I missing any steps? Do I need to do anything to restore the set-up table to allow the delta loads to continue?

Thanks.

Rob

[Former Member · Accepted solution]

your steps are correct.. you neednt do anything to restore the set-up table to allow the delta loads to continue?..as the data in set-up tables is for full load and delta intilization only.. the deltas in your case are not disturbed..

your deltas are taken care by the v3 jobs that are scheduled to collect deltas in extraction queue later RSA7.. so you neednt worry about set-up tables data..to restore for delta.

[Former Member]

Thank you for the helpful answer. The process went well (although I did have some duplicate records that needed to be cleaned up). I awarded you points for your trouble.

Rob