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.
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
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 *SORTED HASHED 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)
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)
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