Ramss

• Nov 16th, 2006

 

A transparent table in data dictionary has a one-to-one relationship with a table in the database

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

 

thanks

mukesh kumar

• Nov 20th, 2006

 

Pooled table is a group of related logical tables.An important difference between transparent table and the pool table is that you cannot create secondary indices on pool table

vikas singh

• Nov 22nd, 2006

 

Transparent table stores application data where as pooled table stores system data.

purna chandra

• Dec 8th, 2006

 

transparent table : where the master data is stored, and which data has no frequent changes .ex: KNA1,MARA,LFA1 etc.

we can have INCLUDE AND APPEND structure in transparent table.

pooled table : it is linear search, where data has changed frequently,it can not have foriegn key relationship,we can not INCLUDE AND APPEND structure.

S.Suresh Babu

• Dec 16th, 2006

 

Dear all,

Tables are 3 types

1. Transparent   
2. Clustered 
3. Pooled

TRANSPARENT tables:
Table Structure in the ABAP dictionary is same as the table structure in the
database. and 90% of the SAP tables are TRANSPARENT tables.

CLUSTERED tables & POOLED tables : 
There is a layer (CLUSTER LAYER) in the database server to process the
incoming requests from the application server, so that database server just
supplies the data instead of processing & then supplying, so that PERFORMANCE
will increase, there its called as a LOGICAL DATA also.

CLUSTER TABLE follows BINARY search.
POOLED TABLE follows LINEAR search.

What ever i provided is with my knowledge...
if any mistakes just give the reply...

Thank you