Skip to Content
avatar image
Former Member

Reg: Creating Ztable

Hi Experts,

I am creating Ztable with more than 100 fileds and its length is 5100 characters,

while craeating the Table ZDC8DT_L_PSITEM is giving Error like... the table is too long (>4030).. so that i cannot activating the table..

Its urgent.. please suggest if anybody..

Helpful answers will be rewarded.

Thanks & Regards,

Mahendar Patha.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 09, 2007 at 03:26 AM

    Hi,

    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.

    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.

    Best regards,

    Prashant

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 09, 2007 at 03:27 AM

    I think the limit for number of characters on a table is somewhere around the 4000 mark. You cannot exceed that limit.

    The solution could be to either shorten your fields that you want to add and bring them under the limit, or create two Ztables with the same key for different fields.

    You can try to check if there are any OSS notes that will allow you to go beyond this limit(highly unlikely).

    Regards,

    Srihari

    Message was edited by:

    Srihari Hebbar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 29, 2007 at 06:20 AM

    hi

    Add comment
    10|10000 characters needed characters exceeded