When a significant volume of a company's crucial master data needs to be updated, master data controllers need...
the right tools and know-how to create such changes. Given the general consistency of master data, however, they may not have these master data management basics at the ready.
Master data is the data that remains in the SAP system for long periods of time and does not frequently change. During the implementation of an SAP system such as SAP ERP Central Component, the SAP consultants are responsible for all data uploads, whereas the company's business users are responsible for providing correct and comprehensive master data to consultants for uploads. The SAP consultants provide Excel-based master data templates with details on how to fill them out. The business users fill out the data and the onus is on SAP consultants to upload the provided data in the SAP systems, including in the SAP's production system. The SAP consultants either use standard data upload programs delivered by SAP or create new data upload programs specifically for the project.
If new data needs to be created once the consultants are gone and the SAP system is live, these three master data management basics can guide master data controllers in navigating this challenge.
Reusing already-created upload programs
All data upload programs that the consultants of the relevant SAP components created are still available in the company's SAP system. Having a complete list of all upload programs and their purposes can go a long way in reusing them when needed. For example, an upload program was created by the SAP Sales and Distribution consultant to create new customer master record, while another program is available for vendor master record creation and a third one is there for employee master record creation. Similarly, upload programs may have also been created to change or update values in a few fields of the existing master data. These upload programs, too, can be put to use by data controllers when needed.
Using mass change functionality
It's often a surprise that so few data controllers are aware of the mass change functionality to quickly change or update data available to all components of an SAP ERP system. For example, transaction MM17 is available to update fields of a large number of material master records. The best way to find mass change functionality for specific master data is to navigate to the menu path of creating or changing master data in the SAP ERP system that also lists the mass change option in the same node.
Using SAP LSMW tool
Legacy System Migration Workbench (LSMW) is a tool that SAP consultants use for all kinds of data uploads. Master data controllers can do themselves a favor by learning how to use this tool. They can even request the SAP consultants deployed on the project to impart LSMW training and knowledge transfer. Imparting training by system integrator can also be made part of SAP project's deliverable.
Test your SAP master data management smarts
What to know about SAP Data Services
How the Altiscale deal with help SAP with big data
Dig Deeper on SAP MDM software
Related Q&A from Jawad Akhtar
The V-Model combines three highly interconnected components of product development: mechanics, electronics and informatics. Here are the steps for ... Continue Reading
One of the main challenges for manufacturers, supply chain managers and materials planners is demand variability. Here are 10 strategies for gaining ... Continue Reading
SAP Sales and Distribution, a component of SAP ECC, has a number of available functions to help create a better order-to-cash cycle. Here's a look at... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.