topic Size category issue in Application Development and Automation Discussions

Size category issue

Former Member — Tue, 15 Oct 2013 17:30:34 GMT

Hi Experts,

I am creating a Custom database table.In that table I choose the size category as maximum means , 8 9,800,000 to 19,000,000.

Now I want to enter more data to the table means more that the above range. So I will do ? How I ll enter more data to the custom table which is more than the sap specified size range.

Regards,

Ajit

Moderator message - Search for available documentation before posting your question.

Message was edited by: Suhas Saha

Re: Size category issue

former_member188827 — Tue, 15 Oct 2013 17:37:02 GMT

Adding size category does not limit the size of table. It reserves an initial space for table in database. When size increases, another extent is added according to size category. Please check SAP's documentation for further detail:

Size category

The size category determines the probable space requirement for a table in the database.

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.

Regards

Re: Size category issue

Former Member — Tue, 15 Oct 2013 17:41:06 GMT

It should be better to change the size category and insert a bigger one.

Max

Re: Size category issue

Former Member — Tue, 15 Oct 2013 17:57:33 GMT

I think you need to read what is the use of size category. Then you won't ask this question

Here you can find the actual use of size category, http://help.sap.com/saphelp_nwpi71/helpdata/en/cf/21ead2446011d189700000e8322d00/frameset.htm

Re: Size category issue

Former Member — Tue, 15 Oct 2013 17:59:06 GMT

Hi,

As you said, ""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.""

Ok its fine the size is increased with the category selected, But my requirement is,it again increased the size of maximum size which is Sap provide i.e 19,000,000. So in that case how to assign the size.

Re: Size category issue

Former Member — Tue, 15 Oct 2013 18:00:49 GMT

Hi Max,

I inserted the the last size i.e 9,800,000 to 19,000,000 which sap provides.But my size is more than this.So how I ll change the size category ?

Ajit

Re: Size category issue

Former Member — Tue, 15 Oct 2013 18:08:43 GMT

open the link given by me and explore that.

Re: Size category issue

SuhaSaha — Tue, 15 Oct 2013 18:58:36 GMT

I think you need to read what is the use of size category. Then you won't ask this question

If you think that a question is of the RTFM type, instead of replying hit the abuse button & let the mods decide how to handle it.