Easy Master Data Mass Maintenance via Upload in Transaction MASS

  • by Kees van Westerop, Senior SAP Consultant, Kwest Consulting
  • December 23, 2015
Since the beginning of the SAP R/3 system, SAP has provided transaction MASS for mass maintenance of master data. Mass maintenance means that per object type you can maintain several objects simultaneously. Examples of object types are cost center, customer, and purchase order. It is now possible to upload the changes to be made using a Microsoft Exel file. The advantage of uploading changes to be made via an Excel file is that you can execute multiple changes at the same time instead of one by one.
Learning Objectives

After reading this article, you will know how to:

  • Upload master data changes using transaction MASS
  • Map fields in a Microsoft Excel upload sheet with the SAP fields

Key Concept

Transaction MASS is a cross-application transaction to be used for mass maintenance of master data.

In several situations you need to do a mass update of specific data—for instance, during a project or when master data that is already uploaded must be changed because of changing requirements. In the SAP system there are several alternatives to do such a mass update. You can use specific transactions to do the update. An example is the Display Customer Line Items transaction (transaction code FBL5N) that you can use to change all selected items. Other examples are Customer Master Mass Maintenance (transaction code XD99) and Mass Changes in Project System (transaction code CNMASS).

SAP has combined the maintenance of many master data objects in transaction MASS. When you start transaction MASS you can choose from 20 object types each representing a master data object. Figure 1 shows which object types currently are supported.


Figure 1
Object types in transaction MASS
 

For more than a year SAP has extended the transaction MASS with the functionality to upload data from an external source such as a Microsoft Excel sheet. In this article I focus on the new functionality to upload data using Excel. As an example I use cost centers and change the User responsible field. As a first step you must prepare the Excel file.

Kees van Westerop

Kees van Westerop has been working as an SAP consultant for more than 25 years. He has an MBA degree in mathematics and a degree in finance. Kees has been concentrating on the financial modules, especially in general ledger accounting, cost center accounting, and consolidation. He also has a great deal of experience with rollouts of kernel systems and integrating finance and logistics.

See more by this author


Comments

1/7/2016 8:34:59 AM
Vishwanath Krishnamurthy

Too good and handy tips..thanks for the article...

Please log in to post a comment.

To learn more about subscription access to premium content, click here.