Explaining Mass Processing in Master Data Governance

The figure shows the entry screen of the generic function in SAP Master Data Governance - Mass Processing: Worklist.

The worklist offers:

• Overview of all processes in various states
• Navigation to process details
• Ability to create and delete processes
• Process monitoring, for example, of long running activation of a process with a high volume of data

The figure shows the entry screen for accessing the general functions: Remove records / split process.

If a process is stopped for review, you can do the following:

• Remove records from the process, for example, records with errors, into a separate process for later processing.
• Also available as a separate process step, automatically remove exception records in the background.

The figure shows the entry screen of the general function: Audit trail.

The figure shows the entry screen of the general function in SAP Master Data Governance - Mass Processing: Importing a file with changes.

Change data by uploading a file in CSV or Office Open XML (XLSX) format with the following data:

• Which master data objects are updated
• Which tables and fields to update
• The respective values

You can also add and delete rows of tables that support this operation.

The first line in the file defines the columns: <TABLE>-<FIELD> (for example: BUT000-NAME_ORG1 or MARC-DISPO).

XLSX can contain one single worksheet (table) or multiple worksheets:

• Single worksheet: The content must be structured as specified for CSV.
• Multiple worksheets: You can organize the content, for example, one worksheet for each table.

You can use the Export Master Data app to check the file format required for upload.

For detailed information, see documentation on SAP Help Portal or Web Assistant.

With this new step, it is possible to remove unchanged data from the process to improve the performance for the validation and activation step. This new step will remove unchanged records completely from the process.

Unchanged data of the following tables will be removed if this part of the record was unchanged:

• Plant Data (MARC)
• Storage Location (MARD)
• Warehouse (MLGN)
• Sales Data (MVKE)

This feature is available for product (OTC: 194) and the process goals Mass Processing and Consolidation of Active Records.

With SAP S/4HANA 2023, this feature is now also available for Business Partner Master Data. Unchanged data of the following tables will be removed if this part of the record was unchanged:

• Company Code (Customer) (KNA1)
• Sales Area Data (KNVV)
• Company Code (Supplier) (LFB1)
• Purchasing Org Data (LFM1)
• Additional Purchasing Data (LFM2)

This is a new effective process for mass deletions of business partner relationships.

The process goal Mass Deletion is integrated into the Manage Mass Processes - Business Partner Relationships app. You can perform the selection of relationships using a selection step or a file upload. The summary of changes is available in the activation step to show the list of deleted relationships.

SAP Master Data Governance Mass Processing supports now mass changes for long text fields. You can use it defining the scope and selection for mass processing. This feature is also available using file upload.

In the Start Mass Processing, you have to enter the following data:

• Description of the process
• Process Template
• Import file with changed data. Supported formats:
  • Comma separated values (CSV)
  • Office Open XML spreadsheet (XLSX)

Information about the Scope step:

• Predefined scope can be stored/selected as Configuration.
• Scope is also freely adjustable.
• Choose fields, using search help (description and technical name).
• For file upload, Scope is derived from file and can be extended.

Information about the Selection step:

• Select objects using search criteria.
• All scope fields automatically added.
• Key fields from affected tables are automatically added.
• For file upload, Selection is defined by file and cannot be changed; Selection step is not visible.
• Data is copied to process tables for staging.
• Objects that are already included in another mass process or are target records in a consolidation process cannot be selected.

Information about the Edit step:

• Edit in a tabular UI - overview table, plus tables defined by scope.
• Edit individual fields or apply changes to multiple fields.
• Filter and sort data.
• You can save your work and resume it at any time

Here you can enter the following:

• Filter and sort data
• Replace values

Now you can enter:

• Changed data indicator per table row
• Display of old and new value

In the last screens of the edit step you can:

• Verify your changes based on statistical information.
• Navigate to changed/unchanged data.

In the Validation step, you:

• Perform a validation of the changed data.
• Execute the integration of rule engine (BRFplus).
• Consider master data governance central governance checks (BRFplus, BAdI).
• Drill-down into step result data from chart view.

In the Activation step, you activate the changed data, to make it effective for relevant business processes.

The figure shows an additional app for mass processing: Track Mass Changes.

Facts about this app:

• Auditing of active area changes documents triggered by a consolidation process.
• Select changes using object ID (Business Partner number, material number), process ID, or change date.