Create Selection Tables

Outcome

A user-defined selection table connected to a sorting order will have been created.

With a selection table connected to your sorting order, you will limit the information displayed on the panel even more, and in that way exclude data that is irrelevant for your purposes.

Before you start

A view and a sorting order must have been created. Refer to documents in See Also section.

Follow these steps

You can create sorting order from any program or directly in 'Sorting order. Open' (CRS022).

In order to create a user-defined sorting order, you need to create (or select) sorting options in 'Sorting Options' (CRS021). In addition, you select the number of filters in (CRS022) and the views in 'View. Open' (CRS020).

In some programs, you have the possibility of creating selection tables in 'General Selection Table. Open' (CRS023) and 'Selection Table. Define Fields (CRS026).

Create Selection Tables

In some programs, you may create selection tables from the (CRS022/F) panel. A selection table makes it possible to choose from and to values in different fields and in that way select the information displayed on the panel.

The programs where you can create selection tables are the following:

• 'Item. Open Toolbox' (MMS200)
• 'Delivery. Open Toolbox' (MWS410)
• 'Delivery. Open Line Toolbox' (MWS411)
• 'Delivery. Connect Package' (MWS412)
• 'Goods Receiving DO/RO. Open Toolbox' (MWS442).

1. Start 'Sorting order. Open' (CRS022). The B panel will be displayed.

2. Fill in the Program field and press Enter.

3. Choose option 2=Change in front of your earlier created sorting order and press Enter.

   Note: You cannot open the F panel with option 1=Create/Select.

4. In the Table field on the (CRS022/F) panel, you press F4 twice to start 'General Selection Table. Open' (CRS023).

5. In the Table field on the (CRS023/B) panel, you give the table a name and choose 1=Create. Press Enter.

6. On the E panel, you fill in the Description and Name fields and then press Enter.

7. Pressing Enter opens 'Selection Table. Select Fields' (CRS026/B), which is used to create keys or search paths for user-defined tables. Fill in the Field column by pressing F4 twice to start 'Field Group. Display Permitted Fields' (CRS109/B).

8. Select the key fields you want for your user-defined table. Fill in the 'From Value' and 'To Value' fields.

9. Press F3=End to return to (CRS023/B). Select the table you have created and press Enter. Your selected table will be displayed on the (CRS022/F) panel.

10. There is nothing to enter on the T and E panels. Press Enter.

11. The sorting order you have created will be displayed on the (CRS022/B) panel.

    If you have opened (CRS022) from another program, such as (MWS410), you will automatically return to this program where you can select the sorting order you have created. Otherwise, you need to open the program where you want to use the new sorting order.

Parameters to set