Start of Content Area

Procedure documentation Converting Pooled Tables to Transparent Tables  Locate the document in its SAP Library structure

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

...

       1.      From the maintenance screen of the pooled table, go to the maintenance screen for the technical settings of the pooled table with Technical settings.

       2.      Select Convert to transparent table. This will only correct the technical settings and not the table definition.

       3.      Maintain the remaining attributes of the technical settings.

       4.      Activate the technical settings.

Result

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

If SAP again delivers a table whose transparent flag is set as a pooled table, it will remain transparent in the user system. 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. You can only change the table category after these actions.

Note

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 one of these restrictions is violated, the technical settings cannot be activated. In this case you can find the cause of the error in the activation log.

See also:

Pooled and Cluster Tables

 

End of Content Area