topic Moving character field data to Quantity field variable in Application Development and Automation Discussions

Moving character field data to Quantity field variable

Former Member — Mon, 05 Jan 2009 09:35:22 GMT

Hi,

I have a screen in which there is a charater field which holds the Quantity. for example 340,00

now i have to update the dictionary table field with this value, when iam assigning directly to the workarea it is giving dump as '340,00 cannot be interpret as number'.

I tried all the ways possible, however it is not solved...

plz help me with your inputs.

thanks in advance

Sunny.

Re: Moving character field data to Quantity field variable

Former Member — Mon, 05 Jan 2009 09:37:54 GMT

Hi..

Did you try using the MOVE statement...?..

Re: Moving character field data to Quantity field variable

Former Member — Mon, 05 Jan 2009 09:39:16 GMT

Hi Sunny,

delcare on variable with the packed decimal 2 and move your value to new variable.

solves your problem.

Thanks

Re: Moving character field data to Quantity field variable

Former Member — Mon, 05 Jan 2009 09:39:42 GMT

Hi,

try this...

GWA_INPUT_TABLE-VALUE - this is your character field

G_AMOUNT is your quantity or currency field.

SHIFT GWA_INPUT_TABLE-VALUE LEFT DELETING LEADING SPACE.

TRANSLATE GWA_INPUT_TABLE-VALUE USING ', '.

CONDENSE GWA_INPUT_TABLE-VALUE NO-GAPS.

G_AMOUNT = GWA_INPUT_TABLE-VALUE.

Regards,

Venkatesh

Re: Moving character field data to Quantity field variable

Former Member — Mon, 05 Jan 2009 09:48:51 GMT

hi,

use field symbols for conversion of charector to the quantity field.

field-symbol : <fs> type KTMNG .

data : v_a(5),

v_b type ktmng.

Move : v_a to <fs>,

<fs> to ktmng.

Regards,

Naresh.