Skip to Content
author's profile photo Former Member
Former Member

Table Creation.

Hi Experts,

How we create cluster and pooled tables and what is the procedure.

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 07:08 AM

    Hi,

    Creating Pooled Tables/Cluster Tables

    Procedure

    In the initial screen of the ABAP Dictionary select object type Table, enter a table name and choose Create.

    The field maintenance screen for the table is displayed. Table type Transparent table is set as default.

    Make the necessary entries in the Short description and Delivery class fields on the Attributes tab page. Then define the fields of the table.

    Proceed as when creating a transparent table. Save your entries.

    Choose Extras ® Change table category.

    A dialog box appears in which you have to select the table type Pooled table or Cluster table.

    Choose Select.

    You return to the field maintenance screen for the table. Field Pool/cluster name is displayed on the Attributes tab page in addition to the standard fields.

    Enter the name of the table pool or table cluster to which you want to assign the pooled table or cluster table in field Pool/cluster name

    Note that the total key length of a pooled table may not exceed the key length of the associated table pool. The key of a cluster table must correspond to the key of the associated table cluster.

    Proceed as when creating a transparent table (see Creating Tables). Remember that you cannot create indexes for pooled or cluster tables.

    All the attributes of the technical settings can be maintained for pooled tables and cluster tables. Before you can access these attributes, however, you must convert the table to a transparent table.

    for more information pls refer:

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

    Regards,

    Renjith Michael.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 09:01 AM

    hi,

    pooled tables:

    These are logical tables, which must be assigned to a table pool when they are defined. Pooled tables can be used to store control data (such as screen sequences or program parameters).

    cluster tables:

    A table cluster combines several logical tables in the ABAP/4 Dictionary. Several logical rows from different cluster tables are brought together in a single physical record. The records from the cluster tables assigned to a cluster are thus stored in a single common table in the database.

    see the below link how to create pooled and cluster tables:

    http://help.sap.com/saphelp_47x200/helpdata/en/81/415d363640933fe10000009b38f839/frameset.htm

    reward if its useful

    Edited by: prs on Jan 29, 2008 2:31 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 09:06 AM

    Hi PB,

    Pooled table 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.

    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.

    Check the limk given below where you will get a clear idea of creating pooled and cluster tables.

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

    Regards

    Sreekar.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 09:50 AM

    hi,

    Procedure

    In the initial screen of the ABAP Dictionary select object type Table, enter a table name and choose Create.

    The field maintenance screen for the table is displayed. Table type Transparent table is set as default.

    Make the necessary entries in the Short description and Delivery class fields on the Attributes tab page. Then define the fields of the table.

    Proceed as when creating a transparent table. Save your entries.

    Choose Extras ® Change table category.

    A dialog box appears in which you have to select the table type Pooled table or Cluster table.

    Choose Select.

    You return to the field maintenance screen for the table. Field Pool/cluster name is displayed on the Attributes tab page in addition to the standard fields.

    Enter the name of the table pool or table cluster to which you want to assign the pooled table or cluster table in field Pool/cluster name

    Note that the total key length of a pooled table may not exceed the key length of the associated table pool. The key of a cluster table must correspond to the key of the associated table cluster.

    Proceed as when creating a transparent table (see Creating Tables). Remember that you cannot create indexes for pooled or cluster tables.

    plz reward if useful..

    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.