topic Re: Dictionary tables maximum width in Application Development and Automation Discussions

Dictionary tables maximum width

Former Member — Mon, 28 Nov 2005 18:39:15 GMT

Hi developers,

does anybody know the maximun length a record of a dictionary table can have?

thanx a lot to everybody.

Re: Dictionary tables maximum width

Former Member — Mon, 28 Nov 2005 18:49:45 GMT

Domenico,

Following are the major constraints in Table. Nothing Else!!!!!!

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.

Thanks

Kam

Note: Allot points for all worthful postings!!!!

Re: Dictionary tables maximum width

RichHeilman — Mon, 28 Nov 2005 18:49:51 GMT

You mean a transpart table? I would say the limit is pretty big, If you look at table STXL, you will see the one field is over 7000 characters long. This is because it is a LRAW field. I know that there will be problems if your key fields are too big.

Regards,

Rich Heilman

Re: Dictionary tables maximum width

Former Member — Mon, 28 Nov 2005 18:55:29 GMT

Hi Manti,

Till 4.6c we can have only 256 fields, but it has been extended in 4.7

( Now it is 1024 fields (with key) and 1023(without key) ) .

Internal length of a table row is 8088 Bytes.

Regards,

Rajasekhar

Re: Dictionary tables maximum width

Former Member — Mon, 28 Nov 2005 18:55:35 GMT

Domenico,

There will be limits beyond SAP's. You will need to speak with a DBA on your staff that supports your underlying DB system.

Each DB system/version will have limits that are enforced on all SAP data dic objects.