VIEW SELECTION CONDITIONS

Hi,

I have one q, plese be so kind to provide me the solution!

I have a VIEW table almost done, i say almost because i can't figure out how to put some conditions that i've previously had in my SELECT statement.

I had a SELECT something like this:

SELECT eket_{eindt eket}menge eket~wemng

ekpo_{ebeln ekpo}ebelp... etc

...

FROM eket AS eket INNER JOIN ekpo AS ekpo

ON eket_{ebeln = ekpo}ebeln AND...etc

...

INTO CORRESPONDING FIELDS OF ... etc

WHERE

ekpo~loekz ne 'L' AND

...

eket~eindt in s_eindt AND...etc(Where s_eindt stands for input parameter on selection screen!

Maja