Download data from STXL table.

[Former Member]

Hi,

I have to download data from table STXL.

I am using WS_DOWNLOAD.

STXL had a field CLUSTD of length 7902 with type LRAW.

After downloading i am getting the following result.

240 TX HRHAP00 01DDE70A8DD295CFF1B00500156004350500000018FAPP NOTE E 0 217 *

CLUSTD is not coming instead * is coming.

Please suggest how to download data from STXL table.

Thanks,

Ramotar.

[viquar_iqbal]

Hi

i have downloaded data sucessfully from STXL into excel sheet with clustd feild containing values as in table.

i just selected edit->download->spreadsheet format in se11 data browser.

Thanks

Viquar Iqbal

[Former Member]

first u fetch all the data into a internal table except the field CLUSTD

then loop the internal table and use FM "READ_TEXT" to fetch the field CLUSTD

[Former Member]

Hi,

You are not supposed to fetch the texts directly from the STXL table as it is stored in RAW format. You should use FM READ_TEXT to read the texts in program , then download as you are doing currently.

Search Forum to see sample codes for READ_TEXT FM or see the FM documentation.

Regards

Karthik D

[Former Member]

hi try this. put the cursor in the starting entries of your field . so as per your requirement clustid field. and press ctrl+y after that just drag the mouse up to the last entries .. right click ->copy text start->run->excel paste it. i hope it will aid u. regards suren.s

[Former Member]

using READ_TEXT U donwload data see the following example

data:tdid like stxl-tdid.

tdid = '0001'.

call function 'READ_TEXT'

exporting

• CLIENT = SY-MANDT

id = tdid

language = 'E'

name = saletext

object = 'MVKE'

• ARCHIVE_HANDLE = 0

• LOCAL_CAT = ' '

• IMPORTING

• HEADER =

tables

lines = lines1

exceptions

id = 1

language = 2

name = 3

not_found = 4

object = 5

reference_check = 6

wrong_access_to_archive = 7

others = 8

.