cancel
Showing results for 
Search instead for 
Did you mean: 

IBP S&OP Time Streams

Former Member
0 Kudos

Dear all,

In regards to the creation of time streams for IBP S&OP planning areas does anybody have good tips or tricks to create and update these in a smarter way than via a text file with the structure defined? It works but it does not seem to be a very robust and flexible way of maintaining a system a state of the art system?

Br., Peter

Accepted Solutions (1)

Accepted Solutions (1)

Irmi_Kuntze
Advisor
Advisor
0 Kudos

Hi Peter you have to use a file. But you can make it quite simple: - The time profile itself is just for display, plus it frames the maximum time horizon you can load the file, so you can have the horizon in the top with a very long end date, e.g. 31.12.2035. This has no impact on sizing and performance, it will just make sure you don't need to change it every year - just don't ever touch again - In the planning area itself, time horizon settings with + / - x years and month etc. frames what can maximum be loaded into the key figures, not into the time profile. - Create one big master file, that has all the horizon for the next many years, e.g. until 2035 as well, and make sure that file is within the horizon of the time profile. Now you can load it, even if the planning area itself has a smaller horizon. - With that, you still cannot maintain key figure data out of the horizon given in the planning area, it just makes sure you load the time profile once and for all. Works pretty easy if you have only month, quarter and year More effort if you have weeks as it is just some work to prepare in the file. Yours Irmi

Former Member
0 Kudos

Thanks for your reply Irmhild, this will work fine, but be aware that when implementing the IBP systems this functionality may seem a little surprising to the customers implementing an IBP-solution.

Br., Peter

Irmi_Kuntze
Advisor
Advisor
0 Kudos

Dear Peter

I am not Product Management but "only" consulting, but surely I know the topic from my own experience...

However, SAP product management does know the topic as well and is working on several topics around time profiles at the moment incl the file load. However, I am not in a legal position to make any promises if or when a report will be provided, so for the moment unfortunately you have to stick with file load.

Former Member
0 Kudos

Thanks for update and info Irmhild!

0 Kudos

Hi Peter,

I could not agree more with you about Time Profile maintenance using flat file upload especially comparing with SAP APO where it is automation (based on storage bucket profile setup).

Having said that we need to consider the pain and effort needed to setup Fiscal Year Variant which is essentially similar to Time Profile in IBP, main difference being flat file upload.

To automate the Time Profile at Day, Week level is really significant effort (month, quarter, year is just 17 entries per year so manageable) but some Excel VB programming has done the trick of creating the repetitive Day and Week data. The bigger challenge is NOT the day, week, month, year period start and end definition but adding Period Description that may very well differ from client to client.

Some more Excel VB magic applied for period formatting will do the needful.

Cheers,

Somnath

Answers (0)