Max. record in SAP standard Table

[Former Member]

can any one tell me what is the maximum limit of records in sap standard table and ztable?

where we set it and when? n what happened if it exceeds?

[Former Member]

Hi,

Just go to technical settings in se11 of that table there you can see

SIZE CATEGORY FIELD where size setting is done.

Just press f1 on that size category field there you observe.

You can select the categories 0 to 4 for your table. Each category is assigned 
a specific fixed storage area value in the database. When you create a table, 
initial space is saved for it in the database. If more space is required later as a 
result of data that has been entered, the storage space is increased in
accordance with the category selected.

Please study the documentation there.

Regards and Best wishes.

[Former Member]

if more space is required then we have to change the categories and save it? do it need any autorization or acces key as we have to change it in sap standard table? so from here we will get the authorization?

[Former Member]

Hi,

If more space is required it will automatically create another extent after reaching maximum

records but if you want to change properties of standard it require authorization.

Regards and Best wishes.

[Former Member]

I don't believe there is a maximum, unless the database server says so.

The replies so far given are in regard to the amount of space reserved by the database server for the table space. Nothing happens when inserting a new entry if this setting is exceeded, except the table space has to be extended (meaning a slight loss of performance every time you insert).

Also consider that the bigger your table/database, the harder it becomes to restore it during a backup or disaster recovery.

But, more importantly, why wait untill the maximum is reached: archive your data!