Inventory: Historical Data not coming

[Former Member]

I have loaded data into the cube 0IC_C03. I have loaded data from 2lis_03_BX and 2lis_03_BF. Now what is happening is that it is showing the correct stock levels but it is not showing historical movements of past. I am not able to see previous period stock levels.

While loading i have taken care that for 2LIS_03_BX i am compressing data source with NO marker update checkbox unchecked.

For 2lis_03_BF i have compresses using no marker update flag checked.

Any thoughts why it is not coming. In r/3 i have done proper settings in Bf11 transaction. There i had check marked for Business Information warehouse. I have selected industry sector as core .

Please provie any inputs please

[Former Member]

Hi Baljit,

I have not worked much on Inventory Management. I just found this link on help.sap.com and thought it might help you.

Bye

Dinesh

[Former Member]

Hi,

You can make a restriction, if you want to display the Stock on that date. (here I am assuming the you have selected a date for 0calday in the restriction.)

So, for the remaining days(if you have included the 0calday in rows) there will be no value.

Or if you have taken a range dates in the restriction (by fixed values or Range variable) , you will get stock value(which is equal to stock on the end date of that range) will be displayed for that range of dates(assuming you have selected 0calday in rows here also).

With rgds,

Anil Kumar Sharma .P

[Former Member]

Anil,

Thanks for your reply. But the issue i am facing is that even when i create a restricted keyfigure on 0calday. If i give a back fate it is still showing current stock level. If you ca see my first posting

[Former Member]

Hi,

It seems , you are restricting the stock qty KF with current date(or a single date). And you are using 0calday in the rows also. If you are going to define 0calday as in the rows, I hope, you should not restrict the QTY KF with 0calday.If you restrict, the Qty on that restricted value will be displayed for all other dtes also, instead of their own value. Because the KF is non cumulatine KF

With rgds,

Anil Kumar Sharma .P

[Former Member]

Anil,

There is no problem with queries. Actually i have aded valuaiton class to 2LIS_03_BX. But now i am loading again into cube it is not giving me previous data

[Former Member]

Hi,

A small doubt -> Are you sure, if there are any transactions on the stock for previous periods?

Thanks

[Former Member]

Hi dear,

first of all, when you face this kind of problem it would be better to start from the beginning (and not from the end, that is the query).

Go to your cube and check there if you can see the movements you want to see in your query.

Then, build a little query-test in which you start with a simple row/column combination and anything else (remove restrictions, filters and so on..)...only in this way we can better understand where exactly is your problem...

Let us know!

Bye,

Roberto

[Former Member]

Hi Guys

I got the problem. Actually there are 2 routines in transfer ruels which by mistake one of my team members has deleted. I reinstalled the business content transfer rules. Transported it and then loaded the data.

It is coming perfect now.

Thanks.

[Former Member]

Hi Baljit,

Check if this link is helpul:

http://help.sap.com/saphelp_nw04/helpdata/en/5b/8dc73cee4fb55be10000000a114084/frameset.htm

Bye

Dinesh

[Former Member]

Hi Dinesh,

I have a doubt can i restrict total stock quantity with 0CALDAY