Skip to Content
0
Former Member
May 11, 2010 at 02:13 PM

Correction of wrong material stocks in BW?

290 Views

Hi all,

we are currently facing the problem that we have a cube showing all material movements over the last 5 years.

Now, the end users realized that something's wrong with it as stock quantity and valued stock in BW does not match the figures in ERP.

That's why we made a review on the data flow and did figure out the following:

--> all material movements seem to be right over the whole time

--> the problem seems to be the initial stock which has been loaded or renewed one year after the first material movement has been established (first material movement has been made in 01.2005, the stock initialization has been made in 11/2006.).

But stock amounts for each month still are not right for the whole period back to 01.2005.

What we now want to do is to correct this initial stock amount. We now about that we are able to re-load the curent stock with 2LIS_03_BX to BW...but we then have the problem that BW says that there has already an opening stock being loaded...

We tried to use reports RSCDS_MERGE_DUPL_REF_POINTS according to note 859320, but without any result...

So how to re-set-up the right stock amount without having to clear and re-load the whole cube? Is there any possibility to get in touch with the table the reference points are being set and to adjust it's values?

What we already tried as well is to build up a second cube and posting in all old values...but BW seems to post in some old reference point as well :-(...(even without having compressed that cube).

Would be great if somebody could provide me some hint,

Best regards,

bivision