(DV-2011) Table Variant Generator

The Table Variant Generator functionality enables to generate Table Variants from standard SAP tables. You can access it from the Table Variants screen. On the first access to the screen the Table Variant Generator scans the systems tables and determines classification SAP Application Components (SAP modules) with the table size (only informative value from DB statistics), which takes some time, therefore there is a progress bar on the bottom left corner of the screen to show the state of the scanning procedure.

_{Figure 1 Accessing the Table Variant Generator}

Estimate number of records in each table is determined from DB table statistics. If DB table statistics could not be used a following message is displayed in status bar

Each next access is fast till a refresh of the content via refresh button.

The Table Variant Generator shows all the found tables in a tree structure, classified into SAP Application Components. Selecting a node in the tree also selects all the nodes in the nodes sub-tree.

Figure 2 Table Variant Generator

Refresh - Re-scans the target systems tables (needed if RFC destination is changed)

Search/Find - Functionality for searching in the tree, supports search patterns, works also by pressing enter in the input search field

Filters - Allows the filtering of the output tree by the table name, component name, and description

Expand/Collapse all - Expands or collapses the tree

Select/Deselect all - Selects or deselects all the tree nodes

Export table list - Allows exporting the list of all the tables (with selection) from the tree into a CSV file

Import table list - Imports tables selection from a CSV file

Proposal list for key fields - Allows the definition of whitelisted (or blacklisted if the exclude flag is checked) fields/data elements of tables which will be used as keys in variants. The default whitelist/blacklist is in the pre-delivered content and always can be restored by clicking on the Reset button. The whitelist/blacklist can be exported/imported to the CSV file. Proposal of the key field in the list can be defined generally (defined only by data element) or specifically for field name or table name. If the field of table fulfills opposed rules (from whitelist and blacklist) then it will not be chosen as a key field in generated table variant.

_{Figure 3 Proposal list for key fields screen}

Execute in background - Executes the Table Variant Generation in a background job. Only one BG job will be triggered and SAP GUI notification message will be sent to the user after the job will finish the generation of variants.

_{Figure 4 Notification when BG job is finished}

Execute in foreground - Executes the Table Variant Generation in a dialog job. Use it for generating table variant of single table or variants without application of portioning.

Generation of table variants is fast only if no portioning is required. If portioning is required than always execute generator in background job if the proximal count of records from all involved table is greater than 3 million for 1MB portions.

Advanced settings:

Variant description pattern - The naming pattern used for the description of generated table variants. Following placeholders are allowed in the pattern:

<INDEX> - add a number of generated variant to the description,

<TABNAME> - add the technical name of the table to the description,

<PORTION> - add portion number of the table to the description

RFC Destination - RFC destination that will be used for Table Variant Generation. After selecting and RFC destination the user should refresh the table tree, so the target systems tables are displayed.

Mapping ID - Set table field mapping name to each variant. 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 Field Mapping for more information on how to define the mapping.

Select number of rows - An option for the column ‘ROWCOUNT' to be added into the output of Table. If there is no match for the key fields of the table from the ‘Proposal list for key fields’ and simultaneously there aren't any suitable non-key fields in the table for value fields, the generated variant will have this option enabled (so the Table Variant won't have an empty output).

Maximum portion size - Defines the maximum portion size in MB for the output image of generated Table Variants. If the selected data from the table are bigger than the maximum size, there will be generated an adequate number of Table Variants for each portion. Each portion will have generated where condition with the range of values for determining maximum portion size in the output image.

SNP