PUBLIC

2023-03-11

Configuration of SAP MDG, Consolidation and

Mass Processing
© 2023 SAP SE or an SAP affiliate company. All rights reserved.

THE BEST RUN

Content

1 Configuration of SAP MDG, Consolidation and Mass Processing. . . . . . . . . . . . . . . . . . . . . . . . 4

1.1 Services for MDG, Consolidation and Mass Processing (Web Dynpro and Gateway). . . . . . . . . . . . . . .7
1.2 Configure Gateway Services for SAP MDG, Consolidation and Mass Processing. . . . . . . . . . . . . . . . . 8
1.3 Set up the Workflow. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
1.4 Configure Process Model. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
1.5 Configure Custom Objects. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
1.6 Specify Table and Field Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .16
1.7 Specify Adapters for Business Partner. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17
Configure SAP HANA Smart Data Quality. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
1.8 Specify Adapters for Material. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .23
1.9 Define Rules Using the Business Rule Framework plus. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
1.10 Configure Scope for Mass Processing. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
1.11 Configure Standardization. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .28
1.12 Configure Parallelization for Update. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30
1.13 Configure Matching for Business Partner. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .31
1.14 Configure Matching for Material. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
Configure Matching. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38
1.15 Configure Best Record Calculation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
1.16 Configure Validation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46
1.17 Configure Filter and Remove. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48
1.18 Configure Activation for Business Partner. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49
1.19 Configure Activation for Business Partner Relationships. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52
1.20 Configure Activation for Material. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56
1.21 Specify Process Template. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59
1.22 Import Predefined Process Templates for Business Partner. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .61
1.23 Import Predefined Process Templates for Material. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65
1.24 Data Load. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67
Example: Loading Vendor and Customer Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69
1.25 App Extensibility: Master Data Governance, Consolidation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81
1.26 App Extensibility: Master Data Governance, Mass Processing. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82
1.27 App Extensibility: Configure Custom Objects. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .84
1.28 Usage of Consolidation Processes for SOA-Inbound Processing. . . . . . . . . . . . . . . . . . . . . . . . . . . 84
1.29 Configure MDG, Consolidation and Mass Processing for Custom Objects. . . . . . . . . . . . . . . . . . . . . 85
Preparations for Custom Objects. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86
Create and Configure Process Model for Custom Objects. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87
Configure BRFplus for Custom Object Consolidation and Mass Processes. . . . . . . . . . . . . . . . . .88

Configuration of SAP MDG, Consolidation and Mass Processing

2 PUBLIC Content
 Configure Gateway Service and Activate BC-Set for Custom Objects. . . . . . . . . . . . . . . . . . . . . 89
Add Tile to Launchpad for Custom Objects. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90
1.30 Parallelization in SAP MDG, consolidation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91

Configuration of SAP MDG, Consolidation and Mass Processing

Content PUBLIC 3
1 Configuration of SAP MDG, Consolidation
and Mass Processing

Use

SAP MDG, consolidation and mass processing enables you to consolidate your master data and it enables you
to run mass processes to update multiple master data records at a time. The order of the process steps as well
as the behavior of each individual process step type can be adapted to your requirements.

This document provides the information you require to set up SAP MDG, consolidation and mass processing. It
contains information about Customizing as well as the information about additional activities that you need to
execute.

Prerequisites

Services

You have activated the gateway services and services for web dynpro applications. For a detailed list of the
relevant services, see Services for SAP MDG, Consolidation (Web Dynpro and Gateway) [page 7].

Business Function

In the Customizing activity Activate Business Functions (transaction SFW5), you have activated at least one of
the following sets of business functions:

• Master Data Governance for Customer, Consolidation 8.0, Master Data Governance for Customer,
Consolidation and Mass Processing 9.0, Master Data Governance for Customer, Consolidation and Mass
Processing 9.1, and Master Data Governance for Customer, Consolidation and Mass Processing 9.2 .
• Master Data Governance for Supplier, Consolidation 8.0, Master Data Governance for Supplier,
Consolidation and Mass Processing 9.0, Master Data Governance for Supplier, Consolidation and Mass
Processing 9.1, and Master Data Governance for Supplier, Consolidation and Mass Processing 9.2.
• Master Data Governance for Material, Consolidation and Mass Processing 9.0, Master Data Governance for
Material, Consolidation and Mass Processing 9.1, and Master Data Governance for Material, Consolidation
and Mass Processing 9.2.

 Note

If you want to run MDG, consolidation and mass processing for custom objects you have to activate the
business function Master Data Governance for Custom Objects, Consolidation and Mass Procesing 9.0.

 Note

If you want to run SAP MDG, consolidation and mass processing in parallel with SAP MDG, central
governance you have to activate the corresponding business functions. For more information, see
Configuration of Master Data Governance.

Configuration of SAP MDG, Consolidation and Mass Processing

4 PUBLIC Configuration of SAP MDG, Consolidation and Mass Processing
Authorization Objects

You have assigned the relevant authorization objects and roles. For more information about authorization
objects and roles, see Authorization Objects and Roles Used by SAP MDG, Consolidation and Mass Processing.

Autorization for Workflow System User

The following authorization objects with authorization for all activities are assigned to the workflow system
user (WF batch user).

• MDC_ADMIN
• MDC_PROOT
• MDC_PFILT
• MDC_MASS
• MDC_LOAD
• S_BGRFC

SAP HANA-Based Fuzzy Matching

To work with views and rule sets in SAP HANA, the ABAP system database user has the privileges and the
permissions for the tasks listed below:

• Permission
• Create packages and write objects into packages
• Create, change and drop attribute views
• Create, change and drop SQL views
• Create, execute and drop rule sets
• Privileges
• Execute for the object EXECUTE_SEARCH_RULE_SET(SYS) of the schema SYS
• Execute for the object GET_PROCEDURE_OBJECTS of the schema SYS
• Execute for the object TRUNCATE_PROCEDURE_OBJECTS of the schema SYS

For more information, see SAP HANA Security Guide and SAP HANA Search Developer Guide - FUZZY
Search .

Basic Configuration of bgRFC

You have configured the bgRFC settings. For more information see, http://help.sap.com/saphelp_nw70/
helpdata/en/44/fda148f5de41dee10000000a1553f6/content.htm .

 Note

If you want to use the automated setup of bgRFC, see SAP Note 1043195 . This note includes the
configuration of web service runtime.

General

Determination of Own Business System:

Either the MDG hub system and the source systems are connected to the System Landscape Directory (SLD) or
the BAdI MDG_IDM_GET_LCL_SYSTEM is implemented to determine the local system ID.

Configuration of SAP MDG, Consolidation and Mass Processing

Configuration of SAP MDG, Consolidation and Mass Processing PUBLIC 5
• To verify the correctness of the SLD content run transaction SLDCHECK in the MDG hub and client systems.
Ignore the browser dialog box. In the systems check that the message reads: Summary: Connection to
SLD works correctly.
• If you decide to implement the BAdI and not to use SLD, see the documentation of the IMG activity under
Master Data Governance Central Governance General Settings Data Replication Define Custom
Settings for Data Replication Define Technical Settings BAdI: Determination of Local System Name .

Process

You run the settings for this process in Customizing under Cross-Application Components Processes and
Tools for Enterprise Applications Master Data Governance Consolidation and Mass Processing .

 Note

You can access all SAP MDG, consolidation and mass processing specific Customizing activities using the
transaction MDCIMG.

1. Services for MDG, Consolidation and Mass Processing (Web Dynpro and Gateway) [page 7]
2. Configure Gateway Services for SAP MDG, Consolidation and Mass Processing [page 8]
3. Set up the Workflow [page 12]
4. Configure Process Model [page 13]
5. Configure Custom Objects [page 15]
6. App Extensibility: Configure Custom Objects [page 84]
7. Specify Table and Field Properties [page 16]
8. Specify Adapters for Business Partner [page 17]
9. Specify Adapters for Material [page 23]
10. Define Rules Using the Business Rule Framework plus [page 26]
11. Configure Scope for Mass Processing [page 27]
12. Configure Standardization [page 28]
13. Configure Parallelization for Update [page 30]
14. Configure Matching [page 38]
15. Configure Matching for Business Partner [page 31]
16. Configure Matching for Material [page 35]
17. Configure Best Record Calculation [page 42]
18. Configure Validation [page 46]
19. Configure Filter and Remove [page 48]
20.Configure Activation for Business Partner [page 49]
21. Configure Activation for Business Partner Relationships [page 52]
22. Configure Activation for Material [page 56]
23. Specify Process Template [page 59]
24. Import Predefined Process Templates for Business Partner [page 61]
25. Import Predefined Process Templates for Material [page 65]
26. Data Load [page 67]
27. Example: Loading Vendor and Customer Data [page 69]

Configuration of SAP MDG, Consolidation and Mass Processing

6 PUBLIC Configuration of SAP MDG, Consolidation and Mass Processing
28. App Extensibility: Master Data Governance, Consolidation [page 81]
29. App Extensibility: Master Data Governance, Mass Processing [page 82]
30.Usage of Consolidation Processes for SOA-Inbound Processing [page 84]
31. Configure MDG, Consolidation and Mass Processing for Custom Objects [page 85]
32. Preparations for Custom Objects [page 86]
33. Create and Configure Process Model for Custom Objects [page 87]
34. Configure BRFplus for Custom Object Consolidation and Mass Processes [page 88]
35. Configure Gateway Service and Activate BC-Set for Custom Objects [page 89]
36. Add Tile to Launchpad for Custom Objects [page 90]
37. Parallelization in SAP MDG, consolidation [page 91]

Result

The system is configured for SAP MDG, consolidation and mass processing.

More Information

Master Data Governance Security Guide

1.1 Services for MDG, Consolidation and Mass Processing

(Web Dynpro and Gateway)

Use

For security reasons the services delivered for Web Dynpro applications initially are available in an inactive state
only. You have to activate the services you want to use.

Activities

To activate the services, proceed as described below in the corresponding system:

1. On the Maintain Services screen (transaction SICF), make sure that the Hierarchy Type SERVICE is
selected, enter the Service Name, and choose Execute.
2. Choose Service/Host Activate , to activate the service.

 Note

You have to perform the procedure for each single service you want to activate.

Configuration of SAP MDG, Consolidation and Mass Processing

Configuration of SAP MDG, Consolidation and Mass Processing PUBLIC 7