topic Re: Storing long text data in Application Development and Automation Discussions

Storing long text data

Former Member — Wed, 01 Oct 2008 08:33:03 GMT

Hi All,

I have a small requirement. I need to store long text data (maybe 5000 characters) in the SAP. And also I need to retrieve the data whenever I need it.

Please guide me how can I achieve the same technically.

Just for your information, I have designed a z-table with the following fields -

1. MANDT

2. KEY FIELD

3. A field whose data type is SMO_LNGTXT (Attachment Pointer - long text data)

But I do not know how to make use of attachment pointer in order to store and retrieve long text data.

Please guide me how to achieve this, either by following the approach I have taken up or any new approach which u suggest.

Thanks in advance,

Pradipta Paul.

Re: Storing long text data

Former Member — Wed, 01 Oct 2008 08:36:18 GMT

use fm

READ_TEXT

to read the long text,

EDIT_TEXT to edit long Text

Regards,

Alpesh

Re: Storing long text data

Former Member — Wed, 01 Oct 2008 08:37:40 GMT

You can create a standard text for each key field using FM 'SAVE_TEXT'.

Regards,

Aparna

Re: Storing long text data

Former Member — Wed, 01 Oct 2008 08:39:59 GMT

But how do i do the same using these two FMs. I also need a reference to the data which I shall be storing, so that I can retrieve the sam in the future.

Re: Storing long text data

Former Member — Wed, 01 Oct 2008 08:45:15 GMT

Use

TDOBJECT = 'TEXT'

TDNAME = ur key field

TDID = 'ST'

TDSPRAS = sy-langu

Create standard text using FM 'SAVE_TEXT' which will create standard text. Enter long text in 'lines' of this FM.

This will create long text which is stored in standard text for each key field.

Read standard text using FM' READ_TEXT'.

I hope this will work.

Regards,

Aparna

Re: Storing long text data

Former Member — Wed, 01 Oct 2008 09:09:17 GMT

you should be carefull about the datatype

you may use lchr or rawstring

for this case

Re: Storing long text data

Former Member — Thu, 02 Oct 2008 16:53:14 GMT

Hi All,

Thanks for the answers. But I could see that the FM cuts the text at 132 characters only. The rest of the text is missed out. Pls help me in this regard.

Regards,

Pradipta Paul.

Re: Storing long text data

Former Member — Thu, 02 Oct 2008 21:13:06 GMT

Hi Pradipta,

Use the Read, Save, Delete text FMs in conjunction with these FMs:

- CONVERT_STREAM_TO_ITF_TEXT, to save text

- CONVERT_ITF_TO_STREAM_TEXT, to read and display text.

You will be using a container object cl_gui_textedit, this is the text box that will display your data.

So, to display your data, you create your object. Call READ_TEXT to get the data into an internal table and then call CONVERT_ITF_TO_STREAM_TEXT which creates another internal table which you pass to display on your screen.

After editing data from the screen, you call CONVERT_ITF_TO_STREAM_TEXT and then call SAVE_TEXT to save your data.

Hope this helps.

Filler

Re: Storing long text data

Former Member — Thu, 23 Oct 2008 04:45:34 GMT