ABAP Keyword Documentation → ABAP - Dictionary → Classic Objects in ABAP Dictionary → Database Tables → Technical Attributes of Database Tables → Table-Specific Technical Attributes of Database Tables
Size Category of Database Tables
The size category determines the size of the initial memory reserved for the table on the database. Values between 0 and 9 can be specified and intervals of expected rows are assigned to these values. The interval limits assigned to each size category depend on the structure of the database table. The range can extend from approximately 1000 rows in size category 0 to several million rows in size category 9. If the initial space reserved is exceeded, a new memory area is added implicitly in accordance with the chosen size category.
Other versions:
7.31 | 7.40 | 7.54
Notes
- In transaction SE11, the input help for Size Category in technical settings shows the interval limits valid for the current database table.
- A size category must be chosen that does not create too many small memory areas and no memory areas that are too big.
Example
The following table shows the interval limits of the database table SPFLI assigned to each size category
| Size Category | Expected Rows |
|---|---|
| 0 | 0 to 3,600 |
| 1 | 3,600 to 14,000 |
| 2 | 14,000 to 58,000 |
| 3 | 58,000 to 230,000 |
| 4 | 230,000 to 930,000 |
| 5 | 930,000 to 1,800,000 |
| 6 | 1,800,000 to 3,700,000 |
| 7 | 3,700,000 to 7,400,000 |
| 8 | 7,400,000 to 14,000,000 |
| 9 | 14,000,000 to 590,000,000 |