X

SAP Mass Maintenance (MASS Transaction)

This tutorial which is part of our SAP MM course talks about SAP Mass Maintenance. You will learn about using MASS transaction in SAP MM to perform quick changes to multiple master records simultaneously.

SAP mass maintenance is a process of changing multiple master data entries at once. Mass maintenance of master records is required when there are a lot of existing master records and you need to change certain data fields in those records. For example, in multiple vendor masters or material masters at one time. Such an operation can save you a lot of efforts comparing to updating those records manually but you need to be extremely careful while making mass changes because SAP system directly updates the tables behind the master records and you need to have a good knowledge of tables and fields of master records to make the necessary changes.

SAP mass maintenance is performed in the transaction MASS.

This tool can be used in different modules including FI, SD, and Materials Management. In MM, we can use MASS transaction to make changes to:

SAP mass maintenance can be performed online or in background. If there are few records to be maintained, then you can run it online (because it will be fast). If there are lots of records to be maintained, it is better to run MASS in background because running it in background will save you a lot of time, have a lesser strain on the SAP system, and in the meantime you can carry on with your other tasks.

As this tool is directly touching tables, when you run MASS, the SAP system will do consistency check to make sure there is no issue between the changes in all the tables. If it finds any issues, it will stop processing to safeguard your database and issue you a log of the said issues.

When using MASS transaction, you will need to specify Object Types to determine which master data you want to touch with the maintenance process. For example, BUS1001 object type is for material (industry), BUS2012 is for purchase orders, BUS2014 is for contracts, BUS2105 is for purchase requisitions, etc.

Once the required Object Type is selected, the SAP system will display you a list of tables. You can select one table at a time for better system performance. You can also select several tables to make the required changes in all selected tables for data to be consistent but this action will put a lot of strain on the system and should be avoided in peak hours.

SAP Mass Maintenance Tutorial: Using MASS Transaction

Now, let’s go through a step-by-step example and carry on mass changes of material group field
for several material master records. We need to start the transaction MASS from the transaction bar.

Start MASS Transaction

In the initial screen of MASS transaction, you need to enter Object Type. You can see a list of available object types by clicking on box besides this field.

Initial Screen of MASS Transaction Requiring Object Type

If you click this box, a list of object types will be displayed. In our example, we will use BUS1001 object type.

List Displaying Available Object Types

Next, you should click on Execute button as highlighted on the screenshot below.

Object Type Selected for Our Case

The SAP system will show the next screen where you should check the box besides General Material Data and click on Fields tab.

Screen Displaying All the Tables Available in Materials Object Type

The system will display all the fields available for MARA table (that is used for general material data).

Fields Available in MARA Table are Displayed

Click on checkbox next to Material Group field to highlight it and then click on Execute button.

Material Group Field is Selected

The system will ask to enter the range of material numbers that require Material Group to be changed. Enter the range of material for which you would like to perform mass maintenance and click on Execute button.

Range of Materials to be Updated

On the next screen, the system will show you the materials you selected and their existing Material Groups. In our example, we want to change Material Group in all these materials to 001. Therefore, this value should entered in New Values field. Next, please click on Carry out Mass Change button .

You Need to Provide New Values to Existing Material Records

You will see that Material Group will be changed to 001 for all materials as required. Finally click on Save button to save the changes.

Material Group is Changed to New Values When You Click on Carry out Mass Change Button

Once the changes are saved, you will receive a message as shown on the screenshot below
notifying that all the changes have been correctly executed.

Screen Confirming All Changes to Materials were Correctly Executed

Check Results of SAP Mass Maintenance

After finishing mass maintenance with MASS transaction we can cross check our changes by opening material master records with one of usual transactions. For example, we can check a material master with a transaction MM02.

Here, we provide material number and hit Enter button on the keyboard.

Initial Screen of MM02 Transaction

The SAP system will display a pop-up window where you should check Basic Data 1 box and hit OK button.

Material Master Views Available in the System

On the next screen you will see that Material Group has been successfully changed through MASS transaction from 002 to 001.

Material Master Basic Data 1 View

Did you like this SAP MM tutorial? Have any questions or comments? We would love to hear your feedback in the comments section below. It’d be a big help for us, and hopefully it’s something we can address for you in improvement of our free SAP MM tutorials.

Navigation Links

Go to next lesson: SAP Purchase Requisition

Go to previous lesson: SAP MM Pricing Conditions

Go to overview of the course: SAP MM Training

View Comments (12)

  • Great, now understood where SAP tables are used. Please share more topics where there is requirement to understand SAP tables, for example MARA

  • I will like to add a new AUOM line to existing materials. This inputs for each material # will be length, width, height, unit, volume unit, net weight unit, quantity and lower unit. The values to be input for each line will be different.
    Can MASS transaction update the records? If yes, how should the file with input data be set up?
    If no, any other way?

  • HI ,

    could you please tell how to add custom fields to the same MASS tcode?
    I tried with SM30 tcode , it is not reflecting in MASS/MM46 tocode.
    Kindly help

    Thanks