Skip to Content

Man is creature of habit.

Although we have upgraded to EHP 6 quite some time ago I just discovered a new option in MM17 Mass changes transaction for material masters.

I saw the buttons earlier, wondered, but did not look into it. Today I tried, and it certainly saves me quite some time in future.

Nathan Genez wrote recently his blog Why it’s time to move on from LSMW and mentioned that some application specific tools like mass maintenance are more suitable than our all-purpose-weapon

And this new function in MM17 is certainly a big step forward and makes it easier to waive once more the LSMW recording and its many steps until you are done.

I really wish SAP would point us more direct to new features like in some other websites when you get there after a change, with a little animation “have you seen this new button? Want to learn more?” .  But not even the menu Help >  Application help got me to something related.

Now let me show the steps of the new feature.

Starting point was an email Friday afternoon 4:30 PM: Can you upload the attached file until Monday, we reorganized the warehouse and need this for our scheduled inventory.

As you see, my users are already drilled to send well prepared data, only this way they can get something on short notice

MM17new_1source.PNG

Start the engine: MM17. You can see the new buttons right on top. Hard to ignore, but …. Leave me a comment if you already tried it before you read this.

Select the table for the data change. In this example it is table MARD with the storage location data of a material.

MM17new_2MM17ini.PNG

click the Import data from File button to get the file browser to select your source file.

Important: you can directly choose an Excel file. I did it with a xlsx extension. Much more convenient than LSMW where you have to convert your Excel first into a text file.

After you selected your file and clicked open in the browser you come back to MM17 and see a pop-up screen to define the Upload Parameters.

Check and set the decimal format  and the other fields according to its appearance in your Excel. Was not really important in my case as I had neither value fields nor date and time fields to change, just a text field. So I could concentrate on the fact if my data is with a header line or without.

As you see in source my first line has the field names, hence I switched the radio button to “with header line”.

SAP omits then this line from the data to be changed.

Execute it after you are done with the settings

MM17new_4MM17uplset.PNG

Next surprise: One click on the assignment button and SAP was able to assign the columns from my Excel automatically to the fields of table MARD.

This is based on the field names used as header in the Excel file.

As you can see in the next picture, 3 fields have this spreadsheet icon with a green traffic light. Here was the auto mapping ok, the gray diamond means it could not automatically assign the source field.

MM17new_5MM17uplset.PNG

No problem with this new feature. Just click this button with the gray diamond and you get all fields of table MARD and you can manually assign the field of your choice. Highlight it and then click the green enter button.

MM17new_6MM17uplset.PNG

Now you can see that the gray column turned green. Fantastic – continue with execution.

MM17new_7MM17uplset.PNG

Now you see the old well known MM17 screen, everything is pre-selected and you could directly start. But first see this interesting information at the bottom of the screen: SAP identified that one record in my Excel file has no record in table MARD.  So you immediately know about records that will not be processed.

MM17new_8MM17mm17.PNG

That’s all. Just finish your work by clicking the SAVE button and SAP will update your records as usual. And since I only got success messages I can waive this screenshot. 

The saved time between doing it this way compared to the LSMW way was used to write this document.

Have fun.

To report this post you need to login first.

73 Comments

You must be Logged on to comment or reply to a post.

  1. Dibyendu Patra

    Unfortunately I can’t see these options as my system as my system is under EHP 6.

    But its a great feature. I adopt the LSMW function for this purpose. As we know LSMW will take more time than MM17.

    (0) 
    1. Jürgen L Post author

      I have not seen any note that would make this function available for lower releases. If I get knowledge about a new feature that is really helpful for me, then I start asking when the next upgrade a planned, write a blog in our Intranet about the new feature to get more people asking for it which may accelerate the decision for an upgrade. It happened this way with the ANST search tool

      (0) 
  2. Robyn Couch

    Looks like a great improvement, thanks Jurgen.

    I’m at an EHP6 client later this week and will need to create a large number of MARD records.  You mention a record that didn’t exist in MARD, does this mean this technique cannot be used to create new records?

    Also does this feature need to be activated?

    (0) 
    1. Jürgen L Post author

      I didn’t test it yet beyond this, it was Friday afternoon.

      Going through my screenshots again I would say it is only available for changes.

      However I am glad to have a feature for variable mass changes now, this way I can get rid of some of my LSMW objects, even some of my work as this activity can be shifted to the key users now .

      (0) 
    1. Nathan Genez

      I’m sure he will but it’s easy to track this information down yourself.  The release notes for each EhP are well maintained so it’s probably worth 10minutes of your time to read through them.

      (0) 
    1. Jürgen L Post author

      It looks like it has more to do with the Basis release than the Application release.

      Sorry for confusion, those release upgrades  go hand in hand in our system.

      the mass maintenance transactions are belonging to component CA-GTF-MS Cross-application Mass Change

      and this is linked to SAP_ABA

      Select from menu System > Status

      then click the component info button in the pop-up

      and check the value next to SAP_ABA. It is 731 in our system

      (0) 
  3. Jaheer Hussain

    Jurgen,

    Even though we have implemented EHP 6 in our system ,I am not able to find in MM17,Import data from file and Import data from clipboard.Do I need to activate any business  function? Can you please guide me?

    (0) 
  4. Amit Anasane

    Many thanks Jurgen for sharing this info today i have changed MRP data for many part nos with ease using this document and i have saved lot of time, i really appreciate your work. 🙂

    (0) 
    1. Jürgen L Post author

      No you cannot, MM17 is for mass material master maintenance, not for inventory load. You have to use LSMW to migrate your data. Just click my name, go to the content tab and filter on blogs and can read some about using LSMW

      (0) 
  5. Jan Tichy

    Nice article. Thank you for sharing.

    I work with this feature since last year. Unfortunately, the SAP has this handy enhancement not thought through.

    For large changes with 40000 materials i get the message DB895. (To many selection conditions with length > 30 in WHERE_CLAUSES)

    Here is the where clause in Select built dynamically. That can not work is clear.

    The only alternative to me here is the LSMW.

    Best Regards

    Jan

    (0) 
      1. Jan Tichy

        Hi Jürgen,

        Unfortunately, this only works on 400 pieces, from 500 I get this message.

        So i have to split 100 times!! 😡

        My employer has a very large material master.

        That can not be part of the solution and the SAP notes do not help.

        I’m trying to make a report to SAP.

        Best Regards

        Jan

        (0) 
  6. Sowmya Varanasy

    Thanks Jurgen,

    It was really very helpful.

    I have a list of 5000 materials ,the user wants to update two fields for these.

    Currently we are doing it using a BDC,can I use this instead of BDC??

    Regards,

    Sowmya

    (0) 
    1. Jürgen L Post author

      Sowmya Varanasy, yes you should try, it works for me.

      Jan Tichy, what fields do you have actually in your Excel sheet and what table did you select? At which moment do you get this error? After you have the Excel data already visible in SAP and assigned the fields and execute, or already in the step of uploading the Excel file ?

      (0) 
    1. Jürgen L Post author

      I have no idea why your program tells you that BMMH1 must be a flat structure, it is certainly a tables declaration in my system too.

      I can only imagine that is a  bug either caused as side effect from SAP or by own developments.

      The dump shows just where the program stopped, but the error is certainly in another place.

      Try to find out if there were some modifications/exits/extensions made to the material master load program, last but not least you may have to approach SAP

      (0) 
      1. Mahesh Naik

        Please can you check this ETIAR ( Label Type) for MM17, from this field also not available in Manual choose , only getting 8 fields, in that label type field not available,

        (0) 
          1. Mahesh Naik

            When i selected MARA and click on Import file, then system going for Dump.  Did u sau shall i prepared excel file with only MATNR and ETIAR, if that is the case then how system check Plant and storage location.

            (0) 
              1. Jürgen L Post author

                Go into your material master, select the view where you enter the label information, do not enter any plant and storage location, if you see the field then you know that it is not plant and storage location specific, it is common to all plants which share this material.

                Without knowing what exactly you did I cannot seriously evaluate the dump, even the screenshot is not sufficient, a dump is several pages longer and has there important information too

                (0) 
  7. Basis GLS Basis

    Dear Sir,

    We can’t find this button as attachment. Then we try to apply SAP note 1769118 but the button still disappear. Could you please help me? 🙂 Capture.JPGCapture2.JPGBest regards,

    (0) 
  8. Arpit Shah

    Hi,

    Trying to create accounting view with above method, getting error

    No data meet the selection criteria

    Message no. M&107

    How to solve this error?

    (0) 
    1. Jürgen L Post author

      At least you would need to explain why you think the error message is not appropriate.

      Also my document was about mass changes, not about mass creation

      (0) 
    1. Jürgen L Post author

      trying it is the simplest way to find out.

      the data provided from the file or via the clipboard is just the proposal for the new value, you can still adjust it if you changed your mind within the few seconds after you started the work

      (0) 

Leave a Reply