Show TOC

Object documentationQuery Wizard: Select Tables for the Report Locate this document in the navigation structure

 

Use this step to select the database tables from which you want to retrieve data for the report.

Query Wizard: Select Tables for the Report
Table

Displays the table code that is defined using four characters, for example, OITM.

Press TAB to open the Choose from List window.

From the window, select the table(s) from which you want to retrieve data. Each table you select is placed in a separate row in the table.

Description

Displays the full name of the tables you select, such as Items.

Lower Table

Displays the codes and descriptions of tables related to the table in the highlighted row of the upper table. This information can help you determine whether you need additional tables that are logically linked to the tables you have already selected for your query.

To add a table from the lower table to the upper table, double-click the relevant row in the lower table.

More Information

Query Wizard