Table Analysis 
Table Analysis
Use
The table analysis tool analyzes table contents. It counts table entries and assigns the number of found entries to specific field values (such as organizational units).
Example
The table BKPF contains document headers for Financial Accounting. Each document is assigned to a company code. The table analysis tool determines how many entries in this table belong to each company code.
Integration
It is often necessary to analyze table contents for data archiving purposes.
Features
The table analysis displays the number of table entries for various field value combinations in a specific table. You specify the fields in an analysis variant.
Activities
You use the transaction TAANA to access the table analysis function. To analyze a table, choose Execute. A dialog box appears in which you can enter the table name. Depending on the table you enter, the system offers a selection of available system variants. The analysis variant DEFAULT is offered for all tables. If the table you want to analyze is client-specific, the client is displayed in the analysis variant DEFAULT. If, however, the table does not contain a client, the analysis variant DEFAULT does not have this field. This means that only the total number of entries is determined in the table analysis.
To improve performance, we recommend that you conduct most of your table analysis in the background rather than online.
The table with the selected analysis variant is displayed in the left area of the screen. During the table analysis, you can obtain the most up-to-date data by choosing Refresh. Once the table analysis has been executed, choose your analysis by double clicking and you access the table analysis display.
Depending on the analysis variant selected, you are offered various field values with the number of associated table entries in the evaluation. The list is sorted in descending order according to the number of table entries.
You can display or process the analysis variants by choosing Environment ® Analysis variants. Choose a name (customer name range: Z_...) and save your analysis variant. When selecting you should give preference to the fields with a low selectivity, that is, we recommend that you select fields that contain as little varying data as possible. Fields with a high degree of selectivity mean that the analysis tool creates a large amount of irrelevant data.
To select and delete table analyses that have already been created, choose Table analysis ® Delete.