Question Re: Display problem with QUAN - comma instead point in Technology Q&A

Display problem with QUAN - comma instead point

Former Member — Thu, 21 Feb 2013 09:16:16 GMT

Hi all,

we habe a display problem. The values of a component type MENGV13 (data type QUAN 13) are correct in the context with a point e.g. 8.500 but in the web dynpro application in a Table TextView-UI-Element they are displayed as 8,600, with a comma.

What can we do? Is there e.g. a general web dynpro customizing needed?

Thanks, regards

Susanne

Re: Display problem with QUAN - comma instead point

naresh_bammidi — Thu, 21 Feb 2013 09:29:05 GMT

Hi,

In user profile you have to change the Decimal notation.Go to SU01 ,under defaults tab chenge the decimal notation.

Thanks

Re: Display problem with QUAN - comma instead point

manish_bisht5 — Thu, 21 Feb 2013 09:49:29 GMT

HI,

You need to change the Decimal notation for the user.

Change the default format.

Re: Display problem with QUAN - comma instead point

Former Member — Thu, 21 Feb 2013 16:16:32 GMT

Thank you for your help. In su01 the decimal notation is like in the screen of manish bisht. This couldn't be the reason. Any other suggestions? I thought it must be somewhere central to customize cause we want that all user see it in this way.

Re: Display problem with QUAN - comma instead point

naresh_bammidi — Fri, 22 Feb 2013 03:53:59 GMT

Usually decimal notaion is depends on user.There is a table USR01,which holds the User data.If you pass the user name which gives the Decimal notation for that particular User.There are only three types of Decimal notaions,so based on decimal notation replace the current notation to required notation.

Thanks

Naresh

Re: Display problem with QUAN - comma instead point

manish_bisht5 — Fri, 22 Feb 2013 09:31:31 GMT

HI,

You can also check in SPRO whether right decimal notation is set.

Goto SPRO : SAP NetWeaver>General Settings>Set Countries>specify counrty in mysap system

country code and check for decimal notation.

Re: Display problem with QUAN - comma instead point

Former Member — Mon, 25 Feb 2013 12:20:52 GMT

Hello Susanne,

As suggested above check your user setting with SU01 and also with SU03.

Because quantity field output format depend upon your country/region settings. If you are running your WD application on local server then your output may differ with respect to comma and dot.

Like same output (e.g currency )can be mentioned in different ways like (1.000,00) (1,000.00) for EURO,

Rupees, Dollar etc.

Regards,

Sudhir Kothavale.

Re: Display problem with QUAN - comma instead point

Former Member — Mon, 25 Feb 2013 12:28:29 GMT

Susanne,

You can hard-code your output also.

First convert that quantity field into character field.

Than use translate syntax...

TRANSLATE ',' TO ' .'.

Regards,

Sudhir Kothavale.

Re: Display problem with QUAN - comma instead point

Former Member — Wed, 06 Mar 2013 14:07:55 GMT

Thank you, I changed the decimal notation to 1,234,567.89 then the WD application displays a dot.

That would be ok so far. But normaly a user doesn't see the WD application on the WD server, cause the application is integrated in a SAP Portal which is on another server. And in der portal the WD application displays still a comma instead a dot. And it doesn't matter whether I personalize the Portal in German or English. What can I do?

I don't want to do hard-coding with TRANSLATE cause then everybody see it in the same way and not like the user it's used. First I thougth this would be ok but I changed my opinion in this point.

Any other ideas?

Re: Display problem with QUAN - comma instead point

nabheetscn — Wed, 06 Mar 2013 19:31:54 GMT

USually in ABAP Smartform when we face this issue of comma and dot we create a local variable of character and move our value from QUAN to it it automically picks the format from SU01. I am just a beginner in Webdynpro please check the field properties and check if you can specify UOM etc.