Getting the header as first record while uploading excel file using bdc

[Former Member]

Hi all,

I am new to abap. I have created a bdc program to upload an excel file for updating esi no in pa30. The excel sheet has the header as first row(like eno,esino,etc). Whlle debugging i c that the first record takes the heading values. How can this be rectified.

I am using ALSM_EXCEL_TO_INTERNAL_TABLE function for uploading the excel file.

Please help me resolving this issue otherwise the program is working fine.

Thanks in regards,

Ashok

[JoffyJohn]

set i_begin_row = 2

in function module

to read from second row of excel

[Former Member]

Hi Ashok ,

You can set the paramater I_BEGIN_ROW in the FM as 2.

Regards,

Arun