topic Data Dictionary in Application Development and Automation Discussions

Data Dictionary

Former Member — Mon, 31 Dec 2007 09:55:55 GMT

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

Re: Data Dictionary

RahulKeshav — Mon, 31 Dec 2007 10:01:33 GMT

Try to use FM 'CHAR_NUMC_CONVERSION'...

If helpful

Plz Reward

Thnx

Rohit

Re: Data Dictionary

Former Member — Mon, 31 Dec 2007 10:14:53 GMT

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.

Please let me know if this serves your purpose.