report

[Former Member]

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?

[Former Member]

This is because of the comma.

[Former Member]

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

[Former Member]

Hi Hema,

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

<b>Reward for helpful answers</b>

Satish

[Former Member]

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

[Former Member]

Hi,

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

[Former Member]

Hi Hema,

Try this.

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

Reward if Useful.

Regards,

Chitra

[Former Member]

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

[Former Member]

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?

[Former Member]

Hi Hema,

Try this.

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

Reward if Useful.

Regards,

Chitra

[Former Member]

can u paste the varible declaration?

[Former Member]

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

[Former Member]

Hi,

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

Thanks,

Sriram Ponna.

[Former Member]

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