Error during Creating Z table

[Former Member]

Dear All,

I am trying to create Z-Table in se11 with 56 fields.Out of 56 fields, 50 fields are type of String.

while activating the table system is giving error saying.....

"Table contains more than 3 long string fields" and if i am giving data type Char and each field length 200 char.

than error is "Table ZQM12_TEXT is too long (>4030)".

Please help me.

Thanks in Advance!!!!!!!!!

Best Rgds,

Shiv

[Former Member]

hi,

why you want to create the so many long field in your table?

what is your requirement?

reagrds

RItesh

[Former Member]

Hi shiv

try to change the data type string with a type char100 or text132...

and check the tecnical parameters

best regards

Marco

[Former Member]

Still same error....

"Table ZQM12_TEXT is too long (>4030)"

Please Help.....

Rgds,

Shiv

[Former Member]

but you really need of all this fiedl of type string??or you simply need a char10?

Regards

Marco

[Former Member]

hi

Change the datatype string to some other data type...

[Former Member]

i had changed the all fields char 132 but still same error.

Rgds,

Shiv

[Former Member]

Have you tried with a cluster table?

Marco

[ThomasZloch]

...or introduce an additional key field (line number, identifier, whatever) or maybe a second, related table and cut it down to just 1 string field this way.

Thomas

[gaursri]

Hi Shiv,

Look at the thread may be you resolve your query soon.

Link: [Thread|;

Have a best day ahead.

[Former Member]

It is not possible to enter fields with length greater than 4032 using transperent tables.

For ur requirement, u have to create a cluster table which allows longtexts and documentation.

[Jelena_Perfiljeva]

I have to repeat the same question for the third time - why on earth do you need a transparent table with so many huge string fields?

Wouldn't it be more efficient to use texts (STXH) to store this information? Instead of trying to "break the system", we could've suggested a better/simpler solution if you could clarify what you're trying to achieve.

[Former Member]

Dear Jelena,

My requirment is: I have to print a quality certifiate by smartform.in that there is are some texts in the half of the page.

and that texts is frequently being change.

That's y user is asking to give a Z table instead of doing change everytime.

Hope u understood my problem.

Rgds,

Shiv

[ThomasZloch]

I think she did, but you didn't understand her suggestion.

Having so many text lines as separate database columns is just bad design, two possible solutions were already given in this thread.

Thomas

[Former Member]

Hello Shiv,

lets get this straight. the error message you get is that your table is too long (wide). Like it seems 4030 is the maximum amount of characters for a table unless we speak of cluster tables.

1. So you either can reduce the number of characters of each of your (text/char/string)-fields to fit this condition, or you could reduce the number of fields until you match the condition.

2. Since you are talking of texts which have to be printed on a smartform, i want to introduce transaction SO10 to you.

There we can store standard texts in a SAP system. Those texts are easily maintainable on TA SO10 and fulfill everything you need you just dont need to create any new table, and so wont have problems.

My answer nw is a bit of a general one since i dont really get what your requirement is, if i were better informed i could help the better.

regards