topic regarding about bdc in Application Development and Automation Discussions

regarding about bdc

Former Member — Wed, 05 Nov 2008 18:06:29 GMT

Hi expeerts,

I have data in four spread sheet for four tcode updation.give me some idea about this.

Thanks

Re: regarding about bdc

Former Member — Wed, 05 Nov 2008 18:09:06 GMT

Hi,

If you want to do this in one session ..You can do it by writing a Zprogram and reading your Excel into four different Internal Tables.

You need to do the Four Recordings also and you have to use four different Calls for the BDC_INSERT FM so as to update all in a Single Session.

Re: regarding about bdc

Former Member — Wed, 05 Nov 2008 18:11:11 GMT

Use session method for that.

create one session and

call the bdc_insert once for each of the transactions.

Re: regarding about bdc

Former Member — Wed, 05 Nov 2008 18:37:49 GMT

Thank you

Re: regarding about bdc

former_member156446 — Wed, 05 Nov 2008 18:45:34 GMT

this will be the code to read the data from excel file

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
       EXPORTING
            filename                = filename
            i_begin_col             = begcol
            i_begin_row             = begrow
            i_end_col               = endcol
            i_end_row               = endrow
       TABLES
            intern                  = intern
       EXCEPTIONS
            inconsistent_parameters = 1
            upload_ole              = 2
            OTHERS                  = 3.

  IF sy-subrc <> 0.
    WRITE:/ 'Upload Error ', SY-SUBRC.
  ENDIF.