Searching for table

Use this procedure to search for tables and/or table indices 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.
  4. Select an entity: Table.
  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.
  6. Click Search.

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

    Column heading Description
    Table Name Name of the table.
    Description Description of the table.
    Component Component of the table.
    Category 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.