topic Re: Table Size in Application Development and Automation Discussions

Table Size

Former Member — Thu, 29 May 2008 04:24:20 GMT

Hello,

What is the maximum number of columns and the total size a SAP table can have? What are the technical limitations involved in having a table more than what is allowed? I want a detailed explanation if possible.

This question is respect to a implementation where I have reached the limit for a table size and no more fields can be added.

Re: Table Size

Former Member — Thu, 29 May 2008 05:08:04 GMT

DGKAT table which store the size cat.....

i think this will help u....if it is usefull

Plz Reward

Regards

Anbu

Re: Table Size

Former Member — Thu, 29 May 2008 05:15:42 GMT

Thanks Anbu.

But you seem to talking about the number of records. But am asking about the number of columns (fields), an SAP table can have.

Re: Table Size

Former Member — Thu, 29 May 2008 06:16:55 GMT

Hai,

Number of columns per table (with KEY) - 1024

Number of columns per table (without KEY) - 1023

Number of primary key columns per table - 512

Number of columns in an index - 16

Number of foreign key columns per table - 16

Number of columns in a SELECT statement - 1023

Number of columns in an INSERT statement - 1024

Number of columns in a results table - 1023

Number of join tables in a SELECT statement - 64

Thanks,

Durai.V

Re: Table Size

JoffyJohn — Thu, 29 May 2008 06:58:01 GMT

Hello,

What is the maximum number of columns and the total size a SAP table can have?

A table must not have more than 249 fields. The sum of all field lengths is limited to 1962 (whereby fields with data type LRAW and LCHR are not counted).

What are the technical limitations involved in having a table more than what is allowed? I want a detailed explanation if possible.

only option left is to define an ztable with the same key as this table and update the ztable.

Re: Table Size

Former Member — Thu, 29 May 2008 09:51:57 GMT

Hi Yogi,

Follow this link... ithink it will be helpful for you

http://www.sapdb.org/htmhelp/32/60a014540911d5a9fd00a0c9449261/content.htm

Reward if helpful.

Regards,

Syed

Re: Table Size

vimalv — Thu, 29 May 2008 11:25:50 GMT

@ Syed : Well that looks like something specific to the SAP DB.

@ All, But if this question is in related to a table in the DDIC, there is a restriction to 249 fields.

For a DDIC Table, the following constraints apply :

1. All the key fields of a table must be stored together at the beginning of the table. A non-key field may not occur between two key fields.

2. A maximum of 16 key fields per table is permitted. The maximum length of the table key is 255.

3. If the key length is greater than 120, there are restrictions when transporting table entries. The key can only be specified up to a maximum of 120 places in a transport. If the key is larger than 120, table entries must be transported generically.

4. A table may not have more than 249 fields. The sum of all field lengths is limited to 1962 (whereby fields with data type LRAW and LCHR are not counted).

5. Fields of types LRAW or LCHR must be at the end of the table. Only one such field is allowed per table. There must also be a field of type INT2 directly in front of such a field. The actual length of the field can be entered there by the database interface.

Please refer this :

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21eb6e446011d189700000e8322d00/content.htm

Reward if helpful