Text Search Across the Whole Table

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). Fuzzy text search can be restricted to specific fields.

Interface: IF_SALV_IDA_TEXT_SEARCH

Examples of reports: SALV_IDA_FUZZY_SEARCH and SALV_IDA_FUZZY_SEARCH_REFRESH

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 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