Skip to Content
0
Former Member
Jun 17, 2009 at 12:39 PM

data type mismatch

673 Views

hi

my query is

SELECT sobid objid FROM hrp1001 INTO TABLE it_var

FOR ALL ENTRIES IN it_org

WHERE sclas EQ 'O' AND

otype EQ 'D' AND

seqnr = it_org-seqnr AND

sobid = it_org-orgeh.

sobid is

sobid TYPE hrp1001-sobid

and orgeh is

pa0001-orgeh

now error is

 When you use the addition "FOR ALL ENTRIES IN itab", the fields "SOBID"
and "IT_ORG-ORGEH" must have the same type and the same length.
   

bcoz SOBID is char type (45) and ORGEH is numeric (8).

Please tell me how to remove the error?

Is there any way other than FOR all entries to write this query?

Sachin