SAPSQL_IN_ITAB_ILLEGAL_OPTION error

[Former Member]

HI All,

Can anyone tell me whats the problem with this select statement.

 SELECT tech_adspec_id max( adcont_vers ) as version

 FROM JQTATTRIBUTE

 INTO CORRESPONDING FIELDS OF TABLE gt_version

WHERE tech_adspec_id IN ra_adspecid

GROUP BY tech_adspec_id.

Here

ra_adspecid

is a range table.

I am getting a runtime error

SAPSQL_IN_ITAB_ILLEGAL_OPTION

at this point.

[Former Member]

HI All,

Can anyone tell me whats the problem with this select statement.

 SELECT tech_adspec_id max( adcont_vers ) as version

 FROM JQTATTRIBUTE

 INTO CORRESPONDING FIELDS OF TABLE gt_version

WHERE tech_adspec_id IN ra_adspecid

GROUP BY tech_adspec_id.

Here

ra_adspecid

is a range table.

I am getting a runtime error

SAPSQL_IN_ITAB_ILLEGAL_OPTION

at this point.

[former_member194669]

You need to check your range table ra_adspecid, whether the records in a range should be like

I EQ 100 
I EQ 101

Something like this way. and also check options or sign in this table may NOT be blank

a®

[Former Member]

HI...

Thanks a lot.... Actually i didnt realise that the range table was not populated properly..thanks a ton...