Error with Select Statement...

[Former Member]

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

[christine_evans]

>

> 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 binsobjecttyp ainsobject cfaedn adate_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 apartner = bpartner
>       AND ainsobject = binsobject INNER JOIN dfkkop AS c
>       ON bpartner = cgpart
>       AND binsobject = cvtref
>       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 binsobjecttyp ainsobject cfaedn adate_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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

• 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