To create SQL check steps that cause as low a system load as possible, you can display additional information about the respective table field when you select it.
Recommendation
To keep the system load low, preferably use fields that are marked as key or index fields.
You have called the Solution Documentation Assistant and chosen Create Check Step
.
You have selected the check step type "SQL" and specified one of the subtypes of an SQL check step ("existence of table field", "existence of table field entry", "number of table entries", or "descriptive"). You have selected a table.
If the information is from an RFC connection, the check box in the From RFC
column is selected. If the field is already used in another SQL check step, the information is stored in the Solution Documentation Assistant, and the check box in the From Pool
column is selected.
Choose the table field that is supposed to be checked.
To show in which context a table field is used, select an indexed table field and choose Index
.
The Table Index
dialog box appears listing all indexes defined for the respective table.
Note
You can display detailed information about the displayed characteristics of the index in the ABAP Dictionary (transaction SE 11) in the system that can be reached using the specified RFC connection.
To show which table fields belong to an existing index, select an index and choose Index Fields
.