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:
- Vendor Master Records
- Material Master Records
- Customer Master Records (In cases when we are using functionality of SD, i.e. STO with shipment, shipment process, etc.)
- Purchase Info Records
- Purchase Orders
- Purchase Requisitions
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.
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.
If you click this box, a list of object types will be displayed. In our example, we will use BUS1001 object type.
Next, you should click on Execute button as highlighted on the screenshot below.
The SAP system will show the next screen where you should check the box besides General Material Data and click on Fields tab.
The system will display all the fields available for MARA table (that is used for general material data).
Click on checkbox next to Material Group field to highlight it and then click on Execute button.
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.
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 will see that Material Group will be changed to 001 for all materials as required. Finally click on Save button to save the changes.
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.
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.
The SAP system will display a pop-up window where you should check Basic Data 1 box and hit OK button.
On the next screen you will see that Material Group has been successfully changed through MASS transaction from 002 to 001.
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.
Go to next lesson: SAP Purchase Requisition
Go to previous lesson: SAP MM Pricing Conditions
Go to overview of the course: SAP MM Training
10 thoughts on “SAP Mass Maintenance (MASS Transaction)”
Very useful. Thanks a lot
Great, now understood where SAP tables are used. Please share more topics where there is requirement to understand SAP tables, for example MARA
Great. Thank you Mr.Cleo.
I completed all lesson that sent by you.
thanks a lot.
Nice explanation at all..
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?
how to do Mass purchase price changes
new purchasing prices need to be upload
here the whole process done ,if the user wants to reset the process then what we have todo.
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.
How to use the “Import data from file” option?