Type Conversion Issue while firing query...

Hi Experts,

Need your help and inputs ASAP.

We are writing a query:

select objid from hrp1010 INTO CORRESPONDING FIELDS OF TABLE lt_hrp1010

FOR ALL ENTRIES IN LT_VARYF

where objid eq LT_VARYF-SOBID.

Where LT_VARYF is internal table of type HRP1001,

and lt_hrp1010 is internal table of type HRP1010.

Now in the above query OBJID is of type NUMC but SOBID is of type CHAR and thats why it is gving us an error message related to Type Mismatch.

Is there any way in which we can manipulate the Data Type of Column(SOBID) of the Internal Table (LT_VARYF), just before we fire above query.

Or is there any other way through which I can solve my propose.

Appreciate your help.

Thanks,

Harish