Pooled Table

Definition - What does Pooled Table mean?

A pooled table is a special type of table available in the SAP ABAP dictionary. The pooled table is a proprietary SAP creation and has many-to-one relationships with tables in the SAP database. This means that for a given pooled table in the database, there could be many smaller tables in the SAP data dictionary. SAP uses pooled tables for integrating and holding a large number of small tables. This helps in reducing the space and resources needed at the database level. SAP mostly uses pooled tables for maintaining system data.

Techopedia explains Pooled Table

A pooled table can have a different name at the database than the one in the ABAP dictionary. It can also have a different number of fields and the field names can be different as well. Pooled tables can hold a large number (thousands) of smaller tables, which can have between 10 and 100 rows. All key fields of a pooled table must also have character data types. Users are allowed to create pooled tables. For this purpose, first the definition of the pooled table has to be defined in the data dictionary. After activating the pooled table definition, associated single tables can be created in the database. For finding pooled tables in a given SAP system, transaction se11 or SE14 can be used.
Share this:

Connect with us

Email Newsletter

Join thousands of others with our weekly newsletter

The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.