topic Re: Error during Creating Z table in Application Development and Automation Discussions

Error during Creating Z table

Former Member — Fri, 26 Mar 2010 08:56:01 GMT

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

Re: Error during Creating Z table

Former Member — Fri, 26 Mar 2010 08:59:16 GMT

hi,

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

what is your requirement?

reagrds

RItesh

Re: Error during Creating Z table

Former Member — Fri, 26 Mar 2010 08:59:22 GMT

Hi shiv

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

and check the tecnical parameters

best regards

Marco

Re: Error during Creating Z table

Former Member — Fri, 26 Mar 2010 09:07:36 GMT

Still same error....

"Table ZQM12_TEXT is too long (>4030)"

Please Help.....

Rgds,

Shiv

Re: Error during Creating Z table

Former Member — Fri, 26 Mar 2010 09:09:44 GMT

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

Regards

Marco

Re: Error during Creating Z table

Former Member — Fri, 26 Mar 2010 09:12:54 GMT

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

Re: Error during Creating Z table

gaursri — Fri, 26 Mar 2010 09:16:09 GMT

Hi Shiv,

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

Link: [Thread|;

Have a best day ahead.

Re: Error during Creating Z table

Former Member — Fri, 26 Mar 2010 09:26:47 GMT

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.

Re: Error during Creating Z table

Former Member — Fri, 26 Mar 2010 09:28:13 GMT

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

Rgds,

Shiv

Re: Error during Creating Z table

Former Member — Fri, 26 Mar 2010 09:32:38 GMT

Have you tried with a cluster table?

Marco

Re: Error during Creating Z table

Jelena_Perfiljeva — Fri, 26 Mar 2010 21:13:52 GMT

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.

Re: Error during Creating Z table

ThomasZloch — Fri, 26 Mar 2010 21:58:59 GMT

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

Re: Error during Creating Z table

Former Member — Mon, 29 Mar 2010 04:52:05 GMT

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

Re: Error during Creating Z table

ThomasZloch — Mon, 29 Mar 2010 09:10:32 GMT

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

Re: Error during Creating Z table

Former Member — Mon, 29 Mar 2010 09:27:18 GMT

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