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 to find the return code of a statement in abap programs?
What are the data types of the external layer?
Explain what is an rfc?
How many types of size categories and data classes are there? : abap data dictionary
What is append structure?
Can i Have Some Realtime Examples On Modulepool programming.
A function module can be called from a transaction screen outside an abap/4 program. State true or false. : abap modularization
Explain what is step-loop?
Does the call transaction method allow multiple transactions to be processed by sap? : abap bdc
What happens if only one of the commands set screen and leave screen is used without using the other?
What is processing class, where we do them and why? : sap abap hr
What is the difference between leave transaction and call transaction?
In a loop of an internal table, what is the use of at first & at last statements?
What is the t-code for transaction recorder? : abap bdc
What are the difference between tables and structures?