topic Re: creating a view in Application Development and Automation Discussions

creating a view

Former Member — Mon, 16 Apr 2007 12:07:21 GMT

Hi,

I'm trying to create a view, but i've got a few questions :

1) can we use outer join in a view ?

I'm using table QMEL with the table AUFK for example.

and i want to have all the notifications, even those with no order attached to them.

2) can we use a table twice ? for example :

i'm using the table JEST with the table TJ30T to get the user status of a notification,

can i use another table JEST but this time with the table TJ02T to get the system status of a notification ?

Thank's

Mayaa

Former Member — Mon, 16 Apr 2007 12:10:51 GMT

Hi,

1. You can use Views in Join Conditions

2. You can write a Join condiiton for JEST with the table TJ30T

3. You can write a Join condiiton for JEST with the table TJ02T separately

Not mixing with 2 nd select.

reward if useful

regards,

Anji

Former Member — Mon, 16 Apr 2007 12:15:18 GMT

Hi,

Follow the link

reward with points.

Former Member — Mon, 16 Apr 2007 12:21:00 GMT

Hi,

Thank's for your answer.

But how can i do that.

in se11 -> create view, you can only add tables and joints (inner join)