Organizing and managing Master Data with SAP IBP


After completing this lesson, you will be able to:

  • Consultants will be able to create basic a step-by-step method to best organize and manage Master Data using SAP IBP Add-In for Microsoft Excel and SAP Fiori Launchpad Master Data App.

Managing Master Data

There are basically three ways to maintain master data in SAP IBP:

  • Via the SAP IBP, add-in for Microsoft Excel
  • Through the SAP Fiori Launchpad (Web User Interface), using the Manage master data App
  • Through Data integration functions: the Cloud Integration - Data Services (CI-DS) and the Real-Time Integration (RTI) solutions

In this lesson, we will focus on the first two options.

Managing master data through the SAP IBP, add-in for Microsoft Excel

The functions for managing master data in the SAP IBP, add-in for Microsoft Excel allow you to make small-scale, ad-hoc changes to the master data in your system.


The functions are not designed to replace the regular data integration functions. We also do not recommend using these functions in systems with large data volumes or several Planning areas because the response time may be slow.

In the SAP IBP, add-in for Microsoft Excel, you have the following options for managing master data records:

  • Single

    You can add, copy, edit, or delete single master data records.

  • Mass

    You can download master data records that belong to a particular master data type to a Microsoft Excel worksheet, where you can view or edit the data. If your configuration supports version-dependent master data, the system allows you to specify the version.

If you execute several queries for the mass maintenance of master data, all queries are opened as master data worksheets within a master data workbook.

In edit mode, the system initially displays a dialog box containing information about allowed and disallowed changes. For example, you can cut and paste rows, or change record keys to create a new record. You cannot delete key columns or other mandatory columns, change the version, or create gaps between rows or columns that you want to upload.


You cannot delete any master data records in the back end using the mass management option. If you delete rows in a worksheet, the system disregards them when you save the data. This improves performance, but does not result in the records being deleted in the back end.

The following video will describe some of the functionality provided in the Master Data Workbook.

Managing master data through the SAP IBP, add-in for Microsoft Excel

Managing master data using the SAP IBP, add-in for Microsoft Excel supports the following four functions

The following video describes these four functions.


    This function does not replace the other data integration functions that are normally used in SAP IBP. We recommend that you use it to create and edit smaller numbers of Planning objects.

    Settings for key figure visibility and workability that exist for Planning Views do not apply when you use this function. For example, the system does not consider the following:

    • Key figure permissions (read, write) that the user might have.
    • Settings made for key figures where key figures are only editable in the past, future, or never.
    • Where key figures are marked as external in the model configuration, the Planning objects are shown without key figure data. These key figure values are not editable.

    Managing master data via the Web UI

    For this function, SAP IBP provides a Manage master data App, a streamlined tool that supports planners and integration experts in carrying out master data management activities. This application provides access to all the master data managed in SAP IBP by your organization. As a planner, you can search, filter, and sort the full set of master data available in your system in a customizable and user-friendly way with high-performance, while as an integration expert, you can easily check whether external master data has been correctly integrated to SAP IBP.

    With this app, users can execute the following tasks:

    • The initial screen of the app displays a worklist of master data type entries. For each entry, a list report view can be accessed, which provides details on the master data maintained for the selected master data type.

    • By default, the app displays Planning area-independent master data. However, list report views can be modified to specifically show master data that only exists in Planning versions.

    • To support users in customizing their master data views, filtering, sorting, and variant management features are available in the app.


    To work with the new app, you have to assign the SAP_IBP_BC_MAN_MASTERDATA_PC business catalog to your business role.

    User restrictions for accessing master data in the app can be set at multiple levels. On the one hand, user access can be configured based on a combination of Business Role, Attribute Permissions, and Permission Filters, which are assigned to the business user's ID. On the other hand, Restriction Types can be defined to limit access to specific master data types.

    Improving master data accuracy using Machine Learning

    Using Machine Learning rules are learned from the master data in IBP. These rules are used to detect errors and make recommendations how they can be corrected. Improved master data quality will improve the result of the IBP planning run. The automatic corrections reduce manual effort when preparing the data for planning.

    Key Capabilities using Machine Learning in SAP IBP are:

    • Analyze master data records to identify rules.

    • Find inconsistent master data records which do not adhere to the identified rules.

    • Make recommendations for repairing the inconsistency.

    • Deal with conflicting rules and decide for the most probable recommendation.

    • Use hierarchical information for unveiling additional patterns.

    With SAP IBP machine learning you can :

    • Develop and prototype algorithms.

    • Validation with customers.

    • Support translation into product component.

    Log in to track your progress & complete quizzes