topic Re: Function Module to convert Exponential form into integer. in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280102#M1218724 <HTML><HEAD></HEAD><BODY><P>During upload, automatic conversion will take place, and there is not FM for this conversion.</P><P>manual conversion will have to be done using type-casting.</P><P></P><P>Regards,</P><P>Mansi.</P></BODY></HTML> Mon, 16 Mar 2009 10:25:47 GMT Former Member 2009-03-16T10:25:47Z Function Module to convert Exponential form into integer. https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280099#M1218721 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>when uploading the excel file into an Internal table, I need the values entered in Exponential form to be convered into Integer. </P><P>For example, 7.62E+14 must be convered to 762000000000000.</P><P></P><P>Is there any Function Module available for conversion.</P><P></P><P></P><P>Thanks in advance.</P></BODY></HTML> Mon, 16 Mar 2009 10:20:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280099#M1218721 Former Member 2009-03-16T10:20:30Z Re: Function Module to convert Exponential form into integer. https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280100#M1218722 <HTML><HEAD></HEAD><BODY><P>download using OLE concept.</P><P></P><P>Check this <A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="2073672"></A></P><P></P><P>Reg,</P><P>Sachin</P></BODY></HTML> Mon, 16 Mar 2009 10:25:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280100#M1218722 Former Member 2009-03-16T10:25:14Z Re: Function Module to convert Exponential form into integer. https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280101#M1218723 <HTML><HEAD></HEAD><BODY><P>do using OLE concept</P><P></P><P>Check thi link <A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="2073672"></A></P><P></P><P>Reg,</P><P>Sachin</P></BODY></HTML> Mon, 16 Mar 2009 10:25:45 GMT https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280101#M1218723 Former Member 2009-03-16T10:25:45Z Re: Function Module to convert Exponential form into integer. https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280102#M1218724 <HTML><HEAD></HEAD><BODY><P>During upload, automatic conversion will take place, and there is not FM for this conversion.</P><P>manual conversion will have to be done using type-casting.</P><P></P><P>Regards,</P><P>Mansi.</P></BODY></HTML> Mon, 16 Mar 2009 10:25:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280102#M1218724 Former Member 2009-03-16T10:25:47Z Re: Function Module to convert Exponential form into integer. https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280103#M1218725 <HTML><HEAD></HEAD><BODY><P>Hi sumitha,</P><P></P><P>Use the FM:</P><P><STRONG>KKEK_CONVERT_FLOAT_TO_CURR</STRONG></P><P></P><P>Regards,</P><P>Nitin.</P></BODY></HTML> Mon, 16 Mar 2009 10:26:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280103#M1218725 Former Member 2009-03-16T10:26:06Z Re: Function Module to convert Exponential form into integer. https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280104#M1218726 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Refer FM <STRONG>C14W_NUMBER_CHAR_CONVERSION</STRONG></P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Tarun</P></BODY></HTML> Mon, 16 Mar 2009 10:26:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280104#M1218726 I355602 2009-03-16T10:26:17Z Re: Function Module to convert Exponential form into integer. https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280105#M1218727 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use FM *<STRONG>QSS0_FLTP_TO_CHAR_CONVERSION</STRONG>* for this purpose.</P><P></P><P>Pass the Floating point value to i_fltp_value and get the converted number in e_char_field.</P><P></P><P></P><P>-Rakesh</P></BODY></HTML> Mon, 16 Mar 2009 10:28:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280105#M1218727 Former Member 2009-03-16T10:28:57Z Re: Function Module to convert Exponential form into integer. https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280106#M1218728 <HTML><HEAD></HEAD><BODY><P>I would prefer, instead of using any Fm, Once you get the value to your field, move it to a variable</P><P>of type p.</P><P></P><P>Regards,</P><P>Nitin.</P></BODY></HTML> Mon, 16 Mar 2009 10:35:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280106#M1218728 Former Member 2009-03-16T10:35:17Z Re: Function Module to convert Exponential form into integer. https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280107#M1218729 <HTML><HEAD></HEAD><BODY><P>the FM QSS0_FLTP_TO_CHAR_CONVERSION, is working fine. thanks a lot for everyone's effort.</P></BODY></HTML> Mon, 16 Mar 2009 11:03:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-convert-exponential-form-into-integer/m-p/5280107#M1218729 Former Member 2009-03-16T11:03:09Z