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

[former_member462254]

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

[former_member462254]

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

[former_member201275]

Have you tried FM 'ALSM_EXCEL_TO_INTERNAL_TABLE'?

[former_member462254]

not working.....

[former_member202818]

Hi Anoop,

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

 

[former_member196651]

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