topic Cluster Tables in Application Development and Automation Discussions

Cluster Tables

Former Member — Mon, 28 Apr 2008 13:27:58 GMT

Sir,

Explain about Cluster tables and give me know anyCluster Tables names in SAP r/3

Re: Cluster Tables

Former Member — Mon, 28 Apr 2008 13:30:05 GMT

Cluster tables - These are logical tables that are arranged as records of transparent tables. One cannot use Native SQL on these tables (only Open SQL). They are not manageable directly using database system tools

EX: BSEG Table

Regards,

Santosh

Re: Cluster Tables

Former Member — Mon, 28 Apr 2008 13:32:50 GMT

Hi,

Goto the table DD02L and enter the field Tabclass as TRANSP to get all transaparent tables,

CLUSTER to get all cluster tables and POOL to get the pooled tables.

Some of the cluster tables present with the system are

BSEC

BSED

BSEG

BSES

BSET

BSSEG

Check the below link.

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

Edited by: Velangini Showry Maria Kumar Bandanadham on Apr 28, 2008 3:34 PM

Re: Cluster Tables

Former Member — Mon, 28 Apr 2008 13:34:51 GMT

From SAP Online Docs


Data Clusters 


A data cluster is a group of several data objects. It can contain elementary fields, field strings and internal tables. 

You can write a data cluster to the global ABAP memory with EXPORT or read it from there with IMPORT. In addition, 
you can use the same statements to write to or read from a database table. 


Structure of a database table for storing data clusters 

The database table is divided into logically related areas, each identified by a two-character name. You can export 
a data cluster to one of these areas under a freely definable key and re-import it from there. 

A table suitable for exporting or importing data clusters must have a standardized structure which satisfies the following rules: 



If the table contains client-specific information, the first field must have the name MANDT (DD-Typ CLNT. 
The field RELID (Dictionary type CHAR, length 2) contains the area ID. 
These are followed by table-specific key fields which must all be of type CHAR. They contain the freely definable 
key of the data clusters. 
The field SRTF2 (Dictionary type INT4) is the last field in the key. Its values are assigned automatically through 
export/import operations. 
This is followed by any number of fields which are not affected by the EXPORT statement. You must assign values 
to these fields explicitly before an export. 
The data part ends with the fields CLUSTR (Dictionary type INT2) and CLUSTD (Dictionary type LRAW). Both fields 
are assigned values automatically through export/import operations. 


In addition, you should note the following points: 



The table should be transparent. 

It should only be buffered if changes are very rare. 



The table INDX can be considered as an example of a table that is suitable for storing data clusters (to view this, 
go into the ABAP/4 Dictionary, enter the table and select Dictionary &#8594; Tables &#8594; Display). It has the following structure: 

Field   Key  Type   Length  Short text 
------------------------------------------------------------ 
MANDT    x   CLNT      3    Client field 
RELID    x   CHAR      2    Area ID 
SRTFD    x   CHAR     22    User-defined key part 
SRTF2    x   INT4     10    Last key field 
LOEKZ        CHAR      1    Field to be explicitly specified 
SPERR        CHAR      1       "      "       "        " 
AEDAT        DATS      8       "      "       "        " 
USERA        CHAR     12       "      "       "        " 
PGMID        CHAR     40       "      "       "        " 
BEGDT        DATS      8       "      "       "        " 
ENDDT        DATS      8       "      "       "        " 
CLUSTR       INT2      5    Next to last data field 
CLUSTD       LRAW   2886    Last data field

Also See Documentation for IMPORT TO DATABASE and EXPORT TO DATABASE.

Edited by: Paul Chapman on Apr 28, 2008 3:36 PM

Re: Cluster Tables

Former Member — Mon, 28 Apr 2008 13:39:47 GMT

Hi,

For example:

RFBLG it is a Cluster of tables and one of this table is the BSEG.

A Cluster table has only the primary key and the other fields are in the other tables packed like BSEG.

The Cluster RFBLG has the following tables:

BSEG, BSEC, BSED, BSES ans BSET.

Regards,

Fernando

Re: Cluster Tables

janewar — Wed, 08 Jun 2016 04:40:58 GMT

KOCLU