topic Re: To Change the decimal notation in program in Application Development and Automation Discussions

To Change the decimal notation in program

Former Member — Fri, 11 May 2007 06:38:47 GMT

Is their any functional module which will change the decimal notation from '1.234.567,89' to '1,234,567.89' and this change should affect only to that program.

Re: To Change the decimal notation in program

sreeramkumar_madisetty — Fri, 11 May 2007 06:40:13 GMT

By changing the User Profile you can achieve this.

Regards,

Sreeram

Re: To Change the decimal notation in program

Former Member — Fri, 11 May 2007 06:41:35 GMT

i dont want to change the user profile but i want this only for that particular program. Is it possible

Re: To Change the decimal notation in program

Former Member — Fri, 11 May 2007 06:41:50 GMT

Hi,

That is Depends on the USER Profile, so change the user profile so the decimal notation will be changes, USe SU01 to change the User profile

Regards

Sudheer

Re: To Change the decimal notation in program

Former Member — Fri, 11 May 2007 06:42:10 GMT

Hi Rajesh K

Follow thiis path,

From SAP Menus

System->User Profile->Own Data

Then

Defualt Tab then change the Decimal Notation

Reward if Useful.

Re: To Change the decimal notation in program

Santosh_Kezkhepatmelathil — Fri, 11 May 2007 06:43:14 GMT

hi,

you can goto transacton su01 and then enter your name and then click change, then check the defaults tab change according to your requirement.

regards,

santosh.

Re: To Change the decimal notation in program

sreeramkumar_madisetty — Fri, 11 May 2007 06:44:04 GMT

Without changing the User Profile, u want to achieve ur requirement:

Only way is

Use

SET COUNTRY statement in ur program.

Regards,

Sreeram

Re: To Change the decimal notation in program

Former Member — Fri, 11 May 2007 06:44:09 GMT

Hi Rajesh,

For a pertucular program you can use REPLACE statement.

For E.g.

Suppose wa_data-wrbtr is your amount,

REPLACE ALL OCCURRENCES OF ',' IN wa_data-wrbtr WITH ' '.

Reward if useful.

Re: To Change the decimal notation in program

Former Member — Fri, 11 May 2007 06:45:57 GMT

In your case use two statements,

REPLACE ALL OCCURRENCES OF ',' IN wa_data-wrbtr WITH '. '

REPLACE ALL OCCURRENCES OF '.' IN wa_data-wrbtr WITH ', '

Reward if useful.

Re: To Change the decimal notation in program

Former Member — Fri, 11 May 2007 06:46:08 GMT

you can try with

data : amt type p decimals 2 value '123456.55'.

set country 'IN'.

write : / amt.

if it does not work you have to assign it in a character var...then have to format pls let us know whether you are getting solution or not?

regards

shiba dutta

Re: To Change the decimal notation in program

Sathish — Fri, 11 May 2007 06:48:36 GMT

you can write a piece of code.

Check for the string length and whereever there is ',' replace by '.'

There is no standard FM for this but can be achieved by writing a piece.