topic Re: bdc upload file data into internal table problem with gui_upload fm in Application Development and Automation Discussions

bdc upload file data into internal table problem with gui_upload fm

Former Member — Wed, 30 Apr 2008 16:01:00 GMT

Hello experts,

my coding is like this ..

data : begin of itab occurs 0 .

field1 like mara-matnr,

field2......

etc,

end of itab.

data: file1 type string.

parameter :file like rlgrap-filename.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR file.

CALL FUNCTION 'KD_GET_FILENAME_ON_F4'

EXPORTING

static = 'X'

mask = space

field_name = 'FILE'

CHANGING

file_name = file.

START-OF-SELECTION.

FILE1 = FILE . "HERE I AM PASSING INTO STRING

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = FILE1

FILETYPE = 'ASC'

has_field_separator = 'X'

TABLES

data_tab = itab. " here the data is not populating from the file , it is giving the error like speified table not found.

HERE i am getting the message like "specified table name not recgonised" . the data is not populating into the itab from the file.

file structure is same as the internal table.

I stored the file as .txt( ie in notepad).

my file is like this..

10000 200 323 sunndarrr.......

i had a problem with this bdc , i am getting like "specified table name not recgonised" in the fm gui_upload while debugging.

when i am using the ws_upload it is working fine.

please guide me where i have done the mistake.

thank you so much for all the replies.

Re: bdc upload file data into internal table problem with gui_upload fm

Former Member — Wed, 30 Apr 2008 16:05:14 GMT

Hi,

Change the field separator to '#' from 'X'.

Thanks,

Pranav

Re: bdc upload file data into internal table problem with gui_upload fm

Former Member — Wed, 30 Apr 2008 16:05:43 GMT

Hi,

Have a look on the following code.

TABLES: kna1.

DATA: BEGIN OF itab1 OCCURS 0,

str(255),

END OF itab1.

DATA: itab2 TYPE kna1 OCCURS 0 WITH HEADER LINE.

CALL FUNCTION 'WS_UPLOAD'

EXPORTING

filename = 'D:\ABAP EVE\ffile1.txt'

filetype = 'ASC'

TABLES

data_tab = itab1

EXCEPTIONS

conversion_error = 1

file_open_error = 2

file_read_error = 3

invalid_type = 4

no_batch = 5

unknown_error = 6

invalid_table_width = 7

gui_refuse_filetransfer = 8

customer_error = 9

no_authority = 10

OTHERS = 11.

IF sy-subrc <> 0.

WRITE:/ 'sorry'.

ELSE.

LOOP AT itab1.

SPLIT itab1-str AT ',' INTO itab2-kunnr itab2-name1.

APPEND itab2.

ENDLOOP.

IF sy-subrc = 0.

LOOP AT itab2.

WRITE:/ itab2-kunnr,itab2-name1.

INSERT INTO kna1 VALUES itab2.

ENDLOOP.

IF sy-subrc = 0.

WRITE:/ 'inserted'.

ELSE.

WRITE:/ 'not inserted'.

ENDIF.

ELSE.

WRITE:/ 'fail'.

ENDIF.

Flat file:

10001,Sadney

10003,Yogesh

20005,Madan

1.U need to define internal table with one field of max size

2.upload the flat file data into that internal table

3.split that internal table data into another internal table(having fields)

<REMOVED BY MODERATOR>

thanks,

Chandu

Edited by: Alvaro Tejada Galindo on Apr 30, 2008 12:17 PM

Re: bdc upload file data into internal table problem with gui_upload fm

former_member156446 — Wed, 30 Apr 2008 17:35:05 GMT

Hi shiva

dont forget to handle the exceptions..


data: i_dwl type standard table of string.

  call function 'GUI_UPLOAD'
    exporting
      filename                = vl_fname
      filetype                = 'ASC'
      has_field_separator     = ' '
    tables
      data_tab                = i_dwl
    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.
  if sy-subrc <> 0.
    message e074(zv).
  endif.