topic Re: report in Application Development and Automation Discussions

report

Former Member — Thu, 18 Oct 2007 13:41:51 GMT

Hi,

I am wrkg on a report.In this I have used a currency field.When I try to execute,it is giving error as 'unable to interpret 145,6 as a number'.What does this mean?

Re: report

Former Member — Thu, 18 Oct 2007 13:43:52 GMT

This is because of the comma.

Re: report

Former Member — Thu, 18 Oct 2007 13:44:58 GMT

It interprets , as a character not as a decimal point.

Either put in the number as 145.6 or change your decimal notation in your user settings:

System - User Profile - Own data

Tab Defaults - Decimal Notation

Regards,

Michael

Re: report

Former Member — Thu, 18 Oct 2007 13:45:27 GMT

Hi Hema,

Give the value as 145.6. SAP can not interpret 145,6.

<b>Reward for helpful answers</b>

Satish

Re: report

Former Member — Thu, 18 Oct 2007 14:00:53 GMT

Hi Hema,

SAP interprets , as a character not as a decimal point.

So provide the value as 145.6.

Incase ur settings might also be a problem.

Change your decimal notation in your user settings:

System - > User Profile - > Own data - > Tab Defaults -> Decimal Notation

Reward if Useful.

Regards,

Chitra

Re: report

Former Member — Thu, 18 Oct 2007 14:04:20 GMT

Hi,

I have given that field as char type.Even then it is giving dump error

Re: report

Former Member — Thu, 18 Oct 2007 14:08:13 GMT

Hi Hema,

Try this.

replace ',' with '.' in that field.

Reward if Useful.

Regards,

Chitra

Re: report

Former Member — Thu, 18 Oct 2007 14:23:17 GMT

when you declared it as 'Char' what is the error u r getting?

Re: report

Former Member — Thu, 18 Oct 2007 14:40:26 GMT

Hi,

Even when I declared it as char type I am getting error as 'unable to interpret 145,6 as a number'.Could u pls suggest me some solution for this?

Re: report

Former Member — Thu, 18 Oct 2007 14:43:07 GMT

Hi Hema,

Try this.

replace ',' with '.' in that field.

Reward if Useful.

Regards,

Chitra

Re: report

Former Member — Thu, 18 Oct 2007 14:46:08 GMT

can u paste the varible declaration?

Re: report

Former Member — Thu, 18 Oct 2007 14:48:19 GMT

Hello Hema,

When you define it as a character field you should definitely not get that error. Are you moving the character field into a number field later on because than it is not allowing this because of your decimal settings in your user profile.

Either put in the number as 145.6 (point instead of comma) or change your user settings for the decimal notation so SAP interprets a , as a comma. You always need to input any numbers with decimal point (either . or ,) that you defined in your user settings.

Regards,

Michael

Re: report

Former Member — Thu, 18 Oct 2007 15:28:46 GMT

Hi,

Could you please let us know, you are displaying the data in ALV?

Thanks,

Sriram Ponna.

Re: report

Former Member — Fri, 19 Oct 2007 03:11:32 GMT

Hi Sriram,

My requirement is to upload the data from excel file to ztable(zrb_hdr).In the internal table(t_zrb_hdr) i have changed the data types of date,time and currency fields to char type.I have used fm 'ALSM_EXCEL_TO_INTERNAL_TABLE' to read the excel file.To upload the data to ztable i haveused insert zrb_hdr from table t_zrb_hdr.But here zrb_hdr and t_zrb_hdr don't have the same structure.so it is giving error.Now how can I upload data to ztable?

Regards,

Hema