topic Re: Table length error in Application Development and Automation Discussions

Table length error

Former Member — Thu, 04 Sep 2008 14:20:09 GMT

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.

Re: Table length error

valter_oliveira — Thu, 04 Sep 2008 14:24:39 GMT

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.

Re: Table length error

former_member585060 — Thu, 04 Sep 2008 14:32:43 GMT

Try to activate in Tcode SE14 - Database Utility,

Re: Table length error

Former Member — Thu, 04 Sep 2008 21:28:25 GMT

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

Re: Table length error

Former Member — Fri, 05 Sep 2008 05:31:21 GMT

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.

Re: Table length error

Former Member — Fri, 05 Sep 2008 09:15:51 GMT

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.

Re: Table length error

Former Member — Fri, 05 Sep 2008 09:39:35 GMT

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

Check this help:

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

Regards,

Manish

Re: Table length error

Former Member — Fri, 05 Sep 2008 10:35:53 GMT

Hi,

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

Re: Table length error

Former Member — Fri, 05 Sep 2008 12:13:54 GMT

BSEG table does have 313 entries but most of them have length in single digit .

it is not the number of fields that matter but the cumulative length of the fields that should not exceed 4030.

Thanks.

Re: Table length error

former_member585060 — Sat, 06 Sep 2008 09:13:31 GMT

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

Re: Table length error

Former Member — Fri, 12 Sep 2008 03:21:06 GMT

Solved