topic Re: excel File upload in Application Development and Automation Discussions

excel File upload

Former Member — Tue, 17 Feb 2009 10:08:12 GMT

Dear ABAP experts,

I have a file with article numbers and their respective serial numbers in excel format.

I want to use transaction IQ04. That means I want to update the transaction IQ04 with the article and serial numbers in SAP.

Can you please guide me as to how I can do this?

Thanks

Re: excel File upload

Former Member — Tue, 17 Feb 2009 10:12:42 GMT

UPLAOD FILE USING fm, gui_upload.

GO FOR THE bdc ON iq04.

Create a Recording through SHDB.

pass values uplaoded from file to BDC and update the transaction.

Re: excel File upload

Former Member — Tue, 17 Feb 2009 10:26:53 GMT

Hi,

Simply execute the below 2 steps:

1.upload the excel file dat into the internal fiel using the FM ALSM_EXCEL_TO_INTERNAL_TABLE/TEXT_CONVERT_XLS_TO_SAP

2. run the bdc for the Tcode with the fields you want to upload .

Pooja

Re: excel File upload

Former Member — Tue, 17 Feb 2009 10:29:01 GMT

Hi,

Upload the data by using the FM "ALSM_EXCEL_TO_INTERNAL_TABLE",

then go for BDC Call transaction method or session method.

Thanks,

Asit Purbey

Re: excel File upload

Former Member — Tue, 17 Feb 2009 12:17:10 GMT

Hi ANDY,

for IQ04 you can use BDC.

For uploading records from excel to internal table the best function module is 'TEXT_CONVERT_XLS_TO_SAP'


DATA : truxdata TYPE truxs_t_text_data.

  CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
    EXPORTING
*   I_FIELD_SEPERATOR          =
   i_line_header              = 'X'
      i_tab_raw_data             = truxdata 
      i_filename                 = p_input     " your input file path
    TABLES
      i_tab_converted_data       = itab    " your internal table where you will store exceldata
   EXCEPTIONS
     conversion_failed          = 1
     OTHERS                     = 2
            .
  IF sy-subrc <> 0.
    MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
            WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
  ENDIF.

Re: excel File upload

Former Member — Tue, 17 Feb 2009 13:58:27 GMT

Thanks for your valueable input.

I have a question if there is a possibility that one can automatise this.

that means the vendor sends a file this file then automatically trigger FM and the FM should update IQ04.

How can this be handled amd automatised that the information daily gets updated in SAP for the respective articles..

Thanks

Re: excel File upload

Former Member — Wed, 18 Feb 2009 04:00:04 GMT

Hello Andy,

This scenario can be achived through scheduling background job.

First you need to write a program (BDC for IQ04 ).

In that report you should give a particular path (fixed path) for your vendor file on application server.

Now create a background job for your program and schedule it daily(or as per your project need).

This job will run everytime and will pick the file from the application server and will execute.

In this case one thing should be remembered , i.e. the path of the file should be fixed.

Regards

Arindam

Re: excel File upload

Former Member — Wed, 18 Feb 2009 10:45:05 GMT

Hi,

Generally for uploading the data from flat file to sap GUI_UPLOAD

if the flat file is in excel format use the ALSM_EXCEL_TO_INTERNAL_TABLE fm

Regards,

Madhu

Edited by: Madhu Babu on Feb 18, 2009 11:47 AM

Re: excel File upload

Former Member — Thu, 12 Mar 2009 06:28:10 GMT