Skip to Content
0

Initialize Daywise Stock in 0IC_C03 where Delta is already active for 2LIS_03_BF

Jan 26, 2017 at 09:03 AM

24

avatar image

Hi

We have Inventory Cubes for Month(0RT_C37) delta is active and the data populated is correct. Now we need daywise stock(0IC_C03). How is this possible without disturbing the current delta loads and Very minimum Source System Downtime. No Historical Inventory details needed in daywise cube. Need only the delta data from the day we initialize.

Expected steps that we are going to follow is given

1. Lock all users in ECC and stop all kind of stock related movements

2. Extract all delta to Monthwise Stock from 2LIS_03_BF & 2LIS_03_UM.

3. Run 2LIS_03_BX and extract to the cube 0IC_C03 using DTP in initial non cumulative mode and compress the data without marker update.

4. Run DTP to 0IC_C03 with mode Delta init without data.

5. Unlock all users in ECC and start all stock movements

6. Extract delta to 0IC_C03 and 0RT_C37 and compress those with marker update.

7. Only if we need historical movements, Fillup setup table and extract to only 0IC_C03 and compress using no marker update.

Will this steps workout or, Is there any other method to get daywise stock without disturbing an ongoing delta ETL

Regards

Reshoi R

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers