Uploading file from desktop

[Former Member]

Hi,

I am using CRM 7.0. I want to upload a excel file into an internal table.Can anyone tell any function module in CRM 7.0?

[Former Member]

Hi,

I am using CRM 7.0. I want to upload a excel file into an internal table.Can anyone tell any function module in CRM 7.0?

[GauthamV]

Plz SEARCH in SCN before posting.

use this FM.

ALSM_EXCEL_TO_INTERNAL_TABLE

[Former Member]

Yes I know how to search in SCN...but are you sure Gautham Vangaveti that the FM is existing in CRM7.0!!!!! That is why I have mentioned CRM 7.0.

[Former Member]

Hi Jjammy,

See below code

CALL METHOD CL_GUI_FRONTEND_SERVICES=>GUI_UPLOAD

EXPORTING

FILENAME = LV_FILENAME

FILETYPE = 'DAT'

HAS_FIELD_SEPARATOR = ',' -

---

>"Use # instead of comma

HEADER_LENGTH = 0

READ_BY_LINE = 'X'

CHANGING

DATA_TAB = LT_UPLOAD_DATA

would work....or you can also try using FM: /RPM/CAP_PLAN_EXCEL_UPLOAD as an alternative.

Regards,

Vikram.S

[Former Member]

Hi,

Try for the following FMs.

I am not sure whether those FMs are in CRM or not.

TEXT_CONVERT_XLS_TO_SAP

KCD_EXCEL_OLE_TO_INT_CONVERT

Thanks and regards,

Venkat