SAP Business One/Creating queries

To create queries, go to Tools -> Queries -> Query Generator (see screenshot).

Hit Tab to display a list of database tables (see screenshot).

You can right-click and Copy Table (see screenshot) and paste into your favorite text editor (e.g. Notepad) or spreadsheet application (e.g. Excel) (see screenshot).

Select a table, and all the fields in that table will appear (see screenshot).