topic Re: Updateing excel sheet in Application Development and Automation Discussions

Updateing excel sheet

Former Member — Mon, 15 Sep 2008 06:45:06 GMT

Hi,

I have got a task to write my BDC program such tht my end user will update the excel sheet using BDC Txcode as he updates the data in his local machine.

For this the logic that i have used is i have selected my maximum value from my table and that i have holded i a local variable and that local variable i have assigned in my begin of row. But it is taking me to RUN time error.

My code...

data: SL TYPE I,

S TYPE I.

SL = 0.

S = 0.

SELECT MAX( FASLN ) INTO S FROM ZRPFORMA1.

SL = S + 1 .

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = P_FNAME

i_begin_col = 1

i_begin_row = SL

i_end_col = 44

i_end_row = 5

TABLES

intern = IT_FILE_UPLOAD

where u can see i have assigned SL in the begin of my row, i want to know whether this is correct or wrong.

Thks

Re: Updateing excel sheet

Former Member — Mon, 15 Sep 2008 08:10:11 GMT

I think it will be correct.

Re: Updateing excel sheet

Former Member — Mon, 15 Sep 2008 08:29:11 GMT

I think The short dump occurs because of output length, check the data type and length of FASLN.

correct your select statement as bellow

SELECT count( distinct FASLN ) INTO s FROM ZRPFORMA1

or correct data type and lenght oif variable S

Thanks

Ganesh

Re: Updateing excel sheet

Former Member — Tue, 23 Sep 2008 15:17:08 GMT

Close.