topic STRING field in a table in Application Development and Automation Discussions

STRING field in a table

Former Member — Mon, 11 Jun 2007 19:04:35 GMT

I have a table in SAP(PLM) where I need to change the existing 255 CHAR fields to 1250 CHAR long. There are six fields in the table that I need to change. All the BAPIs using the table are all created and so using LCHAR data type is not going to be very easy. I have changed the data types of these fields to STRING. But it seems like SAP would allow only three fields in a table to have STRING data type. All the three fields that I changed to STRING type are working good. Is there any other data type that I can use to fit 1250 characters?

Re: STRING field in a table

RichHeilman — Mon, 11 Jun 2007 19:07:53 GMT

Have you tried RAWSTRING?

Regards,

RIch Heilman

Re: STRING field in a table

Former Member — Mon, 11 Jun 2007 19:29:38 GMT

Just tried RAWSTRING. It gives activation warnings and leaves the table Partly active. Following is the warning..

Table contains more than 3 long string fields

Field ZZPERFDET: Type change

ALTER TABLE is not possible

Re: STRING field in a table

RichHeilman — Mon, 11 Jun 2007 19:44:47 GMT

How about storing as long text using text objects and ids. You can use the SAVE_TEXT and READ_TEXT function modules and create your custom objects/ids via transaction SE75.

You can create one object with 3 ids to represent your 3 different long text fields.

Regards,

RIch Heilman

Re: STRING field in a table

Former Member — Tue, 12 Jun 2007 03:30:51 GMT

just try place the<b> remaining 3 fields in the new structure</b> and activate the structure ...

then <b>include the structure in the same table </b> it would work i think...

Girish

Re: STRING field in a table

Former Member — Tue, 12 Jun 2007 06:07:20 GMT

Hi ,

i think any table can have maximum of 4000 char as its length( check for the exact no..)

If it crosses that it wont be activated.

and also see the following from sap help.

STRING

Character string of variable length. This type may not be used in database tables. In ABAP this type is implemented as a reference to a storage area of variable size.

RAWSTRING

Uninterpreted byte string of variable length. This type may not be used in database tables. In ABAP this type is implemented as a referece to a storage area of variable size.

so i think its better to display as char and required length.

Cheers,

Vasant..

Re: STRING field in a table

Former Member — Tue, 12 Jun 2007 06:16:09 GMT

i thinkk u cant decalre a char not max than 255 ..