topic Re: Pooled table in Application Development and Automation Discussions

Pooled table

Former Member — Thu, 12 Oct 2006 14:07:43 GMT

Hi Guys,

What is the Pooled table?.How to create Pooled table?

Thanks and Regards,

Suresh.

Re: Pooled table

Former Member — Thu, 12 Oct 2006 14:11:09 GMT

Check the below link:

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

http://www.datamanagementgroup.com/Resources/Articles/Article_0106_2.asp

It should be created from SE11.

Regards,

Prakash.

Re: Pooled table

Former Member — Thu, 12 Oct 2006 14:11:27 GMT

please search the forum before posting questions

chk this

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

Re: Pooled table

Former Member — Thu, 12 Oct 2006 14:12:00 GMT

Hi,

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.

The definition of a pool consists essentially of two key fields (Tabname and Varkey) and a long argument field (Vardata).

Procedure to create

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

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

3) Choose Extras -> Change table category.

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

4) Click Ok. 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.

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

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

Regards

Sudheer

Re: Pooled table

Former Member — Thu, 12 Oct 2006 14:14:27 GMT

Hi,

pooled table :The data from several tables is stored together in a table pool .

You can create pooled table just like normal custom table (transparent table ).Only thing is you need to change table category once the definition is complete.

you can do so using path : Extras ->Change table category.

Enter pooled/cluster table.

Thanks.

Mark points if helpful.

Re: Pooled table

Former Member — Thu, 12 Oct 2006 14:22:21 GMT

What is the use of pooled table?

Re: Pooled table

Former Member — Thu, 12 Oct 2006 14:39:42 GMT

Difference between transparent tables and pooled tables.- Transparent tables: Transparent tables in the dictionary has a one-to-one relation with the table in database. Its structure corresponds to single database field. Table in the database has the same name as in the dictionary. Transparent table holds application data. Pooled tables. Pooled tables in the dictionary has a many-to-one relation with the table in database. Table in the database has the different name as in the dictionary. Pooled table are stored in table pool at the database level.

Reward if helpful