Selecting Secondary Tables of Matchcode IDs


  1. In the maintenance screen of the matchcode ID, position the cursor on one of the base tables of the ID and select Edit ® Choose sec. tables.

    A dialog box appears listing the tables of the matchcode object linked to the table by foreign keys.

  2. Select the secondary tables required in the dialog box. You can remove tables that were wrongly selected by selecting them again.

    Only transparent tables may be selected for transparent matchcodes (update type I).

    For performance reasons, some restrictions apply to table selection in matchcodes of update type S (synchronous updating).

    Only key extensions are permitted for synchronous matchcode IDs in dependent tables. The selected tables must, therefore, be related hierarchically.

    Table T2 is dependent on table T1, while a further table T3 is dependent on T2. The tables are said to have a hierarchical relationship if the key of T2 contains the key of T1 in its first position and the key of T3 contains the key of T2 in its first position. Only with this type of relationship can T2 and T3 be included as secondary tables for primary table T1 for a matchcode to be updated synchronously.

    If two tables T2 and T4 are dependent on a table T1, only one of the tables may be included in a synchronous matchcode ID in addition to table T1. An exception to this rule are text tables. If T2 or T4 is a text table of T1, then both can be included in the matchcode ID.

  3. Choose Continue.

    You return to the maintenance screen. The selected secondary tables are included in the ID.

  4. Save the selection of the secondary tables.

Next Action when Creating a Matchcode:

Select fields of a matchcode ID