Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

currency field

Former Member

‎2007 Oct 22 10:38 AM

0 Likes
583

Hi all,

I have a requirement where in I have to upload the data from an excel file to ztable.I have used fm ALSM_EXCEL_TO_INTERNAL_TABLE to upload the data from the excel file to ztable.But my ztable has three currency fields.These currency fields have values 146,51,146,51,143,58 in the excel file.When I try to execte the program,I am getting a dump error as 'unable to interpret 146,51 as a number'How can I correct this error?

Hi all,

I have a requirement where in I have to upload the data from an excel file to ztable.I have used fm ALSM_EXCEL_TO_INTERNAL_TABLE to upload the data from the excel file to ztable.But my ztable has three currency fields.These currency fields have values 146,51,146,51,143,58 in the excel file.When I try to execte the program,I am getting a dump error as 'unable to interpret 146,51 as a number'How can I correct this error?

Reply
3 REPLIES 3
Read only

Former Member

‎2007 Oct 22 10:44 AM

0 Likes
505

try formating the the coloumn to number type or you can generate a tab delimated text file from the excel file and use GUI upload.

Read only

Former Member

‎2007 Oct 22 10:48 AM

0 Likes
505

Hema,

Maintain<b> .</b> instead of <b>comma</b>.

<b>Reward for helpful answers</b>

Satish

Read only

Former Member

‎2007 Oct 22 10:58 AM

0 Likes
505

FM ALSM_EXCEL_TO_INTERNAL_TABLE will download the contents of excel file in Character format. SO you internal table should have all the fields of type C and later on you need to convert the ciontents of the field to Currebncy type.