Skip to Content
0
Former Member
Oct 18, 2006 at 11:58 AM

VIEW SELECTION CONDITIONS

383 Views

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 eketeindt eketmenge eket~wemng

ekpoebeln ekpoebelp... etc

...

FROM eket AS eket INNER JOIN ekpo AS ekpo

ON eketebeln = ekpoebeln 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