SAP IBP Copy of time period to future time periods for the same key figure

[willsuus]

Has anything been developed to copy one time period to all future time periods for the same key figure while creating any missing time periods? We have tried to do this in the past and were told this could not be done but I am hoping something has been developed that we missed since our initial question.

[Irmi_Kuntze · Accepted solution]

If you want to copy one value with a time shift to another one, then the copy operator have the functionality to enter a time shift, or you just calculate with function IBP_PERIODSHIFT.

If you want to copy the same figure from the current period into all next, then there is IBP_CURRENT_VALUE.

If you want to generate planning objects, you have the copy operator with the option to generate missing combination. Use any of the above mentioned KF as input. And you have IBP_GENERATE_MISSING_TP.

It really depends on the use case, what is best, whether you need a stored value or a calculated value might be enough.

You could for example use a time-independent KF attribute and display it with the IBP_CURRENT_VALUE and adding another KF as additional input that has all time periods and one common attribute (e.g. just all weeks generated on level WKLOC and add it to a KF on level WKPRODLOC).

Yours

Irmi

[ChristopherSmith]

Hi Susan,

Traditionally we've either used attributes as key figures and/or some CIDS interface(s) with a row generation transform for this purpose. hope that helps a little.

[willsuus]

Thank you, Christopher, for your quick response.

This is a one time copy of, for example, Dec 2024 through Dec 2025 in monthly buckets. We need this as we don't have forecast in 2025 and want an adjustment to disaggregate proportionally correctly.

[ChristopherSmith]

I'm sure there are a couple ways to do this, but the easiest one that comes to my mind is to use CIDS. Two flows, one to extract your forecast from IBP to a flat file, and the second to load it back in but advance the year thru date manipulation. An experienced CIDS person could do this pretty quickly & easily... there are likely other more elegant ways to do this thru copy operators or helper keyfigures; depends on if you want to enhance your PA config or not.

There is also the copy past periods forecast model that you could play with, using the same source and target KF as well as offsets potentially.

Many roads to Rome 🙂 good luck