topic Re: cluster,pool tables in Application Development and Automation Discussions

cluster,pool tables

Former Member — Thu, 13 Sep 2007 06:57:20 GMT

how can i see cluster and pooled tables

in se11 i tried but i am not able to see

can any body help in this regard with example

Re: cluster,pool tables

Former Member — Thu, 13 Sep 2007 07:00:09 GMT

Hi,

Check this,

https://forums.sdn.sap.com/click.jspa?searchID=5215473&messageID=3520315

Reward If Helpful.

Re: cluster,pool tables

Former Member — Thu, 13 Sep 2007 07:02:34 GMT

JUST DO THIS

T040, T040A--pooled

BSEG, BSES---->cluster

Go to se11

table DD02L-> Give TABCLASS as POOL or CLUSTER you will get a list of tables

THANKS

REWARD IF HELPFUL

VIVEKANAND

Re: cluster,pool tables

former_member404244 — Thu, 13 Sep 2007 07:03:48 GMT

Hi,

go through the below links..

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

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

U can directly see them SE11 ,example of cluster table BSEG.

Regards,

Nagaraj

Re: cluster,pool tables

RaymondGiuseppi — Thu, 13 Sep 2007 07:04:15 GMT

Look at <a href="http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCDWBDIC/BCDWBDIC.pdf">BC - ABAP Dictionary</a>

Pooled and Cluster Tables

Table pools (pools) and table clusters (clusters) are special table types in the ABAP Dictionary.

The data from several different tables can be stored together in a table pool or table cluster.

Tables assigned to a table pool or table cluster are referred to as pooled tables or cluster tables.

A table pool or table cluster should be used exclusively for storing internal control information

(screen sequences, program parameters, temporary data, continuous texts such as

documentation). All data of commercial relevance is stored exclusively in transparent tables!

Table Pools

A table in the database in which all records from the pooled tables assigned to the table pool are

stored corresponds to a table pool.

Table Clusters

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.

Regards

Re: cluster,pool tables

Former Member — Thu, 13 Sep 2007 07:04:34 GMT

Hi,

Check this link, hope it helps,

http://web.mit.edu/sapr3/dev/sap_table_types.htm

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

regards,

pritha.

Message was edited by:

Pritha Agrawal

Re: cluster,pool tables

Former Member — Thu, 13 Sep 2007 07:18:13 GMT

hi,

goto se11 tcode utilities -> other Dictionary objects

there u have

1. match code

2 . cluster/pool tables from there we can view

Rewar with points if helpful.