Wildcard search options in the database

Wildcard search options in the database
Wildcards in SAP provide users with a quick and accurate way to find data that meets specific criteria. They are particularly useful when you do not have complete knowledge of the data you need or when you wish to find a group of information that matches a particular pattern. How can wildcards be used to search for data in the system? We have prepared a short guide with clear instructions to answer this question.

Problem

How can I search for records in the database?

Step-by-step guide

To search for records in the database you can use the Wildcard Search Option.

You can use * to replace any string of characters and + to replace any single character.

Examples:

Example of usage Result example
*00 100, 1000, 100000, 200, 3000, 40000
AB+ ABC, ABD, AB1, ABJ

If you want entries to contain wildcards, insert the # symbol before the wildcards * and + to free them from their special function as wildcards.

Examples:

Example of usage Result example
A#+B A+B
A#*B A*B

Have a question? We know the answer!

Use Know-How materials and learn more about the benefits of AMS! Leave your contact details with application support specialists.

We trust that we have successfully introduced you to the technique of searching for data using wildcards. This method will certainly improve your daily work with the system and increase the efficiency of your operations. We are delighted to have been of assistance. Additionally, our consultants can help you in many other areas related to SAP operation. Simply contact us to take advantage of their support.

This site use cookies. By continuing to use this website, you agree to our Privacy Policy.

OK, I agree