topic Re: Size category in Application Development and Automation Discussions

Size category

Former Member — Fri, 29 Aug 2008 09:29:24 GMT

Hi Experts

While creating table in SE11, we mention size category,

If the records exceeds the limit what we mentioned in the table,

then how it will store data.

for example, if exceeds 12000 records, cant we store data in the table.

pls advice me.

regards

rajaram

Re: Size category

Former Member — Fri, 29 Aug 2008 09:30:37 GMT

Hi,

based on the size category, a new chunk of memory is allocated.

for further clarification check

http://help.sap.com/saphelp_nwpi71/helpdata/en/cf/21ead2446011d189700000e8322d00/content.htm

Regards,

Anirban

Re: Size category

Former Member — Fri, 29 Aug 2008 09:31:35 GMT

It will just extend the default space allocated, it will still accept the entered records.

Re: Size category

Former Member — Fri, 29 Aug 2008 09:31:40 GMT

HI ,

It will store . AFter the limit is reached to 12000 , it will added space for more 12000 records.

Re: Size category

SuhaSaha — Fri, 29 Aug 2008 09:32:16 GMT

Hello Raja,

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.

Hope this answers your qn.

BR,

Suhas

Re: Size category

Former Member — Fri, 29 Aug 2008 09:32:20 GMT

Hi,

When a table is created, initial space (an Initial Extent) is reserved in the database. If more space is required at a later time due to data entries, additional memory will be added depending on the selected size category.

for more info check this link:

http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21ead2446011d189700000e8322d00/frameset.htm

Regards

Adil

Re: Size category

Former Member — Fri, 29 Aug 2008 09:34:21 GMT

Hi,

The size category describes the expected storage requirements for the table on the database.

An initial extent is reserved when a table is created on the database. the size of the initial extent is identical for all size categories. If the table needs more space for data at a later time, extents are added. These additional extents have a fixed size that is determined by the size category specified in dictionary.

Regards

Abhijeet

Re: Size category

Former Member — Fri, 29 Aug 2008 09:40:09 GMT

Hi Raj,

If the Size Category exceeds, i.e, for eg. 12000 then the system will allocate memory for more 12000 records.

Regards,

Chandra Sekhar