topic Re: create view in Application Development and Automation Discussions

create view

Former Member — Fri, 23 Feb 2007 07:19:04 GMT

hi,

1) if i want to CREATE a VIEW base on the sql statement, I cannot find the 'IN' operator in the selection conditions tab in maintain view.

SELECT c_{aaa c}bbb c_{ccc c}ddd

FROM tab1 AS a INNER JOIN tab2 AS b ON a_{xxx = b}xxx

INNER JOIN tab3 AS c ON b_{yyy = c}yyy

INTO CORRESPONDING FIELDS OF TABLE itab

WHERE a~xxx = i_xxx AND

a~zzz IN ('04' , '08') AND

b~type = '1'.

2) let say i able to create a view base on the select statement above,

when i quote the select statement using view, the select statement is simplified as below:

select * from zview where a~xxx = i_xxx.

correct?

Re: create view

Former Member — Fri, 23 Feb 2007 07:39:30 GMT

any help?

thanks

Re: create view

Former Member — Fri, 23 Feb 2007 07:47:26 GMT

In SE11 when you create the View, in the Selection Conditions tab,

you can have two lines with TAB2-ZZZ = '04' OR

2nd line TAB2-ZZZ = '08'.

Regards,

Ravi

Re: create view

seshatalpasai_madala — Fri, 23 Feb 2007 07:56:25 GMT

Hi,

1) IN is not allowed since it is generally used with selection options. ALso you can alternatively use OR and mention all the conditions that you want to mention using IN.

2) YES but since IN is not possible you have to use like below.

SELECT c_{aaa c}bbb c_{ccc c}ddd

FROM tab1 AS a INNER JOIN tab2 AS b ON a_{xxx = b}xxx

INNER JOIN tab3 AS c ON b_{yyy = c}yyy

INTO CORRESPONDING FIELDS OF TABLE itab

WHERE a_{xxx = i_xxx AND b}type = '1'

AND ( a_{zzz = '04' OR a}zzz = '08' ).

Regards,

Sesh

Re: create view

Former Member — Fri, 23 Feb 2007 08:16:21 GMT

hi sesha,

the sql statement is working fine.

i am actually asking on creating view.

i got the 1st question and i need the clarification on my 2nd question.

thanks

rgds

Re: create view

Former Member — Fri, 23 Feb 2007 08:20:42 GMT

AS PER YOR 2ND QUESTION YOU ARE CORRECT OR YOU CAN USE IT WITHOUT WHERE ALSO IF YOU ADD THAT CONDITION IN VIEW.

REGARDS

SHIBA DUTTA

Re: create view

Former Member — Fri, 23 Feb 2007 08:32:14 GMT

hi shiba,

thanks.

i need to have where as the variable is passed from the abap program.

Re: create view

Former Member — Fri, 23 Feb 2007 08:37:39 GMT

HI El,

For your 2nd question you don't nee A~ you can simple write:

select * from zview where xxx = i_xxx. "XXX must be a field in the view.

REgards,

Ravi