Issue with adding Long charater field in custom table

[Former Member]

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?

[RaymondGiuseppi]

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

[Former Member]

Hai,

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

Regards ,

Venkat.

[Former Member]

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.

[Former Member]

Hai,

String data type is used for long character data.

For mass data , RAW data type is used.

Regards,

Venkat

[Former Member]

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

Regards.

Akin Ozak

[Former Member]

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