topic Re: Issue with adding Long charater field in custom table in Application Development and Automation Discussions

Issue with adding Long charater field in custom table

Former Member — Thu, 01 Oct 2009 11:13:37 GMT

I have added a URL ( Internet address ) field ZZSSOURIADDR with data element AD_URI whose domain is long character and length 2048.On activation table gives an message in a log

Field ZZSSOURIADDR does not have a preceding length field of type INT4.

What needs to be done to remove this error?

Re: Issue with adding Long charater field in custom table

RaymondGiuseppi — Thu, 01 Oct 2009 11:39:32 GMT

As specified in SAP documentation, this must be the last field, and the previous one must be the actual length field type INT2. (suggestion: use data element AD_URILNG)

LCHR: Character string of any length, but has to be declared with a minimum of 256 characters. Fields of this type must be located at the end of transparent tables (in each table there can be only one such field) and must be preceded by a length field of type INT2. If there is an INSERT or UPDATE in ABAP programs, this length field must be filled with the length actually required. If the length field is not filled correctly, this may lead to a data loss in the LCHR field! A fields of this type cannot be used in the WHERE condition of a SELECT statement.

If error message wasn't clear enough, then try a where-used in transparent table of the data element AD_URI.

NB: You could also use in your development the central address, actual URL would be stored in ADR12 and only ADRNR is in your custom database table, more development (look for BAPI BUPA) but smaller database.

Regards,

Raymond

Re: Issue with adding Long charater field in custom table

Former Member — Mon, 05 Oct 2009 11:00:24 GMT

Hai,

String data type is generally used for long character fields.So just use String data type instead of Char.

Regards ,

Venkat.

Re: Issue with adding Long charater field in custom table

Former Member — Tue, 06 Oct 2009 14:06:53 GMT

hi,

you can declare any field length of table upto 512 character length. add one more field called counter and split your url and save it.

Re: Issue with adding Long charater field in custom table

Former Member — Wed, 07 Oct 2009 07:09:58 GMT

Hai,

String data type is used for long character data.

For mass data , RAW data type is used.

Regards,

Venkat

Re: Issue with adding Long charater field in custom table

Former Member — Tue, 24 Nov 2009 12:16:40 GMT

You should add a new field (just before the LCHR data typed field) which has int2 data type.

Regards.

Akin Ozak

Re: Issue with adding Long charater field in custom table

Former Member — Wed, 25 Nov 2009 09:15:23 GMT

Hi,

Try out this option,

1. In your custom table create a field for GUID

2. Generate a guid using function module GENERATE_GUID.

3. Save the text using function module SAVE_TEXT by generated guid and store the guid in your table.

4. Function module READ_TEXT is used to display the text

Regards,

Kalp..