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
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:
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