Selecting Fields of a Matchcode ID

Proceed as follows to select the fields of a matchcode ID:

  1. In the maintenance screen for the attributes of the matchcode ID, choose Goto ® Fields. The maintenance screen for the matchcode ID appears.
  2. Position the cursor on a table name and choose Edit ® Choose fields.
  3. The fields of the selected table are displayed in a dialog box.

  4. You can include a field in the matchcode ID by clicking on the corresponding entry and choosing Choose. The entry is highlighted. You can remove a wrongly selected field by positioning the cursor on the field in question and choosing Delete.
  5. Once you have selected all the fields you wish to include in the matchcode ID, choose Copy. The selected fields are copied to the matchcode ID.

    The order of the selection exactly corresponds to the order in which the fields are listed in the matchcode ID. The order of the fields in the matchcode ID is of paramount importance for later accessing behavior, for example, in connection with the possible entries help F4. The fields which are most frequently accessed should be placed at the start.

  6. Save your field selections if you do not wish to make any of the optional settings described below.

Restrictions:

For reasons of consistency, matchcode IDs may only contain fields of tables which are linked with a foreign key. For example it is not possible to include fields from two tables which are only linked with a third table which is not contained in the matchcode ID. In such a case this linking table must be included in the matchcode ID with a key field.

The data of a matchcode ID of update types A, S and P are stored in pooled tables. The system tries to store all the fields of the matchcode ID in the key of the corresponding pooled table. The key of a pooled table, however, may not be of arbitrary length. It is therefore possible that some of the fields of the matchcode ID cannot be stored in the key of the pooled table. In order to ensure that the records of a matchcode ID are unique, however, at least all the key fields of the matchcode ID (that is all the fields necessary to uniquely identify a matchcode record) must lie within the first 110 bytes.

In matchcode IDs of update type S, the fields of the ID must uniquely identify each record, but not all of the key fields of the tables in the ID have to be included. A further restriction is that the ID must contain at least one key field of a table included in the ID, even if the remaining fields already uniquely identify each record.

Optional Settings

The advantage of this method is that the user no longer has to enter a field value obtained from memory on the screen by hand.

Simply overwrite the name of the data element in the field Data elem. The new data element must refer to a domain with the same data type and the same length as the original data element.

Next Action when Creating Matchcodes (Optional):

Defining Selection Conditions for Matchcode IDs