topic Re: Convert decimal to User Decimal format in Application Development and Automation Discussions

Convert decimal to User Decimal format

Former Member — Mon, 11 Aug 2008 10:28:34 GMT

Hi All,

I have number in this format 10.000,52.I want to change this format to my User decimal format whcih is entred in SU01.

Can anybody please help me out.

Thanks,

Swapna.

Re: Convert decimal to User Decimal format

Former Member — Mon, 11 Aug 2008 10:30:44 GMT

hii

use FM CONVERT_NUMBER.

thanks

Re: Convert decimal to User Decimal format

former_member585060 — Mon, 11 Aug 2008 10:42:45 GMT

Go to System>User Profile>Own data

Defaults Tab, select the decimal notation type u required.

next time when u give input any number, it will display according to that particular notations.

Re: Convert decimal to User Decimal format

Former Member — Mon, 11 Aug 2008 10:46:25 GMT

Hi Swapna,

Please go to SU01 --> Enter user id --> display --> Anc click on default tab and check the decimal notation.

Declare one field to currency type and then try

Use FM BKK_AMOUNT_CONV_TO_INTERN_MAIN.

you can check by changing the values in su01.but remember your change reflect only when you logoff SAP and again login.so once logoff is needed.

regards,

Ranveer.

Re: Convert decimal to User Decimal format

Former Member — Mon, 11 Aug 2008 12:18:47 GMT

Hi,

I can't change the settings in the SU01.The value is coming from flat file like this '10.500,50'.In this value all commas should be replace with '.' and all '.'with ','.

Or i need to convert this is user decimal format.How can i do tat.

is there any FM to solve this pblm.

Thanks

Re: Convert decimal to User Decimal format

Former Member — Mon, 11 Aug 2008 12:24:05 GMT

Hi Swapna

Below sample code to replace dot with comma and viceversa.

while sy-subrc <> 0.

if wf_value eq '.' then

replace '.' with ',' into wf_value

elseif wf_value eq ',' then

replace '.' with '.' into wf_value

endwhile

Lavanya