‎2007 Nov 19 3:36 AM
hi
i use the function GUI_DOWNLOAD download data to PC CLIENT.
CALL FUNCTION 'GUI_DOWNLOAD'
EXPORTING
BIN_FILESIZE =
FILENAME = FILENAME
FILETYPE = 'DAT'
APPEND = ' '
WRITE_FIELD_SEPARATOR = ' '
HEADER = '00'
TRUNC_TRAILING_BLANKS = ' '
WRITE_LF = 'X'
COL_SELECT = ' '
COL_SELECT_MASK = ' '
DAT_MODE = ' '
CONFIRM_OVERWRITE = ' '
NO_AUTH_CHECK = ' '
CODEPAGE = '8600'
IGNORE_CERR = ABAP_TRUE
REPLACEMENT = '#'
WRITE_BOM = ' '
TRUNC_TRAILING_BLANKS_EOL = 'X'
WK1_N_FORMAT = ' '
WK1_N_SIZE = ' '
WK1_T_FORMAT = ' '
WK1_T_SIZE = ' '
IMPORTING
FILELENGTH =
TABLES
DATA_TAB = P_OUT_LOG
FIELDNAMES =
EXCEPTIONS
FILE_WRITE_ERROR = 1
NO_BATCH = 2
GUI_REFUSE_FILETRANSFER = 3
INVALID_TYPE = 4
NO_AUTHORITY = 5
UNKNOWN_ERROR = 6
HEADER_NOT_ALLOWED = 7
SEPARATOR_NOT_ALLOWED = 8
FILESIZE_NOT_ALLOWED = 9
HEADER_TOO_LONG = 10
DP_ERROR_CREATE = 11
DP_ERROR_SEND = 12
DP_ERROR_WRITE = 13
UNKNOWN_DP_ERROR = 14
ACCESS_DENIED = 15
DP_OUT_OF_MEMORY = 16
DISK_FULL = 17
DP_TIMEOUT = 18
FILE_NOT_FOUND = 19
DATAPROVIDER_EXCEPTION = 20
CONTROL_FLUSH_ERROR = 21
OTHERS = 22
.
in the inter table have a field of content: 455330801880518000
in my concept it's text string,but when download it and make EXECL file.
will get the result is :4.55331E+17
how to set it and i can down load it with text .
thank you !
‎2007 Nov 19 3:39 AM
just make the column size bigger which can display the entrie number in the excel.
Say around 30 .. select the column, right click > column width .. put 30 there.
Regards,
Naimesh Patel
‎2007 Nov 19 3:39 AM
in excell first colum click double.
it will show full value.
ex.
kar|->duble click
it will show karthik.
123| ->duble click.
it will show1234567890
‎2007 Nov 19 3:39 AM
Hi,
IN the Excel after you download you can change the format to number and you will get the result as you need.
Regards,
Lijo Joseph
*Reward if useful.
‎2007 Nov 19 3:43 AM
This is just the display
drag the edge of the column to change its width and display the entire contents