BDC

[Former Member]

Hi ,

i hav reqirement yhat i need to transfer an excel file from legacy system and i want to update in SAP standard tables.

which is the best way to do?

regards,

rao

[Former Member]

first you have to upload data from excel to internal tables using FM: ALSM_EXCEL_TO_INTERNAL_TABLE...after that you can upload data using GUI_UPLOAD.

Reward if useful.

Dara.

[Former Member]

Hi,

where should i write the function module,and the data in the excel shhet does nt hav fixed lengths.suppose i have a field by name amount :the value for amount are 304.45,4 respectively.will sap accept it?or we should give field lengths?

regards,

rao

[Former Member]

hi,

For uploading the data from excel file into the internal table use the function modules :

1. CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_FILENAME = ‘File path’

TABLES

I_TAB_CONVERTED_DATA = ‘Actual data’

or

2. CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

FILENAME = FILEPATH

I_BEGIN_COL =

I_BEGIN_ROW =

I_END_COL =

I_END_ROW =

TABLES

INTERN =

and for updating the data to sap database use call transaction or session method.