topic FM which automatically convert value as per alpha output / input while uploading excel into internal table in Application Development and Automation Discussions

FM which automatically convert value as per alpha output / input while uploading excel into internal table

former_member462254 — Fri, 01 Aug 2014 08:44:59 GMT

Hello evryone,

Do we have any FM whiich automatically pick the data from presentation server / local machine into internal table and also consider call conversion aplha while uploading into internal table...

e.g lifnr has 10 char length with alpha conversion.

If we use FM 'TEXT_CONVERT_XLS_TO_SAP' to upload data into internal table. then this FM doesnt perform any alpha routine in background and show the same value which you have provided in excel file.

Don't provide the solution of using Fm- Alpha input / output inside loop of internal table....

m looking for a tool which can do all the conversion (alpha output / input) automatically while uploading excel file into internal table.

Regards,

Anoop Singh bhandari

Re: FM which automatically convert value as per alpha output / input while uploading excel into internal table

former_member201275 — Fri, 01 Aug 2014 09:03:03 GMT

Have you tried FM 'ALSM_EXCEL_TO_INTERNAL_TABLE'?

Re: FM which automatically convert value as per alpha output / input while uploading excel into internal table

former_member202818 — Fri, 01 Aug 2014 09:12:07 GMT

Hi Anoop,

Simply copy this function module and add code for conversion at the place marked in snap.

Re: FM which automatically convert value as per alpha output / input while uploading excel into internal table

former_member462254 — Fri, 01 Aug 2014 10:50:26 GMT

not working.....

Re: FM which automatically convert value as per alpha output / input while uploading excel into internal table

former_member196651 — Fri, 01 Aug 2014 11:06:36 GMT

Hi Anoop,

I don't think that you will be getting a single FM which will pick the data from presentation server / local machine into internal table and also consider call conversion aplha while uploading into internal table. For this you will need to create a FM of your own using any of the FM for converting the excel values into internal table and do the rest.

Regards,

Abijith