Planning using Revenue, disaggregate to Quantity

[Former Member]

We were told by our consultant to plan in QUANTITY, but for our products this is impossible. Is it common in IBP community to forecast in REVENUE and disaggregate to Quantity ? What's the common setup in IBP users ?

[Irmi_Kuntze · Accepted solution]

Hi Doris
yes you can, I configured it already.

But it is nothing I could explain in a few words, so here just some ideas.

In principle, if you calculate qty to revenue, that would be like:
KFREV@PERPRODCUSTCURR = KFQTY@PERPRODCUST * KFPRICE@PERPRODCUSTCURR

When you do it reverse it would be like:
KFQTY@PERPRODCUST = KFREV@PERPRODCUSTCURR / KFPRICE@PERPRODCUSTCURR

That was easy so far, but you have to answer the following challenges:

• What do I do when I have a KFREV, but not a price as you cannot devide by 0? Answer is according to your business needs.
• How to do conversion, as you need both currency AND UoM conversion?
  For that you first have to understand the conversion you need for a price (is in $ / per unit) as that needs both conversions as well, check SAPIBP1, there is a KF EXCHANGERATEUOMCONVERSION.
  Plus the challenge is that you cannot just enter anything into the field for "concert using" as you do not multiply but devide.
  But you can work around that if you have an additional calculated KF = 1 / conversion, which you then use in the "conversion using"
• Disaggregation: This is not depending on your process, whether you need a disaggregation based on another KF (challenging) or just simple pro rata (easy).
  Assuming you need it based on another KF, you cannot use a qty KF for that as it is not at the same base planning level.
  Hence you need to find any storage KF that has same level. If you have that, you are done.
  But if your requirement is that you want to disaggregate according to the proportions of a qty-KF you are planning, than you first need to somehow convert that into currency and save it first.
  If you have a process where you have a release step in-between qty-planning and currency-planning, you can do that by normal jobs.
  But if there are no release steps in-between and you need to have immediate usage, you need to work with ADVSIM which has impact on performance

So, just these ideas, maybe some day when I have a lot of time I'll write a blog about it...

Irmi

[Former Member]

Hi Irmi, thank you ! When we reach there one day, will surely consult you again. We are currently not even doing disaggregation using key figure and our stat is running a bit of havoc today. First priority to solve now !