topic Re: BDC in Application Development and Automation Discussions

BDC

Former Member — Mon, 21 Apr 2008 10:40:07 GMT

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

Re: BDC

Former Member — Mon, 21 Apr 2008 10:42:53 GMT

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.

Re: BDC

Former Member — Mon, 21 Apr 2008 10:45:51 GMT

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

Re: BDC

Former Member — Mon, 21 Apr 2008 13:24:42 GMT

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’

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.