Projected stock with IBP_CAGGR (current and future periods only)

[thomaskinder977]

Dear all,

I want to model projected stock balance with IBP_CAGGR function. What I'd like to achieve is to start the calculation from the current period and skip anything that lies in the past.

Since IBP_CAGGR requires PASTCURRENTFUTURE parameter @ REQUEST level, all past data will be considered. Using CURRENTFUTURE at @WKPRODLOC level won't change anything since Excel anyway picks @ REQUEST calculation

What is the way to achieve projected stock with current a future periods only?

Many thanks,

Thomas

[Andrei_Lupu]

Hi @thomaskinder977 ,

Have a look at the standard key figure ACTUALSREVYTD in the Planning Area SAPIBP1 (Sample Model Entities app).

You don't use the CAGGR in the request level calculation itself, but rather in one of the subsequent levels. The request level should ideally be a SUM of your previous calculation (in this case, the CAGGR of current and future periods), which is the expected outcome. 

[thomaskinder977]

Hi Andrei,

Unfortunately, it doesn’t work in the case of projected stock.
If I have TWK as the base planning level for the input key figure to be aggregated, and for each TWK within a month I have a value of 20 for this key figure, then the projected stock at the end of the month will still be 20 — not 80 (which I would get if I simply did a SUM).

[Andrei_Lupu]

Hi @thomaskinder977, that doesn’t sound correct.

The CAGGR key figure should be aggregating at the request level using SUM, similar to how it works in the ACTUALSREVYTD example. The only difference is that, unlike ACTUALSREVYTD, you should not use the last parameter (resetting the values). So your CAGGR should look like this: IBP_CAGGR("Insert_your_KF@WKPRODLOCCUST", ''SUM'', ''FORWARD'', ''CURRENTFUTURE'').

If it's still not working as expected, perhaps you could share a snip of the KF setup.