Creating a Compound Master Data Type

Objective

After completing this lesson, you will be able to create a compound master data type

Compound Master Data Type

A compound master data type in SAP IBP is essentially a higher-level master data type that combines several individual master data types. This concept allows businesses to create and efficiently manage complex, hierarchical business structures.

Our example considers the connection between "Customer" and "Product" in a company. Usually, "Customer" and "Product" would be individual master data types in SAP IBP, each with its attributes. For instance, "Product" could have the key attribute "Product ID" and additional assigned attributes like "Product Description" and "Product Category", while "Customer" might have the key attribute "Customer ID" and additional assigned attributes like "Customer Segment" and "Customer Region."

Although these individual master data types can provide important information, combining them in real business scenarios can lead to more effective decision-making processes. This is where the compound master data type comes into play. As not all products are sold to all customers, to represent the valid combinations of products and customers, you could create a compound master data type called "CustomerProduct," which combines the master data types "Product" and "Customer." This allows for a holistic view of the relationship between customers and the products they buy. The key attributes of the assigned master data types "Product" and "Customer" will be automatically assigned as key attributes for the compound master data type "CustomerProduct", and an additional attribute, "Market Segment", can be selected for these combinations. When key figure data containing the key product ID and customer ID is loaded, the system checks against the compound master data type for valid combinations and stores data only for those.

Instead of performing isolated analyses, the company can now analyze the consolidated master data type of "CustomerProduct" to gain comprehensive insights. This could help identify the preferences of certain customer segments for specific product categories or identify sales trends.

Ultimately, the compound master data type aims to integrate related master data types to represent complex business structures better.

Note the following about compound master data types:

  • They are made up of two of more master data types.

  • They validate the data of the master data types that they are comprised of.

  • They define the combinations of planning attributes that can be planned.

You can specify simple, compound, reference, and external master data types as component master data types. Also, make sure that the status of the master data type you select is active or inactive.

The key attributes of the component master data types you selected are automatically added as key attributes under Assigned Attributes.

Note that a decimal attribute can't be a key attribute in a compound master data type.

You can select additional attributes other than those that are automatically included from the compound master data types.

How to Create a Compound Master Data Type

Create a Compound Master Data Type

This exercise requires you to use the simple master data type that you created in the exercise Create a Simple Master Data Type.

In this exercise, you create a compound master data type that is required for one or more subsequent exercises in this course.

Business Example

You are a member of the project team managing the implementation of SAP Integrated Business Planning for Supply Chain. You want to set up the business model objects in the SAP Integrated Business Planning system. The simple master data type was created previously, and you must now continue the business object generation by creating a compound master data type, which combines two or more simple master data types.

When the data values for the exercise include ##, replace ## with the group number that the instructor has provided to you.

Steps

  1. Using the Master Data Types app, create the master data type T##CUSTOMERPRODUCT as a compound master data type of T##CUSTOMER and T##PRODUCT. Use the following details:

    Compound Master Data Type: T##CUSTOMERPRODUCT

    FieldValueSimple Master Data Types
    NameCustomer Product ##N/A
    DescriptionCustomer Product ##N/A
    Master Data TypeCompoundN/A
    Add Simple Master Data Types:N/AT##CUSTOMER
    T##PRODUCT
    ATTRIBUTES:  
    T##CUSTIDKeyN/A
    T##PRDIDKeyN/A
    T##UNITPRICEN/AN/A
    1. Choose the Master Data Types tile.

      The Master Data Types screen appears.

    2. Choose New → Compound.

      The New Compound Master Data Type screen appears.

    3. In the ID field, enter T##CUSTOMERPRODUCT and then enter Customer Product ## in the Name field and the Description field.

    4. Choose Add in the Component Master Data Types screen area.

    5. In the Master Data Types dialog box, enter T## and press Enter to filter for your master data types.

    6. Select T##CUSTOMER and T##PRODUCT master data types in the list and choose OK.

      Note

      The system selects the key attributes for the selected simple master data types in the Assigned Attributes screen area.
    7. Choose Add in the Assigned Attributes screen area.

    8. Enter T## a filter the list for your attributes.

    9. Select the checkbox to the left of T##UNITPRICE and choose OK to include it in the compound master data type.

    10. On the bottom right of the screen, choose Save.

    11. Return to the SAP Fiori launchpad home page.

Log in to track your progress & complete quizzes