topic Re: Converting amount to user's decimal notation in Application Development and Automation Discussions

Converting amount to user's decimal notation

Former Member — Thu, 02 Apr 2009 07:52:38 GMT

Hi All,

We have a requirement as follows:

Amount = 12500.00.(After final calcuation we get an amount like this).

Now as per the user's decimal notation(Maintained in SU01->Defaults->Decimal notation format) we have to convert this amount to that format.

For Eg: If the user's notation is set as ' '(the notation wil be 1.234.456,89). so according to this the amount given above should be made as 12.500,00.

Can anybody let me know is there any function module/any other option available to convert this as mentioned in the above example.

Thanks in Advance,

Cheers,

Sri

Re: Converting amount to user's decimal notation

keerthy_k — Thu, 02 Apr 2009 08:01:25 GMT

Hi,

If u are writing this value to the list...u dont have to convert...it will automatically be in the format specified in the SU01 transaction for currency.

Keerthi

Re: Converting amount to user's decimal notation

Former Member — Thu, 02 Apr 2009 08:04:10 GMT

We will be using this value in BDC and it will be passed to VA01 pricing screen.

Cheers,

Sri

Re: Converting amount to user's decimal notation

Former Member — Thu, 02 Apr 2009 08:12:55 GMT

Hi,

Use the WRITE statement to move the amount field to Char field and use the char field in BDC.

DATA l_char type char20.

l_Amount = '12500.00'.

WRITE l_amount TO l_char.

the value in l_char would like '12.500,00' ( if the notation wil be 1.234.456,89). that is as per the user notation in SU01

Re: Converting amount to user's decimal notation

anuj_srivastava — Thu, 02 Apr 2009 08:13:27 GMT

This message was moderated.

Re: Converting amount to user's decimal notation

Former Member — Thu, 02 Apr 2009 08:17:30 GMT

Hi,

write : amount to t_amount.

use field t_amount in bdc.

Re: Converting amount to user's decimal notation

Former Member — Thu, 02 Apr 2009 08:41:59 GMT

Hi Anuj,

I read the link you have provided...i tried with those options..but still am not able to get it.

Can you please explain little more clearly, so that i can make use of it.

Cheers,

Sri.

Re: Converting amount to user's decimal notation

Former Member — Thu, 02 Apr 2009 08:45:46 GMT

HI,

You need to use the WRITE..TO.. statment to convert the amount format as per the user profile. Please gothrough my answer in the post.

Re: Converting amount to user's decimal notation

anuj_srivastava — Thu, 02 Apr 2009 08:51:04 GMT

Hi ,

Can u check what is the value for the field in table T005X. ??

Re: Converting amount to user's decimal notation

Former Member — Thu, 02 Apr 2009 08:53:37 GMT

I used the land as DE and for DE the field XDEZP is ' '

Re: Converting amount to user's decimal notation

anuj_srivastava — Thu, 02 Apr 2009 09:00:26 GMT

Hi Sri ,

So it seems if you are using the write statement then amount will be diaplayed as xx.xxx,yy instead of what the user setting has been done in Su01.

Try these link hope it solves ur problem.

Regards ,

Anuj

Re: Converting amount to user's decimal notation

anuj_srivastava — Thu, 02 Apr 2009 09:02:51 GMT

Hi Sri ,

If we specify the country key the system do not consider the settings from the user master record and searches table T005X for the country key. If the country key exists, the system sets sy-subrc equal to 0 and formats the output of all the 'WRITE' statements according to the settings defined in T005X. If the country key you specified does not exist, the system sets sy-subrc equal to 4 and formats for all 'WRITE' statements with the decimal characters as period '.'.

Regards ,

Anuj

Re: Converting amount to user's decimal notation

Former Member — Thu, 02 Apr 2009 09:08:58 GMT

Thanks to all for your help and ideas.

Found another solution.

Cheers,

Sri.

Re: Converting amount to user's decimal notation

Former Member — Thu, 01 Oct 2009 10:20:45 GMT

Hi Srikirthi,

Could you please let me know how u solved this problem?

Regards

Balu

Re: Converting amount to user's decimal notation

Former Member — Mon, 05 Oct 2009 14:00:51 GMT

Hi,

Could u please let me know the solution. i am also facing same probelm..

thanks in advance

Re: Converting amount to user's decimal notation

Former Member — Mon, 05 Oct 2009 14:02:06 GMT

Could u please let me know the solution. i am also facing same probelm..

Thanks in advance