Skip to Content

Where does we use Cluster & Pooled Tables

can you please tell where does we actually use the Cluster and pooled tables...and what is the main purpose of the cluster and pooled

Thankyou for your time

Bhaskar

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Jan 09, 2007 at 03:34 AM

    Pooled tables can be used to store control data (e.g. screen sequences, program parameters or temporary data). Several pooled tables can be combined to form a table pool. The table pool corresponds to a physical table on the database in which all the records of the allocated pooled tables are stored.

    A001

    A004

    A005

    A006

    A007

    A009

    A010

    A012

    A015

    A016

    A017

    A018

    A019

    A021

    A022

    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.

    AUAA

    AUAB

    AUAO

    AUAS

    AUAT

    AUAV

    AUAW

    AUAY

    BSEC

    BSED

    BSEG

    BSES

    BSET

    CDPOS

    Raja T

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2007 at 03:37 AM

    Hi Bhaskar ,

    Cluster Table : As the name suggests the data in the table are stored in clusters , cluster tables store a very large volume of data .

    Pooled Tables : Pooled tables are a group of table which are collectively accessed using a common name, usually table where the volume of data and access to the data is less are comnibned together in a pool.

    There is a major diffrenece between cluster tables and pool tables , in case of cluster tables the tables in the cluster must have a relationship between them but it is not necessary in case of pooled tables.

    Please see the help for the same

    http://help.sap.com/saphelp_erp2005vp/helpdata/en/cf/21f0d1446011d189700000e8322d00/frameset.htm

    Regadrs

    Arun

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2007 at 03:43 AM

    check this table DD02L here u can see the cluster & pooled table

    to see pooled table specify pool in tabclass for cluster use cluster in tabclass.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.