topic Re: Cluster table? in Application Development and Automation Discussions

Cluster table?

Former Member — Mon, 18 Sep 2006 15:39:16 GMT

Hi..

How is data stored in a cluster table?

Thank You

Former Member — Mon, 18 Sep 2006 15:41:14 GMT

Hi,

Check this Definition...

Cluster table

Cluster tables contain continuous text, for example, documentation.

Several cluster tables can be combined to form a table cluster. Several

logical lines of different tables are combined to form a physical record

in this table type. This permits object-by-object storage or

object-by-object access. In order to combine tables in clusters, at

least parts of the keys must agree. Several cluster tables are stored in

one corresponding table on the database.

Thanks,

Naren

Former Member — Mon, 18 Sep 2006 15:42:16 GMT

hi,

Several logical data records from different cluster tables can be stored together in one physical

record in a table cluster.

A cluster key consists of a series of freely definable key fields and a field (Pageno) for

distinguishing continuation records. A cluster also contains a long field (Vardata) that contains

the contents of the data fields of the cluster tables for this key. If the data does not fit into the long

field, continuation records are created. Control information on the structure of the data string is

still written at the beginning of the Vardata field.

The records of all cluster tables with the same key are stored under one key in the assigned table

cluster. The values of the key fields are stored in the corresponding key fields of the table cluster.

The values of all data fields of the assigned cluster tables are written as a string to the Vardata

field of the table cluster. Besides the actual data values, the data string contains information on

the structure of the data and which table it comes from. If the string exceeds the maximum length

of the Vardata field, a continuation record is written with the same key values. The continuation

records for a key are distinguished by their value in field Pageno. The actual length of the string

in the Vardata field is stored in the Pagelg field by the database interface.

You need the structural information stored in the ABAP Dictionary to read the data from a pooled

table or cluster table correctly. These tables can therefore only be processed using Open SQL

with the cluster interface, and not with Native SQL directly in the database.

Regards,

Sailaja.

Former Member — Mon, 18 Sep 2006 15:42:33 GMT

Hello,

Go to transaction ABAPDOCU and press the CNTRL + F8. Enter the text CLUSTER TABLE and press enter. Now you can read about it's usage and storage.

Regs,

Venkat Ramanan N