To Change the decimal notation in program

[Former Member]

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.

[Former Member]

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.

[sreeramkumar_madisetty]

Hi

By changing the User Profile you can achieve this.

Regards,

Sreeram

[Former Member]

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

[sreeramkumar_madisetty]

Hi

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

Only way is

Use

SET COUNTRY statement in ur program.

Regards,

Sreeram

[Former Member]

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

[Former Member]

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.

[Santosh_Kezkhepatmelathil]

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.

[Former Member]

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.

[Former Member]

In your case use two statements,

REPLACE ALL OCCURRENCES OF <b>','</b> IN wa_data-wrbtr WITH <b>'. '</b>

REPLACE ALL OCCURRENCES OF <b>'.'</b> IN wa_data-wrbtr WITH <b>', '</b>

Reward if useful.

[Former Member]

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

[Sathish]

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.