Searching for tables

Use this procedure to search for tables and table indexes of M3 Business Engine (BE) system.

  1. On the Search tab, click Search By System Configuration.
  2. In the Keywords field, specify a keyword to search.
  3. Select the MDP BE System.
    See System Configuration fields.
  4. Select an entity: Table.
    See M3 BE entities.
  5. Click the link to More Options for additional search filter.
    1. Select a Component.
    2. Select a Category.
    3. Set the search limit. The default value is 500.

    See System Configuration Advanced Search.

  6. Click Search.

    On the Search Results tab, the Entity: Total match, and a data list is displayed:

    Table Name
    The name of the table.
    Description
    The description of the table.
    Component
    The component of the table.
    Category
    The category of the table.
  7. Use these options to manage the results.

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

    • To filter the results, click the Filter icon in the last column and type a dynamic free text filter for each column.

  8. To view table relations, click a Table Name.
    See Viewing Table and Column Relation Information.