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 data management
Related Q&A from Jawad Akhtar
Replenishment strategies, lot sizes, safety stock, reorder point planning and replenishment lead time are five factors in ERP that can ensure ... Continue Reading
S/4HANA public cloud provides a less disruptive route to digital transformation than some options -- including the on-premises S/4 -- and smoother ... Continue Reading
These nine key components of SAP MDG help ensure regulatory, legal, environmental and financial compliance of your master data and improve ... Continue Reading