Arrangement of the rows in the result list
A database table is in some ways like a book. To accelerate the search in a book is available in many books, an index (an index). The keywords in this index are lexicographically arranged. Sometimes a book index consists of two stages, over a book ABAP / 4 could for example the items' selection - execute "and" selection -- Criteria in turn, "appear in the book index. Two-level entries are sorted first by the first term (in the example "selection"); if there are several entries with the same first term, they are after the second word order ("Run" or "criteria").
Each database table has a relatively simple structured (primary) Index for input and output of data. For the search in "large" amounts of data able to take a table or several other (relatively complex be created structured) index. This is called an index search, the program itself runs differently than the full-text search using the buttons and the lines are a hit at the output as an index (multilevel ordered lexicographically according to the ASCII character code). These are the data of the search fields with the book index terms comparable.
Wildcard characters in search fields
In a field can be only one value can be entered. This also applies to fields of an elementary search help. When put into a search box, only one exact value (for example) a full or no material short Value could pretend, if one had a problem: The exact value is often not (or fragmented) are known, and if one does not provide value, the hit list often too great. For this reason, there are in SAP R / 3 Enterprise (depending on the particular elementary search help) very sophisticated ways for specifying selection criteria. These possibilities are closely associated with the properties of the index search.
In defining the allowed selection criteria for the search fields wildcard characters (wildcards) "+" and / or "* be used."
The sign "+" is in a string as a placeholder for an arbitrary single character used. If you for example into a search box. The term "User Name", the string "m + + enter it," and start the search, search help provide the user with all five letters starting with "M" and end with "ER." The result of this field could thus the name "MEIER", "MAYER" and "MOSER".
"*" Can be used as a placeholder for an arbitrary string. If you for example into the search box material short, "the string "Basic engine type.
The strings 'm + + er "and" base-engine *' of these examples, and (in previous example), the default value "DE", after starting the search SAP R / 3 as a pattern for the fields' material short "or" Language key used.
|
