[WEBINAR] The New Normal: Dealing with the Reality of an Unsecure World

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.

Techopedia Deals

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
"Techopedia" on Twitter

Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Free Whitepaper: The Path to Hybrid Cloud
Free Whitepaper: The Path to Hybrid Cloud:
The Path to Hybrid Cloud: Intelligent Bursting To Amazon Web Services & Microsoft Azure
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.