Sap Script : getting comma in place of decimal point & viceversa

[Former Member]

Hi experts

In one Sap script for 2 currency fields comma is there in place of decimal point & viceversa.(But rest of currency fields are getting displayed correctly.)

ex: 1426.88 is printed as 1.426,88

please provide me solution as early as possible

Thanks & Regards

Swathi Vuddala

[Former Member]

Hi experts

Thanku for ur reply.But the problem is in the same sap script the same value is correctly displayed in some other position.(other window)

So I think this is not related to settings.If it is so all the currency fields should be displayed wrongly, but it is not happening.

Please provide me solution.

Thanks & Regards

Swathi Vuddala

[Former Member]

Hi,

Is this problem araise in case of forieng currency or INR.

If it is in case of foriegn currency,tell to ur functional consultant.

He will change currency settings for foriegn countries.

Regards,

Veda Kumar V.

[Former Member]

Hi ,

I am getting the same problem even i have changed the user settings.

Can you please help me.

Krishna.

[Former Member]

Check the corresponding Currency Key for these 2 fields and check this Keys' Domain's conversion routine.

[Former Member]

Hi Swathi,

Check this info.

I am providing two ways with some sample code, you modify it accordingly to your code.

THIS PROCEDURE IS BY CHANGING SETTINGS :

In your user profile, change the decimal format you are currently using.

System->User Profile->Own data.

Go to defaults tab and then change your decimal notation.

THIS PROCEDURE IS WITHOUT CHANGING DEFAULT SETTINGS:

Report YH642_TEST.

TABLES:

mard.

DATA : W_mard_labst type p decimals 3,

w_dt1(18).

data:

W_N TYPE I.

SELECT SINGLE * FROM MARD INTO MARD WHERE LABST = '10000.00'.

WRITE: mard-labst .

W_mard_labst = mard-labst.

WRITE:/ W_mard_labst .

w_dt1 = w_mard_labst .

write W_mard_labst to w_dt1.

Hope this resolves your query.

Reward all the helpful answers.

Regards

[Former Member]

set country 'IN' , then u will get desired o/p.

Regards

Prabhu