topic Re: Table Creation Problem in Application Development and Automation Discussions

Table Creation Problem

praveen_hannu — Mon, 30 Jun 2008 06:06:27 GMT

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

Re: Table Creation Problem

Former Member — Mon, 30 Jun 2008 06:09:24 GMT

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.

Re: Table Creation Problem

Former Member — Mon, 30 Jun 2008 06:13:48 GMT

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

Re: Table Creation Problem

Former Member — Mon, 30 Jun 2008 06:34:32 GMT

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

Re: Table Creation Problem

Former Member — Mon, 30 Jun 2008 06:41:19 GMT

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

Re: Table Creation Problem

praveen_hannu — Tue, 01 Jul 2008 06:04:22 GMT

I have solved this...

Re: Table Creation Problem

viralkumar_patel — Wed, 09 Mar 2011 10:06:27 GMT

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