Converting Pooled Tables to Transparent Tables 

You can easily convert pooled tables to transparent table with the transparent flag of the technical settings. You can use this option to access a pooled table from outside the R/3 System.

Procedure

  1. From the field maintenance screen for the pooled table, go to the maintenance screen for the technical settings of the pooled table with Goto ® Technical settings.
  2. Mark the flag Convert to transparent table. This will only correct/repair the technical settings and not the table definition.
  3. Activate the technical settings.

Result

The pooled table is now converted to a transparent table. This is done by a conversion (see Adjusting Database Structures). In a dialog box you can decide whether to convert the table directly or in the background. For performance reasons, you should always convert tables with a large number of data records in the background.

If SAP again delivers a table whose transparent flag is set as a pooled table in the next maintenance upgrade/release, it will remain transparent in the user system. If you change the table type directly, you have to manually adjust the table if it is delivered again as a pooled table in an upgrade.

If there is a revised version of the pooled table, you cannot convert it to a transparent table using the transparent flag, and the technical settings of the table cannot be activated.

There are some restrictions for transparent tables (number of key fields, key length, table length) that are not valid for pooled tables. Only those pooled tables which satisfy all these restrictions can be converted with the transparent flag. If the conditions are violated, the technical settings will not be active. In this case you can find the cause of the error in the activation log.

If you want to convert a table whose transparent flag is set back to a pooled table, you must first cancel the transparent flag. Then activate the technical settings. Only then can you change the table type to pool (see Changing Table Types).

See also:

Pooled and Cluster Tables