topic Re: Error with Select Statement... in Application Development and Automation Discussions

Error with Select Statement...

Former Member — Thu, 15 Jan 2009 10:33:58 GMT

Hi Everyone. HOpe that you could help me. I don't know what's wrong with my select statement, but everytime it gets to the select statment, it becomes a run time error. The error is this " Invalid value in OPTION field of value table for IN itab operator." I don't know what's causing this error. Please help. Thanks.

SELECT b_{insobjecttyp a}insobject c_{faedn a}date_from

INTO (wa_bill-insobjecttyp, wa_bill-io, wa_bill-duemon,

wa_bill-date_from)

FROM dimaparbrok AS a INNER JOIN dimaiobpar AS b

ON a_{partner = b}partner

AND a_{insobject = b}insobject INNER JOIN dfkkop AS c

ON b_{partner = c}gpart

AND b_{insobject = c}vtref

WHERE a~partner = wa_itab-partner

AND a~broker = wa_itab-ragency

AND c~blart IN i_blart

AND c~faedn IN b_date

GROUP BY b_{insobjecttyp a}insobject c_{faedn a}date_from b~insobject

ORDER BY a~date_from DESCENDING.

Anna

Re: Error with Select Statement...

christine_evans — Thu, 15 Jan 2009 10:37:27 GMT


> Hi Everyone.  HOpe that you could help me.  I don't know what's wrong with my select statement, but everytime it gets to the select statment, it becomes a run time error.  The error is this " Invalid value in OPTION field of value table for IN itab operator."  I don't know what's causing this error.  Please help.  Thanks.
> 
> SELECT b_{insobjecttyp a}insobject c_{faedn a}date_from
>       INTO (wa_bill-insobjecttyp, wa_bill-io, wa_bill-duemon,
>       wa_bill-date_from)
>       FROM dimaparbrok AS a INNER JOIN dimaiobpar AS b
>       ON a_{partner = b}partner
>       AND a_{insobject = b}insobject INNER JOIN dfkkop AS c
>       ON b_{partner = c}gpart
>       AND b_{insobject = c}vtref
>       WHERE a~partner = wa_itab-partner
>         AND a~broker = wa_itab-ragency
>         AND c~blart IN i_blart
>         AND c~faedn IN b_date
>     GROUP BY b_{insobjecttyp a}insobject c_{faedn a}date_from b~insobject
>     ORDER BY a~date_from DESCENDING.
> 
> Anna

Do what the error message suggests and check what you've got in the option field of one of the tables that you are using with IN.

Re: Error with Select Statement...

Former Member — Thu, 15 Jan 2009 10:39:03 GMT

Hi Anna ,

Please check the value of the ranges

i_blart and b_date.

Please see if the value inf the SIGN and OPTION fields if the range are correct .

How is the data in the range being populate are you doing it or the system does it automatically from a select option .

Regards

Arun

Re: Error with Select Statement...

Former Member — Thu, 15 Jan 2009 10:39:59 GMT

Hi Anna,

The problem might be with fields in the where condition for selection options.

if not please recheck the select option fields and the values you had entered in the selection screen..

Regards,

Phani.

Re: Error with Select Statement...

Former Member — Thu, 15 Jan 2009 10:39:59 GMT

Hi,

This is caused because you are passing an invalid value in the OPTION field of one of the ranges

i_blart or b_date ( assuming these are ranges and not select-options)

The valid values for the option field are EQ,NE,CP,NP,GE,LT,LE,GT.

Please check this and correct the code where you are populating the ranges.

regards,

Advait

Re: Error with Select Statement...

Former Member — Thu, 15 Jan 2009 10:40:26 GMT

Hi,

check content of i_blart and b_date, there should be a field 'option' and you will need to search for allowed values to fill in here. Maybe you will need to debug to get the values first and compare then with allowed values.

Rolf

Re: Error with Select Statement...

Former Member — Thu, 15 Jan 2009 11:22:50 GMT

Please ignore as it has been answered.

Hi Anna,

Its because of your ranges i_blart OR b_date.

First of all if these are not defined by SELECT-OPTIONS and you are filling it yourself then check the content of these ranges table..

As suggested above check if permissible value exist in OPTIONS column for both the ranges..

Revert

Edited by: Ankesh on Jan 15, 2009 4:53 PM