Manage Views

This document describes the creation of user-defined views in different programs. The views control which information or field to display on a panel.

Outcome

A user-defined view is created. The view helps display only the piece of information that a user requires.

The information is stored in these files:
  • View (CSYSTP)
  • Key (CSYSTR)

Before you start

You must generate these items:
  • A field group in 'Field Group. Open' (CRS108)
  • Fields in 'Field Group. Display Permitted Fields' (CRS109)

Follow these steps

  1. To create a view, open the 'View. Open' (CRS020/B) panel.
  2. Specify the 'Program' field on (CRS020/B). The field indicates the program where the view is used.
  3. Create a name for your view in the 'View' field. Depending on the value of the responsible active, (CRS020/E) or 'View. Select Columns' (CRS016/B) is displayed.
  4. Open the (CRS020/E) panel and fill out the 'Field' column by pressing F4 and then selecting among the database fields on 'Field Group. Display Permitted Fields' (CRS109/B). The database field selection is dependent on the given program.
  5. Specify the 'Field sequence number' on (CRS020/E). You may change the order in which the database fields must be displayed. To change the order, switch the numbers.
  6. In the 'Field length' column, optionally specify a value to shorten unnecessarily long fields in M3. If no value is specified, the field length follows the M3 standard.
  7. Open the F panel and specify values in the 'Description' and 'Name' fields. When you press Enter, your new view is displayed on (CRS020/B).

Additional fields on the (CRS020/E) panel

Depending on which program the view is connected to, the fields displayed on (CRS020/E) may vary. In some programs, you can find these fields on the E panel:
  • The 'Sorting sequence' field indicates in which order the record must be sorted in a certain view. The sorting order given here overrules the sorting order defined as the sorting option in use.
  • In the 'Maximum value' field, specify the cumulated maximum value for the record. All values beyond this limit are highlighted when displayed.
  • If you are creating a view for the program 'Delivery. Open Toolbox' (MWS410), the 'Override max value' field is displayed.
    This is where you indicate whether the maximum value specified in the view is replaced by the corresponding value for the current shipment, when present. Select among these values:
    • 0 = No, do not replace.
    • 1 = Yes, replace with the gross capacity of the shipment, if present. This alternative is relevant when comparing the maximum capacity of a shipment to the total of deliveries assigned to it.
    • 2 = Yes, replace with the remaining capacity of the shipment, if present. This alternative is relevant when comparing a collection of planned deliveries to what is left of capacity in a shipment.
      Note: This option only applies to columns that contain information relating to the shipment capacity units: weight, volume, and the freely defined unit.

Translate description on the (CRS016/B) panel

For views that are maintained in (CRS016), there is a check box 'Translate description' (ATRA), and a Language button. If the check box is selected, a view description is generated automatically per language in 'Language Handling. Open' (CRS830) the first time this is required. An automatically generated description is based on the sorting order. For example, a view connected to sorting order 1 is given the description 'Standard view for sorting order 1'

If the 'Translate description' check box is not selected, a description must be maintained manually in (CRS016) or per language in (CRS830). The languages to be used must be specified in 'Language. Open' (CRS010).

The automatic generation is triggered from configurable list programs and configurable browse at startup. Views connected to programs in 'List and Printer programs. Configure' (CMS005), 'Information Browser Category. Open' (CMS010), 'Ad Hoc Report Group. Open' (AHS100) and 'Table Browser. Open' (MNS175) are supported. It is also triggered from (CRS020) and (CRS016).

Parameters to set

Program ID / Panel Field The field indicates …
(CRS020/B) Program ...the program in which the view is used. Refer to the field help for valid programs.
(CRS020/B) View ...the view that is in use. Views are user-defined and determines the sorting order and the column layout.
(CRS020/E) Field ...the information from the file to be displayed. Those fields are also used to create the contents of user-defined files.
(CRS020/E) Field length

...the field length, which also determines the column width. If the field is blank, the field length follows the M3 standard.

(CRS020/E) Field sequence numbers ...the order in which each key field is displayed.
(CRS020/E) Sorting sequence ...how the records in the view must be sorted. The information given in this field overrules the sorting order of the sorting option in use.
(CRS020/E) Maximum value ...the cumulated maximum value for the records that must be displayed without being highlighted.
(CRS020/E) Override max value ...the value that must be valid instead of the maximum value. This parameter is only relevant when browsing deliveries that are not connected to a shipment.
(CRS020/E) Number of decimal places ...the number of decimal places displayed in the numerical fields containing decimals. You may specify 0 to 6 decimals. If nothing is specified, the number of decimal places defined in the database is displayed.
Note: Fields for price, amount, and quantity are often regulated by settings in the system. These settings override the number specified here.
(CRS020/E) Edit code ...an edit code. You can select a predefined edit code to manage how numeric fields should be displayed, for example whether decimal point or comma must be used.