Link Search Menu Expand Document

Field catalog and other table settings

Since tables can include all other data types (strings, range, and other tables) and a field catalog, the way they are set up is not always as obvious as you’d like.


Field catalog

For a field, you most often need to fix Label, the order (Drag & Drop of the row) and also the search help


For a search help facility, it is sufficient to specify a reference type in TABLE-FIELD. The SH of this field will be used during entering data

If there are values in the domain, Dropdown will be displayed


Relationships between tables

In most cases, specifying a field from the data dictionary (SE11) in the form TABLE-FIELD will be sufficient.
If you need a connection with another table in the same option, you can specify it here.


As a result, the main table will have 2 SH-s or dropdowns


In this case, several conditions must be met

  • Tables must be at 1st level (nested tables are not supported)
  • The tables we are referring must be declared as *SORTEDHASHED WITH UNIQUE KEY* with 1 field (links on several fields are not available)

To show dropdown instead of SH, 2 conditions must also be met

  • The number of records must be less than 16
  • This table can have no more than 2 simple fields (those with the exception of string, range, table)


Primary key changes

Quite often it is necessary to change the primary key of the table.
This can be done by running the creation of an option with the parameter IV_REPAIR = ‘X’

or by correcting the description in the code and in the option (simultaneously)


Adding a new field

Also, the IV_REPAIR = ‘X’ parameter can be used for changing the field catalog
or to add/remove a field, you can use the buttons


although changing the description with the IV_REPAIR = ‘X’ parameter from the code itself will be faster and more reliable