how do you work with semi colon separated files in bdc ?
Answer Posted / 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 |
Post New Answer View All Answers
How do you use tab sets in layout sets?
What are the client dependant objects in abap / sap?
How can we upload a text file having delimiters in to legacy system?
What is a collect statement?
dynamic programming in sap abap
What is its? : abap hr
How to upload data using catt ? : abap hr
How to insert a line into abap internal tables?
How to creat transactions? : abap data dictionary
How would you suppress the display of a parameter on the selection screen?
How do you write manual bdc session method? : abap bdc
What is roll area?
How to Raise a Particular Ticket in Realtime ?
foreign key enforcement?
What is a persistent class?