topic quantity field conversion error in Application Development and Automation Discussions

quantity field conversion error

Former Member — Fri, 21 Aug 2020 16:29:36 GMT

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

Re: quantity field conversion error

Sandra_Rossi — Fri, 21 Aug 2020 17:12:22 GMT

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

Re: quantity field conversion error

Sandra_Rossi — Fri, 21 Aug 2020 17:14:27 GMT

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.

Re: quantity field conversion error

Former Member — Sat, 22 Aug 2020 09:26:35 GMT

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

Re: quantity field conversion error

Sandra_Rossi — Sat, 22 Aug 2020 14:02:13 GMT

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...)