create view

[Former Member]

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?

[Former Member]

any help?

thanks

[Former Member]

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

[seshatalpasai_madala]

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

[Former Member]

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

[Former Member]

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

[Former Member]

hi shiba,

thanks.

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

[Former Member]

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