Converting to Transparent Matchcodes


The following requirements must be satisfied so that a physically stored ID (update types A, S or P) can be converted to transparent storage (update type I).

  • All base tables of the ID must be transparent tables.
  • No sub-fields may be defined.

When converting a program-driven ID, it might be necessary to adjust application programs (see Special Features of Program-Driven Matchcodes).


  1. First delete the matchcode data stored in the database.

    If you wish to convert all physically stored matchcode IDs of a matchcode object to transparent matchcode IDs, you should delete the matchcode pool from the database. To do so, go to the database utility from the matchcode object maintenance screen by selecting Utilities ® Database utility. Then choose Database table ® Delete. The matchcode pool is deleted from the database.

    If you wish to convert only one physically stored matchcode ID of a matchcode object to a transparent matchcode ID, you must delete any matchcode data existing for this ID from the database. To do this, call the matchcode utility with the function DEL. Select Utilities ® Matchcode data ® Delete in the screen Maintain Matchcode Object (Attributes). The Matchcode Utility screen appears. Choose Program ® Execute. A list of all matchcode IDs for the matchcode object is displayed. Select the ID you require from this list and choose Execute. The matchcode data is deleted.

  2. Go to the Maintain Matchcode ID (Attributes) screen.
  3. In the field Update type, change the entry to I (transparent storage).
  4. Activate the matchcode ID. The matchcode view is created automatically in the database. The pooled table is then deleted automatically.
  5. To support matchcode selection, it may be advisable to create an index. To find out when an index is required and how to create an index, refer to Creating Matchcode Indexes.

See also:

Effect of Conversion on Transparent Matchcodes