Skip to Content
0
Former Member
Aug 31, 2007 at 10:41 PM

how to use a non cumulative key figure in a multi planning area

57 Views

Hi

I'm new to bps, my problem is

I need to read the last stock quantity and value at plant and material level to do further calculations in a fox formula, so i made a planning area for the cube 0rt_c36 and another for my tc cube where the results should go, then i combine these areas in a multiplanning area.

problems arise when selecting the key figure in the ratios tab of the multi area, the ratios 0CPTOTSTOBU (last stock) and 0CPTOTSTOPV (last stock purchase value) are not available, only the inflow and outflow ratios are 0CPTOTREBU and 0CPTOTREPV.

I know when reporting, the actual value for stock is calculated by bex, namely, there is no data store at database level, so the question is:

How to obtain last stock for using in bps??

thank you for any help

regards

A. Garduñ