Conversion error: right datatype for quantity fix?

[Former Member]

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

[former_member213275]

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.

[Former Member]

Srikanth,

Try using RS_CONV_EX_2_IN.

[Former Member]

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.

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[venkateswaran_k]

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

1. Try using Type  P decimals 3

Or

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.