topic Re: DIFFERENCE BETWEEN TRANSPARENT AND CLUSTER TABLES in Application Development and Automation Discussions

DIFFERENCE BETWEEN TRANSPARENT AND CLUSTER TABLES

Former Member — Mon, 18 Jul 2005 09:33:56 GMT

I WANT TO KNOW THE EXACT DIFFERENCE BETWEEN TRANSPARENT AND CLUSTER TABLES. WHEN WE WILL DECLARE THE TABLE AS CLUSTERED TABLE. PLEASE GIVE ME SOME EXAMPLES OF CLUSTERED TABLES.

THANKS AND REGARDS

Re: DIFFERENCE BETWEEN TRANSPARENT AND CLUSTER TABLES

Former Member — Mon, 18 Jul 2005 09:53:05 GMT

Hi Suresh,

here are some examples:

-BSEG (Accounting Document Segment)

-BSEC (One-Time Account Data Document Segment)

-BSED (Bill of Exchange Fields Document Segment)

-BSES (Document Control Data)

-BSET (Tax Data Document Segment)

Moreover, if you select all entries in table DD02L with TABCLASS = 'CLUSTER', you'll get all cluster tables in the system.

You may also watch this link: http://help.sap.com/saphelp_40b/helpdata/en/cf/21f083446011d189700000e8322d00/content.htm

I hope it helps. BR,

Alvaro

Re: DIFFERENCE BETWEEN TRANSPARENT AND CLUSTER TABLES

Former Member — Mon, 18 Jul 2005 10:16:15 GMT

Hi,

The same topic was discussed in the forum before also:

please check these links:

Regards,

Anjali

Re: DIFFERENCE BETWEEN TRANSPARENT AND CLUSTER TABLES

Former Member — Mon, 18 Jul 2005 10:20:01 GMT

hi,

a transparent table in the DDIC has a one-to-one correspondence with the tables in the database. that is to say that a transparent table is an exact copy of a database table. while this is not so for a cluster table (or for that matter a pooled table). these tables contain data from multiple database tables.

check out this link....understand the difference between a table cluster and a cluster table...

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

regards,