cancel
Showing results for 
Search instead for 
Did you mean: 

Can I in IBP reference a Fixed period in Keyfigure calculations?

abarofsoap
Explorer
0 Kudos
379

I'd like to, from a fixed date or periodid, have a way to control from what period various calculated keyfigures on several planning levels should get it's value from.

For example; Actuals before fixed date 2024-01-01 and Forecasts from there and on.

The date should be set once and then never change. I would like it to be able to affect all keyfigures within a version.
The versions do share masterdata, so i guess using masterdata is out of the question...?

Can time independent keyfigures be used to store a periodid and reference in keyfigure calculations perhaps?
Any other suggestions on any good techniques I could try out?

Accepted Solutions (0)

Answers (2)

Answers (2)

abarofsoap
Explorer
0 Kudos

Formulas I can figure out, but my issue is that I don’t know where to store the periodid "27124". KF1@LP= IF("PERIODID5" >= "27124", ...)

To hardcode it into the formula is not an option as i want it to be a different value in each version.
I also need it to be easy to maintain, so i want to avoid storing it in a lot of time series based keyfigures on multiple planning levels etc.

riyazahmed_ca2
Contributor
0 Kudos

Hi Henric,

Yes of course, you can do the fixed period reference in your keyfigure calculations. So in each keyfigure calculations, you have to periodid check such as follows.

KF1@PL = IF("PERIODIDx" >= "YYYYYY", ...)

PERIODIDx refers to Time Period Level you handle in that calculations.

YYYYYYY refers to PERIODID value.

PERIODID value by SAP's application help relates to $$PERIODIDxCU$$, $$PERIODIDxFR$$ and $$PERIODIDxTO$$. But a hidden info is that you can directly pass the PERIODID values from the Time Profile period list.

For Eg: We have PERIODID as 27123, 27124, 27125 to represent TW26, TW27, TW28 and we want the calculation to start at TW27. Then KF calculations will be written as below.

KF1@PL = IF("PERIODID5" >= "27124", ...)

I hope this helps. Let me know if you have further queries.

Best Regards,

'Riyaz'