selection condition while creating the view

[Former Member]

Hi

Im creating a view on top of three R/3-Tables. In "selection condition" , i need to give some filtering for extracting the data from the one table.

Condition is :-

<b>select distinct objnr stat

into table it_objects

from jcds

where objnr in so_objnr

and stat in ('I0068', 'I0070', 'I0072')

and udate in so_udate

and cdtcode between 'QM01' and 'QM02'.</b>

So in selection condition , i need to give

<b>stat in ('I0068', 'I0070', 'I0072')

and udate in so_udate

and cdtcode between 'QM01' and 'QM02'.</b>

So how can i create this condition in "selection condition". I mean what operatiors i should use , how i need to write the Comparision Value and AND/OR operators.

please let me know

kumar

[Former Member]

if so_udate is a SELECT-OPTION, you will have to take care of that outside of the join - in the actual SELECT against the view.

Rob