Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

cluster table clustd field

Former Member
0 Likes
1,734

hi,

how to read data stored in this field, clustd?

actually how to use this table?

thanks

hi,

how to read data stored in this field, clustd?

actually how to use this table?

thanks

2 REPLIES 2
Read only

Former Member
0 Likes
938

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.

refer link.

Regards,

Priyanka.

Read only

Former Member
0 Likes
938

Hello,

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.

<b>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.</b>

<b>

To access cluster table:</b>

<b>http://fuller.mit.edu/hr/cluster_tables.html</b>

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f083446011d189700000e8322d00/content.htm

regards,

Beejal

**reward if this helps