topic Re: retrieve long text from db in Application Development and Automation Discussions

retrieve long text from db

Former Member — Tue, 07 Oct 2008 10:07:56 GMT

I have a quotation order, and I have to retrieve the long text about the quotation ID. I see I have to use the READ_TEXT function, but I can't find how to use it in this way.

Can anybody help me please?

Thanks

Gabriel

Re: retrieve long text from db

Former Member — Tue, 07 Oct 2008 10:10:47 GMT

Open the quotation, go to the particular long text and than

GO TO -> HEADER

you will get TDID, TDNAME, TDOBJECT.

Pass the same values to Read_text function module

Regards

Madhan

Re: retrieve long text from db

Former Member — Tue, 07 Oct 2008 10:16:03 GMT

thanks for your help, but this is the first time I am doing something like this, so please, could you be a little more specific?

How can I "open quotation"?

Re: retrieve long text from db

Former Member — Tue, 07 Oct 2008 10:20:54 GMT

Just Double click on Script editor where your text was written.than from Goto>header>note all necessary information of ID

LANGUAGE

NAME

OBJECT than use this like below

CALL FUNCTION 'READ_TEXT'
    EXPORTING
      client                  = sy-mandt
      id                      = stxh-tdid
      language                = stxh-tdspras
      name                    = name
      object                  = stxh-tdobject
    TABLES
      lines                   = i_lines[]
    EXCEPTIONS
      id                      = 1
      language                = 2
      name                    = 3
      not_found               = 4
      object                  = 5
      reference_check         = 6
      wrong_access_to_archive = 7
      OTHERS                  = 8.

Re: retrieve long text from db

Former Member — Tue, 07 Oct 2008 10:23:19 GMT

You can open the quotation using VA23 transaction, go to the particular long text and than

GO TO -> HEADER

you will get TDID, TDNAME, TDOBJECT.

Pass the same values to Read_text function module using SE37 transaction.

Regards

Re: retrieve long text from db

Former Member — Tue, 07 Oct 2008 10:23:33 GMT

Good

Checke the below link, this will give you the idea to use the READ_TEXT.

http://www.sap-basis-abap.com/sapac002.htm

Thanks

mrutyun^

Re: retrieve long text from db

Former Member — Tue, 07 Oct 2008 10:37:13 GMT

when I do

GOTO -> HEADER

a tabstrip is shown, and there are many tab, I look in each field of this tabstrip, but I can't find the fields you tell me.

where are there?