Procedure documentationPerforming Table Analysis

Procedure

Analyzing Individual Tables

  1. Using transaction TAANA you can access the screen Table Analysis: Administration.

  2. Choose Start of the navigation path Table Analysis Next navigation step Execute End of the navigation path. A dialog box appears.

  3. Enter the table name. Depending on this table, the system offers the analysis variants available for selection in the input help for the Analysis Variant field.

  4. Select at least one analysis variant, or else create one.

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

    End of the note.

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

  5. Select the desired type of process control and choose Continue.

    Recommendation Recommendation

    To improve performance, we suggest analyzing large tables in the background, not online.

    End of the recommendation.

  6. 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 Note

    While the table analysis is being performed, you can Refresh the current data.

    End of the note.

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

Analyzing Multiple Table in One Step

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

  1. Use transaction SA38 to start program TAAN_PROCESS_MULTIPLE. This takes you to a selection screen.

    Recommendation Recommendation

    To improve performance, we suggest analyzing large tables in the background, not online (transaction SA38, Start of the navigation path Program Next navigation step Execute in Background End of the navigation path).

    End of the recommendation.

  2. Enter the table you want to analyze.

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