Data Dictionary

[Former Member]

hi we are facing some problem in QM report we want to convert character field in to numeric as we want the total and average of the field .table name:- qamr- field name:- Original-Input. Waiting for the reply Regards

[Former Member]

hi we are facing some problem in QM report we want to convert character field in to numeric as we want the total and average of the field .table name:- qamr- field name:- Original-Input. Waiting for the reply Regards

[RahulKeshav]

hi

Try to use FM 'CHAR_NUMC_CONVERSION'...

If helpful

Plz Reward

Thnx

Rohit

[Former Member]

Hi Prashant,

Please use this code.

DATA:

BEGIN OF i_qamr OCCURS 0,

original_input LIKE qamr-original_input,

END OF i_qamr,

BEGIN OF i_qamr1 OCCURS 0,

input TYPE N,

END OF i_qamr1.

SELECT original_input

FROM qamr

INTO TABLE i_qamr

WHERE original_input NE SPACE.

IF sy-subrc EQ 0.

LOOP AT i_qamr.

IF i_qamr-original_input CA sy-abcde.

CONTINUE.

ELSE.

• only numeric values are loaded in this table.

i_qamr1-input = i_qamr-original_input.

APPEND i_qamr1.

ENDIF.

ENDLOOP.

IF i_qamr1[] IS NOT INITIAL.

LOOP AT i_qamr1.

WRITE:/ i_qamr1-input.

ENDLOOP.

ENDIF.

ENDIF.

Please let me know if this serves your purpose.