how do you work with semi colon separated files in bdc ?
Answer / ravi kanth @ reliance sap
There is FM GUI_UPLOAD which will help you in this.
Its has got one parameter calles has_field_separator . Here you can pass comma. So that this will take care while uploading the data in Internal table.
CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
filename = wf_file
filetype = 'ASC'
has_field_separator = ','
* HEADER_LENGTH = 0
* READ_BY_LINE = 'X'
* DAT_MODE = ' '
* CODEPAGE = ' '
* IGNORE_CERR = ABAP_TRUE
* REPLACEMENT = '#'
* CHECK_BOM = ' '
* IMPORTING
* FILELENGTH =
* HEADER =
TABLES
data_tab = it_data
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
Hope this will help you.
Is This Answer Correct ? | 0 Yes | 0 No |
Sy index and sy tabix
Why do we use logical blocks in abap program?
What is page window?
How to find the status of failure a IDOC
How do you use structures in the abap programs?
what are the prerequisites for using a bapi in your program?
Which of the following assigns work to the application server? Options ::Dispatcher, work process, roll area
what is the difference between at first & at new statements ?
Can a filed occur in several field groups? : abap modularization
What are the differences between sap memory and abap memory?
if we are inserting record in BDC,if poweroff how can you know how many records inserted?(poweroff yourside)
what is a value table?