excel sheet

[Former Member]

hi

how to upload excel sheet into SAP using BDC

pls notify the function module .

regards

nageswara rao

hyderabad.

[gopi_narendra]

GUI_UPLOAD or ALSM_EXCEL_TO_INTERNAL_TABLE

function modules will upload the excel sheet data in to a internal table

Regards

- Gopi

[Former Member]

hi,

use FM <b>'ALSM_EXCEL_TO_INTERNAL_TABLE'</b>

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

FILENAME = p_infl

I_BEGIN_COL = 1

I_BEGIN_ROW = 2

I_END_COL = 8

I_END_ROW = 1000

TABLES

INTERN = T_DATA

EXCEPTIONS

INCONSISTENT_PARAMETERS = 1

UPLOAD_OLE = 2

OTHERS = 3.

IF SY-SUBRC <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

hope this helps,

do reward if it helps,

priya.

[Former Member]

Hi,

1) ALSM_EXCEL_TO_INTERNAL_TABLE

2) Gui_upload

3) ws_upload

4) FAA_FILE_UPLOAD_EXCEL

Try with this FM.

Thanks

Sunil