Editability time horizon for key figures in SAP IBP, add-in for Microsoft Excel (Q2/2021)

[peter_casper]

Hi community,

we want to model a product specific time horizon to visualize and restrict data entry. In particular we are looking for standard coverage of a Retail specific requirement to consider an article or article/customer related retail intro and exit date for KF editability and visualization.

Keeping that in mind, we came across the a planned innovation for Q2/2021 named "Editability time horizon for key figures in SAP IBP, add-in for Microsoft Excel".

Unfortunately it does not get clear which concrete capabilities are covered by this innovation item. Is there any chance to get more insights so that we can make a deliberate decision if it's worth waiting or if we need to develop a custom workaround solution (in case even possible)

Also any ideas for a workaround solution to consider intro and exit dates would be very welcome.

Best regards, Peter

[peter_casper · Accepted solution]

Hi all,

as there seems to be no further details around the mentioned innovation, I started to develop a handy custom solution. Therefore I attached two additional fields in the format YYYYMMDD representing intro and exit to MDT PRODUCT.

So far so good. Now I need an inbuilt functionality which converts a calendar date like YYYYMMDD into a specific time period ID being used internally by SAP IBP?

e.g. something like IBP_PERIODCONV(''DATE_FIELD", "PERIODIDn") which would return the internal period ID for the requested level n into which the date in DATE_FIELD falls.

Is there any implicit internal conversion happing by any of the available functions in IBP which would do that trick?

BR, Peter

[robvid · Accepted solution]

Hi Peter

Very interesting post.

Did you progress with your custom solution?

[peter_casper · Accepted solution]

Hi Robert,

not from an SAP perspective. Actually there seems to be no accessible functionality which converts a calendar time period into the internal period id. I am also not overly optimistic that the scheduled innovation will cater for all our needs, in particular to control editability on a product or product group level.

That's why we are converting the intro and exit dates to internal period ids already in the source system, either SAP ECC or SAP BW. Those IDs will be interfaced as MDT attributes to SAP IBP from where we can easily make use of them.

e.g. IF (PERIODID >= INTRO_DATE AND PERIODID <= EXIT_DATE) THEN CELL = editable

BR, Peter