topic Re: Converting Comma into Dot for Amount value in Application Development and Automation Discussions

Converting Comma into Dot for Amount value

Former Member — Mon, 12 Jan 2009 11:03:42 GMT

Hi All,

I need to convert the amount value in comma to dot say 1000,00 to 1000.00.Any function module is there to convert it.After converting it i need to pass this value as exporting parameter to a function module having data type as character(lenght 13).

Thnks

Deb

Re: Converting Comma into Dot for Amount value

Former Member — Mon, 12 Jan 2009 11:07:50 GMT

Goto System->User Profile->Own data

Defaults tab..Maintain the desired one in field Decimal Notation

Re: Converting Comma into Dot for Amount value

Former Member — Mon, 12 Jan 2009 11:16:02 GMT

Hi,

Check the table USR01 for user defaults (DCPFM), based on the value you change the decimal notation.

Hope it helps!!

let me know for any further help!!

Regards,

Pavan

Re: Converting Comma into Dot for Amount value

SuhaSaha — Mon, 12 Jan 2009 11:19:45 GMT

Hello Deb,

Try the code below:


DATA:
V_AMT  TYPE WRBTR VALUE '5000,00',
V_INT1 TYPE NUMC10,
V_DEC1 TYPE NUMC2,
V_DATA TYPE CHAR13.

V_INT1 = TRUNC( V_AMT ).
V_DEC1 = FRAC( V_AMT ).


CONCATENATE V_INT1 '.' V_DEC1 INTO V_DATA.

WRITE: V_DATA.

Hope this helps.

BR,

Suhas

Re: Converting Comma into Dot for Amount value

Former Member — Mon, 12 Jan 2009 11:21:47 GMT

Hi,

Either maintain it in the User profile if you always want to run this way.

Maintain whichever decimal notation is preferred. This has tobe done for the user who will be executing the report..

Or you wish to change onlyin your report then you may use TRANSLATE wa_text USING ',..,' at the time of output..

Re: Converting Comma into Dot for Amount value

Former Member — Mon, 12 Jan 2009 11:24:08 GMT

Hello Suhas,

I guess, the decimal notation is not constant value (.), it will vary based on the user defaults...

so it should dynamically change based on the user defaults.

Regards,

Pavan

Re: Converting Comma into Dot for Amount value

Former Member — Mon, 12 Jan 2009 11:31:21 GMT

Hi,

Use

replace all occurrences of ',' in <your field name> with '.'.

Re: Converting Comma into Dot for Amount value

SuhaSaha — Mon, 12 Jan 2009 11:32:16 GMT

Hello Vishnu,

That is what i have done. FRAC returns me the "Value of the decimal places of the argument ". It does not depend on the decimal separator.

BR,

Suhas

Re: Converting Comma into Dot for Amount value

Former Member — Mon, 12 Jan 2009 11:37:32 GMT

Hi Debabrata,

Did you try with REPLACE statement ?

Check this code snippet:

DATA: a TYPE string VALUE '5000,00'.
REPLACE ALL OCCURRENCES OF ',' IN:
        a WITH '.' .
WRITE a.

Re: Converting Comma into Dot for Amount value

faisalatsap — Wed, 21 Jan 2009 11:16:52 GMT

Hi,

Have a look at the following Thread, it will solve out your problem

[Replace , with . or space|;

Kind Regards,

Faisal