SAP IBP Order-Based Planning Basics and Profiles

Objective

After completing this lesson, you will be able to describe various profiles in SAP IBP OBP

SAP IBP Order-Based Planning Basics and Profiles

OBP configuration entails the creation of certain profiles, planning levels, and specific settings for order-based planning.

These activities are listed under SAP IBP UI Order-Based Planning Configuration Menu.

In this section, we cover all the apps listed above, except "settings for order-based planning", which is covered in the next section.

The figure describes the Order-Based Configuration Menu.

OBP Planning Levels App

OBP Planning Levels App is used to create planning levels in order-based planning (OBP). A planning level consists of a list of attributes of the static data model of order-based planning. For example, MATNR, WERKS, and KUNNR from the sales order field catalog.

OBP planning levels are independent of planning areas. Regarding the planning areas, ensure that all attributes that are used in your OBP planning levels are mapped to attributes in these planning areas in the Settings for Order-Based Planning app under the Sales Order Field Assignments.

OBP Planning levels define the aggregation level at which key figures are read for specific purposes. This level is relevant for other profile settings, namely:

  • Forecast Consumption Profiles
  • Allocation Profiles
  • Fair-Share Set Profiles

In the example above, we selected Location, Location Type, Material, and Customer as an aggregation level, that is, PERPRODLOCCUST.

We will see how this is used.

The figure describes the SAP IBP Order-Based Planning Configuration - OBP Planning Levels.

Forecast Consumption Profile

Forecast consumption replaces forecasted demand with actual sales order demand. Each time you create a sales order line, you create actual demand. If the actual demand is already forecasted, the forecast demand must be decremented by the sales order quantity to avoid counting the same demand twice.

The prerequisite to creating a Forecast Consumption Profile is a Planning Level, which we saw in the previous figure.

The forecast consumption profile in the case of Supply Planning with Allocation Creation run, defines the level at which the forecast key figures are read, in this case, Location, Location Type, Material, and Customer which is the planning level PERPRODLOCCUST.

In the Supply Planning with Order Confirmation run and the Deployment Run, the forecast consumption profiles define how incoming sales orders are deducted from the estimated future demand (forecast).

In the following example, Forecast Consumption Profile is defined at the Location/Material level.

The forecast is at the Location/Material level, but the sales orders are at the Location/Material/Customer level. The sales orders are aggregated to Location/Material and then deducted from the Forecast to derive Open Forecast.

Sales orders are aggregated to Location/Material, in this example as the Forecast Consumption Profile has been defined at the Location/Material level.

You need to assign a forecast consumption profile to each location material to use forecasts as placeholders for anticipating future sales or demands. Forecast consumption profiles can be associated with master data directly in SAP IBP.

Using real-time integration, you can also transfer profile attributes with a BAdI.

The figure describes the SAP IBP Order-Based Planning Configuration - Forecast Consumption Profile.

Allocation Profile

When products are "allocated" it means that the amount that a single customer can purchase of a product is limited. This type of allocation is put on products that are in short supply (or have the potential to be in short supply) while being in high demand to ensure the stability of the supply chain.

In essence, Allocation priority is the first level of supply distribution. Depending on the level of allocation plan being derived, these priorities can be applied at various levels, for example, among various sales channels or geographies, or even at a customer level. In these cases, we start distributing supply to allocation groups in the order of priorities defined so that the higher priority demand sets get satisfied first.

Product allocation profiles can be associated with master data directly in SAP IBP (not in an external system). Using real-time integration, you can also transfer profile attributes with a BAdI.

The figure describes the SAP IBP Order-Based Planning Configuration - Product Allocation Profile.

Available to Deploy Profile

When production is complete, the system first checks what product quantities are available at the source locations (locations where there is stock). The sum of these product quantities is known as the available-to-deploy (ATD) quantity. The system then determines how the ATD quantity is to be distributed to destination locations (locations where there is demand).

Using the Available-To-Deploy profile, you can configure which order types are considered "available to deploy" during the deployment run.

The figure describes the SAP IBP Order-Based Planning Configuration - Available to Deploy Profile.

Source of Supply Selection Profile

The source of Supply Selection profile determines how you want to peg or use up available supply for demands.

Using the Source of Supply Selection Profile, the mode that should be used for a source of supply selection is defined.

These three types of Source of Supply are shown in the following figure.

The figure describes the SAP IBP Order-Based Planning Configuration - Source of Supply Selection Profile.

Planning Run Profiles

Planning Run Profiles are used to define settings that are applied during planning runs.

The planning run profile is a mandatory job parameter for application jobs.

Demand prioritization rule, a maximum lateness rule, and cost rules could also be defined in the Planning Run Profiles app.

The figure describes the SAP IBP Order-Based Planning Configuration - Planning Run Profiles.

We will now see how a Planning Run Profile is used to View Demands by Priority.

We first describe what is Demand Prioritization in the next figure, and then how a Planning Run Profile is used to Simulate Demand Prioritization.

The figure describes the Demand Prioritization (using the Planning Run Profile) and View Demands by Priority.

Demand Prioritization Overview

If you have multiple demands during the planning runs, the system should be configured to know which demands have a higher priority versus other demands, and then put the demands in certain in a sequence. This is demand prioritization.

Demand prioritization and rules behind it will vary for each customer. The rules are flexible and can be configured according to customer requirements.

The demands that enter the system need to be prioritized for the planning algorithms based on the business requirements.

  • Demand prioritization rules are used during the Planning run to prioritize the demands
  • The Simulate Demand Prioritization app can be used to simulate prioritization

Examples:

  • Give Sales Orders a higher priority than forecasts
  • Give Sales Orders with a Requested Date within the next week a higher priority than Sales Orders which are requested later

Demand Prioritization rules are part of the planning run profile. In many areas of the planning run profile, we will come across the concept of segments.

Segments help with grouping. In demand prioritization, segments are used to group demands and putting them in a certain order. In the following example, the demand segment with priority 0 has the highest priority and is covered first. The demand segment with priority 999 has the lowest priority and covered last.

By default, the system has segments 0 and 999. The segments between 0 and 999 can be configured according to customer requirements.

The figure describes the Create Planning Run Profile – Demand Prioritization Rule.

Conditions and Sort Attributes

Conditions used within segments are similar to Select statements. In the example, for Object type Ship To Customer, the Classification is used as a grouping criteria within that segment, and all demands with Classification of 01 are assigned to that segment. Different kinds of demand may fall within the same segment.

Let’s assume that five sales orders fall in that segment which satisfies the condition. Now, we must sort again within those five sales orders, and this is managed by Prioritization Settings.

There are two options in Prioritization Settings.

The first option is Demand Sequence Segment, where sorting is done using ‘sort’ attributes. In the case of five sales orders, they are sorted by Requested Date and Time in an Ascending manner. Alternatively, they can be sorted in a Descending manner.

The second option to sort is Fair Share Set Profiles this is discussed next.

The figure describes the Demand Prioritization Rules – Conditions and Sort Attributes.

Fair Share Set Profiles

The fair share set can also be created using the Fair Share Set Profiles app. Within the Fair share set, you define at which level of granularity fair shares set are created. The next step is to define the "portion size key figure".

The portion size is a dimensionless quantity that defines for demand fair share the maximum demand fulfillment of a fair-share set in one round-robin turn. It controls the proportions between fair share sets and how close you can get to achieving fair share. A basic rule is that the smaller the portion sizes, the closer you can get to achieving fair share, and the likelier it is that the proportions between the sets are kept. However, to increase performance, portion sizes should not be too small in comparison to the demand quantities.

The figure describes the Fair Share Set Profiles.

Illustration of round-robin:

The total available supply is 60; the portion sizes are 100 for set A and 50 for set B. In the first round-robin turn, A gets all the supply, and nothing is left for set B. With a total available supply of 60 and portion sizes of 2 for set A and 1 for set B, set A gets 2, and B gets 1 in the first round-robin turn. In the next turn, they again get 2 and 1. These iterations are repeated until the supply is used up. In this scenario, set A receives 40, and set B gets 20.

Simulate Demand Prioritization

The Simulate Demand Prioritization app can be used to verify whether the demands are being prioritized according to the rules that have been configured in the Planning Run Profile. The demands are sequenced according to segment priority.

The figure describes the Simulate Demand Prioritization App.

Maximum Lateness

In a Planning Run Profile, you can configure the maximum allowed lateness of primary demands.

Lateness can be configured by segment. Each segment is defined by a condition, for example, by material number or location number. Different demands can have different maximum lateness settings, according to their segment condition.

By default, the maximum lateness for sales orders and forecasts is 365 days.

Exception: The confirmation mode on the sales order level can set the maximum lateness for an order to 0 days. You may want to change the default behavior to achieve different maximum lateness handlings for different independent demands.

For example, some of your materials must be fulfilled in time or not at all, while other materials can be shipped late. For such use cases, you can create a rule to define the maximum days of lateness allowed, depending on demand attributes like locations, materials, the MRP controller, the plant type, or custom attributes.

The figure describes the Maximum Lateness settings in the Planning Run Profile.

Demand Prioritization

Business Example

As an account planner, you use the Simulate Demand Prioritization app to understand the prioritization of demands. This is typically done before the execution of the planning run. The ranking of the demands is verified as per the selected Planning Run Profile.

The Demand Prioritization Rules rank the demands using segment conditions and sort attributes.

The ranking of the demands enables you to verify that the prioritization of demands is according to your business goals. If ranking is not acceptable, adapt the Demand Prioritization Rules in the Planning Run Profile, so that the prioritization of demands is according to your business objectives.

Prerequisites

The forecast consumption profile and allocation procedure were assigned to the finished materials in SAP ERP and verified in SAP IBP.

Demand Prioritization Rules in Planning Run Profiles are created.

Planner Workspace for this course had been created and shared with all Trainee user

Note

SAP supports both Planner Workspace and Microsoft Excel User Interfaces. Some screenshots depict Excel Planning views but can also be used to assist with exercises performed using the Planner Workspace UI. The screenshots (Excel or Planner workspace) help participants to understand the key figures and other relevant data.

For this course, Planner Workspace is referenced in all exercise instructions.

In this exercise, when you see ##, replace the characters with your group number.

Note

Customer 1 has a Customer Classification 1.

Customer 2 has a Customer Classification 2.

Customer 3 has a Customer Classification 3.

Steps

  1. Create three sales orders five weeks out for each of the customers CUST01, CUST02, CUST03. Use the Order Type and Organizational Data as per the screenshot below.

    Product/Location/CustomerSales Order Qty
    TXX_PHONE_A in DC71 for CUST01200 for sales order 1
    TXX_PHONE_A in DC71 for CUST02400 for sales order 2
    TXX_PHONE_A in DC71 for CUST03600 for sales order 3
    Order Type screenshot
    1. Use transaction VA01.

    2. Use Order Type OR.

    3. In the Sold-To party and Ship-To party field, enter the relevant customer number from the table.

    4. In the Cust Reference field, enter some text (it does not matter what text you enter, but it must be filled).

    5. In the Req. Deliv. Date field, enter the date five weeks from now.

    6. Enter the order quantity shown above.

    7. Confirm your data with Enter, then choose Continue when the ATP check appears.

      Order screenshot
    8. Choose Save.

      Note

      To double-check that these orders have been created, use t-code MD04.
  2. Log on to the SAP IBP Fiori interface and create your own planner workspaces.

    1. Open Google Chrome and enter the server URL supplied by your instructor.

    2. Log on to SAP IBP Fiori using the credentials supplied by your instructor.

    3. Select the General Planner Group and choose the Planning Filters tile. Review the two template filters for Phones starting with TXX. Copy the filters, ensuring that the selection represents your group ##.

    4. Adjust the Product number in the Filter Criteria section and choose Create.

    5. In the General Planner Group, choose the Planner Workspaces tile.

    6. Choose Create.

    7. Maintain IBP_800 ## as name and description for your new planner workspaces and select ZSAP7F as planning area.

    8. Select the Workbook icon in the upper left corner of the Planner Workspaces screen and choose Add Workbook/Variant.

    9. Choose Create.

    10. Maintain Forecast and Constraints ## as name and description for your new workbook and choose Create.

    11. Choose Add Component.

    12. Select the Planning View.

    13. Choose Forecast and Allocation created by Trainer 01 and choose Add.

    14. In the Setting section choose Save As and maintain Forecast and Allocation ## as name and description for your new component.

    15. Mark the flag for Remove the original component from this workbook and choose Save.

    16. In theFilter section of your component, choose Load Planning filter, and select the T##_PHONE_A filter.

    17. Choose Apply.

    18. Choose Save Component.

    19. Choose Plan.

      Result

      In the Forecasts and Allocations component you should see the sales orders created in Step 1.
  3. If the component is at the weekly level, change it to the daily level, choosing the current date plus 60 days, and enter an unconstrained forecast for TXX_PHONE_A.

    Forecast Qty forForecast Qty
    Customer 1 at DC71 on the 18th day from today1100
    Customer 2 at DC71 on the 16th day from today1200
    Customer 3 at DC71 on the 14th day from today1300
    1. Ensure that the Plan mode is on

    2. Choose Settings.

    3. On the General tab, in the Time Levels screen area, change the time period to daily.

    4. Choose Apply for time periods.

    5. Choose Apply.

    6. Enter the forecast quantity as per the table above.

      Note

      Today is day 1, tomorrow is day 2.

      The requested date of the forecast created for customer classification "03" should be earlier than the requested date of the demand for customer classification "02". Forecast consumption will be described in a later section.

    7. Choose Save Data. There is no need to enter a reason code.

  4. Assign the Forecast Consumption Profile and Allocation Profile to your Product Location.

    1. In the General Planner Group, open the app Manage Master Data.

    2. Go to Master Data Type Z7FLocationProduct.

    3. Search by your Product TXX_PHONE_A.

    4. Go to Settings button and add Product Allocation Profile.

    5. Highlight the first line DC71, TXX_PHONE_A and select Edit.

    6. In the Forecast Consumption Profile field, add PERPRODLOCCUST.

    7. In the Product Allocation Profile field, add PERPRODLOCCUST.

    8. Save the changes.

  5. Review the demand prioritization using Planning Run Profile PRP_CUSTOMER_PRIO1 and Planning Run Profile PRP_CUSTOMER_PRIO2.

    1. In the Account Planner Group, open the SAP Fiori app Simulate Demand Prioritization.

    2. Enter the following:

      • Version: Base Version
      • Planning Run Profile: PRP_CUSTOMER_PRIO1

      • Planning Start Date: Today's date
      • Product Number: TXX_PHONE_A

    3. Choose Start Simulation.

      Result

      A list of your demands will be displayed. The demands are sorted by priority.

      The first column displays the rank of the primary demand. The third column displays the segment to which the demand was assigned.

  6. Check the ranking of the demands with Planning Run Profile: PRP_CUSTOMER_PRIO1.

    1. Review ranked demands.

      Result

      Using the Settings icon, add the column for Ship-To Customer Classification to better understand the results.

      Sales Orders with customer classification "01" are assigned to the segments PRIO_01_CUSTOMER_SALESORDERS. The sales orders are sorted by the requested date.

      Forecasts with customer classification "01" are assigned to the segments PRIO_01_CUSTOMER_FORECAST. The forecasts are sorted by the requested date.

      All Sales Orders with customer classification "02" or "03" are assigned to the segments SALESORDERS_BY_PRIORITY. The Sales Orders are sorted by the customer classification first and then by the requested date.

      All Forecasts with customer classification "02" or "03" are assigned to the segments FORECAST_BY_PRIORITY. The forecasts are sorted by the customer classification first and then by the requested date.

  7. Check the ranking of the demands with the following Planning Run Profile: PRP_CUSTOMER_PRIO2.

    1. Review ranked demands.

      Result

      As a prerequisite, two demands were created for customer classification "02" and "03". The requested date of the demand created for customer classification "03" should be earlier than the requested date of the demand for customer classification "02".

      When changing the Planning Run Profile from PRP_CUSTOMER_PRIO1 to PRP_CUSTOMER_PRIO2, the sequence of the two demands in the ranking will change.

      As seen in the previous figure, when changing the Planning Run Profile to PRP_CUSTOMER_PRIO2, only the sequence of those two demands changes, in segments 4-1 and 4-2.

      Note

      The segment priority identifies the segment: the first number in the priority field matches the segment priority field of the Planning Run Profiles app. The planning run profile name and segment priority together uniquely identify the segment.
  8. Show details for a segment.

    1. Select the appropriate segment description link.

      The figure explain the maintenance of an appropriate segment description.
    2. Check that the detailed information for the chosen segment (like Header information, Conditions, Sort Attributes, and so on), is displayed in the pop-over according to the maintained data in the corresponding Planning Run Profile.

Log in to track your progress & complete quizzes