quantity field conversion error

[Former Member]

Hi Experts,

I am trying to convert excel to internal table using FM 'TEXT_CONVERT_XLS_TO_SAP'. Facing issues in quantity field conversion.

If user enters '11.5' as quantity in excel, FM 'TEXT_CONVERT_XLS_TO_SAP' is converting it to '11.05.2020'. Tried char, string and kwmeng data types but still facing same issue.

I cannot use FM 'ALSM_EXCEL_TO_INTERNAL_TABLE' as I need this program to run in background as well and we may have huge data.

Please help me in solving this issue

[Former Member]

Use abap2xlsx (it also does XLSX to ABAP) as already answered many times in the forum.

[Sandra_Rossi]

Use abap2xlsx (it also does XLSX to ABAP) as already answered many times in the forum.

[Sandra_Rossi]

And concerning TEXT_CONVERT_XLS_TO_SAP, it seems that you have defined a Date field in your internal table at a place where you should have a Quantity field.

[Former Member]

sandra.rossi Thanks for your comment. There is no date field in my excel. May I know if there is any alternate FM

[Sandra_Rossi]

I was not talking about your Excel file, I was talking about the internal table (I said: "it seems that you have defined a Date field in your internal table")

I said: use abap2xlsx (sorry, it's ABAP Objects... My opinion is that function modules are becoming more or less obsolete nowadays...)