Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Uploading latest value of Excel sheet?

Hi,

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

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

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question