Inventory Managment Scenario

[moha_nan]

Hi,

I have following Scenario,

On BW Side:

1) Data is loaded once from DataSource 2LIS_03_BX in Cube1.

2) Data is loaded from DataSource 2LIS_03_BF in Cube1 using 'Initialize Delta Process'.

3) Data is loaded from DataSource 2LIS_03_UM in Cube1 using 'Initialize Delta Process'.

4) Data is loading every week from DataSource 2LIS_03_BF in Cube1 using 'Delta Update'.

5) Data is loading every week from DataSource 2LIS_03_UM in Cube1 using 'Delta Update'.

On R/3 Side:

Outbound Queue MCEX03 (LBWQ) is filling correct and Delta queue (RSA7) for DataSources 2LIS_03_BF und 2LIS_03_UM contains delta data correctly.

So Cube1 is filling correctly und Query on Cube1 is working also correctly.

NOW, we have a new InfoCube (Cube2) which should filled the data from same DataSources 2LIS_03_BX, 2LIS_03_BF and 2LIS_03_UM (same R/3-System) from now onwards.

So,

I have to fill the Setup table for 2LIS_03_BX on R/3-Side, to load Current Stock (opening balance) once in Cube2. Later the delta data from DataSources 2LIS_03_BF und 2LIS_03_UM will be loaded simultaneously in both InfoCube (Cube1 and Cube 2). In RSA3, 2LIS_03_BX contains right now no data!

Question:

When I can fill the Setup table for 2LIS_03_BX on R/3-Side? Or when is the appropriate time to fill the Setup table for 2LIS_03_BX on R/3-Side? Outbound Queue MCEX03 (LBWQ) and Delta queue (RSA7) for DataSources 2LIS_03_BF und 2LIS_03_UM must be empty when I fill the Setup table for 2LIS_03_BX on R/3-Side?? No material postings must be carried out during the process (filling the Setup table for 2LIS_03_BX)?? Any useful suggestion??

Thanks for the answer

Moha

[Former Member]

Hi Mohan,

2lis_03_bx is one time initialization.Here you will load data only once.All the historical data will be loaded through 2lis_03_bx.

All the deltas will be carried from 2LIS_03_BF.

Here is the PDF for Handling Inventory management senario.Have a look at this.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f83be790-0201-0010-4fb0-98bd7c01...

Regards

Karthik