topic Re: fields in a database table in Application Development and Automation Discussions

fields in a database table

Former Member — Fri, 25 May 2007 06:32:41 GMT

hai in a database table max how many fields we can create and what is max no of fields for a primary key

Re: fields in a database table

Former Member — Fri, 25 May 2007 06:34:53 GMT

<b>Constraints while creating a d/b table</b>

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.

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

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.

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).

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

Re: fields in a database table

Former Member — Fri, 25 May 2007 06:36:21 GMT

also check this link

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

Re: fields in a database table

Former Member — Fri, 25 May 2007 06:37:47 GMT

1) The maximum number of keys in a table can be 16

2) The maximum length of the key fields can be 120.

Re: fields in a database table

Former Member — Fri, 25 May 2007 06:39:52 GMT

Maximum No. Key fields = 16.

And the maximum length of the table key is 255...

Tne No of entries in a table is decied by the size of the table that you created..Goto Technical settings od the tble..There in the SIZE-CATEGORY you are assigning the size of the table..Press F1 there ,you can get all the details...

Hope This Will Helps You...

Reward All Helpfull Answers...........

Re: fields in a database table

Former Member — Fri, 25 May 2007 06:40:44 GMT

maximum no of entries in table can be upto 9999 if i am not wrong

when we check the table field POSITION in table DD03L, its length is 4

this defines the position of field in a table

so the maximum no can be 9999