InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What are pooled tables in SAP? |
|
Answer» A pooled table is a special type of table that is present in the SAP ABAP(ADVANCED Business Application Programming) dictionary that is used to store control data. The pooled table is an SAP proprietary creation. It has a many-to-one relationship with tables within the SAP database. This implies that, for a provided pooled table in the database, the SAP data dictionary can have multiple smaller tables. SAP will make USE of pooled tables to integrate and hold a huge number of SMALL tables. This will help in reducing the space and resources required at the database level. SAP will MAINLY use pooled tables for system data maintenance. The above-given figure shows how pooled tables are STORED in the database backend. Here, the table pool will have TABNAME(Name of a pooled table), VARKEY(All primary key fields from pooled table record in string format), DATALN(String length in VARDATA), and VARDATA(All data fields from pooled table record in a string format). |
|