topic Re: Difference b/w transparent ,pool ,cluster tables in Application Development and Automation Discussions

Difference b/w transparent ,pool ,cluster tables

Former Member — Thu, 09 Jun 2005 13:27:17 GMT

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?

Re: Difference b/w transparent ,pool ,cluster tables

Former Member — Thu, 09 Jun 2005 13:29:01 GMT

HEllo,

please go thro' this thread:

Regards, Murugesh AS

Re: Difference b/w transparent ,pool ,cluster tables

Former Member — Thu, 09 Jun 2005 13:31:52 GMT

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

Re: Difference b/w transparent ,pool ,cluster tables

Former Member — Fri, 10 Jun 2005 13:47:59 GMT

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

Re: Difference b/w transparent ,pool ,cluster tables

Former Member — Mon, 13 Jun 2005 06:12:36 GMT

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.

Re: Difference b/w transparent ,pool ,cluster tables

nishanthbhandar — Mon, 13 Jun 2005 06:17:43 GMT

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

Re: Difference b/w transparent ,pool ,cluster tables

Former Member — Mon, 13 Jun 2005 12:48:04 GMT

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

Re: Difference b/w transparent ,pool ,cluster tables

Former Member — Tue, 14 Jun 2005 07:13:49 GMT

Hi Buddy,

Pls close the issue if you are satisfied.

Regs,

Venkat