Page Comparison

This is a collection of Table Variants, after . After you click on the 'Variants' button, a screen for Table Variants selection is displayed.

...

1. RFC Destination – RFC Destination of the system where the Database Table is to be read. When the RFC destination is specified, the F4 help display values from the specified RFC destination in the Table Name field.
2. Variant Description – description of the new Table Variant.
3. Table Name - name of a tested table (supported table categories are transparent table, view, cluster table and pooled table)
4. Characteristics Fields – selection of the table fields to be used as characteristics. These fields will be used as the Key key fields in the comparison of table data.
   1. It is possible to specify characteristics selection as pattern. Pattern is always expanded to several single selections upon save.
5. Key Figure Fields – selection of table fields to be used as key figures. These fields will be used as the Data fields in comparison of table data. Only the number like fields can be selected here. 
   1. Number like fields are those with data type equal to:
      1. DEC
      2. CURR
      3. QUAN
      4. FTLP
      5. INT1
      6. INT2
      7. INT4
   2. It is possible to specify the key figure fields selection as pattern. Pattern is always expanded to several single selections upon save. If pattern is applied for both characteristic and key figure selections, all overlapping table fields are assigned to characteristics selection. 
6. Select Number of Rows – is an option for the column 'ROWCOUNT' to be added into the output of Table.
7. Set Filters (button) – used for defining the filter values to be used during DB table read. Maximum of 100 distinct filtering fields can used.
   
   It is possible to swap between the descriptions of table filtering fields and their technical name by clicking on  'Display Description/Technical Name' button
8. After Image Variant – ID of the Table variant that is used for the after image creation. This allows you to compare the output of different Tables or Tables from different systems.
9. Set Tags - Set Tags – set tags to enable variant execution enhancements. See (DV-2002) Tags for more information about available tags. 
   
10. Field Mapping ID - Set ID – set mapping to variant. Mapping renames columns and converts data elements of created images. To create new mapping, fill the field with mapping name and double click it. If mapping with such name does not exist yet, you will be navigated into the field mapping definition screen. See section (DV-2002) Field Mapping for more information how to define mapping. 

...

To save the Table variant click the 'Continue' (Enter) button. Before saving, before saving various checks are done to ensure the correctness of variant definition.
*Important Notes:

• When no table fields are selected as characteristics and no table fields are selected as key figures, then the ROWCOUNT field is automatically added as only output field of table read.
• In the current version, Validate can hold values with the maximum length of 74 characters. Values that are longer are truncated.

...

...

Storage Management Table variant is a special type of Table Variant. It enables to compare of table data from various storages through the DVD Storage Management. This functionality is hidden in a standard release. If you want to turn it on, please contact us for support as this belongs to the expert settings.

Add Existing Table Variant Image Modified

The 'Add Existing Table Variant' button displays list of all existing Table variants in a the system and you can select one or more variants that are to be added into the current test case.

...

The 'Add Table Variants of Run' button displays list of all existing Table runs in the system and you can select a run that where variants to will be added into the current test case.

...

The 'Copy Table Variants of Run' button displays a list of all existing Table runs in the system and you can select a run that the where variants will be added into the current test case as copies.

...

The 'Add Variants of Test Case' button displays a list of all existing Table Test Case in the system and you can select a Test Case that the where variants are to will be added into the current test case.

...

The 'Copy Variants of Test Case' button displays list of all existing Table Test Case in the system and you can select Test Case that where variants to will be added into the current test case as copies.

Generate RFC Table Variants Image Modified

The screen for generation Table Variants is displayed after clicking on 'Generate RFC Table Variants' button (CTRL+F5). 

_{Figure 172 Generate RFC Table Variants screen} 

In this screen, you can define:

1. Characteristics Fields – selection of the table fields to be used as characteristics. These fields will be used as the Key key fields in the comparison of table data.
2. Key Figure Fields – selection of table fields to be used as key figures. These fields will be used as the Data fields in comparison of table data. Only the number like fields can be selected here.
3. Filter Fields – The selection of Characteristics Fields on which you want to define the filters (from Validate version 1.4.2 navigational attributes are also supported).
4. Set Filters (button) – for defining the filter values to be used during DB table read. Maximum of 100 distinct filtering fields can used. It is possible to swap between the descriptions of table filtering fields and their data element by clicking on  'Display Description/Technical Name' button. Fields for filter values are returned based on selected characteristic field in 'Filter Fields' input field and Tables selection (including patterns). 
   
   
5. Description suffix – Is what will be added to the description of generated variants. Description of the variants are generated in the form 'Gen. Variant for $TABLE_NAME'. If the description suffix is a specified string, then '- $SUFFIX' is added to the description.
6. Select Number of Rows – is an option for the column 'ROWCOUNT' to be added into the output of Table.
7. Tables Selection – In this table, you can specify the pairs of tables for the Before and After Image together with their RFC Destinations. For each pair a new Table Variant is generated that will contain all the settings specified in the header of screen. It is possible to use patterns with asterisk sign (*) in table name and define more table variants at once.

...

_{Create After Image Variants as copies}

Compare Settings

You can compare the chosen settings for variants and its defined after image variant (if there is one). Select the requested variants and then choosing 'Compare Settings' option from the context menu.

...

A dialog with possible settings is displayed select what is to be compared between variants. After you confirm the selection check is done and table with compare status messages is displayed.

Copy Settings

You can copy settings of variant to its defined after image variant. After selection of variants is done you can choose 'Copy Settings' in the context menu. Dialog is then displayed where you can define which settings should be copied from source variant to the after image variant (if there is any). 

...

After you confirm the selection, specified settings are copied and message table is displayed with the information about updated variants.

Copy Variants

You can create copies of Table variants by selecting multiple variants in the selection table and then clicking on  'Copy Table Variants' toolbar button. For each selected variant a new variant is created with exactly the same settings as the source variant. If a copied source variant has a different after image variant specified, also a copy of that will be created. The copied after image variant is then assigned to the copied source variant as its after image variant. 

...