To analyse table for database archiving is prerequest of Database analysis and to do so we use Tcode TAANA. In TAANA after selecting a table we need to provide a Variant to be able to execute a table analysis (transaction TAANA) you always need an analysis variant. A variant belongs to exactly one table and describes which fields should be analyzed.
There are two kinds of analysis variants:
- Analysis variants that you create in transaction TAANA_AV. The definitions of these variants are saved on the database and are available for future table analyses.
- Ad hoc analysis variants, which you create when you schedule a table analysis (transaction TAANA). The definition of this type of variant is not saved on the database and is, therefore, only available for the table analysis you currently scheduled.
Activities related to Analysis Variants
- Creating an Analysis Variant
- Creating Virtual Fields
- Displaying Analysis Variants
- Deleting Analysis Variants
Creating an Analysis Variant
To perform a table analysis, you always need an analysis variant. This relates to only one table and describes which fields are to be analyzed. The system saves the analysis variant to the database; it can then be used for future table analyses.
With the transaction:
- TAANA_AV or alternatively
- Starting from the table analysis (transaction TAANA), choose Environment Analysis Variant.
- to go to the change mode for analysis variants for the table analysis.
- Choose Edit New Entries and enter the name of the table for which you want to create an analysis variant.
- Enter the name of the analysis variant that is in your namespace.
- Choose Fields. The system offers you all table fields for selection.
- Select the relevant fields or create virtual fields if necessary. For more information, see Virtual Fields.
- Save the analysis variant.
Creating Virtual Fields
Procedure
1. The following alternative access
options are available:
Enter the transaction TAANA_VF.
Enter transaction TAANA and
choose Environment Virtual Fields.
Enter transaction TAANA_AV and
choose Environment Virtual Fields.
2. Choose Edit New
Entries and enter the name of the table for which you want to create
virtual fields.
3. Enter a name for the new field.
Make sure it is within your namespace.
4. Enter the data for the value
determination and technical attributes of the field.
5. Save your entries.
Displaying an Analysis Variant
In transaction TAANA_AV, you can find on the left-hand side of the screen a list of all the analysis variants created, sorted by table names. To display an analysis variant, double-click on it. The analysis variant is then displayed on the right side of the screen.
Deleting an Analysis Variant
To delete an analysis variant, display the variant you want to delete on the right side of the screen. Choose .