topic Re: character to quantity type in Application Development and Automation Discussions

character to quantity type

Former Member — Thu, 10 Aug 2006 07:06:18 GMT

Hi All,

I had a requirement to move character to Quantity type field.can any body help me how to move character type field to Quantity type field of length 13, decimal 3 ?

Thanks & Regards,

Anil.

Re: character to quantity type

Former Member — Thu, 10 Aug 2006 07:09:38 GMT

Hello,

In the domain of a particular field, check the 'output length' ( Definition tab )value. hope this helps.

Best regards, Murugesh AS

Re: character to quantity type

former_member628175 — Thu, 10 Aug 2006 07:10:29 GMT

Hi Anil ,

I think 'WRITE' statement will do the job .

e.g . write <char> to <quant> .

Hope this helps .

Regards ,

Shounak M

Re: character to quantity type

naimesh_patel — Thu, 10 Aug 2006 07:16:23 GMT

Hello,

Conversion of Char (type c) to Qty (type p) is not possible. If you try to move it, it will give an error like: unbale_to_interpret_as_number.

Regards,

Naimesh

Re: character to quantity type

Former Member — Thu, 10 Aug 2006 08:22:59 GMT

Hei Anil,

do extacly what you said:

move C to Q

Don't use WRITE if the destination is a P.

If C contains not only numbers a dump occurs for sure.

Re: character to quantity type

Former Member — Thu, 10 Aug 2006 08:23:11 GMT

Try and use the pack command...

PACK l_char to l_qty.

Regards

Anurag

Re: character to quantity type

Former Member — Thu, 10 Aug 2006 08:31:17 GMT

Hi,

if you want to convert the character to amount then you can use the FM <b>HRCM_STRING_TO_AMOUNT_CONVERT</b>

regards

vijay

Re: character to quantity type

Former Member — Thu, 10 Aug 2006 08:40:46 GMT

in this case, WRITE TO will not work, as you are sending CHAR value to a numeric field.

here is the logic i followed to overcome the (user settings of comma(,) and DOT(.))

DATA : V_WEIGHT TYPE LTAP-BRGEW,

V_WT_CHAR(21) TYPE C.

assume you have weight value in a CHAR field.

v_WT_CHAR = '21,987.258'.

here your requirement is to push this value to a weight field.for that follow this,

REPLACE ALL OCCURRENCES OF ',' IN V_WT_CHAR WITH ''.

REPLACE ALL OCCURRENCES OF '.' IN V_WT_CHAR WITH ''.

CONDENSE V_WT_CHAR.

MOVE V_WT_CHAR TO V_WEIGHT.

V_WEIGHT = V_WEIGHT / 1000.

now your V_WEIGHT will have value '21987.258' (as it stores in INTERNAL format)

Check this& let me know,is this working for you ?

Regards

Srikanth