how to declare a custom field more than 255 characters?

[Rashmika_Dulaj]

I've to develop a custom database table which customer will directly use in SM30 to store data. One of the field has length 500 char. So I'm unable to open Table Maintenance Generator as character field more than 255 is not allowed in TMG(Table Maintenance Generator ). Can anyone please suggest how to solved with this issue?

[Sandra_Rossi]

You need a full custom solution for handling this. Apply any solution you want. Remember that a TMD (Table Maintenance Dialog) has its frontend generated as custom code that is calling standard code, so you may change it as you wish, but the drawback is that you risk losing your changes if you generate the TMD again (via the TMG).

[RaymondGiuseppi]

I would create a long text for this (FAQ) requirement, can be a specific long text (SE75) or use standard texts with a custom key (SO10).

• I would also replace the long field in the table with a language field (also a key field), a short text field and a flag for long text exists. But I would create those fields in a separate text table with correct foreign key relationship,
• Create/save long text only if required (longuer than short text) and synchronize first 'line' of long text with short text as SAP does usually.
• Use Event 22: Go to Long Text Maintenance for Other Languages where you could add some logic and call some display/edit long texts FM

[NooruBohra]

Do not put large text fields in Table. Use Text objects instead.
If that's not feasible, then Don't put that column in Table control. Create Text area and use that text area to get the longtext and store it in your table.

[Rashmika_Dulaj]

Thanks for your reply , Are you saying to remove the text field and create a text object? How to do that??

[NooruBohra]

There are lots of solution on community. Look for Long text in Module pool.

[NooruBohra]

There are lots of solution on community. Look for Long text in Module pool. Check programs SAPTEXTEDIT_DEMO_1, SAPTEXTEDIT_DEMO_2. here are couple of links https://community.sap.com/t5/application-development-discussions/how-to-use-text-area-in-module-pool...