topic Re: Conversion error: right datatype for quantity fix? in Application Development and Automation Discussions

Conversion error: right datatype for quantity fix?

Former Member — Wed, 31 Jul 2013 10:54:01 GMT

Hi all,

I need to pass some data from an excel file to an internal table from type rku01g . I am having a conversion problem with the field mefbtr which is of type quantity 15.

I have define my input field with a type char 15 and it is not working. I even used the component type from the table MEFXXX. Help me fix this conversion error. Which data type should i give to my field that get data from an excel file.

Thanks

Re: Conversion error: right datatype for quantity fix?

former_member213275 — Wed, 31 Jul 2013 12:16:05 GMT

Hi Maria,

Use Function module "MOVE_CHAR_TO_NUM". It converst character field to quantity field.

E.g.

call function 'MOVE_CHAR_TO_NUM'

exporting

chr = Charvariable

importing

num = qty_variable

exceptions

convt_no_number = 1

convt_overflow = 2.

Srikanth.

Re: Conversion error: right datatype for quantity fix?

Former Member — Wed, 31 Jul 2013 12:32:59 GMT

Srikanth,

Try using RS_CONV_EX_2_IN.

Re: Conversion error: right datatype for quantity fix?

Former Member — Wed, 31 Jul 2013 12:37:00 GMT

Hi Maria,

Take the type string for that field while uploading into internal table.

Declare one variable of type MEFXXX.

Move that string variable into variable of type MEFXXX.

Re: Conversion error: right datatype for quantity fix?

Former Member — Wed, 31 Jul 2013 13:47:51 GMT

This message was moderated.

Re: Conversion error: right datatype for quantity fix?

Former Member — Wed, 31 Jul 2013 13:48:48 GMT

This message was moderated.

Re: Conversion error: right datatype for quantity fix?

venkateswaran_k — Wed, 31 Jul 2013 14:05:26 GMT

what is your conversion error ? can you please post it.

1. Try using Type P decimals 3

2. Try using MENGE_D

In one of my requirement, I fetch quantity from Excel sheet as follows:

TYPES: BEGIN OF t_upload,

srno TYPE int2,

material TYPe lips-matnr,

quantity TYPE lips-lfimg,

hdrtxt type string,

END OF t_upload.