topic Re: problem in joining. in Application Development and Automation Discussions

problem in joining.

former_member841898 — Mon, 26 Nov 2007 07:30:56 GMT

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

Re: problem in joining.

Former Member — Mon, 26 Nov 2007 07:34:35 GMT

loop at it to wa.

move that field 24 char v_24.

endloop.

here write select query

Re: problem in joining.

Former Member — Mon, 26 Nov 2007 07:36:52 GMT

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

Re: problem in joining.

SantoshKallem — Mon, 26 Nov 2007 07:37:46 GMT

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

regards.

santhosh

Re: problem in joining.

former_member841898 — Mon, 26 Nov 2007 07:57:49 GMT

thanks sir,

problem is solved .rewarded.

pankaj

Re: problem in joining.

former_member841898 — Mon, 26 Nov 2007 07:59:30 GMT

thanks kaveri maam,

problem is solved, rewarded

pankaj

Re: problem in joining.

former_member841898 — Mon, 26 Nov 2007 08:00:46 GMT

hi sir ,

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

rewarded

thanks pankaj