lenght not more than 50 accepted in FM ALSM_EXCEL_TO_INTERNAL_TABLE

[Former Member]

Hi guys,

In the function module ALSM_EXCEL_TO_INTERNAL_TABLE we will get the data in to internal table with structure ALSMEX_TABLINE.

In this structure it only allows 50 char length for a field. But my field length is in 120.

Is the any other FM to capture the entire length of the field.

Regards

Mac

[SimoneMilesi]

KCD_EXCEL_OLE_TO_INT_CONVERT

And there are tons of example all over the web

[Former Member]

hello,

I am asking the Fm where we an capture more than 50 characters.

Ur FM provides only 32 char.

[former_member194669]

Please fm TEXT_CONVERT_XLS_TO_SAP, please search in this forum you can find few sample codes how to use this

a®

[rosenberg_eitan]

Hi,

I did not have the chance to use TEXT_CONVERT_XLS_TO_SAP .

Is the input file a binary native Excel or is it a comma/tab separator text file ?

Regards.

[Former Member]

hi try this

ISU_S_EDM_EXCEL_EXPORT

[Former Member]

hi,

The FM will work in ISU not in the SAP r/3.

Regards

mac

[Former Member]

Solved myself.

[bindu_ramachandran]

Hi Mac,

I have the same issue.   I will be getting a string value in the column of excel , but the FM restricts to only 50 characters. Could you please let me know who you have solved this issue.

Regards,

Bindu.

[Former Member]

Hi Bindu,

I used the method

CALL METHOD cl_gui_frontend_services=>gui_upload

to upload the file and split the data according to the delimiter.

Regards

Mac

[bindu_ramachandran]

Thanks Mac.

Actually I solved this issue by copying this function module to the custom function module and changing the 50 chars to 256 chars. It is working fine.

Thanks and Regards,

Bindu Ramachandran.