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

[Former Member]

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ñ

[Former Member]

Hi Azael,

In the How to Papers, you will find a Guide on how to take a Sanpshot view of the Stocks(How To Handle Inventory Management Scenarios in BW). Basically if you implement the Guide, you will have another cube called ICSNAP1, which will contain stock quantities /values at the end of each month. You will therefore have to take stock at the end of the last month from that cube and add up the relevant receipts and issues to arrive at the current Stock or Stock as on a particular date.

Hope this helps!

Regards

Sriram

[Former Member]

Thank you for the answer (I rewarded points, of course)

cheers

[Former Member]

<FONT FACE = "Tahoma", Font Color = "Blue">

Hi<br>

If you are aware of the formulas used by BEx then you can try to formulate the same thing using FOX Formulas in BPS.

<br><br>

Hope it helps.<br>

Cheers Abhijit</FONT><FONT FACE = "Verdana", Font Color = "Red">

• Please assign Reward Points if I above information was useful

</FONT>