on 2024 Jan 09 9:31 PM
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?
Request clarification before answering.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.