Difference b/w transparent ,pool ,cluster tables

[Former Member]

Hello Sir,

I wanna ask that what is the basic difference between all these tables ?

And in practical scenario where all the 3 tables are used?

[former_member214131]

HEllo,

please go thro' this thread:

Regards, Murugesh AS

[Former Member]

http://help.sap.com/saphelp_erp2004/helpdata/en/81/415d363640933fe10000009b38f839/frameset.htm

More at this link.

regds,

Mano sri

[Former Member]

1. Transparent table

a. You can create secondary index

b. one-to-one relation

2. Clustered tables & Pooled tables

a. We cannot create secondary index

b. We find many tables in database fro one table in dictionary.

Regards,

Venkat Ramanan

[Former Member]

Hi Saurabh

In Sap as u know there r 3 types of tables called

Transparent ,Pooled and Cluster tables.

The strucure of the transaparent tables is same in the Abap Dictionary and the database where as in the case of Pooled and Cluster the structure is differnt as several Pooled tables are stored under the table Pool and the several Cluster tables are stored under the table Cluster.

[nishanthbhandar]

Transparent tables in the dictionary has 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 in the dictionary has 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.

Each field of cluster table behaves as tables which contains the no. of entries.

Cheers

Nishanth

[Former Member]

1. Transparent table

a. You can create secondary index

b. one-to-one relation

2. Clustered tables & Pooled tables

a. We cannot create secondary index

b. We find many tables in database fro one table in dictionary.

Regards,

Venkat Ramanan

[Former Member]

Hi Buddy,

Pls close the issue if you are satisfied.

Regs,

Venkat