Mass Creation of Material Master - Master Data

In order to create multiple materials at once, you should have access to a function like

1. eCatt tool
2. LSMW(Legacy System Migration Workbench)
3. BDC (Batch Data Communication) recordings
4. BAPI (Business Application Programing Interface)

You can also use mass maintenance transaction MM17 to create views in some cases.

But you must keep in mind that not all of the organizational levels should contain the same data (MM17 requires that all data for the materials and organizational levels you select should be the same).

Mass creation is never considered to be end users responsibility.But as a module specialist you may need to work on MM17 . In case of LSMW, BDC or BAPI, it is considered to be developers or consultants work. So you do not have to understand in detail, you just have to know the concept, and that there is this kind of possibility for mass data maintenance.

You can use MM17 for mass changing of material master data (if something can’t be accomplished by this transaction it can be done using LSMW, BDC or BAPI).

Step 1)

1. Enter transaction MM17
2. Select the data type you need to change, for example, we need to change a field in general data.
3. Execute.

Step 2)

1. Enter the material range or list for which we want to change the data
2. Execute

Step 3)

1. When clicking on the button shown below – you will get the Select fields screen.
2. Check the appropriate field (we are changing base unit of measure for our two materials).
3. Click the arrow pointing to the left to add the selected field to the list of fields to be changed.
4. Click the OK button.

Step 4)

Now we are presented with the next screen where we can input our value to be transferred. Let’s say we have maintained PAL – pallet as the base unit of measure for out TV sets 24 and 32″ and we need to change that to PCS – pieces.

1. Enter the value you want to copy in the box.
2. Click on the column heading.
3. Select the button, to overwrite the old values by “PCS”.
4. Execute.

Now your settings are saved, and your material master data is changed.