Skip to Content

How to visualize the Freeze horizon in IBP Excel?

Hi Everyone,

Freeze horizon in order-based planning is one of the recently published features of SAP IBP for Response and Supply 1805. Maybe you have already figured it out. In Web UI you can see the freeze horizon here:

But if you are mainly working in IBP Excel you may wonder how to see it there?

In the following steps I will explain step-by-step how to set it up from a fresh SAP7 Planning area copy.

Step 1: Copy the SAP7 Sample planning area to a new Planning Area

Step 2: Create 3 new attributes in Fiori App: Attributes

Attribute Data Type
FREEZEHORIZONDISTRINT Integer
FREEZEHORIZONPRODINT Integer
PLANDELETIONHORIZONINT Integer

 

Step 3: Add the created Attributes to the Master Data Type for LocationProduct

I used MA9 as prefix of Master data types when copying  Sample Planning area. Run a search for the Prefix used.

As a next step edit Master Data Type for LocationProduct. Now you must assign the previously created Attributes for Freeze Horizon to the MDT. Also assign the Reference columns:

Attribute Reference columns
FREEZEHORIZONPRODINT FREEZE_HORIZON_PRODUCTION
PLANDELETIONHORIZONINT PLAN_DELETION_HORIZON
FREEZEHORIZONDISTRINT FREEZE_HORIZON_DISTRIBUTION

Result looks like this:

Step 4: Add attributes to Planning Area

Open Configuration Fiori App and select your planning area copy. In my case it is MA9SAP7. First show all available attributes (arrow on the left) and then filter by MA9 (arrow on the right).

Expand MA9LocationProduct MDT and select the attributes FREEZEHORIZONDISTRINT, FREEZEHORIZONPRODINT, PLANDELETIONHORIZONINT and save it.

Result looks like this:

Step 5: Add attributes to Planning Level PERPRODLOC

Select the Planning Level PERPRODLOC and display all available attributes. Expand MA9LocationProduct MDT and select the attributes FREEZEHORIZONDISTRINT, FREEZEHORIZONPRODINT, PLANDELETIONHORIZONINT and save it.

Result looks like this:

Step 6: Create Time Profile & Activate Planning Area

Step 7: Run Order-Based Planning: Regenerate Planning Objects Job for Planning Area

In order to generate CVCs in order based planning you have to use Order-Based Planning: Regenerate Planning Objects Job. This Job you can schedule via Application Jobs App. Select your Planning area and hit schedule.

Step 8: Open Excel and logon to your new Planning Area

Select Freeze Horizon Distribution and Production attributes:

Look at results in Excel

Now you are almost there. Now you can develop a VBA Macro that colors the cells within frozen period.

For your convenience I have an example here that you can have a look at.

See SAP Note 2421657 for more details about using VBA in IBP.

 

 

Hope you would have found this topic interesting and thanks for reading it.

Please feel free to leave your Comments/Feedbacks.

 

kind regards,

Michael

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Manoj Gaikwad

    Hi Michael,

     

    Thanks for this very informative document along with your sample VBA script. We were looking of this option way back before VBA hooks were available in IBP.

     

    Will surely try this out, one question from my side is what is the performance impact on the refresh time. With all the loops in the script did you see any major impact ?

     

    Thanks,

    Manoj Gaikwad

    (0) 
  2. Michael Mack Post author

    Hi Manoj,

    good point, of course the VBA is slowing down the refresh time. However it is a question of what is acceptable for the user and the customer scenario. I think a few extra seconds will make the Excel more user friendly

    Kind regards

    Michael

    (0) 
  3. Kai Wipfler

    Hello Michael.

    Thanks for this, but still one question:
    Is there any way to solve this by using the standard EPM Formatting sheet in Excel? After all, the attribute ‘Frozen Horizon’ is available there.

    So far I only had to colour either complete rows or columns and won’t come around to testing this myself this week.

    Thanks and regards

    Kai Wipfler

     

    (0) 
    1. Michael Mack Post author

      Hi Kai,

      I’m afraid that will not work because every Location-Product may have it’s own frozen horizon.

      e.g.

      P1@Loc 1 – 5 days

      P2@Loc 1 – 12 days

       

      kind regards

      Michael

      (0) 

Leave a Reply