SAP IBP, advanced inventory optimization: Configuring and Preparing for Use

Examining Attributes and Master Data Types

Objective

After completing this lesson, you will be able to configure a planning area.

Introduction to the Planning Model for Inventory Optimization: Attributes, Master Data Types, Planning Levels, and Input and Output Key Figures

The figure describes the Supply Chain.

SAP provides sample entities that can be used to model inventory optimization in IBP. Till release 2402, SAP provided a sample planning are explicitly for the inventory-related features of IBP, this planning area was called SAP3. This sample planning area was deprecated with release 2405.

For the purpose of using a predefined planning area capable of using inventory optimization, SAP provided instead the unified planning area SAPIBP1.

In order to include as well the order-based features of IBP into one sample planning area with the other features SAP introduced the harmonized planning area I_SAPIBP2 in 2025.

With a copy of this sample planning area, the related configuration can be used easily. It is also possible to use a partial copy in which the non-inventory-related configuration is excluded. Even if the previous modelling in SAP3 or SAPIBP1 is not exactly the same as in the inventory-related configuration of I_SAPIBP2, the main building blocks, etc. are similar.

This standard model contains all of the model elements needed to use the full functionality of SAP Integrated Business Planning (IBP), advanced inventory optimization..

This unit shows the attributes, master data types, planning levels, and input and output key figures needed for inventory planning and optimization.

The different elements are explained using a simple supply chain shown in the figure, from left to the right:

  • Vendor
  • Warehouse
  • Distribution Center
  • Customer

Comprehensive Data Model for the End-to-End Supply Chain

The figure describes the Data Model of SAP Integrated Business Planning, advanced inventory optimization.

As part of the model construction for inventory optimization, we can classify the data model by the displayed categories as per slide.

Inventory Planning Fundamentals in SAP Integrated Business Planning, Advanced Inventory Optimization

The figure describes the Fundamental Concepts for Advanced Application of Optimization Algorithms.

Understanding the model structure implies that we need to manage inventory planning fundamental definitions. These concepts will helps us to identify business requirements, recognize planning outputs, and speed up SAP IBP, advanced inventory optimization adoption:

  • Safety stock: Demand and supply uncertainty through exposure period (order cycle plus lead time).
  • Demand variability safety stock: Forecast demand variability.
  • Supply variability safety stock: Supply lead time variability.
  • Service variability safety stock: Upstream service variability through the exposure period (order cycle plus lead time).
  • Cycle stock: Propagated demand mean or lot size over length off replenishment frequency (periods between replenishment (PBR)).
  • On-hand stock: Safety stock plus cycle stock.
  • Pipeline stock: Propagated demand mean or lot size over length of internal transportation sourcing lead time.
  • In-process stock: Propagated demand mean or lot size over length of processing/manufacturing lead time.
  • Vendor in-transit stock: Propagated demand mean or lot size over length of lead time sourced from a vendor.
  • Reorder point: Propagated demand mean over length of lead time and lead time variability.
  • Target inventory position: Propagated demand mean and safety stock over length of lead time and length of replenishment frequency (PBR).

Attributes and Master Data Types

Attributes

Attributes are characteristics of master data types, for example, an attribute of the customer master data type might be country or region. Attributes can be either numeric or non-numeric. The following data types are supported for attributes:

To support the planning calendar function of SAP Integrated Business Planning, special attribute types are available with fixed properties as follows:

  • nvarchar

  • decimal

  • integer

  • timestamp

Note

You can only use decimal attributes as key figures in the planning area, and not as planning area dimension attributes.

Description Attributes

When you define a master data type, you can link a description attribute to its corresponding ID attribute. This can be beneficial for the performance of the SAP IBP, add-in for Microsoft Excel. When you link the description and ID attributes, during log-on, the SAP IBP, add-in for Microsoft Excel downloads the master data of one attribute for both the ID and the description, instead of two separate attributes. This reduces the data volume in the SAP IBP, add-in for Microsoft Excel. After you have linked them in configuration, both the description and ID attributes are displayed in the SAP IBP, add-in for Microsoft Excel, but not in any other apps in SAP IBP.

Master Data Types

Master data types represent categories of information, for example, customer, location, product, or resource. You use master data types to segment planning data. A typical example of their use would be a consumer goods company that wants to understand sales data based on the product, customer, and location master data types. Every master data type has one or more attributes, for example, the S2CUSTOMER master data type has S2CUSTID as an attribute.

Note

You cannot change the type of an active master data type. To understand more about the types of the master data types available within SAP IBP, please see SAP Help Portal→Master Data Types.

You can use the harmonized planning area I_SAPIBP2 to jump-start the implementation in case your business process requires integration across different SAP IBP applications. Just like any other sample planning area, this planning area delivers a pre-built integration scenario which you can customize to fit your unique requirements.

You can copy the I_SAPIBP2 sample planning area using the copy option in the Sample Planning Entities app. The copy can be tailored to your requirements by selecting either the full business scope or only the specific areas relevant to your planning scenario.

Note

While the general approach of jump-starting the implementation by using the sample content of the unified planning area SAPIBP1 would also be possible, this course focuses on the use of the harmonized planning area sample content in I_SAPIBP2

For the integrated planning process based on the harmonized planning area, the SAP Best Practices for SAP IBP provides sample data, planning view templates, predefined dashboards, configuration guides, test scripts, and more. Customer test tenants and SAP IBP, starter edition instances include an activated copy of the harmonized planning area with the sample content.

Note

You can also download the content at https://me.sap.com/processnavigator/SolS/rds_ibp.

The sample planning area supports inventory by providing a sample or starting point for your implementation projects. When creating your own planning area, you can copy I_SAPIBP2 sample planning area (partially) and then change it to suit your own requirements. The following list provides information about the required master data types for inventory optimization, as delivered in this sample planing area:

The inventory optimization algorithms require specific sets of master data and attributes with prescribed technical IDs. You first define the required master data attributes (for example, product ID) and master data types (for example, customer, location, and product). You then assign the attributes to the master data types. The following figures provide information about the required master data types and key attributes for inventory optimization, as delivered in the sample planing area:

We recommend that you set the time period range for attributes as key figures to be from 0 (zero) to at least 13 weeks. This is the range configured in the sample planning area. You will need to reload data at the frequency you use for the range. That is, if you set the range to 13 weeks, you will need to reload data every 13 weeks. The best practice is to set the time period range to 13 weeks (or fewer), but if you choose not to update that frequently, we suggest you update every 26 weeks.

We recommend that you add a two or three-letter prefix. In the data model, the prefix XXX has been used (for example, XXXPRODUCT). You must use the same prefix for all master data types accordingly.

Groups of Master Data Types in SAP IBP, Advanced Inventory Optimization
Central Master Data Types in I_SAPIBP2

Production-related Master Data

The production-related master data in I_SAPIBP2 is structured around the Production Data Structure (PDS) model, which replaces the flat Production Source of Supply concept used in legacy planning areas such as SAP4 and SAPIBP1. The model consists of five closely related master data types that collectively describe the complete production process.

I_PDSHEADER is the top-level object of a PDS and represents a production version for a specific output product at a specific location. Its composite key consists of PDS ID (I_PDSID), Location ID (I_LOCID), and Product ID (I_PRDID). The header contains planning-relevant attributes such as validity dates, deletion flag, output coefficient, and the BOM explosion rule. It is used across all supply planning application models, including Inventory Optimization, Time-Series-Based Supply Planning, and Order-Based Planning, and is integrated from SAP S/4HANA through Real-Time Integration (RTI).

I_PDSACTIVITY models the individual steps within the production process. Lead times are defined at the activity level as durations in full days. Component consumption is assigned to the start of an activity, while the output product becomes available at the end of the final activity. Only linear, sequential activity chains are supported; parallel activities are not. Compared to earlier planning area types, this concept introduces multi-step production modeling with activity-specific resource consumption.

I_PDSCOMPONENT represents the BOM components consumed during production. Its composite key consists of PDS ID, Component Location ID (I_COMPLOCID), and Component Product ID (I_COMPRDID). It supports date-dependent component validity periods, enabling the planning engine to consider different BOM structures over time during order explosion. Component data is integrated through RTI and can be extended with custom attributes using the business context /IBP/RTI_PDSBOM.

I_PDSRESOURCE links a production resource to a specific activity within a PDS and defines capacity consumption rates. In Time-Series-Based Supply Planning, capacity consumption is modeled using a numerator-to-denominator ratio. Fixed capacity consumption per period can also be configured at either the start or end of an activity. In Order-Based Planning, capacity requirements are always assigned to the final activity in the production sequence. The Resource ID in I_PDSRESOURCE must consistently reference the same attribute used in the I_RESOURCE master data type.

I_RESOURCE serves as the shared master data type for both production and distribution resources. Its key attribute is Resource ID (I_RESID).. Required attributes include Resource Type, Unit of Measure (UoM) for Available Capacity, and Capacity Consumption Policy. The Constraint Type (I_CONSTRAINTTYPE) attribute determines whether a resource is treated as finite or infinite in Time-Series-Based Supply Planning. In Order-Based Planning, this behavior is controlled through switchable constraints.

Together, these five master data types form a hierarchical, activity-based production model that provides a significantly more flexible and detailed representation of manufacturing processes than its predecessors. The model supports multi-step routings, date-dependent BOM structures, co-products (viaI_PDSADDITIONALOUTPUT), and granular resource capacity modeling.

Overview of Production-related Master Data Types in I_SAPIBP2
Details of Key Production-related Master Data Types in I_SAPIBP2
PDS Header
PDS Activity
PDS Component

Distribution-related Master Data Types

The distribution-related master data in I_SAPIBP2 is structured around the Transportation Lane model, which replaces the Location Source of Supply concept used in legacy planning areas such as SAP4 and SAPIBP1. The model consists of several closely related master data types that collectively describe how products move between locations throughout the supply chain network.

I_TLANEPRODUCT (Transportation Lane) is the central master data type of the distribution model. It connects a source location to a target location for a specific product and mode of transport. Its key attributes are Source Location ID (I_LOCFRID), Target Location ID (I_LOCTOID), Product ID (I_PRDID), Mode of Transport ID (I_MOTID), and Additional Lane ID (I_ADDLANEID). The Additional Lane ID enables differentiation between lanes that share the same source location, target location, product, and mode of transport combination but differ by purchasing organization or procurement type, such as consignment. The transportation lane contains all relevant planning parameters, including validity dates, lead times (maintained in full days), lot-size constraints (minimum and maximum per order or planning period), freeze horizon, and goods receipt processing time. Multiple validity periods can be defined for a single lane to support Time-Series-Based Supply Planning and Inventory Optimization. Unlike the production-related PDS model, distribution processes do not include explicit activity modeling; lead times are maintained directly on the transportation lane.

I_TLANEDOWNSTREAM and I_TLANEUPSTREAM are reference master data types derived from I_TLANEPRODUCT. They provide the downstream (receiving location) and upstream (shipping location) perspectives of the same transportation lane. This distinction is required because key figures in I_SAPIBP2 are defined separately for upstream and downstream planning levels. This represents a significant enhancement compared to the SAP4 and SAPIBP1 planning models, where a single Location Source of Supply object represented both perspectives.

I_TLANEPRODUCTRESOURCE (Transportation Lane Resource Consumption) links a transportation lane to an I_RESOURCE entry and defines the corresponding distribution capacity consumption. Its composite key consists of Source Location ID, Target Location ID, Product ID, Mode of Transport ID, Additional Lane ID, and Resource ID. Capacity consumption is modeled using a numerator-to-denominator ratio and can be maintained either as a time-independent attribute or derived dynamically from a consumption-rate key figure. This enables detailed modeling of distribution capacities, such as weight-based or volume-based truck utilization for specific products and transportation lanes.

I_UNSPECIFIEDPURCHASING (Unspecified Purchasing) represents the point at which supply enters the planning network when the upstream supply chain is not modeled in detail. It is a new concept introduced in I_SAPIBP2 , replacing the External Source of Supply master data type used in earlier planning area types. Instead of modeling a vendor-specific transportation lane, Unspecified Purchasing allows the planning algorithm to generate supply without propagating demand further upstream. The concept supports two modeling approaches: vendor locations without location products and vendor locations with location products. Multiple validity periods can be maintained using the companion master data type I_UNSPECIFIEDPURCHASINGVLDTY. For purchasing see as well the section Purchasing-related Master Data Types in I_SAPIBP2.

I_TSPCUSTOMERTLANEPRODUCT (Customer Transportation Lane) and its associated validity master data type replace the Customer Source of Supply concept from legacy planning areas. They are used primarily in Time-Series-Based Supply Planning to model the relationship between a customer and a specific source location and product combination. This enables customer-specific demand to be assigned to designated sources of supply.

Together, these master data types form a flexible, multi-tier distribution model that supports a broad range of supply chain scenarios, including stock transfers, external procurement, subcontracting, and customer-specific sourcing. The introduction of the Additional Lane ID and the separation of upstream and downstream planning perspectives provide a level of modeling flexibility and planning granularity that was not available in earlier planning area architectures.

Purchasing-related Master Data Types in I_SAPIBP2

The procurement-related master data in I_SAPIBP2 defines how external supply enters the planning network. Unlike production and distribution, procurement does not introduce fundamentally new master data types. Instead, it is built on I_LOCATION, I_LOCATIONPRODUCT, and I_TLANEPRODUCT, which are used in specific modeling variants and enhanced with procurement-specific attributes.

Procurement lanes in I_SAPIBP2 are modeled as transportation lanes of stock transfer type 0 (external procurement) in I_TLANEPRODUCT, connecting a vendor location (Location Type = V) to a receiving plant. I_SAPIBP2 supports a single-tier procurement model in two variants:

  • Vendor locations without location products, which is the simpler RTI-supported variant aligned with the SAP S/4HANA model.
  • Vendor locations with location products and unspecified purchasing, which enables more detailed vendor modeling.

In the first variant, the vendor is represented as a location without an associated location product on the transportation lane. Supply from the vendor is considered unlimited by default and can be restricted using the Adjusted Distribution Supply (Lane) key figure.

Procurement transportation lanes can be generated from purchasing info records, contracts, or special procurement types integrated from SAP ECC or SAP S/4HANA. Each source may result in different combinations of Additional Lane ID (I_ADDLANEID), purchasing organization, and mode of transport.

It is important to note that RTI supports only the variant without vendor location products. The variant with vendor location products requires SAP Cloud Integration or manual maintenance.

I_UNSPECIFIEDPURCHASING identifies the point in the network where external supply enters without explicitly modeling the upstream supplier. It serves as the IBP successor to the External Source of Supply concept used in legacy planning areas such as SAP4 and SAPIBP1.

Only one unspecified purchasing source of supply can be maintained for a given location product. If no other sources of supply exist, the planning algorithm automatically assigns a quota of 100% to the unspecified purchasing source. If additional sources are available, its quota is calculated as the remaining percentage after all other source quotas have been considered.

The source can be blocked using the I_UPBLOCKED attribute. Multiple validity periods are supported through the companion master data type I_UNSPECIFIEDPURCHASINGVLDTY in Time-Series-Based Supply Planning.

Order-Based Planning does not support modeling supply entry points through I_UNSPECIFIEDPURCHASING. Instead, unconstrained external supply must be represented by a PDS header without components.

Subcontracting in I_SAPIBP2 combines procurement and production master data concepts. The subcontractor is modeled as a vendor location (Location Type = V), while the finished product is planned using a subcontracting PDS at that location. The corresponding PDS is identified through the attribute I_VALIDONLYFORSUBC = X in I_PDSHEADER.

The transportation lane from the ordering plant to the subcontractor is defined as type 3, and the I_PDSIDFORSUBC attribute in I_TLANEPRODUCT references the subcontracting PDS. Component provisioning from the ordering plant to the subcontractor is represented through component-provisioning lanes of type 7.

When integrated through RTI from SAP ECC or SAP S/4HANA, the system automatically creates the subcontractor location, location products for both components and the finished product, and the corresponding component-provisioning transportation lanes. However, transportation lanes for direct component shipments from a third-party vendor to the subcontractor (type 0) must be created manually or generated using the BAdI CIF_TLANE_MAP_IBP.

Procurement master data in I_SAPIBP2 is not represented by a separate set of dedicated master data types. Instead, it is modeled through a structured combination of I_LOCATION, I_LOCATIONPRODUCT, I_TLANEPRODUCT, and I_UNSPECIFIEDPURCHASING. These objects are configured in specific ways to represent procurement processes, vendor relationships, external supply sources, and subcontracting scenarios, enabling the planning model to accurately reflect real-world procurement structures and sourcing strategies.

Procurement-related Options related to I_SAPIBP2

Create an Excel Connection

Business Example

To connect to the SAP IBP system, you must create a connection in Excel using a specific planning area. Within this course, we will work with a full copy of I_SAPIBP2 which is named IBP400.

Note

When these two symbols ## appear on this training, replace them with your trainee number.

Steps

  1. In Excel, create a connection to the IBP400 planning area and log on with the same credentials provided by your instructor.

    1. Open Excel and select the SAP IBP tab at the top. If you do not find the tab IBP in excel use windows search bar, type 'SAP IBP' and double-click on the element found.

    2. Select the Log-on icon at the left edge of the tool bar.

    3. In the dialog box, choose the ... (ellipses) button.

    4. In the Connection Manager dialog box, choose Create Connection... in the upper part of the popup.

    5. In the Connection Name field, enter IBP400.

    6. Enter the Server URL provided by your instructor.

    7. Choose ... (ellipses) button. related to Planning Area, enter the credentials provided by your instructor and choose IBP400 from the list of planning areas.

    8. Choose OK in the Select Planning Area dialog box

    9. Set flag Set as Default Connection

    10. Choose OK in the Create Connection dialog box.

    11. Observe in the Connection Manager that you have created a connection to the IBP system. For the upcoming tasks we will use the IBP400 connection.

    12. Click on OK in the Connection Manager dialog box.

Result

Result

At the end of this task, you have established a connection to a planning area of the SAP system.

Create a Planning View Based on a Template

Business Example

To optimize stock levels, a group of templates in Excel can be used as the starting point to guarantee traceability, transparency, and proper application of advanced algorithms. For this task, IBP400 planning area will be used via the IBP400 connection.

In this course we will mainly use a time horizon of 52 weeks into the past and 26 weeks into the future, which will also be reflected in the different planning views and related tabs used in this exercise respectively in this course.

Note

When these two symbols ## appear on this training, replace them with your trainee number.

Steps

  1. Create a planning view for the validation of inputs using template IO 210 Validate Inputs. Add this planning view to a folder called Inventory Optimization.

    1. In Excel log on to planning area IBP400.

    2. In the Excel UI, on the SAP IBP tab, in the Planning View section, choose New View→From Template….

    3. Choose IO 210 Validate Inputs under Template.

    4. Open Workbook Settings on the left of the Create New Planning View from Template window by clicking on the arrow on top of the left panel (if Workbook Settings are not already expanded).

    5. Under Workbook settings, remove any existing filters.

    6. Create a workbook filter named FG1##. For this, select Product ID 2 as Attribute, Operator "Equal to" and the values IBP##-100.,IBP##-200 and IBP##-300. In order to choose all product IDs mentioned, click on …, enter ## in the search field and choose all products listed above. By choosing these products the IDs will appear on the right side of the popup. Click OK.

    7. Click + to create a new planning filter. Use FG1## as name and click Add. Confirm any popup resp. message that appears.

    8. Choose Versions & Scenarios.

    9. Select Base Version under Versions and Baseline under Scenarios.

    10. Under Planning Scope, select all sub-networks also called Planning Units that correspond to your group number ##. For example, learners with ## will have all Planning Units containing ##. .

    11. Close the Workbook Settings panel by using the arrow on top of the panel (again).

    12. In the IO 210 Validate Inputs template, you will find the following tabs: Hist.Distr. Lead Time, Hist.Prod.Lead Time, Demand Input, Distribution Input, Production Input and Inventory Policy.

    13. Ensure, that the tab Demand Input is choosen.

    14. Note

      Demand input will be used partially from the past (e.g. to determine the forecast error) and partially from the future (e.g. for inventory policy). Therefore we will use 52 weeks into the past and 26 weeks into the future as horizon for this tab. For other tabs of this planning view we will use as well 52 weeks into the past in case they are related to historical data (e.g. for historical lead times) and 26 weeks into the future in case they are related to future data (e.g. for distribution and production input respectively for inventory policy). The planning algorithms in the course will usually run for 52 weeks in the future, but we as planners can focus on the details of the next 26 weeks.

      Ensure, that the tab Demand Input is choosen.

    15. Choose To, then pick the week 26 weeks from now if not already selected.

    16. In theTime Settings tab, under Time , select the From field and ensure that the week from one year ago is selected. Next, select the To field and ensure that the week 26 weeks from the current date is selected. If these values are already set accordingly, no changes are required.

    17. Validate the time settings for all tabs of this planning view according to the information given in the note above.

    18. Choose OK in the Create New Planning View from Template dialog box.

    19. Choose OK in the SAP IBP: Warning dialog box, if any.

    20. If an info box is displayed in yellow color, you can optionally read it and take note of the content accordingly. You can then delete it in any worksheet where it appears..

    21. In the Planning View section, choose Favorites→Add…, and save this planning view as your favorite: IO 210 Validate Inputs ##. Select the drop-down menu in the field folder, choose (New Folder) and type Inventory Optimization ## in the field New Folder Name.

    22. Change the filters of the graphs in Excel according to your preference.

Result

Result

At the end of this exercise, you have created a favorite folder for the inventory optimization. Within this folder you have saved the first of the planning views as favorite..

Know General Master Data Types for SAP IBP, advanced inventory

Prerequisites

For this exercise, the connection IBP400 will be used to display the master data types for inventory optimization.

Business Example

You want to understand the master data structure to start your inventory plan. To accomplish this goal, in this exercise we will explore the attributes and master data types delivered in I_SAPIBP2 for IBP, advanced inventory optimization (Planning Area IBP400).

Steps

  1. Display the H40PRODUCT simple master data type in the SAP IBP Web UI, and make a mental note of the attributes that are assigned.

    1. Log on to the SAP Fiori launchpad.

    2. On the SAP Fiori home screen, choose the "Model Configuration Group and there the Master Data Types – Model Configuration tile.

    3. Using the field Search, filter all master data types that begin with the prefix H40.

    4. Select the H40PRODUCT master data type in the left column. View the attributes assigned, including root attributes.

  2. Display the H40CLOCATION simple master data type in the SAP IBP Web UI, and make a mental note of the attributes that are assigned.

    1. On the SAP Fiori home screen, choose the "Model Configuration Group and there the Master Data Types – Model Configuration tile.

    2. Filter all master data types that begin with the prefix H40.

    3. Select the H40LOCATION master data type in the left column. View the attributes assigned, including root attributes

  3. Display the H40CLOCATIONPRODUCT compound master data type in the SAP IBP Web UI, and make a mental note of the attributes that are assigned.

    1. On the SAP Fiori home screen, choose the "Model Configuration Group and there the Master Data Types – Model Configuration tile.

    2. Filter all master data types that begin with the prefix H40.

    3. Select the H40LOCATIONPRODUCT master data type in the left column. View the attributes assigned, including key attributes.

  4. Display the H40TLANEPRODUCT simple master data type in the SAP IBP Web UI, and make a mental note of the attributes that are assigned.

    1. On the SAP Fiori home screen, choose the "Model Configuration Group and there the Master Data Types – Model Configuration tile.

    2. Filter all master data types that begin with the prefix H40.

    3. Select the H40TLANEPRODUCT master data type in the left column. View the attributes assigned, including root attributes.

  5. Display the H40SOURCECUSTGROUP compound master data type in the IBP Web UI and make a mental note of the attributes that are assigned.

    1. On the SAP Fiori home screen, choose the "Model Configuration Group and there the Master Data Types – Model Configuration tile.

    2. Filter all master data types that begin with the prefix H40.

    3. Select the H40SOURCECUSTGROUP master data type in the left column. View the attributes assigned, including root attributes.

    4. Click on the Number below Planning Areas to visualize to which planning area the master data type is assigned.

    5. In the popup that appears, choose IBP400.

    6. Choose tab Mater Data Types to visualize the master data types that are assigned to this planning area. In addition to the master data types that were reviewed in greater detail, you will find a variety of other master data types listed here, providing a comprehensive overview of the planning area's master data structure.

  6. Display the master data types for inventory planning and optimization in the SAP IBP, add-in for Microsoft Excel, and make a mental note of the attributes that are assigned.

    1. In Excel, go to the SAP IBP tab.

    2. Log in to the SAP IBP, add-in for Microsoft Excel using the IBP400 Connection.

    3. Select the Master Data Workbook button.

    4. Choose Create.

    5. In the Create Master Data Workbook popup, select under GeneralMaster Data as Worksheet Type in the right part of the popup.

    6. Select Product as Master Data Type, choose Base Version.

    7. Choose the option with the plus sign on the bottom of the popup to add another sheet to your master data workbook and add Location.

    8. Repeat with the following master data types: Customer from SFC, Location, Location Product, Transportation Lane and Customer Group Source. Verify that you see the information message that you have permissions to edit master data below the drop down options.

    9. On the left side, expand the workbook filter option by using the arrow (if needed).

    10. In the filter dropdown, choose the filter FG1## you have created previously.

    11. Choose OK.. to close the Create Master Data Workbook dialog box.

    12. In the excel window opened, you will find a separate tab for each of the master data typoes selected.

    13. Browse through the master data available in planning area IBP400.

    14. Note the orange column in every worksheet which represent mandatory fields in every sheet in which it is possible to change data.

    15. In case a note appears read it optionally and close it using the x in the upper right corner.

    16. Choose Favorites under Master Data to add your view as a favorite.

    17. Click on + to open the Master Data Favorite dialog box.

    18. Under Name, type in Master Data Model ##, selecting a New Folder called Inventory Optimization ##, save this master data favorite.

Result

Results

You have now analyzed the master data model within planning area IBP400, the full copy of I_SAPIBP2 for inventory optimization.