Hi,
With SAP MDG 9.1, respectively MDG on S/4 Hana 1709 “SAP Master Data Governance - Mass Processing” was introduced to support effective mass change process enabling master data stewards to perform bulk changes in business partner, customer, supplier, and product data. The function is documented in the SAP official help.
With SAP MDG mass processing you can change existing objects, but you can also “extend” existing objects. “Extend” in this context means that you can for instance open existing materials/products on new/additional plants or sales orgs. This is also possible for Business Partner.
A simple way is to prepare the data in an Excel file and upload the file into the source table for further processing in a mass processing process. Its important to know that you can add an additional column into your excel file to define the function for the corresponding line. The key word for the column is “_ACTION_CODE” and the value per line “I” for Insert and “C” for Copy.
Below you will find more details and the steps which you need to do to use the feature.
Steffen
Use MDG Mass Processing to extend 2 products by one plant each.
In this app you will define the scope (which information will be downloaded per product) and you select the products by a selection criteria. The result is a excel file which can be downloaded to your local OS. The file is like a template for later usage in the mass processing process.
In this app you will define the scope (which information will be downloaded per product) and you select the products by a selection criteria. The result is a excel file which can be downloaded to your local OS. The file is like a template for later usage in the mass processing process.
Info: With these settings I will export data for 2 products.
Open the Excel, review it and add the new column in tab “MARC”. The column is the header “_ACTION_CODE”
Background: In this example the product 24 will extended by plant 0002 and product 25 by plant 0001. You can even use the action code with a value “C” to copy plants. The syntax’s would be:
Info: System will extend product 24 with plant 0002 and will copy all values from plant 0001 of the same product.
Save the excel file to your local OS.
Prepare the mass processing by starting the app “Manage Mass Processes”
Click on Create Process and define the import file:
By clicking on SAVE the system will import the data from the excel into the source tables
Finally, you will start the mass processing and the system will inform you by the blue color that you will insert new data to existing records.
Edit Record view:
At the end of the mass processing process the system will validate and activate the data.
To make sure that everything worked you can use various apps to review the new data in the system. The screenshot shows the technical view on DB level.
You can also use Action Code "D" for Deletion. e.g. in case you want to delete an Identification number you can use "_ACTION_CODE" = “D” in the BUT0ID tab the excel.
If you are using an excel with only one tab ( see templates which you can download) you can specify which content to be Insert/Copy/Delete with the following syntax: "BUT0ID-ACTION_CODE" in the Header Line and the action below. In the following example it would delete the Identification Type HCM001 with ID 1214T019129_22_XE
(Special thanks to Christina Lindner)
With SAP MDG 9.1, respectively MDG on S/4 Hana 1709 “SAP Master Data Governance - Mass Processing” was introduced to support effective mass change process enabling master data stewards to perform bulk changes in business partner, customer, supplier, and product data. The function is documented in the SAP official help.
With SAP MDG mass processing you can change existing objects, but you can also “extend” existing objects. “Extend” in this context means that you can for instance open existing materials/products on new/additional plants or sales orgs. This is also possible for Business Partner.
A simple way is to prepare the data in an Excel file and upload the file into the source table for further processing in a mass processing process. Its important to know that you can add an additional column into your excel file to define the function for the corresponding line. The key word for the column is “_ACTION_CODE” and the value per line “I” for Insert and “C” for Copy.
Below you will find more details and the steps which you need to do to use the feature.
Steffen
“How To… Extend products by new plants using SAP MDG Mass Processing”
Goal of the demo:
Use MDG Mass Processing to extend 2 products by one plant each.
1. Download the products into Excel with the app “Export Master Data”
In this app you will define the scope (which information will be downloaded per product) and you select the products by a selection criteria. The result is a excel file which can be downloaded to your local OS. The file is like a template for later usage in the mass processing process.
In this app you will define the scope (which information will be downloaded per product) and you select the products by a selection criteria. The result is a excel file which can be downloaded to your local OS. The file is like a template for later usage in the mass processing process.
Info: With these settings I will export data for 2 products.
2. Prepare Data:
Open the Excel, review it and add the new column in tab “MARC”. The column is the header “_ACTION_CODE”
Background: In this example the product 24 will extended by plant 0002 and product 25 by plant 0001. You can even use the action code with a value “C” to copy plants. The syntax’s would be:
Info: System will extend product 24 with plant 0002 and will copy all values from plant 0001 of the same product.
Save the excel file to your local OS.
3. Prepare Process
Prepare the mass processing by starting the app “Manage Mass Processes”
Click on Create Process and define the import file:
By clicking on SAVE the system will import the data from the excel into the source tables
4. Start mass processing and continue
Finally, you will start the mass processing and the system will inform you by the blue color that you will insert new data to existing records.
Edit Record view:
At the end of the mass processing process the system will validate and activate the data.
5. Review the changes in the system
To make sure that everything worked you can use various apps to review the new data in the system. The screenshot shows the technical view on DB level.
Additional info
More Action Codes available
You can also use Action Code "D" for Deletion. e.g. in case you want to delete an Identification number you can use "_ACTION_CODE" = “D” in the BUT0ID tab the excel.
If you are using an excel with only one tab ( see templates which you can download) you can specify which content to be Insert/Copy/Delete with the following syntax: "BUT0ID-ACTION_CODE" in the Header Line and the action below. In the following example it would delete the Identification Type HCM001 with ID 1214T019129_22_XE
(Special thanks to Christina Lindner)
- SAP Managed Tags:
17 Comments
