Skip to Content
avatar image
Former Member

How do I search for multiple keywords/values?


I'm new to SAP and I hope I'm posting this in the right forum.  I'm trying to do a simple part search in SAP using two keywords, but I'm missing a step.  For example, let's say I want to search for "air pumps" and I want to only get results that contain both words.

In the search box, I enter *air* *pump* , but only a few of the pumps show up.  Looking at the description closely, I see if there are 2 spaces between air and pump, SAP's search doesn't find them.  If there is only one space, the part does show up in the search results.

Why does the number of spaces between words affect the search result?  If I'm using wild cards, shouldn't the system find all the results that contain the strings between the asterisks?  Is there a prefix/symbol I can use to tell SAP to ignore the number of spaces between words in a field?

Thank you,


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 21, 2015 at 04:21 PM

    Is this direct DB searches or are you using Trex searches?

    Add comment
    10|10000 characters needed characters exceeded

    • Is the transaction for Material Search Engine on your system 'MM03'?  MM03 is the method for master data teams to review information on materials.

      If I'm in the same spot then you should see a square next to the input line for searching (F4 also does the same thing).  In the tab strip of the pop up window by default you are set to search the DB directly which limits what kind of searching can be done due to indexes (or lack there of).

      If you have Trex (separate system via SID) you can set Trex to index the materials and providing you with various ways to search including boolean (not 100% how successful this is due to my company not having a great data consistency process) or multiple terms without the need for the *.  If you have Trex setup and you run esh_cockpit or ses_admin (both different ways to index, I suggest esh as it will be real time indexing vs ses which you have to schedule deltas).

      Once indexes are created a new tab shows up in the original tab strip called 'Adv Search' and you can do more of a google search within the GUI.

      If you don't have Trex look for 7.1 and go with the newest patch level.