Databases can support a text search with fuzzy logic for tables and views. You can search in the table for matches to a search term where you define the level of accuracy of the match. So for instance you can find data records with the field content SPA if you search for the text SAP and do not use too high a level of accuracy. This enables you to find data records where the data was not created exactly (typos). This text search must be restricted to specific fields.
Interface: IF_SALV_IDA_TEXT_SEARCH
Examples of reports: SALV_IDA_FUZZY_SEARCH and SALV_IDA_FUZZY_SEARCH_REFRESH
Use the capability check (see Database Awareness) to check if the database incorporates the text search for the table.
An integrated text search is also provided as part of the standard services, and can be activated by application development. This function supports text columns only. Numeric columns and columns with conversion exits cannot be searched. Fuzzy searches are also possible on an in-memory database. On a standard database a simple pattern search is provided, and the hits are highlighted.
Interface: IF_SALV_GUI_STD_FUNCTIONS_IDA Method: SET_TEXT_SEARCH_ACTIVE
Examples of reports: SALV_IDA_TEXT_SEARCH
Using the functions of the field catalog the search can be restricted to selected columns.
Interface: IF_SALV_GUI_FIELD_CATALOG_IDA Method: ENABLE_TEXT_SEARCH
The two search variants cannot be combined together.