Difference between transparent tables and pooled tables.

 transparent tables Vs pooled tables 


Transparent tables:

•  Transparent tables in the dictionary have a one-to-one relation with the table in database. Its structure corresponds to single database field. Table in the database has the same name as in the dictionary. Transparent table holds application data. 

Pooled tables. 

• Pooled tables in the dictionary have a many-to-one relation with the table in database. Table in the database has the different name as in the dictionary. Pooled table are stored in table pool at the database level.

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 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.

ResultA 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.

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 which satisfy all these restrictions can be converted with 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.

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk