What is cluster table ?

[carlos_zhang3]

Hello everybody ,

BSEG is a cluster table in SAP . Has anyone know about this type of table ?

because of i can not find this table when i login the DBServer & use SQLPlus .

And as i know this table is combined with another tables ...

Is it defined in SAP DDIC ?

if i want to use another transparent table to join this table in abap/4 how to do it ?

thanks so much !!!

Best Regrads,

Carlos

[carlos_zhang3]

Hello everybody ,

BSEG is a cluster table in SAP . Has anyone know about this type of table ?

because of i can not find this table when i login the DBServer & use SQLPlus .

And as i know this table is combined with another tables ...

Is it defined in SAP DDIC ?

if i want to use another transparent table to join this table in abap/4 how to do it ?

thanks so much !!!

Best Regrads,

Carlos

[Former Member]

Cluster Table is Logical Table,it is many to one.

use For all entries and it is huge table ...

If you get any performance issue ,then use index,all primary key in where condition if possible ...

[Former Member]

Hi,

Please check this link

http://www.sap-img.com/abap/the-different-types-of-sap-tables.htm

[carlos_zhang3]

thanks a lot !

<b>A clustered and a pooled table cannot be read from outside SAP because certain data are clustered and pooled in one field. </b>

[Former Member]

Cluster Table : Cluster tables are logical tables that must be assigned to a table cluster when they are defined. Cluster tables can be used to strore control data. They can also be used to store temporary data or texts, such as documentation.

[Former Member]

Hi

Occasionally, several tables may be linked by a common key. The ABAP/4 Data Dictionary can also combine these tables into a single table. Each data set of the real table within the database contains a key and in a single data field, several data sets of the subsequent table for this key.

As mentioned above, these table types require special data handling, therefore they are not transparent tables.

Note: Both Pooled and Cluster Tables are stored as tables within the database. Only the structures of the two table types which represent a single logical view of the data are defined within the ABAP/4 Data Dictionary. The data is actually stored in bulk storage in a different structure. These tables are commonly loaded into memory (i.e., 'buffered') due to the fact they are typically used for storing internal control information and other types of data with little or no external (business) relevance.

REWARD IF HELPFUL...!!