Viewing tables with the same unique keys

Use this procedure to view all the tables containing unique keys similar to your selected table. Before you start, you must complete a table search task. See Searching for table.

The CONO and DIVI column keys are used by most of the BE tables. These keys are not included in the unique key comparison.

  1. In the Search Results tab, select a Table name.

    A new search result opens with the header Table Relation Type: Total match.

  2. On the bar at the top, click Same unique keys to display all tables containing unique keys similar to your selected table.

    A new search result opens with this information:

    Column heading Description
    Table Name The table name with unique keys similar to your selected table.
    Description Description of the table with unique keys similar to your selected table.
    Key Info Option to view the same unique keys with this table name.
  3. Use these options to sort and filter your results:

    • To sort the results alphabetically or numerically, click the Sort icon located in one or more column headings.

    • To filter the results, type a dynamic free text filter for each column and select a Filter action.

  4. To view more table relations, see Viewing table and column relation information.
  5. To view same unique keys, see Viewing same unique keys.