Table Creation Problem

[praveen_hannu]

Hi Experts

I got a requirement to create a table in data dictonary, I have around 20 fields, among them 12 are character fields, 2 are Raw datatype fields and remaining are intiger fileds.

Here my problem is among character fields 11 are having 256 as length and 1 is having 10000 as lenght.

Two raw fields are having 1000 and 10000 as length.

When I am using String insted of char and Rawstring insted of Raw, system is throwing an error, table

contains morethan 3 long string fields.

Please give me solution, how can I acheive these, this is a urgent requirement.

Regards

Praveen

[Former Member]

hi,

Standard size of a table to be created should be less than 1962

and a field length is 1<length>255.

you can not create a field or table exceeding this limit.

[Former Member]

Hi Praveen,

A table field can have a length maximum of 255 characters. You cannot exceed that length. Make sure that you donot cross that limit.

Hope this helps you.

Any queires, get back to me.

Regards,

Chandra Sekhar

[Former Member]

hi,

There is no way to declare a table with a field length of 1000 charaters.

As you know SAP has defined the field length for tale fields as 256 only you cannot exceed that limit.

Try to cut short the length of the data.

Hope this will help.

Sumit Agarwal

[Former Member]

You can use LCHR type and declare as much as you can.

But you need to use that filed along with INT2 field.

For reference you can check this table..

TVEP6

[praveen_hannu]

I have solved this...

[viralkumar_patel]

Hi Praveen,

How did u solve this problem? can you please share it so that I can also make use of it... I want to store long text(ie. description) in db.

Thanks & Regards,

Viral