Converting Pooled Tables into Transparent Tables

Use

You can easily convert pooled tables to transparent table using the transparent flag in the technical settings. You can use this option to access a pooled table from outside the SAP system.

Procedure

Open the Repository Browser (transaction code SE80) and navigate to the pooled table that you want to convert.
Double-click on the pooled table.
The maintenance screen of the table appears.
On the maintenance screen of the pooled table, choose Technical Settings.
The maintenance screen for the technical settings of the pooled table appears.
On the technical settings maintenance screen, select the Convert to transparent table indicator.
Note
This corrects only the technical settings and not the table definition.
Maintain the remaining attributes of the technical settings.
Choose with the quick Info text Activate.
The technical settings are activated.

Result

A conversion converts the pooled table to a transparent table. For more information, see Adjusting Database Structures . In a dialog box you can decide whether to convert the table directly or in the background.

If SAP delivers a table again with transparent flag set as a pooled table, it remains transparent in the user's system.

If you have set the transparent flag of a table and you want to convert it back into pooled table, you must first cancel the transparent flag. Then activate the technical settings. Only after these actions you can change the table category .

Caution

If there is a revised version of a pooled table, it cannot be converted to a transparent table with the transparent flag. In this case, the technical settings of the table cannot be activated when the transparent flag is set.

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 that satisfy all these restrictions can be converted using the transparent flag. If you violate one of these restrictions, the technical settings cannot be activated. In this case you can find the cause of the error in the activation log.