Size Category of Database Tables

by | Apr 14, 2018 | ABAP Beginner

Preface – This post is part of the ABAP Beginner series.

Size Category of Database Tables

In Data Class we have defined the kind of Data we are going to have for our table. Now, it’s time to decide the expected Volume of Data. We do it via Size Category of Database Tables.

Initially Every Table receives equal amount of allowed space. If the data exceeds the initial space provided then an extent of memory is provided to the table, the amount of extended memory will depend upon the size category we provide.

In this way we actually prevent creation of Large extended memory and thus reduce the wastage of data base space.


Initially every table have some memory allotted. Size Category tells us the amount of space that will be extended after the initial memory is filled.

What will happen if extended memory created is also filled?

Then a new extend will be created again with the memory equal to the size category provided as shown below:

Size Category of Database Tables

We have 3 Table with Size Category 0, 1, 2 respectively. The Initial memory allotted for all tables are equal but later on depending upon the Size Category the extent is provided in the data base.

How Multiple Extends affects the Data base?

A table with multiple extensions affects database in following ways:

  • Decreases System Performance: Data will be fetched from two different sources.
  • Increases Database management: Database Reorganization is required
  • Lowers Systems Availability: For Database reorganization, it is taken offline.



Size CategoryExpected Rows
00 to 1,000
11,000 to 4,200
24,200 to 17,000
317,000 to 68,000
468,000 to 270,000
5270,000 to 540,000
6540,000 to 1,000,000
71,000,000 to 2,100,000
82,100,000 to 4,300,000
94,300,000 to 170,000,000




Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.