amount conversion

[Former Member]

Hi experts,

my problem is am getting the amount as 123,456,000. but i want it to be 1234560.00. is there any function module for this.

Regards,

Sunita.

[Sandeep_Panghal]

Check your profile settings in SU01 txn and change the currency format accordingly

[former_member222860]

From tcode: SU3 -> Defualts tab

u can change decimal notation

[Former Member]

jus go to SYSTEM->USERPROFILE->OWNDATA->DEFAULTS TAB.

here check for the decimal notation and chg it according to ur req.

[Former Member]

hi,

Declare a varible with CHAR and write to this variable.

REPLACE ',' in v_char with ' ' .

CONDENSE v_char1. to remove the gaps.

data: v_char1 type string.

v_char2 = ' 1,000.00'.

replace ',' in v_char2 with ' ' .

CONDENSE v_char2.

write:/ v_char2.

regards,

Lokesh

[Former Member]

Hi,

You can try using function modules:

CONVERT_TO_LOCAL_CURRENCY

CONVERT_TO_FOREIGN_CURRENCY

Hope it helps

Regards

Mansi

[Former Member]

Hi Sunita,

For the same requirement I am using below Function module and working fine.

CALL FUNCTION 'HRGPBS_HER_FORMAT_AMOUNT'
      EXPORTING
        P_AMOUNT           = G_MAXBT
        P_CURRENCY         = G_WAERS
        P_REQUIRED_FORMAT  = '99999999.99'
      IMPORTING
        P_ERROR            = L_ERROR_DURING_FORMAT
        P_ERROR_AMOUNT     = L_ERROR_AMOUNT
        P_ERROR_CURRENCY   = L_ERROR_CURRENCY
        P_ERROR_OVERFLOW   = L_ERROR_OVERFLOW
      CHANGING
        P_FORMATTED_AMOUNT = G_RWBTR.

    IF L_ERROR_DURING_FORMAT NE 0.
      IF L_ERROR_DURING_FORMAT = 1.
        MESSAGE E002 WITH 'Error during currency format conversion'.
      ELSE.
        MESSAGE E002 WITH 'Error during currency format conversion'.
      ENDIF.
    ENDIF.

Regards

[Former Member]

Hi experts,

i have all the above but its not working..123,456,000. i wnat to keep the decimal point for the last 2 zero's .like 1234560.00.

Regards,

Sunita

[Former Member]

Use the function module what I mentioned in my previous message. Sure It will work.