topic Re: Function module for converting character to currency in Application Development and Automation Discussions

Function module for converting character to currency

Former Member — Mon, 06 Nov 2006 12:23:30 GMT

Hi,

I have got a field with the currency data type, but the text file given to me has only character. so i need a

Function Module to convert the character field to currency.

Re: Function module for converting character to currency

anversha_s — Mon, 06 Nov 2006 12:27:05 GMT

hi,

use this FM HRCM_STRING_TO_AMOUNT_CONVERT

pass the string , thousand separator,decimal separator, if it is currecy pass currecy key WAERS.

or try this code.

DATA: v_dcpfm    TYPE usr01-dcpfm,
      v_amount   TYPE bseg-wrbtr,
      v_char(16) TYPE C.
 
SELECT SINGLE dcpfm FROM usr01
                    INTO v_dcpfm
                   WHERE bname = sy-uname.
IF v_dcpfm = 'X'.
*-- decimal point is '.' and thousands separator is ','
  TRANSLATE v_char USING ', '.
  CONDENSE v_char NO-GAPS.
  v_amount = v_char.

ELSEIF v_dcpfm = 'Y'.
*-- decimal point is ',' and thousands separator is '.'
  TRANSLATE v_char USING '. '.
  CONDENSE v_char NO-GAPS.
  v_amount = v_char.

ELSE.
*-- decimal point is ',' and thousands separator is space
  CONDENSE v_char NO-GAPS.
  v_amount = v_char.
ENDIF.

rgds

Anver

if hlped pls mark points

Re: Function module for converting character to currency

Former Member — Mon, 06 Nov 2006 12:28:45 GMT

Try ISM_CONVERT_CHAR_TO_CURR

function module.

reward points if helpful.

Regs

Manas Ranjan Panda

Re: Function module for converting character to currency

Former Member — Mon, 06 Nov 2006 12:32:31 GMT

Hi clara,

Use the 'PACK' command.