topic Re: Storing text in Application Development and Automation Discussions

Storing text

Former Member — Mon, 15 May 2006 05:57:37 GMT

Hi Everybody

m back here

I want to store texts of about 500 characters

I have created a text box using controls along with one key field on the screen

Now i want that text to be saved and then again display when user enter the key

Can u plz tell me how to store the texts in the table

coz these tests doesnt store in the tables

Thanks in advance

Re: Storing text

sbhutani1 — Mon, 15 May 2006 06:02:28 GMT

Hi rashmi,

You can use the data type LCHR for storing your long text and then you can also fetch this data into your text box. if the length is not sufficient then you can use more than one LCHR field and the while displaying just concatenate those fields and then display

Regards

Sumit Bhutani

Re: Storing text

Former Member — Mon, 15 May 2006 06:06:44 GMT

Hi Sumit

thnks for ur quick response

but its not good idea to display a single line of length 500 chars or more

thatz y we have created a text box using control

and now i want to store and then again access the text

I have found that these texts doesnt store in the z-tables

so any idea about where does this text store and how sap stores this text and then again access the same

Thanks

Re: Storing text

Former Member — Mon, 15 May 2006 06:14:28 GMT

Hi guyz

m waiting for ur replies

Re: Storing text

FredericGirod — Mon, 15 May 2006 06:37:52 GMT

To store long text, you could use the tables STXH, STXL. Don't write directly in the tables, use the functions :

READ_TEXT

DELETE_TEXT

SAVE_TEXT

....

(function group LSTX)

Rgd

Frédéric

Re: Storing text

Former Member — Mon, 15 May 2006 06:59:19 GMT

Thanks Frederic for ur reply

i wann give points but not able to see those stars so will definately give latter

anyway.. i tries fg lstx.. its saying this fg doesnt exist

THanks

Re: Storing text

FredericGirod — Mon, 15 May 2006 07:01:16 GMT

Function group is STXD (I read to fast)

Fred

Re: Storing text

Former Member — Mon, 15 May 2006 07:28:57 GMT

Hi Frederic again

I am new to this

I have gone through the FM documentation .

In that we can transfer the text to the tables parameter

but can u plz tell me how to transfer this text to std table or how to link fm save_text with std table

Secondly i have gone thorugh tables stxh but in that therz no field exceeding length of 100

ya therz one field of type lraw in table stxd

so do we need to use the same for this purpose??

THanks a lot

Re: Storing text

Former Member — Mon, 15 May 2006 07:36:37 GMT

Rashmi,

There are three important paramters in reading and saving the texts like this.

TDOBJECT, TDNAME, TDID.

So, if you are not dealing with any of the texts of the documents like PO / SO, you can use SO10 transaction to do this.

TDOBJECT = TEXT

TDNAME = Whatever name you want

TDID = ST

Now, you can pass these values to the READ_TEXT and SAVE_TEXT funcitons to read and save texts.

Regards,

Ravi

Note : Please mark the helpful answers

Re: Storing text

athavanraja — Mon, 15 May 2006 07:43:41 GMT

if you are going to use FMs from function group STXD the text will be stored in the standard table where long texts for documents and standard texts are stored.

if you want to store them in custom table (Z)

you can create a ztable with field type string (if you are on WAS) or LCHR to hold large texts.

as far the formatting when you read the text from the textedit control use method GET_TEXTSTREAM to get the text from the control into a string . (all line breaks, tabx will be retained within the string)

this string you can then directly store it in database and when you want to read this text from database and set it in the text editor you can use method SET_TEXTSTREAM for the same.

Regards

Raja

Re: Storing text

Former Member — Mon, 15 May 2006 07:57:15 GMT

THanks Ravi

but can u plz bit elaborate the point

I have gone thru the transaction SO10.. therz option textname but as such no option tdobject

where do we need to mention all these tdobject, tdname and tdid and how do we relate this with fm save_text??

and ya Raja .. we need to store all these texts in std tables but we are accessing the key from z table

Thanks a lot

Re: Storing text

Former Member — Mon, 15 May 2006 08:01:42 GMT

and ya one more thing

in the documentation of fm save_text, therz a line like

"The function module writes a text module to the text file or text memory, depending on the specific <b>text object</b>"

so whatz this text object and whr do we need to mention this

Thanks once again

Re: Storing text

Former Member — Mon, 15 May 2006 08:02:22 GMT

Rashmi,

These are the values that you enter on SO10 transaction before you can see the text - First screen of SO10.

In case of a ZTABLE, all I have store is the name of the TEXT and I can retrieve that by passing the name to READ_TEXT. So, I don't have to worry about storing the entire text in the ZTABLE myself.

And the TDOBJECT / Object field on SO10 is what he is mentioning about, so in this case we are hard coding it to TEXT. If you see the texts of the PO / SO, it will have different values like , EKKO (For header), EKPO (For item) etc etc. See the table TTXID (Not sure of the exact name).

Regards,

Ravi

Note : Please mark all the helpful answers

Message was edited by: Ravikumar Allampallam

Re: Storing text

Former Member — Mon, 15 May 2006 08:29:05 GMT

Hi Ravi

le me explain my requirement again

What we want to do is

we have one z table and screen for these table fields

Now we want user to enter texts say description of length more than 300 chars

For this we can have one lchar type field in z table but we don want to display a single line on the screen

and thatz why instead of creating field of type lchar in the z table , we have created textcontrol using controls on the screen

Now i want to store and again access this text depending on the table key of ztable in the control on the same screen..

so what should be the approach

1. using FM save_text and read_text

when m using fm save_text,

its giving error message ' Text ID TID for text objt DMC does not exist"

Plz reply soon its argunt

Thanks

Re: Storing text

Former Member — Mon, 15 May 2006 08:32:51 GMT

Rashmi,

Yes SAVE_TEXT / READ_TEXT is the way to go with the key in the ZTABLe. While using SAVE_TEXT passing ST for TDID and TEXT for TDOBJECT and with whatever key as the TDNAME.

Now, you should be able to retrieve the same with the same values using READ_TEXT function.

Regards,

Ravi

Re: Storing text

Former Member — Mon, 15 May 2006 08:39:14 GMT

but where do we need to mention all these tdid, tdobjt, tdname

threz no such import parameter in fm save_text

thanks

Re: Storing text

Former Member — Mon, 15 May 2006 08:46:19 GMT

Look under the HEADER Parameters, I am not sure of the exact name. There will be a structure parameter under which all these will be there.

Regards,

Ravi

Note : Please mark all the helpful answers

Re: Storing text

Former Member — Mon, 15 May 2006 08:52:51 GMT

Check structure THEAD and pass it to Header of save_text .

Regards

Siddharth

Re: Storing text

Former Member — Mon, 15 May 2006 09:12:31 GMT

Thanks Siddharth, Ravi

I am now able to save the text as its not giving any error message

but now when i am trying to read it using read_text fm

its giving dump

The procedure is same for both read and save_text fm or its different??

I have given same parameters as :

CLIENT = SY-MANDT

ID = 'ST'

LANGUAGE = 'EN'

NAME = 'TKEY'

OBJECT = 'TEXT'

in the fm read_text

but its giving dump

Re: Storing text

Former Member — Mon, 15 May 2006 09:26:43 GMT

m waiting for ur replies