VIEW SELECTION CONDITIONS

[Former Member]

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

[Former Member]

still nothing...

[Former Member]

Hi Maja,

YOur question is slightly confusing towards the end.

can you explain it a bit further?

Regards,

ravi

[Former Member]

so to be more specific,

my SELECT works fine, but when i try to put my SELECT statement conditions, join and etc in a VIEW Table, i don't get same data in internal table, because i have to put some data from selection screen as one of my conditions in VIEW Table.

Message was edited by: Maja Zugaj

[Former Member]

YOu can write select statements on a view as well.

Whichever condtions you want to specify(Related to the selection screen) you can mention in the select statement itself like this

select *

from <view name>

into table itab

where field1 in s_field1.

Regards,

Ravi

[Former Member]

Hi,

Thank you both for this but then i get this error:

Wrong table name or table alias name "EKET". the field "EKET~EINDT".

for every field that refers to selection screen field...

[Former Member]

when you write a select for your view directly, you don't need to give aliases(eket~EINDT)..jUST GIVE EINDT.

Regards,

ravi

[Former Member]

The selection of fields should be as like the selection of fields from table.

here we should not use the EKET OR EKPO to specify the field selection.

I mean you can directly specify the fiels which is requied from the crated view.

Hope i am clear on the issue.

Regards,

Satya

[Former Member]

Fixed parameters can be specified in your view definition, however, parameters that users enter at selection screen of your report should be specified in 'select' command ('where' condition) in ABAP code.