Performing Table Analysis

Procedure

Analyzing Individual Tables

Using transaction TAANA you can access the screen Table Analysis: Administration.
Choose Table Analysis Execute.A dialog box appears.
Enter the name of the table. Depending on this table, the system offers the analysis variants available for selection in the input help for the Analysis Variant field.
Select at least one analysis variant, or else create one.

Note

The system offers analysis variant DEFAULT for every table. This variant contains no fields. Therefore it determines the total number of entries in the client in which it is performed.

If an adequate analysis variant does not exist, the following options are available for creating analysis variants:
- To create an ad hoc analysis variant specifically for a current table analyses, use Ad Hoc Variant. This variant is not saved on the database, and is available only for the table analysis that you are currently scheduling. For more information, see Creating an Ad Hoc Analysis Variant.
- Use the transaction TAANA_AV to create an analysis variant. It is saved to the database and you can use it multiple times. For more information, see Creating Analysis Variant.
If you want to restrict the number of records to be analyzed, choose Data Selection. The Data Selection for Table <Name> window appears.

Enter the criteria with which you want to restrict the selection. By default, the system suggests the fields that are either part of the table's primary key or are defined for secondary indexes. If necessary, you can add additional fields to the selection by choosing New Field Selection. You can also restrict the number of entries to be analyzed using Maximum Number of Entries. Save your entries.

Note

While selecting the data, and later, when displaying the result, you can use the options in the Settings menu to switch between technical field names and field labels.
Select the desired type of process control and choose Continue.

Recommendation

To improve performance, we suggest analyzing large tables in the background, not online.
Specify a start time for background processing. Save your entries. When you perform the analysis online, it is started immediately.

The table and analysis variant you selected for analysis are displayed on the left side of the screen.

Note

While the table analysis is being performed, you can Refresh the current data.
Double-click the table analysis on the left side of the screen to display it.

The table analyses on the left side of the screen are sorted by table name, name, analysis variant, and time of analysis.

The result of the analysis is displaed on the right of the screen. If you restricted the number of records to be analyzed before the analysis, the Data Selection button is displayed. You can use this button to display the values of the selection restrictions that applied for the selected analysis.

Analyzing Multiple Table in One Step

If you want to analyze multiple tables in one step, proceed as follows:

Use transaction SA38 to start program TAAN_PROCESS_MULTIPLE. A selection screen appears.

Recommendation

To improve performance, we suggest analyzing large tables in the background, not online (transaction SA38, Program Execute in Background).
Enter the table you want to analyze.
Enter the relevant analysis variant and start the program.

Use transaction TAANA to view the results of the table analysis (see above).

Result

The various field values with the number of related table entries in the evaluation are displayed in accordance with the analysis variant you selected. The list is sorted in descending order by number of table entries.