‎2007 Nov 15 6:06 PM
hi abapers
i have a query
while uploading data using anymethod how shd we handle the special
characters which r in the flat file.
thx in advance
‎2007 Nov 16 7:25 AM
Hi Rao,
while uploading data using GUI_UPLOAD
_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.
i think it will helps u.
<b>Reward is usefull</b>
‎2007 Nov 16 7:25 AM
Hi Rao,
while uploading data using GUI_UPLOAD
_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.
i think it will helps u.
<b>Reward is usefull</b>