topic Re: Pooled table in Application Development and Automation Discussions

Pooled table

Former Member — Mon, 27 Mar 2006 06:50:49 GMT

hi,

What is a Pooled table, and how to create it.

Thanks

Abhishek

Re: Pooled table

Former Member — Mon, 27 Mar 2006 06:52:33 GMT

<b>Pooled tables</b>

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

http://www.sap-img.com/abap/the-different-types-of-sap-tables.htm

<b>Creating pooled tables:</b>

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

Re: Pooled table

Former Member — Mon, 27 Mar 2006 06:56:22 GMT

hi ,

A pooled table in R/3 has a many-to-one relationship with a table in the database ..

For one table in the database, there are many tables in the R/3 Data Dictionary.

The table in the database has a different name than the tables in the DDIC, it has a different number of fields, and the fields have different names as well..

Pooled tables are primarily used by SAP to hold customizing data.

You might create a table pool if you need to create hundreds of small tables that each hold only a few rows of data...

To implement these small tables as pooled tables, you first create the definition of a table pool in R/3 to hold them all.

When activated, an associated single table (the table pool) will be created in the database. You can then define pooled tables within R/3 and assign them all to your table pool

regards

satesh

Re: Pooled table

Former Member — Mon, 27 Mar 2006 07:06:45 GMT

Creating Pooled Tables

Procedure

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

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

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

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

5.Choose Extras ® Change table category.

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

Re: Pooled table

Former Member — Mon, 27 Mar 2006 07:09:07 GMT

The pool and table is a many to one relationship table. This means many pool table store in a database table which is know as table pool.

All the pool table stored table in table pool does not need to have any foreign key relationship.

Table pool can contain 10 to 1000 small pool table which has 10 to 100 records.

For pool you can create secondary index and you can use select distinct, group for pool table. You can use native SQL statement for pool table.

go through this URL.It will help you to create a Pooled Table.

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

I hope this will help you to solve your problem

Thanks

Mrutyunjaya Tripathy