Table length error

[Former Member]

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.

[valter_oliveira]

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.

[former_member585060]

Try to activate in Tcode SE14 - Database Utility,

[Former Member]

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

[Former Member]

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.

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

[Former Member]

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

[Former Member]

Hi,

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

[Former Member]

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.

[former_member585060]

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

[Former Member]

Solved