topic Re: Decimals issue while Displaying Amount in Application Development and Automation Discussions

Decimals issue while Displaying Amount

Former Member — Tue, 17 Aug 2010 05:38:22 GMT

Hello Gurus

i have a requirment to add Zfields of type CURR to the table VBAK with 4 Decimals. I have added the screen Additional data B as well.

and its working fine.

i have one issue with the display of hte amount value as my field is of 4 decimals.

example: in the table the values is stored as 100,0000, but on the screeen it is been displayed as 1.0000,00.

it seems that while dispalying the amount we are getting only 2 decimals not 4. please let me know how i can fix it

Thanks in Advance.

Re: Decimals issue while Displaying Amount

Sandeep_Panghal — Tue, 17 Aug 2010 05:42:57 GMT

The field value is displayed in a diff format.

Check the user settings in SU01.

Also , check the properties of the domain which you have assigned to the field.

Re: Decimals issue while Displaying Amount

Former Member — Tue, 17 Aug 2010 06:09:05 GMT

In SU01 default Decimals notation is as below.

1.234.67,89

and i have created new domain with Decimals 4 of type CURR.

Re: Decimals issue while Displaying Amount

Sandeep_Panghal — Tue, 17 Aug 2010 06:16:49 GMT

then change it to 1,234,567.89

Re: Decimals issue while Displaying Amount

SuhaSaha — Tue, 17 Aug 2010 06:21:05 GMT

What is the currency ? Does this currency have zero decimal places defined viz., JPY, HUF etc. ?

@Sandeep: How does this depend on the user's decimal & thousand separator settings ?

Re: Decimals issue while Displaying Amount

Former Member — Tue, 17 Aug 2010 06:22:16 GMT

Hi friend,

Did you set currency/quantity fields for your zfields in table VBAK. If yes, in field's attribute of zfields in screen must have ref. fields is currency unit.

Please check and reply.

regards,

Re: Decimals issue while Displaying Amount

Former Member — Tue, 17 Aug 2010 06:54:29 GMT

hello Sandeep,

if you change the SU01 settings then it will change the format, it will not display 4 decimals.

yes i have specied reference table and reference field as VBAK-WAERK.