Register Login

Convertion of special character turn into #

Updated May 18, 2018

I am Ulpoading a file in the step 'READ DATA' in LSMW and when I check the result in the next step 'DISPLAY READ DATA' I see that the upload (i do not know if LSMW make an WS_UPLAOD or GUI_UPLOAD or another function) converts a special character that we use in Portugal

in the file: Fabricação
in LSMW after Upload: Fabrica##o

The file was an Excel which I saved as txt (tab delimited)

Who can help??????


LSMW is having 'GUI_UPLOAD' function module to upload data.

GUI_UPLOAD FM is having import parameter CODEPAGE.Whose functinality is to take care of such special character.

Include which is called for READ DATA step, you can very wel find out that the codepage is not suitable for your Portuguese language.

Do one thing write an BDC...Call GUI_UPLOAD FM and then Pass CODEPAGE number.

codepage number you will get from tcp00 table.

here is example to take care of special Japanese character:

CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
filename = l_ws_path
filetype = 'ASC'
has_field_separator = '#'
codepage = '6300'
TABLES
data_tab = i_aenr
EXCEPTIONS
file_open_error = 1
file_read_error = 2
no_batch = 3
gui_refuse_filetransfer = 4
invalid_type = 5
no_authority = 6
unknown_error = 7
bad_data_format = 8
header_not_allowed = 9
separator_not_allowed = 10
header_too_long = 11
unknown_dp_error = 12
access_denied = 13
dp_out_of_memory = 14
disk_full = 15
dp_timeout = 16
OTHERS = 17.


×