Skip to Content
avatar image
Former Member

Table length error

Friends,

I am working on a customized table. I have inserted 126 fields in the table so far.

When i activate the table, the error message "Table <name> is too long (>4030)" is encountered.

Please let me know how to resolve this issue. I would like to use a single table for my scenario instead of splitting data between 2 or more tables.

Thanks and Regards.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

7 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 04, 2008 at 02:24 PM

    Well you cannot avoid that restriction. Perhaps you can make a work around.

    I'm wondering, since string fields have dynamic lenght, you can create one string field, and then concatenate some of your field on it, separated by some special character like '&separator&. You can do this with fields that you won't use in select queries "where" condition.

    You can only have 3 of this fields (another restriction you cannot avoid! 😊 ).

    Regards.

    Valter Oliveira.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 04, 2008 at 02:32 PM

    Try to activate in Tcode SE14 - Database Utility,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 09:28 PM

    Hi,

    The following reasons might be possible:

    The total length of the output columns exceeds 4048.

    The total length of the output columns, together with the columns specified in the <ORDER clause> or <GROUP clause>, exceeds 4048.

    The total length of the output columns, together with the correlated columns and columns of <PREDICATE>s which contain a <SUBQUERY>, exceeds 4048 in an SQL statement with correlated subqueries.

    Thanks,

    Ravi Kanth

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 05, 2008 at 05:31 AM

    Hi,

    The problem because you had given the name of the table too long. Give the name of the table as 'ZNEW'.

    I think there is no restriction, you can use any number of fields in a table.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I tried activating in Tcode SE14 - Database Utility and still getting the same error.

      The table name does not matter as I still get the same error with 'ZNEW' as table name.

      Thanks and Regards.

  • avatar image
    Former Member
    Sep 05, 2008 at 09:39 AM

    Hi,

    I dont think there is any limit to the number of fields in a table.

    U can try renaming the table or creating a new one.

    Moreover you can refer to the following links....

    How many maximum number of fields can be in a table ?

    fields in a database table

    Check this help:

    http://help.sap.com/saphelp_nw04/helpdata/en/41/bf33c977c7f240832dcd166653ec29/content.htm

    Regards,

    Manish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 05, 2008 at 10:35 AM

    Hi,

    Check the BSEG table which consists of more than 300 fields.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      You better create a TEXT table for Descriptions and attach to your Ztable.

      Eg:-

      MARA -- Main table

      MAKT --- Text table for MARA

      You can access it from SE11, Menubar Goto > Text Table.

      Create a Text table in the following way

      1. Suppose

      zabc = Normal table

      ZABCT = Text table

      2. Create first ZABC table thru se11,

      with primary key field(s)

      3. Create ZABCT thru se11,

      and specify all the primary key field(s)

      of the first table,

      along with SPRAS (language field)

      4. When we specify the primary key of this table,

      a) We have to give check table as ZABC

      b) Specify all the primary key fields of ZABC table

      (along with mandt)

      c) Click the RADIO BUTTON,

      'key fields of a text table'.

      Regards

      Bala Krishna

  • avatar image
    Former Member
    Sep 12, 2008 at 03:21 AM

    Solved

    Add comment
    10|10000 characters needed characters exceeded