cancel
Showing results for 
Search instead for 
Did you mean: 

0TOTALSTCK displays data intermittently

Former Member
0 Kudos
76

Hi All,

I have an issue where we have query that uses 0totalstck for an opening and closing stock value. It seems to work fine with the opening and closing stock date variables being set equal to a day. Except there is one plant which has movement types prior to the day which are not being picked up. If I change it so that the opening stock day variable is less than or equal to the date specified, then it displays the correct value. The same goes for the closing stock.

This only seems to be an issue for a certain plant / material while all other plants have the correct data using a single date for both the opening and closing stock.

Can anyone advise why this might be?

Thanks in advance for any help on this.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Just thought I would share the solution to this.

It looks like the validity date for the cube was not set up properly. I fixed it using transaction RSDV.

Details on how to proceed can be found here:

http://help.sap.com/saphelp_nw70/helpdata/EN/02/9a6a1f244411d5b2e30050da4c74dc/frameset.htm