selection condition while creating the view

Former Member — Fri, 19 Oct 2007 16:25:39 GMT

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

Re: selection condition while creating the view

Former Member — Fri, 19 Oct 2007 16:30:12 GMT

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

topic selection condition while creating the view in Application Development and Automation Discussions

selection condition while creating the view

Re: selection condition while creating the view