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

Decimals format in scripts

Former Member
0 Likes
1,034

Hi all,

I have a scripts in which the currency values are getting displayed in the format 123.456.78,910 whereas I need the format 123,456,78.910

I've set the defaults in SU3 to meet this requirement, but its not working. I even checked the values in print program in debug mode & its fine there.

I have given the additional (I) to that field in scripts so that it shouldn't print 0 if there's no value.

Kindly suggest me any standard method/setting to solve this.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
977

Hi,

Set country is the command in sapscript influences the decimal format.

set country as US, it will resolve your problem.

Thanks

7 REPLIES 7
Read only

Former Member
0 Likes
977

Hi,

Please give (T) to that field in the script and check the output. T is for thousands.

Regards,

Venkatesan.

Read only

Former Member
0 Likes
977

hi

after changing the defaults in SU3, i think we need to log-off and log-in again for the changes to reflect.

pls check it...

thx

pavan

Read only

Former Member
0 Likes
977

try with that

(c.3) or (i.3).

it may work but not sure

regards

shiba dutta

Read only

Former Member
0 Likes
978

Hi,

Set country is the command in sapscript influences the decimal format.

set country as US, it will resolve your problem.

Thanks

Read only

Former Member
0 Likes
977

Hi Jithendra,

Try to comply the format according to the country code. It should solve your problem.

Cheers,

Patrick

Read only

Former Member
0 Likes
977

hi,

Omitting the Separator for ‘Thousands’ Symbols of the DEC, CURR, INT, and QUAN data types are normally formatted with the a ‘thousands’ separator character.

The T option allows you to omit this separator character. Syntax: &symbol(T)&

use this syntax .

use set country for country specific format and then adjust the currency setting currency format.

U have to go for that option

why dont u move this values into aa character variable and see the same as already u mentioned it that in debugging values are fine .

regards,

vijay

Read only

Former Member
0 Likes
977

hi Jitendra

Could you please tell me how you got the solution for your problem. I have a similar kind of requirement where in i had to display 1,22.00 for a french script and 1.22,00 for an english script.

Anticipating your reply