UPLOAD

[Former Member]

Hi Gurus,

I need to upload Text DATA at each line item level of the Quotation (VA21 From an excel sheet .Tere r around 500 Line items and each will be loaded with text from excel sheet

Thank you very much in advance

[former_member609120]

FORM UPLOAD_EXCEL_FILE .

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

FILENAME = P_FNAME " File Name

I_BEGIN_COL = 1 " start Column

I_BEGIN_ROW = 2 " start row

I_END_COL = 22 " total columns

I_END_ROW = 9999 " max rows

TABLES

INTERN = IT_FILE_UPLOAD. " internal table

ENDFORM.

Use the above FM to upload data from excel sheet

[Former Member]

TEXT_CONVERT_XLS_TO_SAP

ALSM_EXCEL_TO_INTERNAL_TABLE

Reward if useful