Using the transparent flag, you can easily convert pooled tables to transparent tables. You can use this option to access a pooled table from outside the R/3 System.
If you want to convert a pooled table to a transparent table, you must select Convert to transparent table in the technical settings of the pooled table. This will only correct/repair the technical settings and not the table definition. Then activate the technical settings.
The pooled table is converted into a transparent table. 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 in the next maintenance upgrade/release SAP again delivers a table which you set to transparent as a pooled table, 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) which 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 not satisfied, 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.