DIFFERENCE BETWEEN TRANSPARENT AND CLUSTER TABLES

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

The same topic was discussed in the forum before also:

please check these links:

Regards,

Anjali

[Former Member]

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,

PJ