topic Re: Save long text field in DataBase in Application Development and Automation Discussions

Save long text field in DataBase

muhammad_sohail — Thu, 25 Jun 2009 05:25:52 GMT

Dear All,

I have 9 long text fields in my own smart form. I want to save every long text to my own table.

Following thead i m using.

FORM txt_edit .

thead-tdobject = 'QMEL'.

thead-tdname = zlt_name.

thead-tdid = 'LTXT'.

thead-tdspras = 'E'.

thead-tdlinesize = '40'.

CALL FUNCTION 'READ_TEXT'

EXPORTING

client = sy-mandt

id = thead-tdid

language = thead-tdspras

name = thead-tdname

object = thead-tdobject

.....................

....................

.....................

Edit

commit

save

...............

How can i do that?

Thanks and Regards,

Sohail

Re: Save long text field in DataBase

Former Member — Thu, 25 Jun 2009 05:31:33 GMT

You can not save long text in the tables. For saving you need to use READ TEXT , SAVE TEXT Function modules and it will save in the Transaction Code : SE78. So you can save it with some numbers for reading later on.

Re: Save long text field in DataBase

Former Member — Thu, 25 Jun 2009 05:37:38 GMT

hi,

insted of READ_TEXT you use SAVE_TEXT or EDIT_TEXT

because EDIT_TEXT work like both read and save.

hope this hepls

Regards

RItesh J

Re: Save long text field in DataBase

Former Member — Thu, 25 Jun 2009 05:52:02 GMT

Hi,

You cannot directly save the long text to the database tables.

Instead you can use SAVE_TEXT function module to save your long text, after which in transaction SO10 the saved text can be viewed.

Use READ_TEXT to read the long text.

Thanks,

Sudagar Shanmugam

Re: Save long text field in DataBase

Former Member — Thu, 25 Jun 2009 09:27:29 GMT

Hi,

Use SAVE_TEXT Function module.

Regards,

Bhavana