problem in joining.

[former_member841898]

hi all,

i m selecting hkont (gl no) ,gsber ( business area) from table bseg.

e.g. select hkont gsber from bseg into table ibseg.

now i m selecting subclass(orgz unit) , set name (set id) , valfrom (from value)

from table setleaf.

eg. select subclass setname valfrom from setleaf into table iset for all entries in ibseg where valfrom = ibseg-hkont .

now the data type of valfrom is 'C' and <b>length is 24</b> , but that of hkont is 'C' and <b>length is 10</b> , so it is gving syntax error . how to resolve this.

thanks

pankaj

[Former Member]

loop at it to wa.

move that field 24 char v_24.

endloop.

here write select query

[former_member841898]

hi sir ,

thanks for ur code........

rewarded

thanks pankaj

[Former Member]

Hi Pankaj,

Try this...

take one more inttemp table for ur field wid field length 24 of type char.

inttemp[] = int[].

select subclass setname valfrom from setleaf into table iset for all entries in inttemp where valfrom = ibseg-hkont .

Regards,

Kaveri

[former_member841898]

thanks kaveri maam,

problem is solved, rewarded

pankaj

[SantoshKallem]

while declaration of HKONT in internal table, Give the length of 24 of type c and check

regards.

santhosh

[former_member841898]

thanks sir,

problem is solved .rewarded.

pankaj