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