Skip to Content

Self Inventory Init in BW

Hi,

I have the necessity to set a new inventory init for my BW model. Create a new init from ECC using the 2LIS_03_UX data source is not possible due the huge data volume in MSEG table (over than 2000 millions records).

So, I´m trying to create a self inventory init en BW:

1. I have a query over my infocube 0IC_C03 to take the inventory at specific date (for example 31.12.2017) in a APD.

2. The APD saves the inventory balance in a DSO.

3. I connect this DSO to a new Infocube ZIC_C03.

4. Load the inventory balance at 31.12.2017

5. Load all UM and BF requests, using the filter "posting date > 31.12.2017"

But, when I want to compare the inventory at 31.01.2018 I´m realized the snapshot at 31.12.2017 is not cosidered in the balance at 31.01.2018. Somebody have tried something like this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 28 at 02:39 PM

    Hi Galindo,

    check out the OT-NC Wiki Page. There is a topic box on 'Data Mart extraction from non-cumulative InfoCubes and ADSOs'.

    Extraction mode and 0RECORDTP are the things to check in detail for the reference points to be created.

    Cheers,

    Nora

    Add comment
    10|10000 characters needed characters exceeded