« What are indexes?
What is Constants Statement »

What is the 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.

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.

Popularity: 4% [?]

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • del.icio.us
  • Facebook
  • Google
  • Slashdot
  • StumbleUpon
  • Reddit

This entry was posted on Monday, June 30th, 2008 at 1:27 am and is filed under SAP. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.