topic Re: Data uploading in Application Development and Automation Discussions

Data uploading

Former Member — Tue, 18 Jul 2006 06:12:12 GMT

Hello all,

Can we upload the data from .Xls (or) .Dat to z_table with out using BDC??

If yes, Pls describe me the process.

Thnx in advance.

sreenivas

Re: Data uploading

dani_mn — Tue, 18 Jul 2006 06:15:37 GMT

Hi,

ya you can.

first use 'GUI_UPLOAD' function module to upload data from excel or dat file into internal table.

then use this internal table to update z_table directly using. 'MODIFY' or 'INSERT' command.

TABLES: z_table.

LOOP AT itab.

MOVE-CORRESPONDING itab TO z_table.

INSERT z_table.

ENDLOOP.

Regards,

Wasim Ahmed

Re: Data uploading

aris_hidalgo — Tue, 18 Jul 2006 06:23:17 GMT

Hi,

You can use the function module GUI_UPLOAD. By using this, you can upload your file into an internal table.

Regards!

P.S. Please award points if helpful

Re: Data uploading

naimesh_patel — Tue, 18 Jul 2006 06:26:22 GMT

Hello,

You can use INSERT or MODIFY statment to insert / change data into your ztable. But don't forget to populate your MANDT (client) in the database table.

Regards,

Naimesh

Re: Data uploading

Former Member — Tue, 18 Jul 2006 06:37:03 GMT

Hi Sreenivasalu,

Yes its possible to update DB table directly.

Consider I am updating DB table MARA.


REPORT zztest.



DATA : it_mara TYPE STANDARD TABLE OF mara WITH HEADER LINE,
       ftemp TYPE string.

PARAMETERS : p_file TYPE rlgrap-filename DEFAULT 'C:UPLOADdata'.

START-OF-SELECTION.

  <b>CONCATENATE p_file '.xls' INTO p_file.  "(or .dat file as required)</b>
  ftemp = p_file.
  CONDENSE ftemp NO-GAPS.


  CALL FUNCTION 'GUI_UPLOAD'
    EXPORTING
      filename                = ftemp
      filetype                = 'ASC'
      has_field_separator     = '#'
    TABLES
      data_tab                = it_mara[]
    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 ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
            WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
  ENDIF.


<b>  MODIFY  mara     FROM TABLE it_mara.</b>

Note : Standard table like MARA, MARC etc, shouldnt be updated directly, either use FM's or BAPI in any case. Its fine if you are updating a custom table.

Regards,

Arun Sambargi.

Re: Data uploading

Former Member — Tue, 18 Jul 2006 06:40:36 GMT

Hi sreenivasulu

You can use the function 'ALSM_EXCEL_TO_INTERNAL_TABLE' tu upload your ecel file in the internal table. then you can use the insert statement to update the data in the table without using BDC. But remind that intarnal table must conatin the field MANDT and its value must be equal to your client in which you want to upload the data.

Regards,

Varun Sanghi