topic Re: Table Creation. in Application Development and Automation Discussions

Table Creation.

Former Member — Tue, 29 Jan 2008 06:56:46 GMT

Hi Experts,

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

Thanks in advance.

Re: Table Creation.

Former Member — Tue, 29 Jan 2008 07:08:36 GMT

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.

Re: Table Creation.

Former Member — Tue, 29 Jan 2008 09:01:45 GMT

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

Re: Table Creation.

Former Member — Tue, 29 Jan 2008 09:06:16 GMT

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.

Re: Table Creation.

Former Member — Tue, 29 Jan 2008 09:50:04 GMT

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