Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Currency Format Problem

Former Member
0 Likes
1,139

Hi folks,

In Smartform, when i am displaying the amount it is coming as 10.000 instead of 10,000. I want the same in the second format. Please help me for the same.

Thanks in advance

Siddarth Jain

10 REPLIES 10
Read only

Former Member
0 Likes
1,103

Hi,

Check for the User Settings In SU01 T Code.

You can change the format.

Also check for the Country specific settings.

Regards,

Anji

Read only

Former Member
0 Likes
1,103

Change the user settings.

<b>System > User profile > own data > default tab > change it to second option.</b>

This will solve ur problem, reward points if thsi helps.

Read only

Former Member
0 Likes
1,102

Hello,

Go to System->UserProfile->Own Data

change the decimal notation in the 'Default's tab.relogin and check the change.

Regards,

Shehryar

Read only

Former Member
0 Likes
1,102

u have declared the field which is currency type filed, there u can also define currecy field in smartform...asiign related curreny reference field.....

( in global declaration threre is one more colom at the declaration....assign threre...

)

smartforms->ur smartform->change mode->Global definations->go to tabstrip Currency/Quantity field..

give ur field name which is already assigned and give reference field name and check currency...

Ramesh.

Message was edited by:

Ramesh

Read only

Former Member
0 Likes
1,102

Hello,

in addition to my thread, you can use the respective correct currency key.

Regards,

Shehryar Dahar

Read only

Former Member
0 Likes
1,102

Hi folks,

First of all thanks for your reply. Current settings for the user 1,234,567.89 but still it is showing in 1.234.567,89.

thanks in advance

Siddarth

Read only

0 Likes
1,102

hi,

try this.


 1.234.567,89 => 1,234,567.89 .


data: l_amnt(100) type c.

l_amnt = your_value

replace all occurrences of '.' in l_amnt with '#'.

replace all occurrences of ',' in l_amnt with '.'.

replace all occurrences of '#' in l_amnt with ','.

write : l_amnt.

Regards,

Anver

Read only

Former Member
0 Likes
1,102

Hi Folks,

Problem is something different. I just now debugged the program and got that in the field of intenal table it is showing in proper format i.e. 1,234,567.89 but when I drag that field and put it on the smartform then the format changes to 1.234.567,89. That is what happening which i don't want. So please help me for the same.

Thanks in advance.

Siddarth.

Read only

0 Likes
1,102

do like this

Go to System->UserProfile->Own Data

change the decimal notation in the 'Default's tab.relogin and check the change.

Restart the system and u ll get the required result..

Read only

0 Likes
1,102

The problem is with ur settings only, please change the same and save it. Login againa nd check.

Will solve ur problem.