Skip to Content
author's profile photo Former Member
Former Member

max fields in a Z Table

Hai Friends,

what is the maximum number of fields i can create in a Z Table?. Is there any restrictions.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 24, 2009 at 07:01 AM

    Hi Vennila,

    Please have look at the constraints below for the Table Creation:

    Constraints

    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.

    Please have a look at this following link which will give you complete details:

    Constraints

    http://help.sap.com/saphelp_webas620/helpdata/en/cf/21ea31446011d189700000e8322d00/frameset.htm

    Thanks,

    Samantak.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 25, 2009 at 04:22 AM

    hi

    A Table can have

    1) Not more than 249 Fields & the sum of all the field lengths is limited to 1962.

    2) Maximum of 16 key fields & maximum length of table key is 255.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 25, 2009 at 05:10 AM

    Dear vinnela,

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

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

    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.

    Cheers

    Fareed

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 25, 2009 at 05:46 AM

    Hi Dude,

    Max fields in a table is 249 only.. not more than that..

    Edited by: Raghunath Shyamala on May 25, 2009 7:49 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 24, 2009 at 05:21 AM

    It should be dependant on the underlying database, for Oracle database table there is limitation of 254 fields max.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 24, 2009 at 06:51 AM

    Hi Vennila,

    Check this

    hope it helps you

    Thanks!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 25, 2009 at 08:50 AM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.