topic Re: Convert packed decimal to char/string in Application Development and Automation Discussions

Convert packed decimal to char/string

rainer_hbenthal — Tue, 22 Sep 2009 05:44:21 GMT

Hi,

i would like to convert a packed decimal to character variable, but i dont want to use the users profil defaults, i would like to choose whether i'm getting

1.234,56

1,234.56

so WRITE TO is not an option (or i missed a parameter somewhere) and i'm unable to find a function module/method where the decimal notation is X or Y.

Re: Convert packed decimal to char/string

Sandeep_Panghal — Tue, 22 Sep 2009 06:01:57 GMT

have you already tried this FM : /OSP/GET_DECIMAL_NOTATION

Re: Convert packed decimal to char/string

Former Member — Tue, 22 Sep 2009 06:12:14 GMT

Hi ,

Try the following FM;

CALL FUNCTION '/OSP/GET_DECIMAL_NOTATION'

EXPORTING

i_uname = 'SAPUSER'

IMPORTING

ET_RETURN =

EV_DECIMAL_NOTATION = lv_dec_not

EV_TEXT = lv_text .

When i executed;

lv_dec_not returned 'X' and

lv_text returned 1,234,567.89

Regards,

Vijay

Re: Convert packed decimal to char/string

rainer_hbenthal — Tue, 22 Sep 2009 06:12:17 GMT

You misunderstood me, i dont wanna know the users defaults, i want to convert indepent from those values.

Re: Convert packed decimal to char/string

Former Member — Tue, 22 Sep 2009 06:12:42 GMT

I had a bit like requirement, and I dealt with ABAP code. Even I wasnu2019t able to find a right FM for that, thus Iu2019ve done with a bit mixture of ABAP code and FM

Below is the code snippet,Please Have a look.

SELECT SINGLE * FROM usr01 WHERE bname = sy-uname.
  IF sy-subrc = 0.
    CASE usr01-dcpfm.
      WHEN ' '.
        FIND ',' IN in_par-value.
        IF sy-subrc = 0.
          REPLACE ',' WITH '.' INTO in_par-value.
        ENDIF.

        MOVE in_par-value TO i_kurrf.

      WHEN 'X'.
        FIND ',' IN in_par-value.
        IF sy-subrc = 0.
          REPLACE ',' WITH '.' INTO in_par-value.
        ENDIF.
        CALL FUNCTION 'MOVE_CHAR_TO_NUM'
          EXPORTING
            chr             = in_par-value
          IMPORTING
            num             = i_kurrf
          EXCEPTIONS
            convt_no_number = 1
            convt_overflow  = 2
            OTHERS          = 3.

      WHEN OTHERS.
        FIND ',' IN in_par-value.
        IF sy-subrc = 0.
          REPLACE ',' WITH '.' INTO in_par-value.
        ENDIF.

        MOVE in_par-value TO i_kurrf.

You may alter this code according to you.

Cheers

Re: Convert packed decimal to char/string

Former Member — Tue, 22 Sep 2009 06:14:38 GMT

Hi Rainer

Did you try USING EDIT MASK ?

Pushpraj

Re: Convert packed decimal to char/string

rainer_hbenthal — Tue, 22 Sep 2009 06:16:42 GMT


data num type p decimals 2.
data str type string.

num = '3141.59'.

call some_function_module exporting notation = 'X' num = num importing str.

Depending on the notation X or Y or blank i would like to get

3.141,59 or 3,141.59. I'm searching for such a function module.

Re: Convert packed decimal to char/string

rainer_hbenthal — Tue, 22 Sep 2009 06:19:00 GMT

Where in the edit mask can i put the notation i would like to be used? Besides that, i was unable to find a edit mask which will work for every p typed varaible.

Re: Convert packed decimal to char/string

Former Member — Tue, 22 Sep 2009 06:53:58 GMT


> Depending on the notation X or Y or blank i would like to get
> 3.141,59 or 3,141.59. I'm searching for such a function module.

That's the same thing I have done in my code above.

Why not you go with ABAP code instead of FM(Since yet we donu2019t able to find the exact FM)? Or is there any chance to create your own Z Function module which consist the above code inside the FM?

Cheers

Re: Convert packed decimal to char/string

rainer_hbenthal — Tue, 22 Sep 2009 06:59:52 GMT

Sorry our postings did overlap so i wasnt aware of yours...

i guess in_par-value is c based variable? Where did you find that snippet? SAP Standard?

Re: Convert packed decimal to char/string

Former Member — Tue, 22 Sep 2009 07:50:57 GMT

Yep, In_par-value is C based.

And itu2019s not an SAP standard Snippet. I wrote this code from my left hand in one of the Subroutines of SAP Script.

Cheers

Re: Convert packed decimal to char/string

Former Member — Tue, 22 Sep 2009 08:17:21 GMT

Did you try Function C14N_NUMERIC_FORMAT ?