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
SAP query how to use end users?
Hi my dear friends,Please give the answers for the following link http://www.saptechnical.com/InterviewQ/interviewQ.htm
What is alv programming in abap?
Explain the advantages of abap query tool?
How many ways you can create table? : abap data dictionary
What is a report?
wht is the diff. b/n initialization and lotus of event
what are the two methods of modifying sap standard tables? : abap data dictionary
How do you take care of performance issues in your ABAP programs?
How many detail lists can be created in interactive reporting?
How do you Export a session ?
Explain what is sap script?
Define database layer? : abap data dictionary
if while coding power goes off , how to retrieve the codes?
What are function modules?