cancel
Showing results for 
Search instead for 
Did you mean: 

why use MCNB for intialization of the current stock

Former Member
0 Kudos

Hi all :

could you please tell mw why should we use use MCNB for intialization of the current stock ?

if no intialization of the current stock , what influence it may bring?

could you please tell me what effects marker udpate when uploading /compressing may bring?

Thank you very much!

Edited by: jingying Sony on Jun 13, 2009 5:57 AM

Accepted Solutions (1)

Accepted Solutions (1)

chemicala_srimallikarjuna
Active Contributor
0 Kudos

Hi,

In Inventory, When you initialize the stcok by using BX Datasource. It will bring the current status of the stock by calculating the past transactions happend in all the storage locations.

After loading the Data into CUbe you compress the cube with Marker update, then system will take a reference point for the marker.

Next when you load BF for the historical data, you compress with "Nomarker update". This may n't be necessary in all the cases. If the client requires reporting on the past data you need to extract this. This time you run the infopackage with init Delta. If historical data is not required you can run the infopack Init with out Data transfer.

In the above case you use No marker update, because you have initialized the stock by calculating all the histoirical data and then you are loading historical data, there would be data mismatch happen to avoid that use no marker so that it will n't add to the referect point.

Later you can run the delta loads by using BF data source. This time you need to use "Marker update" because all the delta movements are new they should be updated to reference point. SImilarly UM also With marker updte for Price revaluations.

Need to set the Referece point : Bcoz ,When you use Non CUmulative KF in the CUbe, During query execution the data will come from Referece point which is set by marker update

Also pls chk this link;How to Handle Inventory Management Scenarios in BW (NW2004)"

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

Regards

CSM Reddy

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Jigying Sony,

In many cases your SAP R/3 system goes live earlier than your BW system.

Say during go live in R/3 on 1st May 20009 - you had certain stock of product1 in inventory - say 100 PCS.

You then sold 20PCS of product1 and brought 40PCS until today.

So the stock of product1 in your inventory is 100 - 20 + 40 = 120.

Now if your BW system was to Go Live tomorrow.

You would have to let BW know what is your current stock level.

From tomorrow then you can record only movements in BW.. ie you will send only data of sold and brought pcs of prodct1 from tomorrow.

To inform BW about the current stock level you need the data source 2LIS_03_BX.

To send the movements to BW you have the data source 2LIS_03_BF.

2LIS_03_BX picks data from statistical table.

For the statistical table to reflect the current stock of product one , you need to run MNCB ---> which precisely calculate the current stock level of product1 using the logic 100 - 20 + 40 ie stock till date and stores it in the statistical table.

Then you load this data through 2LIS_03_BX to BW. Thus BW has the information of current stock.

Then you load the movemens only through 2LIS_03_BF after setting up the delta.

Markers can only be updaed when compression is done.

You choose to update the marker based on certain conditions.

BW uses markers to store the information of stock levels.

It stores the stock as the marker value(reference value) +/- delta changes.

When the cube is compressed you can update the marker. This will make the reference more current in time. Thus to calculate current stock you will have to take into account lesser deltas and a more current marker .. this improves performance...

Fo further details on this :

[How to handle inventory management scenarios|http://sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f83be790-0201-0010-4fb0-98bd7c01e328]

Hope this helps,

Best regards,

Sunmit.

Former Member
0 Kudos

thank you very much for your reply, I understand it now ,

and could you please tell me what effects marker udpate when uploading /compressing may bring?

Thanks again .