Skip to Content
author's profile photo Former Member
Former Member

Want to have field in table with 5000 characters length - Is it possible???

Hi All,

My requirement is to have a field in a custom database table with length 5000.

When i try to activate the database table, i am getting the following error

'Field is too long (Specifiy a length between 1 to 255).

I have tried using the field type as STRING but there is no use.

If you have any solution then please let me know.

Regards,

Mallika

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Sep 08, 2011 at 05:38 AM

    Hi Mallika,

    Welcome to SDN.

    Well, as you might have noticed the length of a defined table is 4096. If you use the last field of your table with a predefined type of RAWSTRING, then, it can be of help.

    Also, when I had faced a similar problem, I chose to divide my single fields into multiple smaller fields (field1, field2, ......, fieldn) and in multiple tables to synchronize with RFC's.

    Regards,

    Pranav.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Mallika ,

      I just tried to create RFC function contains table with long text and activate it. I think use table type is OK. Be careful about set pass by value in parameter definition.

      In my RFC, I have one Import parameter with type string, and this parameter checked as Pass by Value. I have one Tables parameter with type 'Z_T_LONGTXT' and type 'Z_T_LONGTXT' is a table type. In this table type's structure there is one field with type DI_DATA.

      This RFC is just for test, so only 2 parameter in it. At first I didnot chek Import parameter as Pass by Value, and the message was post("Reference parameters are not allowed with RFC"), I think it maybe the real problem.

      Hope this will be helpful.

      Thanks & Regards

      T Bharat Bhushan

  • Posted on Sep 08, 2011 at 06:41 AM

    Hi mallika,

    You can use the predefined data type LCHR, the condition you should follow is it should be the last field in the table and the preceding field should be of type int4.

    This will work for sure.

    Regards,

    Ramesh.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 08, 2011 at 06:46 AM

    how-to-store-long-text-in-db

    You can even search for predefined datatypes in SE11 and search for CHAR

    Edited by: Sim on Sep 8, 2011 8:58 AM

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.