SAP / SAP Beginner (0 to 2 yrs) Interview questions
What is the difference between a transparent table and a pooled table?
A transparent table defined in the ABAP Data Dictionary has a direct, one-to-one correspondence with an actual physical table in the underlying database — its structure in SAP exactly mirrors the real database table, and you could even query it directly with database tools outside of SAP. A pooled table doesn't have its own dedicated physical database table; instead, several pooled tables' data is combined and stored together in a shared underlying database table called a table pool.
| Transparent Table | Pooled Table |
| One-to-one mapping to a physical database table. | Data shared with other pooled tables in one combined physical table. |
| Can be queried directly outside SAP with database tools. | Only accessible meaningfully through SAP's own Open SQL layer. |
| Used for most business data (customers, orders, etc.). | Traditionally used for internal SAP system control data. |
The vast majority of business data you'd work with day-to-day (customer master, sales orders, materials) lives in transparent tables; pooled tables are a more specialized, less common category mainly seen in system-internal configuration areas.
More Related questions...
