10-15-2013 6:30 PM
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
10-15-2013 6:37 PM
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:
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
10-15-2013 6:41 PM
Hi
It should be better to change the size category and insert a bigger one.
Max
10-15-2013 6:57 PM
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
10-15-2013 7:58 PM
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.
10-15-2013 6:59 PM
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.
10-15-2013 7:08 PM
10-15-2013 7:00 PM
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