Skip to Content
0
Aug 21, 2020 at 04:29 PM

quantity field conversion error

95 Views

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