topic Re: VIEW SELECTION CONDITIONS in Application Development and Automation Discussions

VIEW SELECTION CONDITIONS

Former Member — Wed, 18 Oct 2006 11:58:42 GMT

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

Re: VIEW SELECTION CONDITIONS

Former Member — Wed, 18 Oct 2006 12:13:18 GMT

still nothing...

Re: VIEW SELECTION CONDITIONS

Former Member — Wed, 18 Oct 2006 12:22:06 GMT

Hi Maja,

YOur question is slightly confusing towards the end.

can you explain it a bit further?

Regards,

ravi

Re: VIEW SELECTION CONDITIONS

Former Member — Wed, 18 Oct 2006 12:26:18 GMT

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.

Re: VIEW SELECTION CONDITIONS

Former Member — Wed, 18 Oct 2006 12:34:54 GMT

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

Re: VIEW SELECTION CONDITIONS

Former Member — Wed, 18 Oct 2006 12:37:50 GMT

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

Re: VIEW SELECTION CONDITIONS

Former Member — Wed, 18 Oct 2006 12:42:35 GMT

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...

Re: VIEW SELECTION CONDITIONS

Former Member — Wed, 18 Oct 2006 12:46:31 GMT

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

Regards,

ravi

Re: VIEW SELECTION CONDITIONS

Former Member — Wed, 18 Oct 2006 12:53:58 GMT

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